AnsweredAssumed Answered

Data recovery from SQLite file

Question asked by Curtis.overholt@riotinto.com on Dec 13, 2019
Latest reply on Dec 16, 2019 by j.moore-esristaff

Hi All,

 

I encountered an issue with Survey123 and thankfully been able to extract the SQLite file that contains the data.

 

The survey123 form sent blank information to the feature class and I am hoping to somehow extract this information and import it into the form feature class. I have searched and seen that you can convert to CSV using python with this file 

https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fgithub.com%2Ftedrick%2FReadS123DB 

 

However, my python skills are poor and i'm not sure how to run this file.

 

I can open it up, and see the text but I'm not sure how to correctly set the paths. Does it matter where I store the file? I have the sqlite database just on my C:\Temp 

 

I can see at the top of the file it has these parameters where I believe you should enter your paths, but I'm just not good enough to understand this yet.

 

 

#Constants for easy running
IN_DB = r'./a084e65cd9403d813e8ec667ca329a63.sqlite'
OUT_DIR = r'./out'

 

If my path is C:\Temp 

 

Should this be the edited to this 

 

IN_DB = r'C:/Temp/a084e65cd9403d813e8ec667ca329a63.sqlite' and saved?

 

What about the OUT_DIR ? 

 

Does the file have to be placed somewhere specific ?

 

 

 

Lastly,

 

How do I import that data back to the form?

 

 James Tedrick

Outcomes