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 :