topic Re: Batch add field, calculate field as filename in Geoprocessing Questions

Batch add field, calculate field as filename

JasonDaniels — Thu, 02 Jan 2014 20:06:19 GMT

So here is my last and final question and unfortunately my largest hurdle. I have a tonne of shapefiles (4249 to be exact). I have never used a model builder or scripted anything. I need to somehow batch add a field (named RTENO) and assign the shapefile name to that field. The only other option I have is to batch calculate field with file name one at a time over 4000 times. If anyone knows of anything I could do to make this possible it would be a life saver.

Re: Batch add field, calculate field as filename

YichiLiu1 — Sat, 04 Jan 2014 18:29:05 GMT

Hi,

If I were you, I would use model buider and do the following:

1. Use iterator to read the feature classes that you would like to run. While excuting iterator, model builder will generate a system variable (it should originally show up as 'Name' in iterator), which stores the file name.

2. Use Add Field tool to add field.

3. Use Calculate field. This is when you need to use that system variable, use %Name% to get the feature class' name,

http://help.arcgis.com/en/arcgisdesktop/10.0/help../index.html#/A_quick_tour_of_using_iterators_for_iteration_Looping/002w0000001w000000/

Hope this helps!

Re: Batch add field, calculate field as filename

JakeSkinner — Sat, 11 Dec 2021 21:12:59 GMT

Hi Jason,

Here is a script you can run:

import arcpy
from arcpy import env
env.workspace = r"C:\DATA"

for shapefile in arcpy.ListFeatureClasses("*"):
    name = shapefile.split(".")[0]
    arcpy.AddField_management(shapefile, "RTENO", "TEXT")
    arcpy.CalculateField_management(shapefile, "RTENO", '"' + name + '"', "PYTHON")

You will just need to change the 'env.workspace' to the directory path of your shapefiles. Don't forget to include the 'r' before the path.

Re: Batch add field, calculate field as filename

JasonDaniels — Wed, 08 Jan 2014 10:17:51 GMT

Thank you both. This was a huge time saver. Really wish I was more comfortable with scripting tools. The time I could have saved.

Re: Batch add field, calculate field as filename

JakeSkinner — Wed, 08 Jan 2014 10:26:54 GMT

Thank you both. This was a huge time saver. Really wish I was more comfortable with scripting tools. The time I could have saved.

Take a look at the following training courses you can take:

http://training.esri.com/gateway/index.cfm?fa=catalog.webCourseDetail&courseid=2520

http://training.esri.com/gateway/index.cfm?fa=catalog.webCourseDetail&courseid=2114

http://training.esri.com/gateway/index.cfm?fa=catalog.webCourseDetail&courseid=2143

http://training.esri.com/gateway/index.cfm?fa=catalog.courseDetail&CourseID=50131064_10.x

Re: Batch add field, calculate field as filename

DavidMrázek — Thu, 17 Feb 2022 09:32:57 GMT

Hi, i know it's an old conversation but you don't know why it doesn't work for me?

var AL016 = "MS_FT_AL016_T"; var typObjektu = "TYP_OBJEKTU"; var NF103 = "MS_FT_NF103_T"; var NF109 = "MS_FT_NF109_T"; var NF121 = "MS_FT_NF121_T"; var NF127 = "MS_FT_NF127_T"; var NF128 = "MS_FT_NF128_T"; var FTJmeno = "MS_FT_JMENO_P_T"; List<string> names = new List<string>(); names.Add(AL016); names.Add(NF103); names.Add(NF109); names.Add(NF121); names.Add(NF127); names.Add(NF128); names.Add(FTJmeno); foreach (var name in names) { FeatureLayer featureLayer = mv.Map.FindLayers(name).First() as FeatureLayer; FeatureClass fc = featureLayer.GetTable() as FeatureClass; await AddField(fc, typObjektu, "TEXT", "", "", 10); object[] paraList = { fc, typObjektu, '"' + name + '"' }; //always comes NULL in the column await StartATask("management.CalculateField", paraList); }

Re: Batch add field, calculate field as filename

GirijaKalyani — Wed, 19 Apr 2023 04:48:36 GMT

Does this work for Ratsers too?

I don't think, with a few changes, where the feature classes are mentioned, I denoted Rasters - but nothing works!!!

Also, the simple %name% - doesn't work!!