Latest Contributions by CurtisOverholt

‎12-16-2019

Hi Jim, I tried this workflow. Recover data from a mobile device When I did the steps, however, when I went to hit 'fix database' there is no prompt for me to look up the SQLite file. I'm using Survey123 for ArcGIS (desktop) 3.6.153 I was looking the workflow below where it says to use SQL to update the path, but my path doesn't seem like it would be affected PATH: /var/mobile/Containers/Data/Application/8A723410-E546-42CC-B7D4-90F97E082B0E/Documents/ArcGIS/My Surveys/2e80645d696a430e868903bfae471ef9/esriinfo/Survey123Name.xml SQL Code Update UPDATE Surveys SET path = REPLACE (path,"/sdcard", "C:/Users/Me") where path LIKE "/sdcard%" Any Ideas?

‎12-13-2019

Hi All, I encountered an issue with Survey123 and thankfully been able to extract the SQLite file that contains the data. The survey123 form sent blank information to the feature class and I am hoping to somehow extract this information and import it into the form feature class. I have searched and seen that you can convert to CSV using python with this file https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fgithub.com%2Ftedrick%2FReadS123DB However, my python skills are poor and i'm not sure how to run this file. I can open it up, and see the text but I'm not sure how to correctly set the paths. Does it matter where I store the file? I have the sqlite database just on my C:\Temp I can see at the top of the file it has these parameters where I believe you should enter your paths, but I'm just not good enough to understand this yet. #Constants for easy running IN_DB = r'./a084e65cd9403d813e8ec667ca329a63.sqlite' OUT_DIR = r'./out'‍‍‍‍‍‍‍‍ If my path is C:\Temp Should this be the edited to this IN_DB = r'C:/Temp/a084e65cd9403d813e8ec667ca329a63.sqlite' and saved?‍‍ What about the OUT_DIR ? Does the file have to be placed somewhere specific ? Lastly, How do I import that data back to the form? James Tedrick‌ :

‎12-10-2019

So I tried this. It worked and it gave me the the details of the output and loaded onto into contents of the map. Why, when run again does it crash? I am just inputting the arcpy.makefeature layer... function, nothing else.

‎12-10-2019

SOLVED: I found the INBOX feature of Survey123. It allows to refresh all samples from ALL devices and view them.

‎12-10-2019

a arcpy.management.SelectLayerByAttribute("(SHAPE_IN_CONTENTS)", "NEW_SELECTION", "LEASE_NAME LIKE 'ABC%'", None) arcpy.management.CopyFeatures("(SHAPE_IN_CONTENTS)", r"C:\Data\GIS\Project\Python\Python.gdb\(SELECTED_SHAPE)", None, None, None, None) arcpy.management.Dissolve("(SELECTED_SHAPE", r"C:\Data\GIS\Project\Python\Python.gdb\(SELECTED_SHAPE_DISSOLVE)", None, None, "MULTI_PART", "DISSOLVE_LINES") ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Shapefile name is within ( ) I can run each line separately. I can run 2-3 separately. Occasionally 1-3 work, 1-2 work, 2-3 works 100% of the time. I'm wondering if I need to add code between line 2-3 to reference the file? When I try to run the entire code, the trailling dots freeze and windows says ArcGIS Pro has stopped working

‎08-29-2019

Hi All, When multiple users are collecting data, is there a way to view, on a single mobile device (not portal / Arc), the location for all of the users survey location? Ideally there was a way to load all the surveys on to each device and view all the records on the map, the location of each survey. I know this can be done in Arc / Portal but there isn't a way that I know of you can avoid duplicating survey locations without looking at screen shots of Arc or Paper maps drawn onto. I know Survey123 stores the data on the phone in folders but I'm not sure 1) how to export that to a spreadsheet, hopefully with XY data 2) If you can export it to a spreadsheet, how to re-import all of them to a device and have the device be able to see the locations that were included in the spreadsheet/database Is this possible currently? Cheers, -Curtis

Online Status	Offline
Date Last Visited	‎12-23-2020 03:13 PM

My Ideas

Latest Contributions by CurtisOverholt

Re: Data recovery from SQLite file

Data recovery from SQLite file

Re: What is causing my ArcGIS Pro to crash when running this Python code through the Python Window in ArcPro?

Re: Sharing Survey123 form data between data collectors / Syncing

What is causing my ArcGIS Pro to crash when running this Python code through the Python Window in ArcPro?

Sharing Survey123 form data between data collectors / Syncing