topic Re: ArcPad 10 synchronization using disconnected workflow in ArcPad Questions

ArcPad 10 synchronization using disconnected workflow

NickHarrison — Wed, 08 Sep 2010 20:56:58 GMT

I am investigating using ArcPad 10 in the following situation:

Data edits are disconnected
Source data is versioned Oracle ArcSDE Geodatabase

When an existing feature is edited, how is that edit synchronized upon checkin?

Since there is no primary key in the geodatabase does the synchronization rely on an added GUID column? (That is how CartoPac does it). You can't rely on the ObjectID. I can't find this info in the ArcPad help libray.

Re: ArcPad 10 synchronization using disconnected workflow

EricHajek1 — Thu, 09 Sep 2010 15:05:27 GMT

Admittedly, I don't have much experience with this, but I believe this is how it works, and maybe someone with more familiarity with it will comment:

You check out from a versioned SDE database, and add a feature. The feature has (as well as all checked out editable features) a new UID called AXF_ObjectID (you can see these in the Feature Tables in ArcPad Studio) which performs the function of a UID while the data is checked out. The existing ObjectID will either remain the same, or be blank in the case of a new feature. When the edits are checked back into your version, the features are given new ObjectIDs that mesh with the ObjectIDs in that version. Subsequently checking in that version into the base SDE version will of course compare those ObjectIDs to the existing ObjectIDs where you have to edit them via the reconciliation process as usual if you have duplicates. (I don't know that you have to edit them, the reconciliation process might be aware enough to figure it out on its own, I don't work with SDEs much.)

I believe ESRI recommends a seperate version for each ArcPad checkout you want to have simultaneously so that the ObjectID issue is handled through the conflict detection process.

Hope this helps,
Eric

Re: ArcPad 10 synchronization using disconnected workflow

NickHarrison — Thu, 09 Sep 2010 15:39:36 GMT

Eric,

Thanks for the feedback.
That's really interesting. Is this documented anywhere?

I certainly don't like the idea of having to keep a version going (effectively with a long transaction) for each ArcMap field editor. And I don't like relying on the ObjectID (which can change). I have experienced ObjectID changes so I know it can happen.

Nick

Re: ArcPad 10 synchronization using disconnected workflow

NickHarrison — Thu, 09 Sep 2010 15:50:20 GMT

For those who don't believe me about the ObjectIDs changing check out this blog:

http://eaglemap.com/blog/bid/45781/GUIDs-as-EventIDs-in-APDM-PODS-ESRI-Spatial-Geodatabases