Recover survey data from .sqlite database on mobile device

6947
12
11-06-2017 11:13 AM
SimonAllard2
New Contributor III

https://community.esri.com/thread/183922-download-survey-from-device-after-upload-failed 

Has anyone developed a python script to extract the feature class data from the sqlite database? We had a schema change in a survey which overwrote the data on the hosted layer in ArcGIS Online and we would like to recover the data from the device and append this to the new survey layer.

Thanks for any help,

Cheers,

Simon

12 Replies
SimonAllard2
New Contributor III

Hi Seth,

Thank you for writing this script!

You mentioned that this script needs to be run from an Arc Toolbox. Do you mean a python toolbox or a normal ArcToolbox? I don’t have much experience creating my own script tools and was having some difficulty getting the toolbox to fetch the input and output parameters.

Also, what version of ArcGIS/ArcGIS Pro have you tested this script in?

Any chance you could set this up in an ArcToolbox and package it up in a .zip file?

Cheers,

Simon Allard

GIS Analyst

Bay of Plenty Regional Council Toi Moana

0 Kudos
SethPaine1
New Contributor III

Hi Simon,

I am running the tool in ArcMap 10.6.1 but the version shouldn’t have too much impact unless its really old.

Try copying the file and folder in this zip to the same location and adding to ArcMap. The script may need editing if your .sqlite file format is substantially different than mine.

Cheers,

Seth

Seth Paine

Geographic Information Systems Specialist

Office of Spill Prevention and Response

California Department of Fish and Wildlife

1700 K Street, Suite 250

Sacramento, CA 95811

Office Phone: (916)324-9817

Seth.Paine@Wildlife.ca.gov<mailto:Seth.Paine@Wildlife.ca.gov>

http://www.wildlife.ca.gov/OSPR

0 Kudos
SimonAllard2
New Contributor III

Thank you for your reply Seth. There was no .zip file attached in response. Perhaps you could email me directly at simon.allard@boprc.govt.nz<mailto:simon.allard@boprc.govt.nz>

Here is the error I was getting….

My tool looks like this

What are your input and output data types?

Cheers,

Simon Allard

GIS Analyst

Bay of Plenty Regional Council Toi Moana