topic Re: Preserving Global IDs with ArcPro 3.2 Append in ArcGIS Pro Questions

Preserving Global IDs with ArcPro 3.2 Append

ZachBodenner — Wed, 10 Jan 2024 17:40:31 GMT

Hello,

I've been having some trouble using the updated append tool since upgrading to ArcPro 3.2. So I have a feature class (A) that I am migrating to a new feature class (B). A has global IDs enabled, which are required for photo attachments and a related table, and so B feature class must have them enabled as well. I set up Feature Class B and enabled Global IDs.

Okay, so now when I go to append features from A and use the field mapper, GlobalID is one of the mappable field. If I run the append by filling out the GlobalID field, the correct Global ID does not get written in to dataset B - it's just a new GlobalID

I discovered this after my initial workflow failed: I went into the environment settings and selected Preserve GlobalIDs and then left the field map option blank. But that results in the Global ID of feature class B being written as 000-...

Which, if I'm appending more than one feature, will fail on the second feature because it's trying to write the same value to all the records.

What am I missing? Prior to 3.2 I was able to do work like this with no issues at all.

Re: Preserving Global IDs with ArcPro 3.2 Append

DanPatterson — Wed, 10 Jan 2024 20:17:02 GMT

not sure if this is related

BUG-000156786 for ArcGIS Pro (esri.com)

Re: Preserving Global IDs with ArcPro 3.2 Append

ZachBodenner — Wed, 10 Jan 2024 20:24:44 GMT

Possible, though after doing more testing the solution is that both options need to be enabled - that is, in the field mapper you need to set Global ID from B to equal Global ID from A and also the environment setting needs to be set to preserve Global IDs. Seems counterintuitive that it should be the case, but I'm back off and running so I'll take it!

Re: Preserving Global IDs with ArcPro 3.2 Append

StefanBrandt — Thu, 29 Feb 2024 13:57:14 GMT

Pardon me, but could you elaborate on your solution? I have run into the same issue as you described in your original post, but have been unable to solve it.

Re: Preserving Global IDs with ArcPro 3.2 Append

ZachBodenner — Thu, 29 Feb 2024 14:30:15 GMT

Absolutely! I will illustrate with pictures:

Attempt 1: I use the field mapper to make sure that the GlobalID from my input dataset is being written into the GlobalID of my Target Dataset. I leave the environment setting "Preserve Global IDs" unchecked:

When I do that, you can see that the GlobalID is not actually written in correctly:

Attempt 2: As above, except this time in addition to matching GlobalID from the Input to GlobalID from the Target, I also make sure the environment setting is checked on too:

The result is now what we're looking for, the Global IDs are written in correctly.

Re: Preserving Global IDs with ArcPro 3.2 Append

DanPatterson — Thu, 29 Feb 2024 14:48:24 GMT

Tool environment settings should take precedence over any other setting set elsewhere.

I couldn't find a global setting for preserving global ids in the project, options, settings under geoprocessing or editing or elsewhere

Re: Preserving Global IDs with ArcPro 3.2 Append

ZachBodenner — Thu, 29 Feb 2024 15:03:50 GMT

Yes it definitely should, though as I mentioned in the original post, when I had the field map Global-to-Global not set, but the tool environment Preserve Global IDs toggled on, I was getting a tool failure.

Re: Preserving Global IDs with ArcPro 3.2 Append

DanPatterson — Sun, 03 Mar 2024 18:00:11 GMT

BUG-000156786 for ArcGIS Pro (esri.com)

it now says In Product Plan dated Feb 12, 2024, so I presume for 3.3

Re: Preserving Global IDs with ArcPro 3.2 Append

LMedeirosUI — Wed, 03 Apr 2024 21:52:47 GMT

@ZachBodenner Could you post a screenshot of your parameters and field mapping? I am having the same issue, but can't figure out the correct settings to make it work for me.

Also - what type of portal are you using? AGOL? Enterprise? I am trying to use tables hosted on AGOL and wonder if that is an issue.

Thanks!

Re: Preserving Global IDs with ArcPro 3.2 Append

LMedeirosUI — Wed, 03 Apr 2024 21:53:18 GMT

@DanPatterson Does this link still work for you? I am getting a 404 page...

Re: Preserving Global IDs with ArcPro 3.2 Append

DanPatterson — Wed, 03 Apr 2024 23:17:04 GMT

It appears to be gone now

