Send recovered data from sqlite using a different survey?

734
2
06-07-2021 07:02 AM
luckachi
Occasional Contributor III

I am trying to figure out if it is possible to take the unsent records recovered from the sqlite database on a device (phone) and send those records to another survey? I had some issues with a survey the other day and it ended up having to be deleted and a new survey published. The unsent records are still sitting on various devices and I need to take these survey records and send them using this new survey. The new survey is using the same existing hosted feature layer as the old deleted survey.

I have tried to make changes to the path and name in the sqlite file but nothing has been successful. 

0 Kudos
2 Replies
BrettStokes
Esri Contributor

Hi @luckachi ,

Have you tried the options mentioned in this FAQ tech article? It contains some useful links to the Survey123 and ArcGIS Pro documentation that may help you find a solution.

Brett

0 Kudos
luckachi
Occasional Contributor III

Hi @BrettStokes , I had tried the recover the data from a mobile device and I was able to access the .sqlite file and copy it over to my computer but had not had much success with using the DB browser to update the paths and use the Survey123 app on my computer to send them. I was also unable to make heads or tails of the data by adding the .sqlite database to pro.

It looks like the script was successful with creating the csv files but the polygon coordinates appear in one field as this:

POLYGON ((-84.6283077 42.5205877 237.41690195581052,-84.62827114712927 42.52101448883445 0,-84.6287299788221 42.52093680245353 0,-84.62884103279313 42.52052944487289 0))

so I am not quite sure how to use that field to actually re-create the polygon?

 

0 Kudos