CalculateField with PYTHON with international settings

[CoDrost]

I tried to calculate an area with:

  gp.CalculateField(fcGFE_Result,'AREA','!SHAPE.AREA!','PYTHON')

When I use the internation settings with a . as decimal separator everything is doing just fine.
But my localsettings are set to ((Dutch_Netherlands)) with a "," as a decimal separator.

The error message I got is:
    gp.CalculateField(fcGFE_Result,'AREA','!SHAPE.AREA!','PYTHON')
arcgisscripting.ExecuteError: ERROR 000539: Error running expression: 304852,037832481 <type 'exceptions.SyntaxError'>: invalid token (<string>, line 1)

When I using the same command within ArcMap I got no problem.

I also tried to set the locale parameters:
  locale.setlocale(locale.LC_ALL, 'C')
and
locale.setlocale(locale.LC_ALL, '')

Is there anybody with a proper solution? Now I am using a workarround, but I am still curious....

[JasonScheirer]

Use locale.atof.

[CoDrost]

Use locale.atof.

I tried already the locale option:
  gp.calculatefield(fn,'area','locale.atof(!shape.area!)','PYTHON')

gives Error:

  ExecuteError("ERROR 000539: Error running expression: locale.atof(7133,63322549874) <type 'exceptions.AttributeError'>: 'int' object has no attribute 'replace'\nFailed to execute (CalculateField).\n

[JasonScheirer]

gp.calculatefield(fn,'area','locale.atof("!shape.area!")','PYTHON')

[CoDrost]

Thanks, it works!!!

Isn't it posible to disable the international settings when programming with ArcGIS in Python? It is very confusing when ArcMap functionate well with the same command and in a script you need to "locale" the geoprocessing commands...

[JasonScheirer]

Unfortunately due to implementation details, Python doesn't see the ArcMap locale, meaning you essentially have to double-set it, once in ArcGIS and then once again in your Python script.

[DanPatterson_Retired]

Is this double-setting being addressed in some release?  It also occurs when using SA tools necessitating that one set environments in any running tools rather than relying on defaults set elsewhere.