I've got to the stage where I'm able to output to a csv file to eventually put into an Access database. However, I'm having difficulties with formatting a date. I'm using an args file, but it's not obvious to me where and how the -d '%d-%m-%Y %H:%M:%S' format goes. I've tried running the exiftool function as
exiftool -d '%d-%m-%Y %H:%M:%S' -DateTimeOriginal *.jpg
This gives the date without time and says one file couldn't be processed, yet everything I've seen says to put single quotes around the format as it has the space.
Here are some of the lines from my args file
-EXIF:Artist
-EXIF:copyright
-d '%d-%m-%Y %H:%M:%S'
-EXIF:DateTimeOriginal
-XMP:Description
-EXIF:ExposureTimeWhat am I doing wrong?
Malcolm
This is FAQ #29, "My options don't work in a -@ ARGFILE" (https://exiftool.org/faq.html#Q29).
You would use
-d
%d-%m-%Y %H:%M:%S
Separate lines, no quotes, no trailing spaces.
I tried that and it still threw a wobbly - then I noticed a space after -DateTimeOriginal, removed that and now it works. Something to be aware of. Now to seeing about importing into Access!
Is there a thanks button on this forum? If not then 'Thanks!'
Malcolm