topic Re: Convert arcmap to ArcGIS PRO - scripts in Python Questions

Convert arcmap to ArcGIS PRO - scripts

SoratoSouza_e_Silva — Tue, 23 Nov 2021 18:49:41 GMT

Hi,

Is there any practical way to convert scripts from arcmap to arcgis pro?

I need to convert several scripts, and for example this snippet I'm having a lot of problems.

arcpy.CalculateField_management("temp_informe_Layer", "EST_SUBREP", "" + anoAtual + " - Right( [PLANTIO],4 )", "VB", "")

would anyone know help me with the correct syntax for Arcgis PRO?

Thank´s

Re: Convert arcmap to ArcGIS PRO - scripts

MichaelVolz — Tue, 23 Nov 2021 18:55:03 GMT

How about create a simple model in Pro using that specific query and see what the python export script looks like?

Re: Convert arcmap to ArcGIS PRO - scripts

DanPatterson — Tue, 23 Nov 2021 18:56:15 GMT

Fundamentals of field calculations—ArcGIS Pro | Documentation

Calculate Field (Data Management)—ArcGIS Pro | Documentation

Calculate Field Python examples—ArcGIS Pro | Documentation

to get you started

Re: Convert arcmap to ArcGIS PRO - scripts

SoratoSouza_e_Silva — Tue, 23 Nov 2021 19:03:50 GMT

My problem is basically converting this snippet that is in VB and I can't find similar in PRO. This is a date field, and it says I can't slice a date field.

- Right( [PLANTIO],4 )

Re: Convert arcmap to ArcGIS PRO - scripts

SoratoSouza_e_Silva — Tue, 23 Nov 2021 19:05:11 GMT

My problem is basically converting this snippet that is in VB and I can't find similar in PRO. This is a date field, and it says I can't slice a date field.

- Right( [PLANTIO],4 )

Re: Convert arcmap to ArcGIS PRO - scripts

Anonymous User — Tue, 23 Nov 2021 19:05:32 GMT

Hello SoratoSouza_e_Silva,

ArcMap uses Python 2 while ArcGIS Pro use Python 3. Many scripts will still be functional, but some will not. Esri and Python.org has some documentation that discusses the change. See below:

Python migration from 10.x to ArcGIS Pro

Some general information about the change plus extra resources.

Analyze Tools for Pro (Data Management)

A data management geoprocessing tool that can identify potential scripts that will have a problem running successfully.

2to3 - Automated Python 2 to 3 code translation

A command line utility to convert Python 2 code to Python 3 code.

I'd make sure to read up on any other these before making changes (especially the 2to3 command line utility). For safety, I'd recommend making a copy of the script(s) and making changes to the copy rather than the original.

I hope this is helpful and have fun!

Cheers,

Mike

Re: Convert arcmap to ArcGIS PRO - scripts

JayantaPoddar — Tue, 23 Nov 2021 19:27:30 GMT

VB is not supported in ArcGIS Pro.

Try PYTHON3, ARCADE or SQL.

e.g.

!PLANTIO![-4:]

Also Replace "VB" with "PYTHON3"

Re: Convert arcmap to ArcGIS PRO - scripts

DanPatterson — Tue, 23 Nov 2021 21:45:35 GMT

If it is a date field, you can use python expressions to work with dates, or more simply convert it to a string representation prior to slicing

assume datetime.datetime.now represents !PLANTIO!

import datetime datetime.datetime.now() Out[2]: datetime.datetime(2021, 11, 23, 16, 42, 51, 182197) str(datetime.datetime.now()) # str(!PLANTIO!) ***** Out[3]: '2021-11-23 16:43:08.012047' str(datetime.datetime.now())[:4] # str(!PLANTIO!)[:4] ***** Out[4]: '2021' # the year

Re: Convert arcmap to ArcGIS PRO - scripts

SoratoSouza_e_Silva — Tue, 23 Nov 2021 22:24:47 GMT

Thank you so much, you are fantastic...

But I think I wasn't very clear, I'll need to do a numerical count, and I can't subtract string:

arcpy.CalculateField_management("temp_informe_Layer", "EST_SUBREP", "" + anoAtual + " -  Right( [PLANTIO],4 )", "VB", "")

My data format is 23/11/2021

Re: Convert arcmap to ArcGIS PRO - scripts

DanPatterson — Wed, 24 Nov 2021 01:26:15 GMT

still not clear since I don't know what the values are or what they represent, but if you have a number and a string and you want to subtract them, then

anoAtual = 100

fld = "2000"

anoAtual - int(fld)
-1900

Re: Convert arcmap to ArcGIS PRO - scripts

curtvprice — Wed, 24 Nov 2021 05:00:59 GMT

The issue you may be running into is that VB doesn't care about data type, if you throw a string function at it, it will use a string rep of the value. For example, you can add "1" and "1" and get 2. In Python you need to convert data types yourself, so, assuming your PLANTIO is a date field, you may be able to get what you want like this:

expr = 'float(' & str(anuAtual) & ') - float(time.strftime(!PLANTIO!,"%Y"))' # at runtime, expr will be something like: # float(1999) - float(time.strftime(!PLANTIO!,"%Y")) arcpy.CalculateField_management("temp_informe_Layer", "EST_SUBREP", expr, "PYTHON")

More on handling dates in Calculate Field in the help!

Re: Convert arcmap to ArcGIS PRO - scripts

SoratoSouza_e_Silva — Wed, 24 Nov 2021 11:06:01 GMT

Thank´s,

Thank you very much for your suggestion. It's a great option too!

Re: Convert arcmap to ArcGIS PRO - scripts

curtvprice — Sun, 07 Aug 2022 17:54:48 GMT

For some reason this popped up in my email so I thought I'd add that using string formatting is easier to understand and debug. This is especially true if your expression is complex.

For example:

expr = 'float({}) - float(time.strftime(!PLANTIO!,"%Y"))'.format(anuAtual) # at runtime, expr will be something like: # float(1999) - float(time.strftime(!PLANTIO!,"%Y")) arcpy.CalculateField_management("temp_informe_Layer", "EST_SUBREP", expr, "PYTHON")