Manual Sync with Database using SQLite database from ArcGIS Collector

[BrianHiller]

We are using the ArcGIS Collector on an iPad Air to edit existing features and add new features while disconnected. The application collects the data fine, but we are having issues trying to synchronize with an ArcGIS Server 10.2.2 feature service.

Is it possible to use the file sharing capability through iTunes to copy the the SQLite database off of the iPad and manually synchronize the database with ArcGIS Server and the ArcSDE geodatabase?

Brian

[MichaelDavis3]

ArcGIS 10.3 has a toolbox tool to convert the SQLite .geodatabase file to a FGDB.  Once converted you can add the data to your SDE however you choose.  It's a manual sync, but better than no sync at all.

[847396730]

Thanks for the tip, but I must still be missing something.  Running that tool (runtime to fgdb) still results in delta tables, not the actual data.  The result is identical to the output of Russell's script, so I still have the same question.

[MichaelDavis3]

Strange - every time I've used it the tool produces a geodatabase, and it takes care of merging all the delta  tables together.

Is it possible that your SQLite database was modified after you pulled it from the mobile device?

[847396730]

Well... I'm not doing exactly what is prescribed here.  Our IT does not allow iTunes (but they do issue everyone iPads...).  So, what I'm doing is pulling the sqlite off of the ArcGIS Server.  I was hoping, since the iPad reported a successful sync, that I might find data there.  But I didn't, just the tables I referenced above. 

[MichaelDavis3]

Yeah - that's your problem.

You need to tell your IT department to get over their hang up with iTunes. Pulling the geodatabase off the iPad with iTunes is the ONLY way to recover the data so you can convert it and sync.

Before we started using iOS runtime apps iTunes was a no-go with our IT folks as well... But eventually even they have to wake up to progress.

- Mike