Re: Preserving Global IDs with ArcPro 3.2 Append

ZachBodenner — Thu, 04 Apr 2024 14:45:59 GMT

I just marked my comment on page 1 as the solution since that got it working for me. There are pictures to illustrate the parameters so hopefully that helps you.

These are all database feature classes in Pro, so if you're doing it online in some fashion, that'd be a different environment and might cause different behavior.

Re: Preserving Global IDs with ArcPro 3.2 Append

LMedeirosUI — Fri, 12 Apr 2024 19:04:45 GMT

@ZachBodenner I saw the pictures, but I was hoping for a screenshot of what you did in the field mapping dialog box (see attached screenshot) to "set" GlobalID of B to be equal to the GlobalID of A. By default, that's what mine is set to but I wanted to see if I was missing something.

For the second question, I was asking if you were using a local FGDB or accessing the feature classes via a portal (e.g., accessing a database/feature class stored in AGOL).

I'm also trying to do this in a related table... which makes it different, but I think it should work the same? Who knows - appending data while preserving GlobalIDs and maintaining attachments seems to be an ongoing problem for esri.

I am currently using this workaround: https://mediaspace.esri.com/media/t/1_pnnrcvlp, but it's a pain --and-- I don't seem to be able to remove a join and keep the copied data (steps 6 and 7 in the text below the video) if using layers accessed via the portal. Instead, for me, the layer being copied from has to be local.

Re: Preserving Global IDs with ArcPro 3.2 Append

ZachBodenner — Fri, 12 Apr 2024 19:15:33 GMT

Ah I see what you're saying, no it looks like you have it set up correctly. Here's mine:

I've done mine in local FGDBs and also our primary Enterprise Geodatabase. Nothing online. When you say you're doing it in a related table, are you trying to migrate an entire parent AND child dataset (ie. feature class and related table)? Whether it's a table or a feature class shouldn't make a difference.

Re: Preserving Global IDs with ArcPro 3.2 Append

LMedeirosUI — Mon, 15 Apr 2024 18:05:39 GMT

@ZachBodenner Not an entire parent and child dataset - just a subset of each (separately) as new data is entered.

The "original" data is uploaded as a result of the entire sampling process, then I narrow it down and import data from another source for my experience page. The original data has pictures associated with it that I do want for the experience page, but the "preserve GlobalID" option not working has really made the process more difficult. It'd only have to work for the feature class, really. Then I could append the related table data from the "original" related table (without preserving the GlobalIDs from the "original" related table) and everything would/should work.

The hosted layers not working for the workaround is just an extra pain. Doable, but exporting a new FGDB whenever I want to update the feature class and table for the experience page slows the process down as it's a big dataset with attachments.

Oh well, sounds like I wasn't missing anything. Thanks for your help.

Re: Preserving Global IDs with ArcPro 3.2 Append

NguyenBang123 — Thu, 11 Jul 2024 09:39:28 GMT

Hi ZachBodenner ,

Did you run append and keep GlobalID with FGDB or Enterprise Geo, because as I know File geodatabases don't support unique attribute indexes so can not run tool with Global ID check?

I try to use but get Error

Re: Preserving Global IDs with ArcPro 3.2 Append

ZachBodenner — Thu, 11 Jul 2024 13:10:57 GMT

I used an egdb. Do both of your feature classes here have GlobalIDs enabled? If they do but you're still getting that error, I'd check to be sure there is a unique index?

Re: Preserving Global IDs with ArcPro 3.2 Append

NguyenBang123 — Fri, 12 Jul 2024 08:00:41 GMT

Hi, I run to append from FGDB to EGDB on oracle it work well, but if I run to append for FGDB to FGDB, it failed.

Because I find some one ask some issue and reason is FGDB not support Unique Index

Unique and ascending indexes are not supported for shapefiles or file geodatabases. These parameters are ignored when the tool is run on a shapefile or on file geodatabase data

I try to Add attribute index to GlobalID field but it still set value is "NO", it make tool run failed

I run in ArcGIS Pro 3.3 and want to know did you test okie with FGDB or not, I really thankful for your feedback

Re: Preserving Global IDs with ArcPro 3.2 Append

PeterMilenkovic — Wed, 18 Dec 2024 02:11:36 GMT

so glad I found this post...

writing a script to append data downloaded from agol (feature with attachments) to feature classes in our sde. was messing around with search/insert cursors with no success. enabling preserve gobalids was a far simpler solution.