nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 Connect - sqlite recovery iOS

John_RMellor__GISP

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.

sqliteFile.PNG

Encontre mais publicações marcadas com

Accepted answers

JamesTedrick

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

All comments

MichelleWilliamsERM

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!

DavidCook2

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!

JamesTedrick

Hi Gregg,

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

roemhildtg

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.

JamesTedrick

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

John_RMellor__GISP

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.

JamesTedrick

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.