Haha, I am a man indeed. I think I know why you got an error. We actually do need to include a test to exclude those tables that end in '_olay' because it will keep looping through the ws (as new tables are created) and create tables that end in '_olay_olay' etc. These tables will cause an error since they will not have the original field names in them when they get passed into the GetFieldMappings().Also, we needed to have a dummy template just so that the append tool would work properly. When the field names don't match you have to use NO_TEST, as you already knew, but the fields will not be appended if they do not already exist in the table and the fields that are matched through the field map would not actually be inserted into the table. Essentially you would be appending the fields to a table with only an OID field which will not work. This was a tricky one though. I had never worked with field mappings before. Here is the optimal solution:
# Import arcpy module
import arcpy, sys, traceback
arcpy.env.overwriteOutput = True
from os import path as p
def GetFieldMappings(fc_in, fc_out, dico):
field_mappings = arcpy.FieldMappings()
field_mappings.addTable(fc_in)
for input, output in dico.iteritems():
field_map = arcpy.FieldMap()
field_map.addInputField(fc_in, 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'}
template = r'C:\gdblooptest\template\template.gdb\Template_table'
arcpy.env.workspace = r"G:\ChrisGIS\COMBO_fishdist_events"
for ws in arcpy.ListWorkspaces("*", "FileGDB"):
arcpy.env.workspace = ws
listFCS = arcpy.ListTables()
for inputFC in listFCS:
if not inputFC.endswith('_olay'):
targetFC = inputFC +"_olay"
# Process: Append
if arcpy.Exists(targetFC):
arcpy.Delete_management(targetFC)
print 'deleted %s' %targetFC
arcpy.CreateTable_management(ws, targetFC, template)
Mapper = GetFieldMappings(inputFC, targetFC, dico)
arcpy.Append_management(inputFC,targetFC,'NO_TEST',Mapper)
print 'Appended "{0}" to "{1}" in {2}'.format(inputFC, targetFC, p.basename(ws))
print 'done'
