topic Re: Append Unsynced Field Map Relational Data Into Dataset in Data Management Questions

Append Unsynced Field Map Relational Data Into Dataset

tiztrain — Mon, 05 Feb 2024 06:49:45 GMT

Hey all,

I have a user that forgot to sync his data from Field Maps and the replicas have been disconnected in the meantime. The service contains a couple of feature classes and 4 tables, everything related to each other.

I have downloaded a copy of the service from AGOL and based on this article Preserving a GlobalID while moving data between Fe... - Esri Community, I have copied the data from this service to a 'Mobile Geodatabase'.

When I try to append the unsynced data, I get the following insert error 000597: Failed to insert input record with FeatureID <value>.—ArcGIS Pro | Documentation.

Looking for the correct methodology to append this data?

Re: Append Unsynced Field Map Relational Data Into Dataset

RhettZufelt — Mon, 05 Feb 2024 21:40:23 GMT

If the replicas are just disabled, but still on the device, you may be able to follow these directions to sync the edits back to the hosted feature service.

Re: Append Unsynced Field Map Relational Data Into Dataset

tiztrain — Tue, 06 Feb 2024 08:25:22 GMT

I have not no problems extracting the data from the mobile device. The problem is appending due to having multiple related feature classes and tables.

Re: Append Unsynced Field Map Relational Data Into Dataset

RhettZufelt — Tue, 06 Feb 2024 15:37:29 GMT

I have only used this with non-related data, but since the directions show a 'sync offline edits' option, thought that it might keep all the relationships if the mobile database is recognized as a 'valid offline dataset'.

Re: Append Unsynced Field Map Relational Data Into Dataset

tiztrain — Tue, 06 Feb 2024 15:50:25 GMT

It keeps the relationships together and that is all fine. The problem is trying to apend it to the original dataset due to the global IDs changing which in turns loses the connectivity between all the tables. Using MGDB is supposed to be the fix as it supports the option to 'preserve global IDs' but I get that error in the original post above

Re: Append Unsynced Field Map Relational Data Into Dataset

tiztrain — Thu, 08 Feb 2024 10:05:53 GMT

If anybody else comes across this problem, you need to make sure that you are only appending values with unique globalid's. If the feature already exists in the original dataset (and you just downloaded a copy), then you must update the already existing feature and filter these existing records out of your append. You will only be appending new features then and it should work.