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; } } }

Convert arcmap to ArcGIS PRO - scripts

SoratoSouza_e_Silva

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

Find more posts tagged with

Accepted answers

danretired

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

All comments

SoratoSouza_e_Silva

Thank´s,

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

curtvprice

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!

danretired

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

SoratoSouza_e_Silva

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

danretired

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

JayantaPoddar

VB is not supported in ArcGIS Pro.

Try PYTHON3, ARCADE or SQL.

e.g.

!PLANTIO![-4:]

Also Replace "VB" with "PYTHON3"

Anonymous User

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

SoratoSouza_e_Silva

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 )

SoratoSouza_e_Silva

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 )

danretired

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

MikeVolz

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.