topic Re: Publish simple tool with calculate in Python Questions

Publish simple tool with calculate

ModyBuchbinder — Sun, 12 Dec 2021 16:38:39 GMT

Hello all

I have a one line python script that looks like this:

arcpy.CalculateField_management(r"DemandPoints1","from1",'"aaa"',"PYTHON_9.3")

from1 is a text field in DemandPoints1 and I would like to put the value aaa in it.

This script runs with no problem as tool (no parameters) in ArcMap but when I try to publish it as geoprocessing service I get:

24046: Tool <value> cannot use VB expressions for services
There are many examples of complex calculations but I would like to make it simple!!
Any ideas?

Re: Publish simple tool with calculate

DanPatterson_Retired — Tue, 25 Apr 2017 08:04:19 GMT

exclamation marks for fields when using python ie !FieldName! could be the issue

http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/calculate-field-examples.htm

Re: Publish simple tool with calculate

ModyBuchbinder — Tue, 25 Apr 2017 08:07:50 GMT

I know that! I need to put a VALUE not a field value.

Re: Publish simple tool with calculate

Anonymous User — Tue, 25 Apr 2017 09:45:07 GMT

Hi Mody,

Can you provide us more information like,

ArcGIS server installed on which OS?

Is there only issue with this GP process?

From first look like is related to selection on labeling.

Re: Publish simple tool with calculate

ModyBuchbinder — Tue, 25 Apr 2017 10:08:40 GMT

I am using ArcGIS Server 10.3.1 on windows.

The tool is published and works. It just gives warning (level High) when I analyse before publishing.

Looks like a bug to me.

Re: Publish simple tool with calculate

Anonymous User — Tue, 25 Apr 2017 11:00:19 GMT

Ohh

Thanks for the information.

Re: Publish simple tool with calculate

DanPatterson_Retired — Tue, 25 Apr 2017 11:31:37 GMT

it is a warning as documented here http://server.arcgis.com/en/server/latest/publish-services/windows/24046-tool-cannot-use-vb-expressions-for-services.htm and http://support.esri.com/Search-Results#search?q=24046 for more

Re: Publish simple tool with calculate

ModyBuchbinder — Tue, 25 Apr 2017 11:49:41 GMT

Hi Dan

Thanks, as usual you are correct.

They only problem is that I do not have any VB expression in my python code.

That is why I think it is a bug.

Re: Publish simple tool with calculate

DanPatterson_Retired — Tue, 25 Apr 2017 11:58:30 GMT

Which is why I pointed it out... it said to ignore it if you don't have a vb expression or to fix it if you do. Confusing needless to say, but perhaps the simple example that you were testing is too simple and 'it' thinks it is vb.. perhaps try something more complicated (well not really) but is truly python...

"{}".format("aaa") which of course yields 'aaa'

Re: Publish simple tool with calculate

RandyBurton — Sun, 12 Dec 2021 00:47:53 GMT

After running the tool in ArcMap, if you go to Geoprocessing > Results and right-click on Calculate Field and select Copy As Python Snippet, it produces the following code:

# ArcMap 10.2.1 - Fails, doesn't like """"aaa""""
arcpy.CalculateField_management("DemandPoints1","from1",""""aaa"""","PYTHON_9.3","#")

# ArcMap 10.5 - Success
arcpy.CalculateField_management(in_table="DemandPoints1", field="from1", expression="'aaa'", expression_type="PYTHON_9.3", code_block="")‍‍‍‍‍‍‍‍

Here are other variations I have tried:

arcpy.CalculateField_management("DemandPoints1","from1","{}".format("aaa"),"PYTHON_9.3","#") # fails

arcpy.CalculateField_management("DemandPoints1","from1","{}".format("'aaa'"),"PYTHON_9.3","#") # success

arcpy.CalculateField_management("DemandPoints1","from1",'aaa',"PYTHON_9.3","#") # fails

arcpy.CalculateField_management("DemandPoints1","from1","aaa","PYTHON_9.3","#") # fails

arcpy.CalculateField_management("DemandPoints1","from1","'aaa'","PYTHON_9.3","#") # success‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