topic Re: How to setup BATCH process for my Script. in Python Questions

How to setup BATCH process for my Script.

ChristopherClark1 — Fri, 11 Jan 2013 18:07:26 GMT

Ok, I have the following python script which migrates and maps fields and the values of those fields into a target Feature Class.

# Import arcpy module import arcpy  arcpy.env.workspace = "G:\ChrisGIS\WDFW_NWIFC_EVENT_17100101.gdb" arcpy.env.overwriteOutput = "True"                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 inputFC = "WDFW_CHFA_2HEM_evt_1" targetFC = "WDFW_CHFA_2HEM_evt_olay_1"  dico = {'Permanent_Identifier': 'Permanent_ID',                 'STRM_NAME':        'LLID_STRM_NAME',     'DATE_SRVY': 'SOURCE_DATE',     'SPPCODE': 'SPECRCODE',     'SRC_AGENCY': 'SOURCE_AGENCY',     'SRC_WHO': 'SOURCE_WHO'}      Mapper = GetFieldMappings(inputFC, targetFC, dico) # Process: Append arcpy.Append_management(arcpy.env.workspace+"\\"+inputFC, arcpy.env.workspace+"\\"+targetFC,"NO_TEST",Mapper)

I have several feature classes to run this script on. AN exmaple of the Feature Classes that I need to run my script on are :

WDFW_CCT_2HEM_evt_olay
WDFW_CHFA_2HEM_evt_olay
WDFW_CHMF_2HEM_evt_olay
WDFW_CHSP_2HEM_evt_olay
WDFW_CHSU_2HEM_evt_olay
WDFW_COHO_2HEM_evt_olay
WDFW_DBT_2HEM_evt_olay
WDFW_KOK_2HEM_evt_olay
WDFW_RBT_2HEM_evt_olay
WDFW_SOCK_2HEM_evt_olay

These feature classes are represented in several geodatabases (see image)
[ATTACH=CONFIG]20670[/ATTACH]
I could simply go to each individual geodatabase and run the script for each featureclass in that geodatabase. This however seems redundant and I would like to figure out how to batch my scrip or automate this process. All geodatabases are located in one working directory.

I appreciate any help or advice!

Re: How to setup BATCH process for my Script.

Anonymous User — Sat, 11 Dec 2021 20:33:40 GMT

Yes, you can use the ListWorkspaces().

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//000v0000001w000000

arcpy.env.workspace = r'some\path'
for ws in arcpy.ListWorkspaces("*", "FileGDB"):
    arcpy.env.workspace = ws
    for fc in arcpy.ListFeatureClasses('WDFW*'):
         # paste your code here
         # do stuff

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Fri, 11 Jan 2013 21:21:53 GMT

Will try this evening. Thanks Caleb!

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Fri, 11 Jan 2013 21:55:55 GMT

I messed around with Calebs suggestion and could not get it to work properly.

Notice in my script I have a input FC and a Target FC. In every GDB there will be several paired Input and target FC (1 pair for each species). For example here is a list of FCs found in one gdb. Every inputFC and its targetFC for my script in this gdb would be :

InputFC: ---------------------------TargetFC:

WDFW_CHFA_2HEM_evt_1-------WDFW_CHFA_2HEM_evt_olay_1

WDFW_CCT_2HEM_evt_1--------WDFW_CCT_2HEM_evt_olay_1

WDFW_CHMF_2HEM_evt_1-------WDFW_CHMF_2HEM_evt_olay_1

WDFW_CHSP_2HEM_evt_1-------WDFW_CHSP_2HEM_evt_olay_1

WDFW_COHO_2HEM_evt_1-------WDFW_COHO_2HEM_evt_olay_1

WDFW_KOK_2HEM_evt_1---------WDFW_KOK_2HEM_evt_olay_1

The long way would be to change my workspace each time to the correct GDB then run my script for each InputFC. The list above for example would have me run the script 6 times. Each time I would edit the variables : inputFC and targetFC.

