nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Add/Calculate Field within a python script

AlexGole1

Hi all,
I am trying to build a tool in python that selects by location, copy to new feature class, add a field to the new feature class, and calculate the field that was just added in the script. The first part of the script works well, however it stops working when adding field/calculating field. I am not quite sure why...
The error is: ERROR 000728 on CalculateField: Field Does not exist. In my script I specifically added a python line to add a line.
What lines in this script are wrong (adding field or calculate field, both?)
Thanks,
Alex

PS: The calculate field first purpose was to do the following: the field "Update" = "arcpy.GetParameter(3)" (the text will be entered by the tool user.

CNDDB_new_5.py.zip

Vind meer berichten getagd met

Accepted answers

curtvprice

Thank you! It seems like the script is running better now. However, I still come back to my first error. ERROR 00728: Field Update does not exist within table... I am not sure why because the two lines before calculating the field were specifically written to create this field...

My guess is the field name "Update" was not legal for that workspace/table type, so the field name got saved as something legal like "UPDATE_". (UPDATE is a reserved word in SQL.)

If I try to add a field to a fGDB table with this name interactively, I get a warning:

WARNING 000304: Renamed field Update to Update_ Adding Update_ to sampcells_RotateFeatures...

See the help for arcpy.ValidateFieldName for more details on how to deal with that.

All comments

curtvprice

You're welcome!

Can you point me the ESRI web help for the field calculator used in python script.
For instance, I never saw this in any help document before:

Expression = "'{0}'".format(arcpy.GetParameterAsText(3))

This is a Python thing. Although there are three main ways to do string formatting in Python, the format() function is current way to do it.

Python Tutorial: 7.1. Fancier Output Formatting

AlexGole1

Thanks!!! It works like a charm now!
Just for future reference, can you point me the ESRI web help for the field calculator used in python script.
For instance, I never saw this in any help document before:

"'{0}'".format(arcpy.GetParameterAsText(3))

Thanks again

curtvprice

Thank you! It seems like the script is running better now. However, I still come back to my first error. ERROR 00728: Field Update does not exist within table... I am not sure why because the two lines before calculating the field were specifically written to create this field...

WARNING 000304: Renamed field Update to Update_ Adding Update_ to sampcells_RotateFeatures...

See the help for arcpy.ValidateFieldName for more details on how to deal with that.

AlexGole1

Thank you! It seems like the script is running better now. However, I still come back to my first error. ERROR 00728: Field Update does not exist within table... I am not sure why because the two lines before calculating the field were specifically written to create this field...

curtvprice

I think your Expression variable should actually be:
Expression = '"Update" = ' + "'" + arcpy.GetParameter(3) + "'"

Or better yet, use Python string formatting - easier to get the syntax right. The expression just has to be the part that you would have typed into the Calculate Field dialog -- "Update = " is handled by putting your field UpdatedField in the second argument.

The error is: "cannot concatenate 'str' and 'geoprocessing value object' objects".

I also recommend using arcpy.GetParameterAsText unless you have a special reason for needing to use GetParameter (value tables etc). The text representation is usually much easier to work with, as you have discovered.

I moved the message first because it makes sense to say what you're about to do before you do it...

# Add Field
arcpy.AddMessage("Adding Updated Field...") 
arcpy.AddField_management(Selected_cnddb_point, UpdatedField, "TEXT", "", "", "50","", "NULLABLE")


#Calculate Field
arcpy.AddMessage("Calculating Updated Field...")
Expression = "'{0}'".format(arcpy.GetParameterAsText(3)) # single quoted string literal
arcpy.CalculateField_management(Selected_cnddb_point, UpdatedField, Expression, "PYTHON")

AlexGole1

Thanks for your quick answer. I just tried your line. The positive thing is that i get a different error. The error is: "cannot concatenate 'str' and 'geoprocessing value object' objects".
I am not sure how else I could possibly calculate this field...

Lucas Danzinger

I think the issue is with your Expression variable. Here is what you have:

UpdatedField = "Update"
Expression = (" = " + "'" + arcpy.GetParameter(3) + "'")
arcpy.CalculateField_management(Selected_cnddb_point, UpdatedField, Expression, "PYTHON")

If your user entered parameter was "hello", the expression would be: ='hello' and not: "Update" = 'hello'.

I think your Expression variable should actually be:

Expression = '"Update" = ' + "'" + arcpy.GetParameter(3) + "'"

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.