I'm another one of those "have thousands... " with a (soon to be) CSV file and will be doing a massive import into Aperture or Lightroom. Both stuff that's been sorted/provided to me and what I'm doing myself, to get an absolute crapton of pictures into a referenced library structure.
What I have so far- a whole lot of directories and photos with a file as such that has three columns. Filename, Names and Descriptions. (See the image below)
I'd like the names to get into the keyword field and the description to get into the caption.
Will the comma's are going to cause issues, perhaps I had need to export these enclosed those with quotes.. or figure out JSON? I've never heard of that format until reading it here.
I'll be renaming the Pic ID as SourceFile, Names as IPTC:keywords and Description as IPTC:caption and where I'm doing my own, start that way. If I want to add an event name in there, it would be using some other field .. I just need to see what IPTC files Aperture puts stuff in I guess.. .
If I go to each directory in terminal and do this:
exiftool -csv+=2003XXX.csv -r .
What will happen with the file time/datestamps? Will they stay the same, or become [now] when it's done?
(I see that the example I chose has some incorrect entries.. )