Add Path to JPGs in Attribute Table based on Unique ID

Question

I've been tasked with updating attribute table fields with file paths to image files in a folder based on a unique ID. I'm having trouble thinking up a script that will do this? I'm working on a standalone script in ArcGIS Pro 2.3.1 Arcpy.

This is an example of how the table should look. Every JPG has a unique ID that matches the Post_Number field unique ID. Currently, the paths to the JPGs are entered manually into the table, and there are 1000s of them.

I don't think a Calculate Field will work because not all JPGs are stored in the same directory. All I've done so far is create a cursor that searches the Post_Number and Photo fields.

#for each row print the fields with arcpy.da.SearchCursor(fc, fields) as cursor: for row in cursor: print(u"{0}, {1}".format(row[0], row[1]))

Answer 1

Because my reputation implies in comment limits I need to assume you already had the 'Post_Number' field filled when the geometry for a photo is created, so the script below just search for the photos and fills the 'Photo' field with the full path:

import fnmatch
import os

# Directory/unity where search begins
src = 'C:\\'

# List of files with complete path and filename
matches = []
rowM = [None, None]

# Counters for log purposes
count1 = 0
count2 = 0

print 'Beginning search of photos'

for root, dirnames, filenames in os.walk(src):
    count1 += 1
    print count1
    for filename in fnmatch.filter(filenames, '*.jpg'):
        count2 += 1
        rowM[0] = os.path.join(root, filename) # complete path
        rowM[1] = os.path.join(filename[:-4]) # filename without extension
        matches.append(list(rowM))

import arcpy

fc = 'C:\Teste\Teste.gdb\Teste_pto'
fields = ['Post_Number', 'Photo']
expression = fields[1] + ' IS NULL'

print 'Beginning search of paths'

try:
    with arcpy.da.UpdateCursor (fc, fields, expression) as uc:
        for line in uc:
            for row in matches:
                if (line[0] == row[1]): # if Post_Number matches filename
                    line[1] = row[2] # Photo is equal to path
                    uc.updateRow(line)
except arcpy.ExecuteError:
    arcpy.AddMessage(str(arcpy.GetMessages(2)))


print 'End of script'

Answer 2

This script worked well too:

import arcpy, os

ws = r'pathTo\JPGsdirectory'
jpgs = {} # empty dictionary

for dirName, subdirList, fileList in os.walk(ws): #iterate the directory
    for fname in fileList:
        jpgs[fname[:-4]] = os.path.join(dirName,fname) #create key:value pairs dictionary

fc = r'pathTo\featureclass\WCDOT_Signs'
fields = ['OID@', 'Post_Number', 'Photo']

with arcpy.da.UpdateCursor(fc, fields) as cursor:
    for row in cursor:
        try:
            row[2] = jpgs[row[1]]
            cursor.updateRow(row)
        except KeyError:
            print("No photo for: {}".format(row[1]))

del cursor