Hello James,
Is it possible to extract photos from the Survey123 SQLite database?
Yigal
I believe those are not stored in the database, they can be found in the My Survey Attachments folder on your device. ...\username\arcgis\My Survey Attachments
Hello James,
I'm running the script but keep receiving the following error:
inDB = sys.argv[1]
IndexError: list index out of range
I've tried debugging and cannot understand the issue, I would appreciate help.
Hi @JamesTedrick , I would like to utilize this script to extract data> I have copied the "my surveys" folder onto windows but I don't know how to point to the database and also to specify the output csv file.
Kindly advise how I parse-in the database and the output directories.
Thanks,
We have a user with this issue. Have these tools been developed further? How would we go abut running the python on the phone, just from a command line?
Thanks
Hi Adrian,
We are planning to improve the tools available, but don't have anything released quite yet. You will need to copy the 'My Surveys' folder from the phone to a computer - iOS does not allow a script to run on a phone, and while it may be possible to run python on Android (I haven't looked deeply into that, but it's likely a developer has done it), the script above was not designed for any hiccups a python implementation on a phone might have. See Troubleshoot—Survey123 for ArcGIS | ArcGIS for information on transferring the data.
I created a script to export a Survey123 SQLite database to a file geodatabase:
arcpy.AddField_management(fcPath, str(tier2key), "TEXT")
File "c:\program files (x86)\arcgis\desktop10.6\arcpy\arcpy\management.py", line 3424, in AddField raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000012: OBJECTID already exists Failed to execute (AddField).
I set up the SQLiteDB input as a File and the Output location as a folder.
Any advice?