# Import arcpy module
import arcpy
arcpy.env.overwriteOutput = True
from os import path as p
def GetFieldMappings(inputFC, targetFC, dico):
field_mappings = arcpy.FieldMappings()
field_mappings.addTable(inputFC)
for input, output in dico.iteritems():
field_map = arcpy.FieldMap()
field_map.addInputField(inputFC, input)
field = field_map.outputField
field.name = output
field_map.outputField = field
field_mappings.addFieldMap(field_map)
del field, field_map
return field_mappings
#Variables
dico = {'Permanent_Identifier': 'Permanent_ID',
'STRM_NAME': 'LLID_STRM_NAME',
'DATE_SRVY': 'SOURCE_DATE',
'SPPCODE': 'SPECRCODE',
'SRC_AGENCY': 'SOURCE_AGENCY',
'SRC_WHO': 'SOURCE_WHO'}
arcpy.env.workspace = r"G:\ChrisGIS\COMBO_fishdist_events"
for ws in arcpy.ListWorkspaces("*", "FileGDB"):
listFCS = arcpy.ListTables("WDFW*evt")
arcpy.env.workspace = ws
for inputFC in listFCS:
targetFC = inputFC +"_olay"
Mapper = GetFieldMappings(inputFC, targetFC, dico)
# Process: Append
arcpy.Append_management(p.join(ws,inputFC), p.join(ws,targetFC),"NO_TEST",Mapper)
print 'Appended "{0}" to "{1}" in {2}'.format(inputFC, targetFC, p.basename(ws))
After running this script I am again getting this error :Runtime error <class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000732: Target Dataset: Dataset G:\ChrisGIS\COMBO_fishdist_events\WDFW_NWIFC_EVENT_17100102.gdb\WDFW_CCT_2HEM_evt_olay does not exist or is not supported Failed to execute (Append).I feel like I am close, but I do not understand why WDFW_NWIFC_EVENT_17100102.gdb\WDFW_CCT_2HEM_evt_olay cannot be found when it is supposed to be created. This is also the 2nd geodatabase in my list, so it seems like it goes through WDFW_NWIFC_EVENT_17100101 without generating any errors.....
