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; } } }

Calculate Field not working in arcpy

SolanaFoo4

Not sure why this statement wouldn't run within an edit session in arcpy:

edit = arcpy.da.Editor(gdb)

edit.startEditing(False, True)

edit.startOperation()

arcpy.CalculateField_management ('Export_Output', 'Point_Type', 'UNKNOWN')

edit.stopOperation()

edit.stopEditing(True)

I am working with a versioned replica in SQL Express. Working on the default version.

Solution: I just ended up using da.UpdateCursor to calculate all recs to 'UNKNOWN'. This worked fine. Was getting strange results otherwise (on small and large datasets).

Najděte více příspěvků označených jako

Accepted answers

RichardFairhurst

Do this for the calculation:

arcpy.CalculateField_management ("swXSectionPoint", "Point_Type", '"UNKNOWN"')

Notice that the expression cannot be "UNKNOWN", it must be '"UNKNOWN"' (single quote, double quote, UNKNOWN, double quote, single quote).

This assumes that swXSectionPoint is a layer recognized by the script and that Point_Type is a field in that layer. There is no bug and support will tell you to write the calculation expression the same as what I have written in this post.

All comments

RichardFairhurst

You forgot the quotes for the expression. It needs to be '"UNKNOWN"' Quotes are always the first thing to check whenever you do calculations, especially when they are run in a script.

SolanaFoo4

So single quotes don't work here?

RichardFairhurst

No, that is not the problem. It is that it must quote a quoted string, since the expression in the normal field calculator must be quoted. "UNKNOWN" is what you should enter in the field calculator outside of a script. Inside a script that quoted string needs to be quoted again to send it as a string value with quotes.

SolanaFoo4

So I did use quotes, but just single quotes to quote the string.

RichardFairhurst

In a script you have to quote the expression regardless of what the value inside it contains (field names, numbers and strings all have to be in quotes). So 'UNKNOWN' equates to an unknown value of UNKNOWN (no quotes) to the field calculator, which does not exist and causes an error. You want to sent "UNKNOWN" (a quoted string), so you have to put that in quotes in the script, i.e., ' "UNKNOWN" ' (works for VB Script or Python calculations) or " 'UNKNOWN' " (works only for Python calculations).

SolanaFoo4

Ah okay! Thank you!

SolanaFoo4

Ah that did it! Support thought it was a bug too, but they realized after looking further that it was a SQL issue. I have no idea how this has not been an issue for me in the past. I don't remember double-quoting my strings.

SolanaFoo4

Interesting finding again, with this function. Tried running:

arcpy.MakeFeatureLayer_management(fc,"cmpl","Material IN ('CMP',' CMP')")

arcpy.CalculateField_management("cmpl","Pipe_Material","'CMP'")

on some sde data unversioned (so no need to start an edit session). It wouldn't run the calculate without error. I had to add what they say is an optional parameter, expression_type: "PYTHON_9.3" to make it run.

RichardFairhurst

I have gotten so used to Python not caring whether I use single quotes or double quotes that I forgot you cannot use single quotes with VB Script. In VB Script you have to write the calculation with escapes. The following works (determined by creating a model and exporting it to a Python script):

arcpy.CalculateField_management("cmpl","Pipe_Material","\"CMP\"")

Since this is not pure Python or pure VB Script it is not always easy to figure out where the Python parser of the script handles quotes and where the VB Script parser of the calculation handles quotes, so I usually build a model and export it to a Python script to get a reliable syntax.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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