FieldMap: Error in adding input field to field map

AZumwalt

Here is my code:

 

I keep getting the error: "FieldMap: Error in adding input field to field map." This is my first time using field mapping, and I'm a little confused.

 

point="T:/GIS/Projects/GIS/WorkOrderTools/MapDocuments/WorkOrderTesting/Default.gdb/WO"+workOrder+"/point"
consumer="C:/Users/azumwalt.UECOOP/AppData/Roaming/ESRI/Desktop10.4/ArcCatalog/ElectricModel - azumwalt.sde/consumer"

fm_mapname = arcpy.FieldMap()
fm_phasing = arcpy.FieldMap()
fms = arcpy.FieldMappings()

fm_mapname.addInputField(point, "WMMAPNAME")
fm_phasing.addInputField(point, "WMPHASING")

type_mapname = fm_mapname.outputField
type_mapname.name = "esMapName"
fm_mapname.outputField = type_mapname

type_phasing = fm_phasing.outputField
type_phasing.name = "esPhasing"
fm_phasing.outputField = type_phasing

fms.addFieldMap(fm_mapname)
fms.addFieldMap(fm_phasing)

arcpy.Append_management(point, consumer, "", fms, "1")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

AZumwalt

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Work Order Number</SPAN>
workOrder <SPAN class="operator token">=</SPAN> <SPAN class="string token">"1103612"</SPAN>

<SPAN class="comment token"># Name the Append and Target Layer (target layer is named in the ArcGIS Pro Map)</SPAN>
append_layer<SPAN class="operator token">=</SPAN><SPAN class="string token">"T:/GIS/Projects/GIS/WorkOrderTools/MapDocuments/WorkOrderTesting/Default.gdb/WO"</SPAN><SPAN class="operator token">+</SPAN>workOrder<SPAN class="operator token">+</SPAN><SPAN class="string token">"/point"</SPAN>
target_layer<SPAN class="operator token">=</SPAN><SPAN class="string token">"Consumer_SQL02"</SPAN>

fieldmappings <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldMappings<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Like when you manually choose a layer in the toolbox and it adds the fields to grid</SPAN>
fieldmappings<SPAN class="punctuation token">.</SPAN>addTable<SPAN class="punctuation token">(</SPAN>target_layer<SPAN class="punctuation token">)</SPAN>
fieldmappings<SPAN class="punctuation token">.</SPAN>addTable<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Lets map fields that have different names!</SPAN>
list_of_fields_we_will_map <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># list_of_fields_we_will_map.append(( append layer field name, target layer field name)</SPAN>
list_of_fields_we_will_map<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'esMapName'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'WMMAPNAME'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
list_of_fields_we_will_map<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'esPhasing'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'WMPHASING'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
list_of_fields_we_will_map<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'esUplineFeeder'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'FEEDER'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> field_map <SPAN class="keyword token">in</SPAN> list_of_fields_we_will_map<SPAN class="punctuation token">:</SPAN>
    <SPAN class="comment token"># Find the fields index by name.</SPAN>
    field_to_map_index <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>findFieldMapIndex<SPAN class="punctuation token">(</SPAN>field_map<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># Grab "A copy" of the current field map object for this particular field</SPAN>
    field_to_map <SPAN class="operator token">=</SPAN> fieldmappings<SPAN class="punctuation token">.</SPAN>getFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># Update its data source to add the input from the the append layer</SPAN>
    field_to_map<SPAN class="punctuation token">.</SPAN>addInputField<SPAN class="punctuation token">(</SPAN>append_layer<SPAN class="punctuation token">,</SPAN> field_map<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># We edited a copy, update our data grid object with it</SPAN>
    fieldmappings<SPAN class="punctuation token">.</SPAN>replaceFieldMap<SPAN class="punctuation token">(</SPAN>field_to_map_index<SPAN class="punctuation token">,</SPAN> field_to_map<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Create a list of append datasets and run the the tool - the "1" at the end is for the subtype.</SPAN>
inData <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>append_layer<SPAN class="punctuation token">]</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN>inData<SPAN class="punctuation token">,</SPAN> target_layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_TEST"</SPAN><SPAN class="punctuation token">,</SPAN> fieldmappings<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"1"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

So, after changing my code completely, it turns out I had my field names reversed, needed to add "1" as subtype to the Append_management tool, then it worked! I also finally figured out how to post code using the advanced editor button.