Preserve GlobalIDs with python truncate append

kapalczynski — Fri, 21 Jul 2023 15:01:28 GMT

I have a script that I am trying to truncate and append features from one DB to another... DEV to TEST

The truncate and Append works but I need to preserve the GlobalIDs.

I read that this is what I need to define but the GlobalIDs on the out FC are different than the original ... Again these are in different DBs but same FC name

Note this is an Enterprise Geodatabase....

Any thoughts?

# Set the preserveGlobalIds environment to True arcpy.env.preserveGlobalIds = True

# --Import arcpy module-------------------------------------------------------------------------------------- import arcpy layers_to_Modify = { "Database Connections\\GIS_DEV@gis_data.sde\\GIS_DATA.AAAA": "Database Connections\\GIS_TEST@gis_data.sde\\GIS_DATA.AAAA" } # Set the preserveGlobalIds environment to True arcpy.env.preserveGlobalIds = True def truncateAppendData(): print("Starting to Replace the data") for layer in layers_to_Modify.keys(): fromRelationship = layer toRelationship = layers_to_Modify[layer] try: arcpy.TruncateTable_management(toRelationship) arcpy.Append_management(fromRelationship, toRelationship, "NO_TEST") print("-- append Successful...".format()) except Exception: # Handle errors accordingly...this is generic tb = sys.exc_info()[2] tb_info = traceback.format_tb(tb)[0] # Python 3.x #pymsg = f'PYTHON ERRORS:\n\tTraceback info:\t{tb_info}\n\tError Info:\t{str(sys.exc_info()[1])}\n' #msgs = f'ArcPy ERRORS:\t{arcpy.GetMessages(2)}\n' # Python 2.7 pymsg = 'PYTHON ERRORS:\n\tTraceback info:\t{tb_info}\n\tError Info:\t{str(sys.exc_info()[1])}\n' msgs = 'ArcPy ERRORS:\t{arcpy.GetMessages(2)}\n' print(pymsg) print(msgs) print.error("-- PYTHON ERRORS:\n\tTraceback info:\t{tb_info}\n\tError Info:\t{str(sys.exc_info()[1])}\n".format()) print.error("-- ArcPy ERRORS:\t{arcpy.GetMessages(2)}\n".format()) if __name__ == '__main__': ## Truncate and Append Data truncateAppendData()

Re: Preserve GlobalIDs with python truncate append

kapalczynski — Fri, 21 Jul 2023 15:20:49 GMT

UGGGGGGG my mistake... I was looking at the wrong Feature Class in the Destination... duh.... That code is working fine....

Cheers

Re: Preserve GlobalIDs with python truncate append

kapalczynski — Fri, 21 Jul 2023 15:21:32 GMT

Please REFER to the original post... that code works ....

topic Preserve GlobalIDs with python truncate append in Python Questions

Preserve GlobalIDs with python truncate append

Re: Preserve GlobalIDs with python truncate append

Re: Preserve GlobalIDs with python truncate append