Thanks for the update Kirk. If the IPTC date field is not modifiable and I can't create a custom field it would still be a help if I could import the dates into an otherwise unused field. I thought that ahoward's reply above implied that this could be a possibility.
David
So you'll want to save that spreadsheet as a TSV with the filename in the first column, and then save it as a UTF_8 formatted txt file. Then, use that as your code replacement file:
https://docs.camerabits.com/support/solutions/articles/48000223660-introduction-to-code-replacements-in-photo-mechanicThen, in the field where you would like this information, you'll want to use the filename variable inside of the code replacement delimiters, and then apply that in a Metadata Template to all the images that the spreadsheet has the information about. My code replacement delimiter is: =
If your spreadsheet has the extension on the filenames, you would use the following:
={filename}=
If your spreadsheet does not have the extension, you would use this:
={filenamebase}=
Photo Mechanic will evaluate the variable, giving you the full filename or the base of the filename, and then it will use the result to look for text to replace it with in the code replacement file. By default it will replace the text that it finds in the first column with the text in the next column, but you can have it use text from any number of columns:
https://docs.camerabits.com/support/solutions/articles/48000358641-advanced-code-replacementsHope that helps!
