topic Re: CalculateField_management in Python Questions

CalculateField_management

danielROUFFART1 — Mon, 12 Jul 2021 09:03:00 GMT

Hi everybody,

i need some help about the arcpy expression CalculateField_management.

So wrote a py program to correct some field in a layer.

so wrote my py prog like this


import arcpy


# Recherche de la gdb pour correction

ma_table = R"C:\représentation parcelaire\cadpmm_vierge.gdb"

# rappatriment des champs utilises dans la fonction
expression = "ma_fonction(param_ccogrm=!ccogrm!, param_ddenom=!ddenom!)"
print("environnement charge")
# correction du champ ccogrm
code_block: str = """def ma_fonction(param_ccogrm, param_ddenom):
   if param_ccogrm == 1 and ddenom == "COPROPRIETAIRES DU LOTISSEMENT LE COTEAU":
      return 7
      return None"""
arcpy.CalculateField_management(
    in_table=ma_table,
    field="ccogrm",
    expression=expression,
    expression_type="PYTHON3",
    code_block=code_block
)

so when i execute the program, i've got an error message

Traceback (most recent call last):
File "C:/Users/d.rouffart/PycharmProjects/pythonProject/2021_07_08_ReplaceValue.py", line 60, in <module>
code_block=code_block

can you help me to resolve my problem please. I don't see xhere is the problem .

thanks

Re: CalculateField_management

DanPatterson — Mon, 12 Jul 2021 09:22:53 GMT

code_block =""" def ma_fonction(param_ccogrm, param_ddenom): if (param_ccogrm == 1) and (ddenom == "COPROPRIETAIRES DU LOTISSEMENT LE COTEAU"): return 7 return None """

don't put str = in the code block if you did

Re: CalculateField_management

danielROUFFART1 — Mon, 12 Jul 2021 09:32:21 GMT

thanks for your help,

so i've retired the str in the prog and i've got the same message.

Re: CalculateField_management

HamishMorton — Mon, 12 Jul 2021 09:39:18 GMT

Hi @danielROUFFART1,

You havent specified your table in the line - it is just the path to the geodatabase:

ma_table = r"C:\représentation parcelaire\cadpmm_vierge.gdb"

does it work if you specify the table name?

ma_table = r"C:\représentation parcelaire\cadpmm_vierge.gdb\ma_table"

The formatting of the function also looks a bit strange where you have pasted it to the browser. Might it be safer to use the following?

code_block = """ def ma_fonction(param_ccogrm, param_ddenom): if param_ccogrm == 1 and ddenom == "COPROPRIETAIRES DU LOTISSEMENT LE COTEAU": return 7 else: return None """

Re: CalculateField_management

DanPatterson — Mon, 12 Jul 2021 09:39:29 GMT

so it looks like this now?

import arcpy # Recherche de la gdb pour correction ma_table = R"C:\représentation parcelaire\cadpmm_vierge.gdb" # rappatriment des champs utilises dans la fonction expression = "ma_fonction(!ccogrm!, !ddenom!)" print("environnement charge") # correction du champ ccogrm code_block = """ def ma_fonction(param_ccogrm, param_ddenom): if (param_ccogrm == 1) and (ddenom == "COPROPRIETAIRES DU LOTISSEMENT LE COTEAU"): return 7 return None """ arcpy.CalculateField_management( in_table=ma_table, field="ccogrm", expression=expression, expression_type="PYTHON3", code_block=code_block )

Re: CalculateField_management

danielROUFFART1 — Mon, 12 Jul 2021 11:40:09 GMT

hi HamishMorton

so i try your solution and i've got thie reponse for

# coding: utf-8

import arcpy


# Recherche de la gdb pour correction

ma_table = r"C:\représentation parcelaire\cadpmm_vierge.gdb\proprio"

# rappatriment des champs utilises dans la fonction
expression = "ma_fonction(param_ccogrm=!ccogrm!, param_ddenom=!ddenom!)"
print("environnement charge")
# correction du champ ccogrm
code_block ="""
def ma_fonction(param_ccogrm, param_ddenom):
   if param_ccogrm == 1 and ddenom == "COPROPRIETAIRES DU LOTISSEMENT LE COTEAU":
      return 7
   else:
      return None
"""

arcpy.CalculateField_management(
    in_table=ma_table,
    field="ccogrm",
    expression=expression,
    expression_type="PYTHON3",
    code_block=code_block
)
print("CalculateField ok")

and for response:

