Latest Contributions by RandyBurton

I was doing some experimenting with a Python toolbox and came up with the following code: import arcpy import datetime class Toolbox(object): def __init__(self): """Define the toolbox (the name of the toolbox is the name of the .pyt file).""" self.label = "Toolbox" self.alias = "" # List of tool classes associated with this toolbox self.tools = [Tool] class Tool(object): def __init__(self): """Define the tool (tool name is the name of the class).""" self.label = "Tool" self.description = "" self.canRunInBackground = False def getParameterInfo(self): """Define parameter definitions""" feature = arcpy.Parameter( displayName = "Feature layer to search", name = "feature", datatype = "GPFeatureLayer", parameterType = "Required", direction = "Input") startDate = arcpy.Parameter( displayName = "Select start date", name = "startDate", datatype = "GPDate", parameterType = "Required", direction = "Input") endDate = arcpy.Parameter( displayName = "Select ending date", name = "endDate", datatype = "GPDate", parameterType = "Required", direction = "Input") params = None return [ feature, startDate, endDate ] def isLicensed(self): """Set whether tool is licensed to execute.""" return True def updateParameters(self, parameters): """Modify the values and properties of parameters before internal validation is performed. This method is called whenever a parameter has been changed.""" return def updateMessages(self, parameters): """Modify the messages created by internal validation for each tool parameter. This method is called after internal validation.""" return def execute(self, parameters, messages): """The source code of the tool.""" # the addMessages are for debugging and can be removed messages.addMessage('Feature: {}'.format(parameters[0].valueAsText)) messages.addMessage('Start: {}'.format(parameters[1].valueAsText)) messages.addMessage('End: {}'.format(parameters[2].valueAsText)) messages.addMessage('Type: {}'.format(type(parameters[2].value))) # one way to set the time portion # startDate = '{} 00:00:00'.format(parameters[1].value.strftime("%Y-%m-%d")) # endDate = '{} 23:59:59'.format(parameters[2].value.strftime("%Y-%m-%d")) startDate = parameters[1].value.strftime("%Y-%m-%d %H:%M:%S") endDate = parameters[2].value.strftime("%Y-%m-%d %H:%M:%S") where = "DateTime BETWEEN DATE '{}' AND DATE '{}'".format(startDate, endDate) messages.addMessage('Where: {}'.format(where)) arcpy.SelectLayerByAttribute_management(parameters[0].valueAsText, "NEW_SELECTION", where_clause=where) return‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ There are lots of addMessage() for debugging.  At line 72, I used the type function to verify that the parameter being used was a datetime type.   In addition I came across this topic: arcpy script tool - format parameter Date data type. It may provide some additional insight in how date/time works in a Python script or toolbox.  Hope this helps. ... View more

Some things to try (assuming there is no space in the last name - that is not  a name like Van Gogh): >>> name = 'Doe M Jane' >>> ', '.join(name.split(" ", 1)) 'Doe, M Jane' >>> " ".join(name.split(" ", 1).__reversed__()).replace(',','') 'M Jane Doe' >>> name = 'Doe, M Jane' >>> if ',' not in name: ', '.join(name.split(" ", 1)) >>> name 'Doe, M Jane' >>> name = 'Doe M Jane' >>> if ',' not in name: ', '.join(name.split(" ", 1)) 'Doe, M Jane' ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

You will also need to close the file before renaming it.  Perhaps: 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("%Y-%m-%d",ds) newname = fname[0:7] + "_" + nt + ".jpg" image.close() os.rename(os.path.join(root,fname), os.path.join(root,newname))‍‍‍‍‍‍‍‍‍‍‍ ... View more