topic Re: Survey123 Connect - sqlite recovery iOS in ArcGIS Survey123 Questions

Survey123 Connect - sqlite recovery iOS

John_RMellor__GISP — Fri, 03 Jan 2020 16:16:12 GMT

I have version 3.7.60.

I am testing how to recover the sqlite file from an iOS mobile device (an iPad) and open it on desktop. I have seen the document for recovering the data from the mobile device. There is a statement in the documentation about where to find the file on the mobile device (see attached). I can't seem to find the file on the mobile device, any help would be appreciated.

Re: Survey123 Connect - sqlite recovery iOS

JamesTedrick — Fri, 03 Jan 2020 21:03:31 GMT

As the documentation mentions, in order to access files on an iOS device you need to use iTunes or similar software (iExplorer; if you have a computer with macOS 10.15 Catalina, you now use the Finder). If using iTunes:

1) Plug the iOS device in to the computer; this should launch iTunes

2) If prompted on the iOS device, allow the computer to access the files on the iOS device

3) In iTunes, click on the device button located in the top of the application. This will open up the iOS device's page

4) In the device page, click on 'File Sharing'. This will show a list of applications. Select Survey123 (you may need to scroll through the list of applications if it's not visible immediately).

5) With Survey123 selected, select the 'ArcGIS' folder in the right column and then click 'Save As'. Select a location on your computer to save the directory.

You will now have the data stored by Survey123. The sqlite file will be in ArcGIS -> My Surveys -> Databases

Re: Survey123 Connect - sqlite recovery iOS

John_RMellor__GISP — Mon, 13 Jan 2020 17:10:58 GMT

James Tedrick‌ - Thank you - this worked exactly as how you described it. Now all I have to do if figure out how to open the sqlite file.

Re: Survey123 Connect - sqlite recovery iOS

JamesTedrick — Mon, 13 Jan 2020 18:58:30 GMT

A tool I use on Windows is DB Browser for SQLite . I would also point out GitHub - tedrick/ReadS123DB: Convert the survey data stored in the Survey123 Field App into a set of CSV files

Re: Survey123 Connect - sqlite recovery iOS

roemhildtg — Thu, 26 Mar 2020 15:26:01 GMT

James Tedrick‌ is there an easy way to have users access the log file in survey123 and email it? We have dozens of remote workers who are using ipads and don't have easy access to a laptop/itunes so we really need a way to be able to share diagnostics information for troubleshooting and recovery.

Re: Survey123 Connect - sqlite recovery iOS

JamesTedrick — Fri, 27 Mar 2020 18:59:26 GMT

Hi Gregg,

Accessing the logs currently requires a separate computer to access the files.

Re: Survey123 Connect - sqlite recovery iOS

DavidCook2 — Tue, 05 Jan 2021 21:55:11 GMT

Hi James - i am looking at the GitHub SQLite Covert script https://github.com/tedrick/ReadS123DB/blob/repeats/readDb.py

I am unable to get it to work in my environment. is this functional for python 3.7 or still in development?

thanks!

Re: Survey123 Connect - sqlite recovery iOS

MichelleWilliamsERM — Tue, 25 May 2021 20:36:01 GMT

WOW - I love the Python script. All I had to do was drop the .sqlite file into the folder with your script, and make an out folder for the csv. THANK YOU so much!