topic Re: CalculateField_management on table name with accent don't work in Python Questions

CalculateField_management on table name with accent don't work

GregoireCatineau — Wed, 06 Jul 2022 11:48:50 GMT

Hello,

I have a table name with an accent and i want to do a calculate :

arcpy.CalculateField_management("inTable_view", "Centralité__point___ATTACH"+".SEQ", calcExp, "VB")

But it's seems impossible to speficy a name with accent, i have this error :

ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000728: Field CentralitÃ©__point___ATTACH.SEQ does not exist within table
Failed to execute (CalculateField).

Failed to execute (ExtractionPJ).
Failed at Wed Jul 6 13:42:20 2022 (Elapsed Time: 20,79 seconds)

But it's work if i use manually the calculate tool with the same name : "Centralité__point___ATTACH"

Re: CalculateField_management on table name with accent don't work

JohannesLindner — Wed, 06 Jul 2022 13:12:29 GMT

Try using a raw string:

arcpy.CalculateField_management("inTable_view", r"Centralité__point___ATTACH"+".SEQ", calcExp, "VB")

Re: CalculateField_management on table name with accent don't work

GregoireCatineau — Wed, 06 Jul 2022 13:58:28 GMT

Thank you Johannes but it's the same error.

Re: CalculateField_management on table name with accent don't work

DanPatterson — Wed, 06 Jul 2022 14:49:00 GMT

# -*- coding: utf-8 -*-

is that line in your script? Although it shouldn't matter

Re: CalculateField_management on table name with accent don't work

GregoireCatineau — Wed, 06 Jul 2022 15:19:53 GMT

Yes Dan, it's in the script.

Re: CalculateField_management on table name with accent don't work

DanPatterson — Wed, 06 Jul 2022 19:01:59 GMT

strange. Is it a joined field? You said it works in the calculatefield tool interface, but you would have to show more of the script in case the paths to the workspace aren't being read properly (or something else)