topic Re: Append feature classes using Python in Python Questions

Append feature classes using Python

EdwardGlover1 — Thu, 05 Jul 2018 13:53:00 GMT

I have 5 point feature classes that I am trying to append into a point feature class. I get the following error when I attempt to run the code shown below:

Failed to execute. Parameters are not valid.
ERROR 000338: Inputs must be either all Feature Classes, Tables or Rasters; not mixed.
Failed to execute (Append).

I can run the append successfully when using the Append tool in Desktop. I am at a loss as to why the code throws the error. Any insight would be very much appreciated.

# Import arcpy module
import arcpy
import os

SDE = r'C:\Development\py1\gis@GISDEV02 frt (emadb51 DC) - VegD2.sde'

# Set local variables
FC_Inven = os.path.join(SDE, 'GIS.VegD_Inventory')
FC_Unit = os.path.join(SDE, 'GIS.VegD_Unit_Inventory')
FC_Hrly2 = os.path.join(SDE, 'GIS.VegD_Hourly_Inventory')
FC_Hrly = os.path.join(SDE, 'GIS.VegD_Hourly')
FC_Flat = os.path.join(SDE, 'GIS.VegD_FlatRate')
FC_Matrix = os.path.join(SDE, 'GIS.VegD_Matrix')
schemaType = "NO_TEST"
fieldMappings = ""
subtype = ""

try:

# Process: Truncate Table
arcpy.TruncateTable_management(FC_Inven)

# Process: Append the feature classes into the empty feature class
arcpy.Append_management('FC_Unit; FC_Hrly2; FC_Hrly; FC_Flat; FC_Matrix', FC_Inven, schemaType, fieldMappings, subtype)

except Exception as err:
print(err.args[0])

Re: Append feature classes using Python

DanPatterson_Retired — Thu, 05 Jul 2018 15:31:30 GMT

have you tried a comma delimited list as inputs rather than a semi-colon delimited string?

The help isn't clear as to what is acceptable

http://pro.arcgis.com/en/pro-app/tool-reference/data-management/append.htm

Re: Append feature classes using Python

EdwardGlover1 — Thu, 05 Jul 2018 15:40:31 GMT

Thanks for the suggestion. I just tried a comma delimited list and got the same error message.

Re: Append feature classes using Python

JoshuaBixby — Thu, 05 Jul 2018 15:59:26 GMT

What about:

arcpy.Append_management( ','.join(FC_Unit, FC_Hrly2, FC_Hrly, FC_Flat, FC_Matrix), FC_Inven, schemaType,    fieldMappings, subtype)‍

Re: Append feature classes using Python

Juan_ManuelAngel_Cuartas — Thu, 05 Jul 2018 16:41:31 GMT

Try to set the arcpy.env.workspace with the SDE path and just call the name of the FC in the list.

Re: Append feature classes using Python

EdwardGlover1 — Thu, 05 Jul 2018 16:56:57 GMT

I tried this and got the following message in the python interpreter: join() takes exactly one argument (5 given)

Re: Append feature classes using Python

EdwardGlover1 — Thu, 05 Jul 2018 17:19:15 GMT

Unfortunately, I get the same error message when I try this approach as well.

Re: Append feature classes using Python

JoshuaBixby — Thu, 05 Jul 2018 17:20:37 GMT

Ah, sorry, forgot to wrap them in a list.

arcpy.Append_management( ','.join([FC_Unit, FC_Hrly2, FC_Hrly, FC_Flat, FC_Matrix]), FC_Inven, schemaType,    fieldMappings, subtype)

Re: Append feature classes using Python

EdwardGlover1 — Thu, 05 Jul 2018 17:40:42 GMT

I get the same error. I am going to copy the 6 feature classes into a fgdb and run the script on it to see if the error persists. Thanks for taking the time to offer some assistance.

Re: Append feature classes using Python

JoshuaBixby — Thu, 05 Jul 2018 17:47:34 GMT

Same error? Did you re-copy and paste my code? The square brackets I added to the code should have made the join error go away. There still may be an error, I am just surprised you are getting a join error still.

Re: Append feature classes using Python

EdwardGlover1 — Thu, 05 Jul 2018 17:59:17 GMT

Sorry for my lack of clarity. The "same error" I was referring to is based on my original post. Your revision did address the argument message when I attempted to run your initial line of code.

Re: Append feature classes using Python

DarrenWiens2 — Thu, 05 Jul 2018 18:34:21 GMT

The help example uses a list for the feature classes, not a delimited string.

Append—Data Management toolbox | ArcGIS Desktop

Re: Append feature classes using Python

DanPatterson_Retired — Thu, 05 Jul 2018 18:56:16 GMT

Darren... already suggested with not diff

https://community.esri.com/message/782971-re-append-feature-classes-using-python?commentID=782971#comment-782971

Re: Append feature classes using Python

EdwardGlover1 — Thu, 05 Jul 2018 18:57:41 GMT

I get the same ERROR 000338 when I copied the feature classes to a fgdb and modified the code to reference it and run it. I then tried using the Append tool and navigating to the fcs within the tool to add them with their entire fgdb path - it ran successfully. I went to the results, right-clicked and copied as code snippet. I took the input and target syntax from that code and replaced my append input and target parameters with it and ran the code - it worked successfully. I repeat these steps with a database connection and was successful.

arcpy.Append_management("'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_FlatRate';'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Hourly';'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Matrix';'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Hourly_Inventory';'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Unit_Inventory'", "C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Inventory", schemaType, fieldMappings, subtype)

I still don't know why when I attempt to clean this line of code up using variables, it results in the ERROR 000338.

Re: Append feature classes using Python

DanPatterson_Retired — Thu, 05 Jul 2018 19:06:42 GMT

perhaps there is some internal workings that handle the punctuation and spaces that isn't activated through arcpy calls to the tool directly

Re: Append feature classes using Python

DarrenWiens2 — Thu, 05 Jul 2018 19:16:02 GMT

Ah, so it was. I thought you meant comma-delimited string. You can't make a list any other way

Re: Append feature classes using Python

EdwardGlover1 — Thu, 12 Jul 2018 12:29:33 GMT

The error was caused by the Append input being interpreted as a string as opposed to variables. Below is syntax that worked for me. Thanks to all for your assistance with my issue!

arcpy.Append_management('"' + FC_Unit + ';' + FC_Hrly2 + ';' + FC_Hrly + ';' + FC_Flat + ';' + FC_Matrix + '"', FC_Inven, schemaType,    fieldMappings, subtype)‍