arcpy.Append_management from FGDB to SDE

Question

Hello everyone,

I need to append a polygon layer located in a FGDB to the same layer located in SDE.

arcpy.Append_management(FGDB__Layer, SDE_Layer , "TEST", "", "")  fails because the structure is not the same. Polygon layers in FGDB have 2 additional fields SHAPE.AREA and SHAPE.LENGTH

I need to use "NO_TEST" on the schema_type

arcpy.Append_management(FGDB__Layer, SDE_Layer , "NO_TEST", ??????, "")

How do I create the field_mapping list?

Thanks

EliasJörholt · Answer

Jose you are a genious!

This is the easiest solution if the fieldnames are the same in both tables!

JoseSanchez · Answer

This is what  I did and it works:

fieldmappings = arcpy.FieldMappings()
 fieldmappings.addTable(FGDBLayer)
 fieldmappings.addTable(SDELayer)

arcpy.Append_management(FGDBLayer, SDELayer, "NO_TEST", fieldmappings, "")

LukeWebb · Answer

Hi, Theres some stuff about field maps here also that may help you!

https://community.esri.com/thread/185431-append-tool-and-field-mapping-help-examples