topic Re: Exporting Surveys from sqlite in ArcGIS Survey123 Questions

Exporting Surveys from sqlite

PaulKaczka — Wed, 19 Sep 2018 17:01:05 GMT

I extracted surveys from an iphone and now need to export them to a gdb or shapefile. I have the sqlite file but cant figure out how to get them in GIS.

Re: Exporting Surveys from sqlite

MarisaClaggett — Mon, 24 Sep 2018 19:45:00 GMT

Hi Paul,

You can try the following workflow in order to access the survey submissions from the sqlite database.

1. Open the sqlite file in DB Browser for SQLite

2. Inside of this database is a single table called "Surveys"

3. If you select the browse data tab, you can see that all submission data is stored in the "data" field as JSON.

4. You can export the survey table as a CSV file by selecting File > Export > Table(s) as CSV File...

5. This CSV will require cleaning up - the most important thing here is the data column which will need to be parsed and cleaned up to match your survey's schema. You can use the following json to csv converter to clean up the data field.

https://konklone.io/json/

6.Once the schema of the CSV matches the Survey's hosted feature layer you can append the CSV to the survey .

Best,

Marisa

Re: Exporting Surveys from sqlite

PaulKaczka — Thu, 04 Oct 2018 17:43:17 GMT

Thanks Marissa! This worked perfectly!!!

Re: Exporting Surveys from sqlite

GaryBowles1 — Thu, 04 Oct 2018 20:01:21 GMT

Marisa,

What about attachments that are part of the survey?

Thanks,

--gary

Re: Exporting Surveys from sqlite

SolanaFoo2 — Thu, 18 Aug 2022 11:56:38 GMT

Same question! Looks to be unanswered...