Latest Contributions by JaredPilbeam2

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