Trying to automate this is proving a nightmare!

Re: How to setup BATCH process for my Script.

Anonymous User — Sat, 11 Dec 2021 20:33:43 GMT

WDFW_CHFA_2HEM_evt_1-------WDFW_CHFA_2HEM_evt_olay_1
WDFW_CCT_2HEM_evt_1--------WDFW_CCT_2HEM_evt_olay_1
WDFW_CHMF_2HEM_evt_1-------WDFW_CHMF_2HEM_evt_olay_1
WDFW_CHSP_2HEM_evt_1-------WDFW_CHSP_2HEM_evt_olay_1
WDFW_COHO_2HEM_evt_1-------WDFW_COHO_2HEM_evt_olay_1
WDFW_KOK_2HEM_evt_1---------WDFW_KOK_2HEM_evt_olay_1

The long way would be to change my workspace each time to the correct GDB then run my script for each InputFC. The list above for example would have me run the script 6 times. Each time I would edit the variables : inputFC and targetFC.

Trying to automate this is proving a nightmare!

If these really are the field names for FCs in each GDB, it can be easy to set the input and targets. Programming the inputs and outputs is a lot easier than you think if the same names exist in each GDB. Try this:

# 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"
for ws in arcpy.ListWorkspaces("*", "FileGDB"):
    arcpy.env.workspace = ws
    for fc in arcpy.ListFeatureClasses():
        if fc[-6:] != 'olay_1':
            inputFC = fc
            targetFC = fc[:-1] + 'olay_1'   
            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))

EDIT: I added the part in red. I forgot to add this when I originally posted the code. This is to exclude the target features when looping through each GDB (since you only need the ones that end in 'evt_1' as inputFC's).

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Sun, 12 Dec 2021 16:30:29 GMT

Thanks for the help Caleb! I cleaned up my gedodatabases, and modified the your script to reflect my changes. Now, in a given GeoDatabase I have File geodatabase tables such as :

WDFW_CCT_2HEM_evt
WDFW_CHFA_2HEM_evt
WDFW_CHMF_2HEM_evt
WDFW_COHO_2HEM_evt
WDFW_KOK_2HEM_evt

These are going to be the InputFC for my field mapping and append processes. Here is the code I am trying to run. I get this error every time and do not understand why. 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_17100101.gdb\WDFW_CCT_2HEM_evt_olay does not exist or is not supported Failed to execute (Append)."

# 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))

Any ideas?

Re: How to setup BATCH process for my Script.

Anonymous User — Sat, 11 Dec 2021 20:33:46 GMT

"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_17100101.gdb\WDFW_CCT_2HEM_evt_olay does not exist or is not supported Failed to execute (Append)."

I think you were almost there. The indentation for the append needed to be in line with the for loop (otherwise it would not create an input and target fc since it was outside the loop where the tables are listed).

So the input will look like this?
WDFW_CCT_2HEM_evt

and the output will look like this?
WDFW_CCT_2HEM_evt_olay

If those are the correct names, this code should work with the corrected indentation.

# 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"):
    arcpy.env.workspace = ws
    listFCS = arcpy.ListTables("WDFW*evt")
    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))

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Sun, 13 Jan 2013 17:45:29 GMT

Thanks for the quick replies Caleb. When I try to run the last script you provided I keep getting a syntax error on line 34 which reads

if inputFC[-5:] != "_olay"

what is the error?

Do I have to exclude the olay files? I do not have any olays in my geodatabases to start, after running the script there will be tables name ***_olay. I thought when I make my FeatureClass.list tables the append will only be run on the values found in that list. If this is the case there are no _olay tables, as they are only created when I run my script. It may seen confusing from the earlier posts b/c I cleaned out all the tables name **_olay.

Re: How to setup BATCH process for my Script.

Anonymous User — Sat, 11 Dec 2021 20:33:48 GMT

