nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Publish simple tool with calculate

mody_buchbinder

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?

Encontre mais publicações marcadas com

Accepted answers

All comments

RandyBurton

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:

<SPAN class="comment token"># ArcMap 10.2.1 - Fails, doesn't like """"aaa""""</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DemandPoints1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"from1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""""aaa"""</SPAN><SPAN class="string token">","</SPAN>PYTHON_9<SPAN class="number token">.3</SPAN><SPAN class="string token">","</SPAN><SPAN class="comment token">#")</SPAN>

<SPAN class="comment token"># ArcMap 10.5 - Success</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="operator token">=</SPAN><SPAN class="string token">"DemandPoints1"</SPAN><SPAN class="punctuation token">,</SPAN> field<SPAN class="operator token">=</SPAN><SPAN class="string token">"from1"</SPAN><SPAN class="punctuation token">,</SPAN> expression<SPAN class="operator token">=</SPAN><SPAN class="string token">"'aaa'"</SPAN><SPAN class="punctuation token">,</SPAN> expression_type<SPAN class="operator token">=</SPAN><SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">,</SPAN> code_block<SPAN class="operator token">=</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here are other variations I have tried:

arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DemandPoints1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"from1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"aaa"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">,</SPAN>"<SPAN class="comment token">#") # fails</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DemandPoints1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"from1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"'aaa'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">,</SPAN>"<SPAN class="comment token">#") # success</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DemandPoints1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"from1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'aaa'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">,</SPAN>"<SPAN class="comment token">#") # fails</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DemandPoints1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"from1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"aaa"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">,</SPAN>"<SPAN class="comment token">#") # fails</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DemandPoints1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"from1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"'aaa'"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">,</SPAN>"<SPAN class="comment token">#") # success‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>