Model Builder - Deleting fields in 80+ Files in a folder
5375
3
12-02-2015 09:56 PM
by
by
Not ModelBuilder, but how about a small python script?
I suggest you run the FeatureClassToFeatureClass_conversion once mannualy to see the correct mapping, for example, I ran
The grabbed the python snippet from the results tab
arcpy.FeatureClassToFeatureClass_conversion(in_features="C:/__temp/Pts1_3338.shp", out_path="C:/__temp/test.gdb", out_name="pts1_3338", where_clause="", field_mapping="""PtID "PtID" true true false 5 Short 0 5 ,First,#,C:/__temp/Pts1_3338.shp,PtID,-1,-1""", config_keyword="")
so I could see the field mapping to use in the script. Update the workspace, out FGDB, and the fieldmapping as needed.
import arcpy
import os
# update with the location of you files
arcpy.env.workspace = theWS = r'C:\__temp'
# update with the target FGDB....assumes in same folder as the shapes, change if needed
outFGDB = arcpy.os.path.join(theWS, "test.gdb")
# grabs a list of the shapes
featureClasses = arcpy.ListFeatureClasses()
for fc in featureClasses:
#outfile to be the same name as input, minus the .shp
outfc = fc.strip(".shp")
# field mapping from manual fun....{0} will be the "fc", i.e. the shapfile name
fieldMapping = ("""PtID "PtID" true true false 5 Short 0 5 ,First,#,{0},PtID,-1,-1""".format(fc))
#print ("{0}, {1}, {2}".format(fc, outfc, keepField))
arcpy.FeatureClassToFeatureClass_conversion(fc, outFGDB, outfc, "", fieldMapping, "")
hope this helps. BTW - it will take ALL the shapes from the workspace, so issolate if needed. If one of the files doesn't have the field, the output will add the field, but values will be empty. As always....test on a copy of the files until you get it the way you want.
by
