topic Re: arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation in Python Questions

arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation

RebeccaStrauch__GISP — Fri, 10 Dec 2021 21:31:48 GMT

I'm trying to use arcpy.CalculateField in a script where I'm setting a "short" field to basically "(int(TransSeriesNo) * 100) + !OID!"

I have tried many incarnations of this based on the help docs and various geonet and other threads with no luck. I have success if I hardcode the the first part of the equation (ie. "int('!OID!') + 400") but of course that is not what I want to do. Below are some of the various things I have tried....the error message, if there is one, is in the comment above the set.

by the way, I know I can .format the better ( Curtis Price ) and will, but just trying to get it working first. Thanks for any help

#works
TransSeriesNo = "4"
setNo = (int(TransSeriesNo) * 100)
expression = "int('!OID!') + 400"
arcpy.CalculateField_management("Pts1c", "testID", expression , "PYTHON_9.3")

# doesn't work   NameError: name 'setNo'is not defined
TransSeriesNo = "3"
setNo = (int(TransSeriesNo) * 100)
expression = "int('!OID!') + setNo"
arcpy.CalculateField_management("Pts1c", "testID", expression , "PYTHON_9.3")

# doesn't work   NameError: name 'setNo'is not define
TransSeriesNo = "2"
setNo = (int(TransSeriesNo) * 100)
codeblock = "setNo"
expression = "int('!OID!') + setNo"
arcpy.CalculateField_management("Pts1c", "testID", expression , "PYTHON_9.3", codeblock)

#  doesn't work   NameError: name 'setNo'is not define
TransSeriesNo = "1"
setNo = (int(TransSeriesNo) * 100)
expression = "getPtID(setNo, !OID!)"
codeblock = """def getPtID(setNo, theOID):
    setPtID = int(theOID + setNo)
    return setPtID"""
arcpy.CalculateField_management("Pts1c", "testID", expression , "PYTHON_9.3", codeblock)

Re: arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation

Zeke — Wed, 28 Oct 2015 19:08:28 GMT

I'm going to guess that setNo in expression needs to be formatted somehow. It may just be seen as a string as is.

Re: arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation

IanMurray — Wed, 28 Oct 2015 19:14:51 GMT

Hi Rebecca,

I think in this case you will need to use some type of string formatting since you need to insert the value(an integer) into a string expression.

See below

I have this thread bookmarked as reference for string formatting examples, it gets confusing if you don't use it often.

Python - Select by attributes query issue

Re: arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation

RebeccaStrauch__GISP — Fri, 10 Dec 2021 21:31:51 GMT

Good guess, but I could never figure out the right way. The issues seems to be that I'm mixing a variable or variable calculation with a field value. Although this wasn't what I was going for, it dawned on me, if that was the problem I could just set the field to the variable, then calc it again adding the two fields. That worked.

TransSeriesNo = "9"
setNo = (int(TransSeriesNo) * 100)
arcpy.CalculateField_management("Pts1c", "testID", setNo , "PYTHON_9.3", codeblock)
arcpy.CalculateField_management("Pts1c", "testID", "!testID! + !OID!", "PYTHON_9.3", codeblock)

With an added comment or two in my code, it may not be the most efficient way, but at least I finally got it to calc the values I expected.

Re: arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation

RebeccaStrauch__GISP — Fri, 10 Dec 2021 21:31:53 GMT

Ian, thanks. I had something similar on several occasions, but had the " in the wrong place in the expresison. Below is the basically the code I'll use:

TransSeriesNo = "3"
setNo = (int(TransSeriesNo) * 100)
print setNo
expression = "int('!OID!') + {}".format(setNo)
arcpy.CalculateField_management("Pts1c", "testID", expression , "PYTHON_9.3")

Thanks for the quick help. Been driving my batty for a day. ugh!

Re: arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation

IanMurray — Wed, 28 Oct 2015 19:30:42 GMT

Quite welcome, sometimes making valid expressions like that with python can be a pain, hence why I found myself a reference to go back to. I don't use python quite enough to be fully comfortable with string formatting without a guide.

Re: arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation

RebeccaStrauch__GISP — Wed, 28 Oct 2015 19:41:38 GMT

yes, that link has many good samples. I usually don't have that many issues with the formatting, but what typically worked for me in the past didn't with CalculateField. I'm glad I didn't need to deal with the code block, etc. Anyway, now I have two ways to fix it....yours, which I will use....and my double calc if all else fails.

Re: arcpy.CalculateField_management not passing (variable + !FieldValue!) calculation

curtvprice — Fri, 10 Dec 2021 21:31:56 GMT

I'm trying to use arcpy.CalculateField in a script where I'm
setting a "short" field to basically "(int(TransSeriesNo) * 100) + !OID!"

#  no .format
expr = "(int(" + str(TransSeriesNo) + ") * 100) + !OID!"
# format
expr = "(int({}) * 100) + !OID!".format(TransSeriesNo)
# or, if TransSeriesNo is an integer (1) or string with no decimals ("1"):
expr = "(" + str(TransSeriesNo)  + " * 100) + !OID!)"
# .format:
expr = "({} * 100) + !OID!".format(transSeriesNo)

Hints:

1. The calculate value expression must be entirely a string

2. Field definitions (eg !OID!) are replaced at runtime with the field value for each row at runtime 'in data type' (!OID! will be integer and doesn't need an int() around it, and a string field would not need quotes around it for its to be recognized as a string). For example:

expr = "!CITY! + ' ' + !STATE! + ' ' + !ZIP!"