"C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python.exe" C:/Users/d.rouffart/PycharmProjects/pythonProject/2021_07_08_ReplaceValue.py
environnement charge
Traceback (most recent call last):
File "C:/Users/d.rouffart/PycharmProjects/pythonProject/2021_07_08_ReplaceValue.py", line 27, in <module>
code_block=code_block
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 5209, in CalculateField
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 5206, in CalculateField
retval = convertArcObjectToPythonObject(gp.CalculateField_management(*gp_fixargs((in_table, field, expression, expression_type, code_block, field_type), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 511, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 160706: Cannot acquire a lock.
Échec de l’exécution de (CalculateField).

Re: CalculateField_management

danielROUFFART1 — Mon, 12 Jul 2021 11:48:08 GMT

thanks for your reply Dan,

but when i try this code it's doesn't work to. i've got a problem whith my code_block..

environnement charge
Traceback (most recent call last):
File "C:/Users/d.rouffart/PycharmProjects/pythonProject/2021_07_08_ReplaceValue.py", line 21, in <module>
code_block=code_block
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 5209, in CalculateField
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 5206, in CalculateField
retval = convertArcObjectToPythonObject(gp.CalculateField_management(*gp_fixargs((in_table, field, expression, expression_type, code_block, field_type), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 511, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 160706: Cannot acquire a lock.
Échec de l’exécution de (CalculateField).

i try to understand where is the problem but when i saw the esri explain i don't see

Re: CalculateField_management

HamishMorton — Mon, 12 Jul 2021 12:20:47 GMT

Okay thats a bit better. Is the feature class open or being edited in any other app? If so try closing those and then run the script again from wherever you are running it. e.g. your IDE.

Re: CalculateField_management

danielROUFFART1 — Mon, 12 Jul 2021 13:03:05 GMT

so i close arcgis pro and i try to start my py with charmPy and i've got that

"C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python.exe" C:/Users/d.rouffart/PycharmProjects/pythonProject/2021_07_08_ReplaceValue.py
environnement charge
Traceback (most recent call last):
File "C:/Users/d.rouffart/PycharmProjects/pythonProject/2021_07_08_ReplaceValue.py", line 21, in <module>
code_block=code_block
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 5209, in CalculateField
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 5206, in CalculateField
retval = convertArcObjectToPythonObject(gp.CalculateField_management(*gp_fixargs((in_table, field, expression, expression_type, code_block, field_type), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 511, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: Échec de l’exécution. Les paramètres ne sont pas valides.
ERROR 000732: Table en entrée: Dataset C:\représentation parcelaire\cadpmm_vierge.gdb\proprio does not exist or is not supported
Échec de l’exécution de (CalculateField).

Process finished with exit code 1

Re: CalculateField_management

HamishMorton — Mon, 12 Jul 2021 14:06:54 GMT

That is odd. I would make sure that your data still exists and that it is a feature class or table.

import arcpy path = r"C:\représentation parcelaire\cadpmm_vierge.gdb\proprio" if arcpy.Exists(path): print("{} exists".format(path)) desc = arcpy.Describe(path) print("Data type is {}".format(desc.dataType)) else: print("{} does not exist".format(path))

Re: CalculateField_management

danielROUFFART1 — Mon, 12 Jul 2021 14:24:21 GMT

Thanks for your help! thank of you i found the error!

i've forget an _ on the way to the gdb.

so now i've got that

"C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python.exe" C:/Users/d.rouffart/AppData/Roaming/JetBrains/PyCharmCE2021.1/scratches/scratch.py
environnement charge
CalculateField ok

Process finished with exit code 0

one more time thanks for your help

Re: CalculateField_management

danielROUFFART1 — Tue, 13 Jul 2021 06:16:45 GMT

so it's like this:

# coding: utf-8

import arcpy

arcpy.env.overwriteOutput = True
# Recherche de la gdb pour correction
ma_table = r"C:\rvierge.gdb\proprio"
# rappatriment des champs utilises dans la fonction
expression = "ma_fonction(!ccogrm!, !ddenom!)"
print("environnement charge")
# correction du champ ccogrm
code_block = """
def ma_fonction(param_ccogrm, param_ddenom):
   if (param_ccogrm == 1) and (ddenom == "COPROPRIETAIRES DU LOTISSEMENT LE COTEAU"):
      return 7

    return None
"""
arcpy.CalculateField_management(
    in_table=ma_table,
    field="ccogrm",
    expression=expression,
    expression_type="PYTHON3",
    code_block=code_block,
    field_type='TEXT'
)
print("CalculateField ok")

Re: CalculateField_management

danielROUFFART1 — Tue, 13 Jul 2021 09:34:02 GMT

hi ! i come back to you because now when i execute the script that's erase all of my field...

i just wanna change the nuber of certain lines of my field not erase...

do you now why the script does that?

 coding: utf-8

import arcpy

arcpy.env.overwriteOutput = True
# Recherche de la gdb pour correction
ma_table = r"C:\representation_parcelaire\cadpmm_vierge.gdb\proprio"
# rappatriment des champs utilises dans la fonction
expression = "ma_fonction(param_ccogrm=!ccogrm!, param_ddenom=!ddenom!)"
print("environnement charge")
# correction du champ ccogrm
code_block = """
def ma_fonction(param_ccogrm, param_ddenom):
   if (param_ccogrm == 1) and (param_ddenom == "COPROPRIETAIRES DU LOTISSEMENT LE COTEAU"):
      return (param_ccogrm == 7)
"""

# return None
arcpy.CalculateField_management(
    in_table=ma_table,
    field="ccogrm",
    expression=expression,
    expression_type="PYTHON3",
    code_block=code_block,
    field_type="TEXT"
)
print("CalculateField ok")

Re: CalculateField_management

HamishMorton — Tue, 13 Jul 2021 11:33:32 GMT

return (param_ccogrm == 7)

should just be:

return 7

unless your field is of text type. In which case it should be:

return str(7)

Also worth checking to make sure your conditions are correct.

Re: CalculateField_management

danielROUFFART1 — Tue, 13 Jul 2021 12:40:09 GMT

thank for your help effectively it's all in Text type so i need to put str in my codeblock?

like:

code_block = """
def getClass(param_ccogrm, param_ddenom):
   if str(param_ccogrm == 1) and str(param_ddenom == "COPROPRIETAIRES DU LOTISSEMENT LE COTEAU"):
       return str(7)
   else:
       return None
"""

Re: CalculateField_management

danielROUFFART1 — Tue, 13 Jul 2021 12:45:31 GMT

ok it'work ! but now it's change all of my ccogrm part with the number 7