topic Python code to run hyperlink in the attribute table in ArcGIS Pro Questions

Python code to run hyperlink in the attribute table

JonPeroff — Sat, 29 Jun 2024 17:43:27 GMT

I am using arcpro 3.3 and I have an attribute table with a field with hyperlinks to download files from the internet. Is there a tool or script to run to automatically do this?

Re: Python code to run hyperlink in the attribute table

BobBooth1 — Mon, 01 Jul 2024 02:14:48 GMT

Hi Jon,

Are you trying to download every linked item from each row of your table? Or are you trying to format hyperlinks so a pop-up will allow the user to download a selected link?

Best,

Bob

Re: Python code to run hyperlink in the attribute table

JonPeroff — Mon, 01 Jul 2024 14:33:22 GMT

Hi Bob,

Happy Canada Day!

I am trying to download from every linked item in a row. The URL is in one field of the attribute table and there are many rows, too many to download one at a time.

Thanks,

Jon

Re: Python code to run hyperlink in the attribute table

BobBooth1 — Mon, 01 Jul 2024 15:42:21 GMT

Hi Jon,

Happy Canada Day to you!

So, to do the downloading automatically, I'd use a search cursor to iterate over the table and get the values from the URL field in a list.

https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/searchcursor-class.htm

You could make a list, my_urls, for example, and for each cycle of the search cursor append the URL string to the list.

https://www.w3schools.com/python/python_lists_add.asp

It would look something like this:

import arcpy # path to table/feature class fc = r'C:\Geology\OH\OH_geol_poly' my_urls = [] # Use a search cursor to iterate through the table. # For each row, get the attribute value in a field, # and append it to a list. with arcpy.da.SearchCursor(fc, 'SRC_URL') as cursor: for row in cursor: my_urls.append(row[0]) print(my_urls)

Once you have the URLs as a list, use Python to download them to your preferred location. There's an example here:

https://towardsdatascience.com/use-python-to-download-multiple-files-or-urls-in-parallel-1759da9d6535

Best,

Bob

Re: Python code to run hyperlink in the attribute table

JonPeroff — Fri, 09 Aug 2024 20:13:11 GMT

I apologize for the late response. I thought I would get a notification.

I did finally get a script to work and it's very similar to yours. So thank you for that. I just need to figure out how to download and mosaic them together in the one script. Another topic for another day!

Jon