Thanks for the quick replies Caleb. When I try to run the last script you provided I keep getting a syntax error on line 34 which reads

if inputFC[-5:] != "_olay"

what is the error?

Do I have to exclude the olay files? I do not have any olays in my geodatabases to start, after running the script there will be tables name ***_olay. I thought when I make my FeatureClass.list tables the append will only be run on the values found in that list. If this is the case there are no _olay tables, as they are only created when I run my script. It may seen confusing from the earlier posts b/c I cleaned out all the tables name **_olay.

No, sorry, that was a mistake by me. I saw that and realized it wasn't necessary and took it out. Your code *should* work once you put the last 3 lines inside the for loop so the code ends like this:

    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))

Re: How to setup BATCH process for my Script.

Anonymous User — Sat, 11 Dec 2021 20:33:51 GMT

Actually, I just realized... If the olay tables do not exist beforehand you will get an error because append works on only existing features. You should use the CreateTable_management tool to create the table first right above the append.

Try this:

# 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"):
    arcpy.env.workspace = ws
    listFCS = arcpy.ListTables("WDFW*evt")
    for inputFC in listFCS:
        targetFC = inputFC +"_olay"   
        Mapper = GetFieldMappings(inputFC, targetFC, dico)
        # Process: Append
        arcpy.CreateTable_management(ws, targetFC))
        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))

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Sun, 12 Dec 2021 16:30:32 GMT

# 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.....

Re: How to setup BATCH process for my Script.

Anonymous User — Sat, 11 Dec 2021 20:33:54 GMT

# 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.....

Look at my last post about creating the table before appending.

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Sun, 13 Jan 2013 18:31:37 GMT

Okay, I added the create table and here are some results

Appended "WDFW_CCT_2HEM_evt" to "WDFW_CCT_2HEM_evt_olay" in WDFW_NWIFC_EVENT_17100102.gdb
Appended "WDFW_CHFA_2HEM_evt" to "WDFW_CHFA_2HEM_evt_olay" in WDFW_NWIFC_EVENT_17100102.gdb
Appended "WDFW_CHMF_2HEM_evt" to "WDFW_CHMF_2HEM_evt_olay" in WDFW_NWIFC_EVENT_17100102.gdb
Appended "WDFW_CHSP_2HEM_evt" to "WDFW_CHSP_2HEM_evt_olay" in WDFW_NWIFC_EVENT_17100102.gdb
Runtime error <type 'exceptions.RuntimeError'>: FieldMappings: Error in adding table to field mappings

How can this error come to pass after a few tables have already been appended?
After I got these results I went into ArcCatalog and check the geodatabase it was working in and there were no _olay tables. I am assuming this is because the script hit the error before it finished?

Re: How to setup BATCH process for my Script.

Anonymous User — Sun, 13 Jan 2013 18:43:01 GMT

Okay, I added the create table and here are some results

Appended "WDFW_CCT_2HEM_evt" to "WDFW_CCT_2HEM_evt_olay" in WDFW_NWIFC_EVENT_17100102.gdb
Appended "WDFW_CHFA_2HEM_evt" to "WDFW_CHFA_2HEM_evt_olay" in WDFW_NWIFC_EVENT_17100102.gdb
Appended "WDFW_CHMF_2HEM_evt" to "WDFW_CHMF_2HEM_evt_olay" in WDFW_NWIFC_EVENT_17100102.gdb
Appended "WDFW_CHSP_2HEM_evt" to "WDFW_CHSP_2HEM_evt_olay" in WDFW_NWIFC_EVENT_17100102.gdb
Runtime error <type 'exceptions.RuntimeError'>: FieldMappings: Error in adding table to field mappings

How can this error come to pass after a few tables have already been appended?
After I got these results I went into ArcCatalog and check the geodatabase it was working in and there were no _olay tables. I am assuming this is because the script hit the error before it finished?

