Latest Contributions by JaredPilbeam2

Hello, The intention of this script is to update the 'Photo' field of a feature class table with the full path of a JPG based on the 'Post_Number' field. The problem is only the first seven digits of the JPG matches the unique ID in the 'Post_Number' field. The rest of the file name is a date. I've placed a string index number variable in a for loop that gets the JPG by the first seven digits.  A dictionary is then built off the existing paths without the date. The cursor is then supposed to update the 'Photo' field. The script runs without error but the Photo field isn't updated??  I'm thinking the 'var' variable is in the wrong place.  '''Python 3.6.6. The purpose of this script is to update the 'Photo' field in the fc with the full path of a JPG. ''' import arcpy, os ws = r'path\to\Projects\DOT_SignInventory\pics' jpgs = {} # empty dictionary for dirName, subdirList, fileList in os.walk(ws): for fname in fileList: var = fname[:7] # get first seven digits of file name jpgs[var[:-4]] = os.path.join(dirName,var) fc = r'path\to\Projects\DOT_SignInventory\Data2.gdb\WCDOT_Signs' fields = ['OID@', 'Post_Number', 'Photo'] # fields of FC 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 ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Here's how the JPG looks in the directory: Here's how I want the Photo field to be updated. Right now it's empty. Both fields are text fields. ... View more

I have a working script that updates the 'photo' field with a file path to a JPG based on the 'post_number' field. In other words, the script searches the directory for JPGs which it puts into a dictionary with it's file path. It then uses a cursor to update the photo field with a path to the JPG.  import arcpy, os, re ws = r'path\to\Projects\DOT_SignInventory' jpgs = {} # empty dictionary for dirName, subdirList, fileList in os.walk(ws): for fname in fileList: jpgs[fname[:-4]] = os.path.join(dirName,fname) fc = r'path\to\Projects\DOT_SignInventory\Data.gdb\WCDOT_Signs' editws = os.path.dirname(fc) fields = ['OID@', 'Post_Number', 'Photo'] # Start an edit session. Must provide the workspace. edit = arcpy.da.Editor(editws) # Edit session is started without an undo/redo stack for versioned data # (for second argument, use False for unversioned data) edit.startEditing(False, True) # Start an edit operation edit.startOperation() 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 # Stop the edit operation edit.stopOperation() # Stop the edit session and save the changes edit.stopEditing(True) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ It works fine now because the 'Post_Number' field is the same as the JPG: My problem is that the JPG will soon have a date concatenated to look like this, for example: 0110100_20180607. So, my question is how can I change the code so it uses only those first seven digits to populate the Photo field? They are both text fields. ... View more

I need some help putting the date in the filenames. Here's the working code I have so far.  import arcpy, sys import exifread from exifread import exif import os import time from datetime import datetime im = r"path\to\DOT_SignInventory" for root, dirnames, filenames in os.walk(im): #iterate directory for fname in filenames: if fname.endswith('.JPG'): with open(os.path.join(root, fname), 'rb') as image: #file path and name exif = exifread.process_file(image) dt = str(exif['EXIF DateTimeOriginal']) #get 'Date Taken' from JPG ds = time.strptime(dt, '%Y:%m:%d %H:%M:%S') nt = time.strftime("%m/%d/%Y",ds)#variable with 'Date Taken' print("Photo:{} Date Taken:{}".format(fname, "_" + nt))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I've tried these couple things after the print statement, but no cigar: new_file = fname + nt + ".jpg"‍‍ f = open(fname.format(nt), "w") f.write(fname + nt) f.close‍‍‍‍‍‍ ... View more

I'm attempting to extract the Date Taken from jpgs within a directory. And then I want to have the date printed as such: mo/day/year  Here's an example of a JPG's Properties menu: This code runs with no error but the output isn't what I want. import exifread from exifread import exif import os import time im = r"path\to\DOT_SignInventory" for root, dirnames, filenames in os.walk(im): for fname in filenames: if fname.endswith('.JPG'): with open(os.path.join(root, fname), 'rb') as image: #file path and name exif = exifread.process_file(image) dt = str(exif['EXIF DateTimeOriginal']) #get Date Taken from JPG date = time.strptime(dt, '%Y:%m:%d %H:%M:%S') print("Photo:{} Date Taken:{}".format(fname, date))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Photo:0710100.JPG Date Taken:time.struct_time(tm_year=2018, tm_mon=6, tm_mday=5, tm_hour=13, tm_min=49, tm_sec=40, tm_wday=4, tm_yday=166, tm_isdst=-1)‍‍‍ Ideally, I want the output to look as such: Photo:0710100.JPG Date Taken:06/05/2018‍‍‍‍‍ For line 14, I can't find the right format. I've also tried the datetime module but couldn't get that to work right either.  ... View more