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

python field calculator issue

Anonymous User

Original User: frankv3

i am having trouble calculating a string field named Plat_Link in a polygon feature class that has an integer field named MAP_BOOK and an integer field name PAGE
i tested this code in IDLE and it worked fine if MAP_BOOK and PAGE were set (see picture), but it will not work in the field calculator, an error of 000989 is returned
the code was tried both of these ways (first way in attached picture):

MapNum = str(!MAP_BOOK!)
PageNum = str(!PAGE!)
if len(PageNum) == 1:
PlatLink = "\\\\" + "Covsdesrv" + '\\' + "GIS Common" + '\\' + "Plats" + '\\' + "00" + MapNum + '\\' + "00" + MapNum + "000" + PageNum + ".TIF"
elif len(PageNum) == 2:
PlatLink = "\\\\" + "Covsdesrv" + '\\' + "GIS Common" + '\\' + "Plats" + '\\' + "00" + MapNum + '\\' + "00" + MapNum + "00" + PageNum + ".TIF"
elif len(PageNum) == 3:
PlatLink = "\\\\" + "Covsdesrv" + '\\' + "GIS Common" + '\\' + "Plats" + '\\' + "00" + MapNum + '\\' + "00" + MapNum + "0" + PageNum + ".TIF"

AND

if (!PAGE!) = 1:
PlatLink = "\\\\" + "Covsdesrv" + '\\' + "GIS Common" + '\\' + "Plats" + '\\' + "00" + str(!MAP_BOOK!) + '\\' + "00" + str(!MAP_BOOK!) + "000" + str(!PAGE!) + ".TIF"
elif (!PAGE!) = 2:
PlatLink = "\\\\" + "Covsdesrv" + '\\' + "GIS Common" + '\\' + "Plats" + '\\' + "00" + str(!MAP_BOOK!) + '\\' + "00" + str(!MAP_BOOK!) + "00" + str(!PAGE!) + ".TIF"
elif (!PAGE!) = 2:
PlatLink = "\\\\" + "Covsdesrv" + '\\' + "GIS Common" + '\\' + "Plats" + '\\' + "00" + str(!MAP_BOOK!) + '\\' + "00" + str(!MAP_BOOK!) + "0" + str(!PAGE!) + ".TIF"

any help appreciated

PlatLink_succeed.jpg

PlatLink_fail.jpg

Luke_Pinner_0-1765230606954.png

2022_mug.png

Vind meer berichten getagd met

Accepted answers

All comments

ChrisMathers

Im not sure why that isnt working but for starters you should try string substitution instead of concatentation and raw strings so you dont have to excape all those'\'.

http://docs.python.org/release/2.6.6/library/stdtypes.html#string-formatting-operations

PlatLink = r"\\Covsdesrv\GIS Common\Plats\00%s\00%s000%s.TIF"%(MapNum,MapNum,PageNum)

Anonymous User

Original User: frankv3

Im not sure why that isnt working but for starters you should try string substitution instead of concatentation and raw strings so you dont have to excape all those'\'.

http://docs.python.org/release/2.6.6/library/stdtypes.html#string-formatting-operations

PlatLink = r"\\Covsdesrv\GIS Common\Plats\00%s\00%s000%s.TIF"%(MapNum,MapNum,PageNum)

thank you for the tip, i'm just learning to use this scripting language and any help is much appreciated

Anonymous User

Original User: frankv3

it is still not calculating in ArcMap, reports the Error 000989 - Python Syntax Error , this is the calculation code (saved out)

MapNum = str(!MAP_BOOK!)
PageNum = str(!PAGE!)
if len(PageNum) == 1:
PlatLink = r"\\Covsdesrv\GIS Common\Plats\00%s000%s.TIF"%(MapNum,MapNum,PageNum)
elif len(PageNum) == 2:
PlatLink = r"\\Covsdesrv\GIS Common\Plats\00%s00%s.TIF"%(MapNum,MapNum,PageNum)
elif len(PageNum) == 3:
PlatLink = r"\\Covsdesrv\GIS Common\Plats\00%s0%s.TIF"%(MapNum,MapNum,PageNum)
__esri_field_calculator_splitter__
PlatLink

it runs fine in the IDLE window as before, anyone know what i'm doing wrong?

PatrickOMalley

The code you are showing does not show indentation of the action parts of the if statements. Python is very picky about white space and there must be indentation. I'm certain when you typed it into IDLE it supplied the indentation for you automatically.

Try this

if len(PageNum) == 1:
    PlatLink = r"\\Covsdesrv\GIS Common\Plats\00%s000%s.TIF"%(MapNum,MapNum,PageNum )
elif len(PageNum) == 2:
    PlatLink = r"\\Covsdesrv\GIS Common\Plats\00%s00%s.TIF"%(MapNum,MapNum,PageNum)
elif len(PageNum) == 3:
    PlatLink = r"\\Covsdesrv\GIS Common\Plats\00%s0%s.TIF"%(MapNum,MapNum,PageNum)

PatrickOMalley

I know I put 4 spaces in front of every line that started with PlatLink, but they don't show up in my submittal to the forum. Maybe your indentation is fine and the forum software strips off excess whitespace.

DanPatterson_Retired

You have to put code in the code blocks in the html editor, select the # tool from the message posting toolbar, paste your code and the proper indentation will be maintained as in this nonsence example

names = ["Obi", "Bob", "Billy"]
for name in names:
  if name == "Obi":
    print name, "is ", True, "a", "Jedi master"
  else:
    print name, "is not a Jedi master"

don't forget to copy, compile and run the script to see if it works 🙂

Anonymous User

Original User: frankv3

so, the field names go at the bottom in the Expression box and then the result goes above in the Code Block box
it's almost the opposite of how the VBA calculator expressions ran

this is what works for us to calculate hyperlinks based on two fields:
Code Block:
def SetLink(map,page):
if len(str(page)) == 1:
     num0 = "000"
elif len(str(page)) == 2:
     num0 = "00"
elif len(str(page)) == 3:
     num0 = "0"
return r"\\Covsdesrv\GIS Common\Plats\00%s\00%s%s%s.TIF"%( str(map), str(map), num0, str(page))

Expression:
SetLink( !MAP_BOOK!, !PAGE! )

PlatLink_success.jpg

NiklasNorrthon

Seems unecessarily complicated. Simpler version follows:

def SetLink(map, page):
    return r"\\Covsdesrv\GIS Common\Plats\%03d\%03d%04d.TIF % (map, map, page)

InformalPhoto_Cropped (2).jpg

Details.jpg

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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