Hi!
In the last couple of years I have successfully managed to build a pretty decent workflow around my "camera uploads" dropbox folder using Hazel. Images get imported from various cameras/iphones. Pictures presently get renamed using Phil Harveys ExifTool according to the YYYYMMDD-hhmmss_001.jpg scheme pattern and collected hourly into subfolders with the pattern "YYMMDD NEW_hh0000" - which means I get all pictures from a certain date within one hour into a subfolder named like this. After I manually revise the pictures in all folders I replace the "NEW_hh0000" part of the folder with a description of the content. As soon there is no "NEW_" part in the foldername anymore, the folder gets archived (moved) into my picture archive on another harddisk which is in a "/pics/YYYY/YYMMDD Party with Jon in New York" structure.
So far, so good. It has shown that it's quite much work to manually revise the "NEW_" folders and rename them. Sometimes I also need to take out some pictures of the hourly created folders which do not belong to the set of pictures taken in that hour and sometimes I also need to move pictures from several "NEW_" folders into one, because the pictures are geographically related or all the pictures taken saved in different "NEW_" folders belong to an single event, for example, a party with Jon in New York.
I want to improve this routine so I have less manual work. I thought about these steps will be helping me a lot:
1) Hazel should be able to recursively dive from a parent folder into (hundrets) of these "YYMMDD NEW_hh0000" subfolders and get Exiftool to find the coordinates and rename the images.
2) Exiftool or another tool would find the GPS coordinates and will look up into a predefined "geographical keyword database" to see if the GPS location is in a predefined area. If there are new pictures from a location which do not have yet a predefined area, I get asked to predefine it. This means at the end pictures out of the all the hourly subfolders taken within a certain time (usually on the same day) in a certain predefined area they will be renamed according to individual keywords (e.g. "YYYYMMDD-hhmmss Party with Jon in New York.jpg")
3) I want Hazel to sort the images with the same keywords into new subfolders which also contain the keywords of all images (e.g. /pics/YYYY/YYMMDD Party with Jon in New York/YYYYMMDD-hhmmss Party with Jon in New York.jpg")
Is anyone willing to help me with that? I would even pay for help, if some professional Hazel programmers want to offer it, its much appreciated.
Thanks,
Markus