topic Re: ArcPy Calculate Field Codeblock Error using VB in ArcGIS Pro Questions

ArcPy Calculate Field Codeblock Error using VB

JosephPilkington1 — Mon, 28 Aug 2023 15:38:41 GMT

Getting an ExecuteError: ERROR 999999: Error executing function. 99.9% positive the error is in my code block. I know, I should use python, but we are keeping the script consistent with VB. For the life of me I cannot see what I am doing wrong. Probably a quotation thing. I have a real problem with that. Lol. Any help is forever appreciated.

# Feature Layer Variable:
TaxParcel_Layer = "TaxParcel_Layer"

# School District Codeblock Variable:

SCHOOLDISTCodeblock = """
Dim X
if ([TaxParcel_INT.SCHOOLDISTNO] = "0091") Then
X = "ALMA CENTER SCHOOL DISTRICT"
elseif ([TaxParcel_INT.SCHOOLDISTNO] = "0476") Then
X = "BLACK RIVER FALLS SCHOOL DISTRICT"
elseif ([TaxParcel_INT.SCHOOLDISTNO] = "0485") Then
X = "BLAIR-TAYLOR SCHOOL DISTRICT"
elseif ([TaxParcel_INT.SCHOOLDISTNO] = "2009") Then
X = "GALESVILLE-ETTRICK-TREMPEALEAU SCHOOL DISTRICT"
elseif ([TaxParcel_INT.SCHOOLDISTNO] = "3428") Then
X = "MELROSE-MINDORO SCHOOL DISTRICT"
elseif ([TaxParcel.SCHOOLDISTNO] = "4186") Then
X = "OSSEO-FAIRCHILD SCHOOL DISTRICT"
elseif ([TaxParcel_INT.SCHOOLDISTNO] = "4368") Then
X = "PITTSVILLE SCHOOL DISTRICT"
elseif ([TaxParcel_INT.SCHOOLDISTNO] = "5460") Then
X = "SPARTA AREA SCHOOL DISTRICT"
elseif ([TaxParcel_INT.SCHOOLDISTNO] = "5747") Then
X = "TOMAH AREA SCHOOL DISTRICT"
elseif ([TaxParcel_INT.SCHOOLDISTNO] = "6426") Then
X = "WHITEHALL SCHOOL DISTRICT"
end if"""

arcpy.CalculateField_management(TaxParcel_Layer, "SCHOOLDIST", "X", "VB", SCHOOLDISTCodeblock)

Re: ArcPy Calculate Field Codeblock Error using VB

DanPatterson — Mon, 28 Aug 2023 17:55:16 GMT

You have posted this in ArcGIS Pro place, hence, supported CalculateField languages include

Python, Arcade, SQL

Calculate Field (Data Management)—ArcGIS Pro | Documentation

Re: ArcPy Calculate Field Codeblock Error using VB

JosephPilkington1 — Mon, 28 Aug 2023 18:00:04 GMT

Any python3 scripting suggestions under this scenario?

Re: ArcPy Calculate Field Codeblock Error using VB

DanPatterson — Mon, 28 Aug 2023 20:09:34 GMT

def school(fld): """specify the field name as""" if (fld == "0091"): X = "ALMA CENTER SCHOOL DISTRICT" elif (fld == "0476"): X = "BLACK RIVER FALLS SCHOOL DISTRICT" elif (fld == "0485"): X = "BLAIR-TAYLOR SCHOOL DISTRICT" elif (fld =="2009"): X = "GALESVILLE-ETTRICK-TREMPEALEAU SCHOOL DISTRICT" elif (fld =="3428"): X = "MELROSE-MINDORO SCHOOL DISTRICT" elif (fld == "4186"): X = "OSSEO-FAIRCHILD SCHOOL DISTRICT" elif (fld == "4368"): X = "PITTSVILLE SCHOOL DISTRICT" elif (fld == "5460"): X = "SPARTA AREA SCHOOL DISTRICT" elif (fld == "5747"): X = "TOMAH AREA SCHOOL DISTRICT" elif (fld =="6426"): X = "WHITEHALL SCHOOL DISTRICT" else: X = "no clue" return X

you can begin with a more literal translation, although there are better data structures that could be used in the code block (eg a dictionary), but this should get you started

Re: ArcPy Calculate Field Codeblock Error using VB

JosephPilkington1 — Tue, 29 Aug 2023 14:02:04 GMT

THANK YOU! Worked like a charm! 🙂