topic Re: Hyperlinks and Field Calculator in Geoprocessing Questions

Hyperlinks and Field Calculator

DanielErklauer — Tue, 01 May 2012 16:53:45 GMT

I am using the field calculator to automatically populate a column of hyperlinks to pdf documents. I have a folder with pdfs that are named the same as an existing field in my shape file. Over 90% of my hyperlinks work but some do not for one of two reasons..... There is not a pdf for that attribute or the pdf naming convention does not match the field name. Is there a way to determine which hyperlinks are not working? I currently am clicking on each polygon using info to verify that the link is live. If the link is dead I delete the link if I do not have a pdf or modify the link to point at the correct PDF. Is there another way to automatically tell me which links are dead or possible an entirely different way to do this?

I am using Arc info 9.3
My field Calculator statement is (This work fine): "N:\Reports\" & [Asbestos] & "AESC.pdf"

Thank you.

Re: Hyperlinks and Field Calculator

markdenil — Sat, 11 Dec 2021 19:50:37 GMT

It looks like the target files are somewhere on your network (to wit: a letter mapped drive and not http)
so
Runs a search cursor through the table, and pick up each path string in turn.
pass that path string to
os.path.exists(pathString)
and if the result is False, write the path (or the OID, or both) to a list.

if not os.path.exists(pathString):
    brokeList.append(theOID)

Re: Hyperlinks and Field Calculator

DanielErklauer — Sat, 11 Dec 2021 19:50:39 GMT

Thanks Mark

what am I missing here to write the results to an text?

import os
import arcgisscripting


# Create the geoprocessor object

gp = arcgisscripting.create(9.3)

#Create search cursor 

shp = "C:\Dan\search_cursor.shp"

rows = gp.SearchCursor(shp)
row = rows.Next()
fields = gp.ListFields(shp)

if not os.path.exists(shp):
    brokeList.append(path,"demo.txt")

Re: Hyperlinks and Field Calculator

markdenil — Wed, 02 May 2012 14:28:45 GMT

Well, append is a method of adding to a python list, not a file.
You know the shp exists, you want to test the path in the record (which you never access)

Try this. It has no errorchecking, and you should replace "<<WHATEVER THE PATH FIELDNAME IS>>" with the field name of your field with the paths.

import os import arcgisscripting  # Create the geoprocessor object gp = arcgisscripting.create(9.3)  shp = r"C:\Dan\search_cursor.shp" brokeList = []  # <- you need a list  #Create search cursor rows = gp.SearchCursor(shp) row = rows.Next() while row:     #  grab the item values you are interested in     pathString = row.<<WHATEVER THE PATH FIELDNAME IS>>     theFID = row.FID     # see if the link path is valid     if not os.path.exists(pathString):         #  append the FID of bad links to the list         brokeList.append(theFID)     row = rows.Next()  if len(brokeList) > 0: print "Broken links found!"  # write the list to a file txt = open(r"C:\Dan\demo.txt", 'w') for broke in brokeList:     txt.write(str(broke) + "\n") txt.close() print 'DONE'

Re: Hyperlinks and Field Calculator

DanielErklauer — Wed, 02 May 2012 16:00:15 GMT

Mark, thanks for your answer this was very helpfull.