topic Re: How to automate an ID (Guid or sequence) without using the ArcMap Calculate Field in Data Management Questions

How to automate an ID (Guid or sequence) without using the ArcMap Calculate Field

NathalieLambert — Fri, 06 Sep 2013 11:42:44 GMT

I found many exemples on how to calculate a field that contain an ID (sequence or GUID), but it was always with the field calculator, which means that it is calculed on time for all records.

What I'd like to do is, that everytime we create a new record, the ID field is automatically calculated.

Any Idea on how to do it ? Do I need to do a class extension ?

Thank you,

Nathalie

Re: How to automate an ID (Guid or sequence) without using the ArcMap Calculate Field

DuncanHornby — Fri, 06 Sep 2013 15:43:54 GMT

I'm guessing you need your developer to create an extension that listens out for "on create of Feature" events. Look at the IEditEvents interface. This has an event handler that captures the on create of feature event which you could insert code to generate an ID in your field.

Duncan

Re: How to automate an ID (Guid or sequence) without using the ArcMap Calculate Field

ForrestJones — Mon, 09 Sep 2013 15:18:05 GMT

You could maybe use a globalid (a guid maintained by the geodatabase) or a trigger in the database if using sde...

Some info from the help:

ArcGIS field data types

Inserting a value into a global ID or GUID column in SQL Server using SQL

Re: How to automate an ID (Guid or sequence) without using the ArcMap Calculate Field

ThomasColson — Thu, 12 Sep 2013 11:43:21 GMT

If you're using an enterprise geodatabase, e.g. MS SQL, you could set the field type to uniqueidentifier, and default it to newid() or newsequentialid(). THen write an instead of insert trigger, including ALL columns EXCEPT for the GUID column.

Re: How to automate an ID (Guid or sequence) without using the ArcMap Calculate Field

NathalieLambert — Thu, 12 Sep 2013 12:59:53 GMT

In fact, I'm using ArcSDE with an Oracle Database (ArcGIS 10.0).

I first used a GloablID, because it allows me to create a unique ID, but then I read, that I cannot import a GlobalID in an other table; this is why a change my mind about GlobalID.

If I use a field of GUID Type, it is not automatically calculed. I can only calculated it with the field Calculator.

I'd love to use a trigger to calculated my ID, but I don't know how I can create a trigger in an ArcSDE database.

Thank you,

Nathalie

Re: How to automate an ID (Guid or sequence) without using the ArcMap Calculate Field

MichaelRobb — Wed, 19 Oct 2016 22:07:10 GMT

Hi Nathalie,

I know this is an old posting but I want to help others that may come across this...

There are many ways to copy and load records into a new table in a new geodatabase and preserve GlobalID Values.

1. When copying data in ArcGIS, copy and paste, data extraction and XML workspace import preserves the GlobalID Values.

2. ArcObjects: on an unversioned SDE Geodatabase, you can convert the gloablID to a GUID field... then import the data... then convert the GUID back to the GloablID field.

3. ArcObjects: on an unversioned SDE Geodatabase...Using DataChangesImporter to monitor delta and preserve GlobalIDs.

4. In ArcGIS Pro: Preserve GlobalIDs. - Python

ref: Preserve Global IDs (Environment setting)—Geoprocessing | ArcGIS for Desktop

Re: How to automate an ID (Guid or sequence) without using the ArcMap Calculate Field

MitchHolley1 — Thu, 20 Oct 2016 15:21:06 GMT

You can do it in Python with the UUID module. See here: UUID objects — Python 2.7.12 documentation