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
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 ?
How do I import that data back to the form?