laptop and a wrench

Bug

The Field Map parameter in the Append tool does not recognize the matching fields of a layer with editor tracking enabled in ArcGIS Pro.

ArcGIS Pro
Bug ID Number BUG-000157802
SubmittedApril 25, 2023
Last ModifiedJune 5, 2024
Applies toArcGIS Pro
Version found3.1.1
Operating SystemWindows OS
Operating System Version10.0 64 Bit
Version Fixed3.2, 3.1.3
StatusFixed

Additional Information

This issue is addressed in ArcGIS Pro 3.2 and ArcGIS Pro 3.1.3.

Workaround

The following Python script works to enable the editor tracking fields to be append and match the source dataset:

######################################

import arcpy

source = <link to source data>

target = <link to target data>

arcpy.env.preserveGlobalIds = True # can comment out this line if data does not have GlobalIds or if do not wish to preserve GlobalIds

arcpy.TruncateTable_management(target)

myFieldMappings = arcpy.FieldMappings()

myFieldMappings.addTable(target)

for fmi in range(myFieldMappings.fieldCount):

fm = myFieldMappings.getFieldMap(fmi)

 for targetfield_index in range(fm.inputFieldCount):

  intable = fm.getInputTableName(targetfield_index)

  if intable == arcpy.Describe(target).catalogPath:

fm.removeInputField(targetfield_index)

   myFieldMappings.replaceFieldMap(fmi, fm)

   break

    

for fmi in range(myFieldMappings.fieldCount):

fm = myFieldMappings.getFieldMap(fmi)

 targetFieldName = fm.outputField.name

 sourceFieldList = arcpy.ListFields(source,targetFieldName)

 for f in sourceFieldList:

 if (len(sourceFieldList)) > 0:

  sourceField = sourceFieldList[0]

  newFMap = arcpy.FieldMap()

 newFMap.addInputField(source,sourceField.name)

  myFieldMappings.replaceFieldMap(fmi, newFMap)

arcpy.Append_management(source, target, "NO_TEST", myFieldMappings)

Steps to Reproduce

Bug ID: BUG-000157802

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options