topic Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed in ArcGIS Pro Questions

Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

BenVan_Kesteren1 — Mon, 29 Oct 2018 05:13:38 GMT

I have a Rubbish_Bins feature class in my SDE, this has GlobalID (type is Global ID) column as per below screenshot:

You can see all the global ID's are populated.

I then run the Copy Rows tool in Arc Pro (right click | data | export table):

I open this CSV and I note the global ids are all removed, yet all other columns are populated.

I then tried testing this in ArcMap 10.6.1

I open the attribute table, click export, then use these settings:

Then i get this error:

Note this error is only happening on this feature class (its the only one I have added GlobalID to).

Am I doing something wrong here or is this a bug?

Thanks

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

Asrujit_SenGupta — Mon, 05 Nov 2018 10:40:34 GMT

To confirm that, just add GlobalID to some other data and test the same workflow. Could be data specific (or maybe not)

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

BenVan_Kesteren1 — Mon, 05 Nov 2018 21:59:16 GMT

I have spoken with ESRI and they have confirmed this is a bug in the tool, and hopefully is rectified in the future.

Cheers

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

Asrujit_SenGupta — Tue, 06 Nov 2018 03:46:33 GMT

Maybe just share the Bug details here, for reference, in case someone else comes across the same issue.

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

BenVan_Kesteren1 — Tue, 06 Nov 2018 04:52:39 GMT

I can see the bug is logged in my.esri.com support page, it says "#BUG-000117958 GlobalID's are set to zero when using Copy Rows tool in ArcGIS Pro with data coming from an Enterprise SQL Server Geodatabase"

I am unsure how to link it here? How do I find it for others to see?

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

Asrujit_SenGupta — Tue, 06 Nov 2018 05:37:56 GMT

It doesn't seem that there is a public link to share yet. Normally you can search for Bugs here: Esri Support Home

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

JeanineEGS — Wed, 08 Sep 2021 06:48:47 GMT

I just got this as well.

Export from Arc Pro filegdb export table to csv in a folder and global-id s all go Zero.

If I export to .dbf then they are preserved.

I need to csv to append /update new data in AGOL and wanted to preserve the Global_ID.

Any news on the fix?

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

JessicaJThompson — Fri, 01 Oct 2021 18:28:27 GMT

I am wondering the same thing. It is still doing this as of today - October 2021.

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

Anonymous User — Mon, 11 Jul 2022 17:41:25 GMT

Still occurring on July 11, 2022

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

MatthewCriel — Fri, 02 Dec 2022 19:22:14 GMT

ESRI... Its time to fix this!

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

Robert_LeClair — Fri, 02 Dec 2022 22:28:49 GMT

Matthew - I pulled up BUG-000117958 and it's listed as "under review." As I do not work for Support Services or the ArcGIS Pro team (I work in Training Services), I do not know when it will be fixed. The proposed workaround is to use the Table to Excel GP tool. That's all I've been able to find. Not great news I know, but news nevertheless.

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

RobertTaylor5 — Thu, 29 Dec 2022 22:18:19 GMT

I have this problem when using Export function from within attribute table in ArcGIS Pro 2.9.5. Global ID field is definitely set in the table, but the exported *.csv file has null data.

And why is it when someone notes that this is already been logged as a BUG does the problem get marked as SOLVED in this forum?

This problem is years old and still not solved!

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

RobertTaylor5 — Thu, 29 Dec 2022 22:19:54 GMT

Wondering why this is marked as solved when this bug persists years later.

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

JessicaJThompson — Fri, 30 Dec 2022 13:24:19 GMT

Hello @RobertTaylor5,
Yes. It is very frustrating....

My work-around that I have used a few times is I create a new field GlobalID_copy. Calculate the field to = the GlobalID field. Then when you export to xls/csv they do not get deleted and you can copy and paste them back into the GlobalID column.

Excessive but it does get the job done.
Hope it helps!

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

RobertTaylor5 — Fri, 30 Dec 2022 17:47:40 GMT

Thanks Jessica. I tried a different workaround: I exported the table as a dbf instead of csv and then just changed the dbf extension to csv. For some reason, the Global ID is correctly exported in that case.

But enough with workarounds!

Esri. Are you listening? How about fixing this???

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

Becca_ — Tue, 05 Sep 2023 15:49:11 GMT

This is still a problem in 2023?? 5 years later..

Re: Exporting Feature Class with GlobalID from Enterprise SDE to a table, globalID's are removed

Robert_LeClair — Wed, 13 Sep 2023 20:14:44 GMT

@KoryKramer - do you know if there's an update to this BUG-000117958 - it's listed Under Review. Thx!!!