Hmmm...I am not sure, that is a good question! It looks like the code is correct now since it worked on several tables before crashing. Do the other olay tables look okay? Maybe on the table where it crashed on does not have all the same fields in your 'dico' variable? Do you know which table it crashed on? If so, I would look at that table and see if there are differences between that one and the others.

If this is not the case perhaps my only other idea is maybe a schema lock?

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Sun, 13 Jan 2013 19:06:42 GMT

The olay tables that get created only have Object ID field. Nothing else is copying over. Now I am really confused... seems as if the append is not really appending???

Re: How to setup BATCH process for my Script.

Anonymous User — Sat, 11 Dec 2021 20:33:57 GMT

Maybe it would be better to use Merge instead, it also supports field mappings. I also removed the targetFC parameter from the GetFieldMappings() function. Try this:

# Import arcpy module
import arcpy
arcpy.env.overwriteOutput = True
from os import path as p
        
def GetFieldMappings(inputFC, 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"):
    arcpy.env.workspace = ws
    listFCS = arcpy.ListTables("WDFW*evt")
    for inputFC in listFCS:
        outTab = r'in_memory\%s_2' %inputFC
        targetFC = inputFC +"_olay"   
        # Process: Append
        Mapper = GetFieldMappings(inputFC, dico)
        arcpy.CreateTable_management(ws, outTab))
        arcpy.Merge_management([p.join(ws,inputFC),outTab],p.join(ws,targetFC),Mapper)
        print 'Appended "{0}" to "{1}" in {2}'.format(inputFC, targetFC, p.basename(ws))

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Sun, 13 Jan 2013 19:38:06 GMT

Runtime error 'outTab' not defined.

arcpy.Merge_management([p.join(ws,inputFC),outTab],p.join(ws,targetFC),Mapper)

I tried to change it to outTable, and got the same error.

arcpy.Merge_management([p.join(ws,inputFC),outTable],p.join(ws,targetFC),Mapper)

I also removed outTab all together but then I get this error

Runtime error <class 'arcgisscripting.ExecuteError'>: ERROR 000605: Output WDFW_CCT_2HEM_evt_olay already exists within G:\ChrisGIS\COMBO_fishdist_events\WDFW_NWIFC_EVENT_17100102.gdb. Failed to execute (Merge).

Re: How to setup BATCH process for my Script.

Anonymous User — Sun, 13 Jan 2013 19:46:07 GMT

Runtime error 'outTab' not defined.

arcpy.Merge_management([p.join(ws,inputFC), outTab],p.join(ws,targetFC),Mapper)

I tried to change it to outTable, and got the same error.

arcpy.Merge_management([p.join(ws,inputFC), outTable],p.join(ws,targetFC),Mapper)

I also removed outTab all together but then I get this error

Runtime error <class 'arcgisscripting.ExecuteError'>: ERROR 000605: Output WDFW_CCT_2HEM_evt_olay already exists within G:\ChrisGIS\COMBO_fishdist_events\WDFW_NWIFC_EVENT_17100102.gdb. Failed to execute (Merge).

did you set up this variable in the 'in_memory' workspace?

outTab = r'in_memory\%s_2' %inputFC

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Sun, 13 Jan 2013 19:50:25 GMT

I had missed that variable. Once I add it I get another error :

Runtime error <class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000732: Input Datasets: Dataset G:\ChrisGIS\COMBO_fishdist_events\WDFW_NWIFC_EVENT_17100102.gdb\WDFW_CCT_2HEM_evt;in_memory\WDFW_CCT_2HEM_evt_2 does not exist or is not supported Failed to execute (Merge).

I am starting to get pretty lost 🙂

Re: How to setup BATCH process for my Script.

ChristopherClark1 — Sun, 13 Jan 2013 19:53:46 GMT

Wait, I figured out that error also....my bad. Starting to get sloppy and not have the 'sharp eyes'