Latest Contributions by JimW

‎12-12-2019

I am encountering a similar issue. I receive the error when I am trying to use the Excel to Table geoprocessing tool. It doesn't happen when I run Table to Excel. I am running windows 7 and ArcGIS Pro 2.4.2. I installed the Microsoft Database Engine 2016, using the quiet mode, and the problem persists. If I keep the same session running, I sometimes continue to get the error message whether I am running the tool or not.

‎09-26-2019

That was the issue. Thanks for the help. In hindsight, my question should have pointed me in that direction.

‎09-24-2019

I have a creator role assigned to me. My end user is a custom role, created by our site admin, called field editor. This role has the following privileges assigned: Editor with routing View organization members Join organization groups View groups shared with organization Create, update, and delete content View content shared with organization Network Analysis Edit features

‎09-23-2019

I have a Survey123 form that uses reverse geocoding to capture the address and town of a utility mark out. I use the pulldata function in a hidden question to get the JSON object and then get the city and address properties so my end user doesn’t have to type these in. When I am signed into the Survey123 field app, this works as expected. When my user is signed into the field app, it doesn’t work. Neither the address nor the town values get populated. The only difference that I can tell is we have different user types. I had him sign in as himself on my IPad and IPhone and the same thing happened. I signed into his IPad and it worked for me. Does reverse geocoding require a certain user type or am I doing something else wrong? Survey form is attached. Thanks.

‎07-03-2019

I get the following error when opening the XLSForm from Survey123 Connect: If I click yes, the spreadsheet opens with this message: All the drops downs, etc. that are part of the spreadsheet are removed making it much more difficult to work with the spreadsheet. This did not always happen with this particular survey. I am using version 3.5 of Connect but it has happened with several previous versions. I thought it may be due to using Excel 2010. However, I upgraded recently to Excel 2013 and it is still happening. Why is this happening and is there anything that can be done to prevent it from happening again? Thanks.

‎04-01-2019

I have an indicator widget configured to calculate the total length of pipe cleaned today. I also have a reference set to show the total length of pipe cleaned yesterday. What I want to see is something like this: except for the time frame "today" compared to "yesterday." However, yesterday being Sunday, no pipes were cleaned. My widget is displaying my 'No Data' text but I know that pipes were cleaned today. If I change the statistic to count, the widget does what it is supposed to which is show me today's results compared to yesterday's. Has anyone else experienced this issue?

‎03-12-2019

I just tried publishing from ArcMap instead of Pro. The issue appears to have gone away and my survey does not hang up on submission of a record. I have to check the other surveys in my workflow that follow this one up now and see if they work.

‎03-12-2019

Hi Phil, Thanks for the reply. The layer in question is a brand new hosted feature service. It is identical to another hosted feature service expect for the addition of two new fields. The older hosted feature service when accessed in Survey123 works no problems. These two new fields aren't part of the survey in question. This is the only change that I made and my "new" hosted feature service was published as brand new in ArcGIS Online. Nothing else has changed. In my survey if I change the item id to my new hosted feature service, Survey123 hangs on submission. If I change it back to my original layer, the record gets submitted. I tried publishing my new hosted feature service from a brand new map in Pro, from a brand new project in Pro and I recreated the hosted feature layers in a brand new geodatabase before publishing to AGO. The survey always hangs when I got to submit the record. If I switch it back to my original layer, it works. I even created a brand new survey based on my feature service in Connect. This survey was identical in logic and functionality. The only difference is the hosted feature service it uses. But it still hangs on the submission. The issue seems to be with my new layer but I can't tell what the issue is. I am using version 3.3.51 of Survey123 Connect and version 3.3.64 of Survey123 for windows and iOS. This happens on my desktop, IPad and IPhone. I reinstalled the previous version of Connect and Survey123 with the same results. Thanks for your help. Jim

‎03-11-2019

Hi Philip, What's the bug you referenced below? I have a survey that contains related records but that are not being edited via the inbox or sent box. The related table might have records added during the survey depending on the conditions in the field. When I collect a brand new point and submit, the survey hangs on one of the related tables. No error message. The survey just keeps chugging away. Jim Philip Wilson wrote: Hi Aaron, Are you using repeat count on the repeat questions? Are you trying to edit existing records via the Inbox or Sent box? If so this could be related to a known bug currently identified. Does this issue happen on all devices and OS versions, or just some? Can you share a copy of the xlsx file so we can take a closer look? Thanks, Phil.

‎12-06-2018

I have a AGOL hosted feature layer that has a parent feature class (Repair Locations) and a related child feature class (Paving Cut Details). There can be one - three paving cuts at each repair location and each paving cut can have a different job status. If there are three paving cuts at one repair location, there will be three points, each with a different job status. I only want the Survey123 inbox to display those repair locations that have paving cuts with a job status of 'received'. However, the job status is an attribute of the paving cut layer and not the repair location layer. Currently, the inspector sees all repair locations regardless of the status of the related paving cuts. I have a query set in the bind::esri:parameters column for the correct job status on the related child layer but the inspector has to select a repair location to see if there are any paving cuts with the job status of received. It would be much better for our inspectors if I could set an inbox query that would only show those repair locations that having paving cuts with a job status of received. I tried something like this: RepairLocations.Town='Hartford' AND PavingCutDetails.JobStatus=1 but get a Code 400 Cannot perform query. Invalid query parameters. when I refresh my inbox. Is this a limitation of standardized queries? Is what I want to do possible? Thanks.

‎10-03-2018

For what it's worth, I can run this script in ArcMap and it runs as expected.

‎07-25-2018

That's it? One lousy space? I am glad it was something simple. I should have noticed that based on the other if statements in my sheet. Thanks for the help!

‎07-24-2018

Thanks for your help!

‎07-24-2018

Dedented lines 45 & 46 with the same results: Total Cleaning Recs: 983 row[0]16000 row[1]GIS6089793 Processing row 16000 for SAPLINKID GIS6089793 (0.0% percent complete) row[0]16001 row[1]GIS6093070 I put some print statements inside the for loop and the script appears to hang on the first select layer by attribute statement (line 41) when the loop begins its second iteration. But I can't see anything that is wrong that would cause the script to not run beyond this point without throwing an error message of some kind.

‎07-23-2018

Hi Dan, Thanks for your help! Here is the result: Total Cleaning Recs: 826 row[0]16000 row[1]GIS6089793 Processing row 16000 for SAPLINKID GIS6089793 (0.0% percent complete) row[0]16001 row[1]GIS6093070 My final print statement never runs either.

Online Status	Offline
Date Last Visited	Thursday

My Ideas

Latest Contributions by JimW

Re: ArcGIS Pro "ExcelToSQLite has stopped working" error

Re: Does reverse geocoding require certain user type and/or privileges?

Re: Does reverse geocoding require certain user type and/or privileges?

Does reverse geocoding require certain user type and/or privileges?

XLSForm Error in Excel

Indicator Widget Shows No Data Today When No Data Yesterday

Re: Survey 123 send stuck on Getting service information

Re: Survey 123 send stuck on Getting service information

Re: Survey 123 send stuck on Getting service information

Inbox Query Expression for Related Attributes

Re: Python Script to Snap by Attribute Not Working

Re: Calculating Inbox Record

Re: Python Script to Snap by Attribute Not Working

Re: Python Script to Snap by Attribute Not Working

Re: Python Script to Snap by Attribute Not Working

Re: Edit Widget Displays Domain Code, Not Descript...

Edit Widget Displays Domain Code, Not Description

Re: What's Coming in ArcGIS Experience Builder (Ju...

Repeated Login Prompts When Already Signed In

Re: Analyze Survey Error