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

Question

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

MitchHolley1 · Answer

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

MichaelRobb · Answer

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

NathalieLambert · Answer

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