topic Re: Converting a VB script into Python in ArcGIS API for Python Questions

Converting a VB script into Python

SLouq — Thu, 24 Oct 2019 15:29:26 GMT

I had some VB code in one of my Calculate Field modules in modelbuilder. I am trying to convert it to Python
Can anybody help me with this?

IF RTRIM([PRE_DIR]) = " " then

MyLabel = LTRIM([STR_NAME]) & " " & [SUF_FIX]

else

MyLabel = RTRIM([PRE_DIR]) & " " & LTRIM(RTRIM([STR_NAME])) & " " & [SUF_FIX]

end If

Thanks

Re: Converting a VB script into Python

RobertBorchert — Thu, 24 Oct 2019 15:32:24 GMT

If you have it in model builder simply open it in model builder.

Then under Model and Export you can export it automatically to a python scrip.

Re: Converting a VB script into Python

SLouq — Thu, 24 Oct 2019 15:36:50 GMT

Thanks Robert! I knew there was an easy way to do this. HAHA!

Re: Converting a VB script into Python

SLouq — Fri, 25 Oct 2019 14:15:35 GMT

I know I marked your response as correct and it may be correct but I'm still getting an error when trying to convert my if statement to python. I tried this but it isn't working

If (!PRE_DIR!).RTrim() = " "

print(!STR_NAM!) + " " + (!SUF_FIX!)

else

print(!PRE_DIR!).RTrim() + " " + LTrim (RTrim(!STR_NAME!)) + " " +

Return !SUF_FIX!

Any help would be appreciated!

Thanks

Re: Converting a VB script into Python

RobertBorchert — Fri, 25 Oct 2019 14:23:25 GMT

Whatever your trying to convert it does not look like it came from Model Builder.

I have used VB code in model builder expressions in the past and if they work in model builder, which I am assuming yours do, they should convert to python and the code from your last post is not python. Or are you just posting the original VB code.

Re: Converting a VB script into Python

SLouq — Fri, 25 Oct 2019 14:33:29 GMT

I know I have the syntax wrong because I am very unfamiliar with python syntax. I have just been looking at python examples on the internet and doing what I thought would work since what I had in VB works. Here is a screenshot of the Calculate Field module I have in python.

Re: Converting a VB script into Python

RobertBorchert — Fri, 25 Oct 2019 14:53:40 GMT

What does the syntax look like when you open the python script after you export it as python

Re: Converting a VB script into Python

SLouq — Fri, 25 Oct 2019 14:58:31 GMT

# Process: Calculate Field (2)
arcpy.CalculateField_management(clines__5_, "LABEL", "RTRIM([PRE_DIR]) & \" \" & LTRIM(RTRIM([STR_NAME])) & \" \" & [SUF_FIX]", "VB", "IF RTRIM([PRE_DIR]) = \" \" then\\n MyLabel = LTRIM([STR_NAME]) & \" \" & [SUF_FIX]\\nelse\\n

Re: Converting a VB script into Python

RobertBorchert — Fri, 25 Oct 2019 15:00:54 GMT

That looks like it should work when you run the python script.

Re: Converting a VB script into Python

SLouq — Fri, 25 Oct 2019 15:04:56 GMT

Then I just need to learn how to enter it into the prelogic part of the module.

Thank you for helping me figure out this issue Robert!

Re: Converting a VB script into Python

RobertBorchert — Fri, 25 Oct 2019 15:21:16 GMT

I have been able to accomplish some pretty cool things by exporting a model to python.

I had to figure out a way to import 6 feature classes from 1400 file geodatabases that all had the same name that were exports from StakeOut (a software for marking utility lines)

So I made a model that would do it for one of the databases. Exported it to python. Took the python script into MS Access and pasted it in to a Long Text Field. I then put in the variations of the database names in another table and joined them together. Did a find replace to insert the variables, added the Del function at end. Pasted the new script back into python and went from there.

So my next question is. Is this a script that will run more than once? If so you need add the Del function at the end of the script to reset the variables.

Re: Converting a VB script into Python

SLouq — Fri, 25 Oct 2019 15:34:30 GMT

Yes this is a script which I will have to run occasionally. I still have ArcMap 10.7 on my computer so I'm not completely devoid of using my old way of running the script in VB. I'm just slowly trying to learn how to do it in Python in case in the future I lose my connection with ArcMap and have to rely on using ArcGIS Pro.

Hopefully I never have to get that complex in scripting. That's a clever way of using other programs to figure out how to accomplish a complex task!

Cheers!