Merge IPTCMETA DATA from Spreadsheet into images

[richben90]

I have 80,000 image files, with keyword and caption data stored separately in a spreadsheet. I would like to merge the meta data into the images. I have read and tried to follow previous postings on this subject without success. I have read the posting at the following link: http://forums.camerabits.com/index.php?topic=6668.0

I have saved my data from excel as a tab-separated text file. I've tried to keep it simple to start with, using a 2 row and 2 column text file of dummy data. The first column contains the filename of the image file. The second column contains a single keyword, as per below. The text file is attached.

filename   Keyword
P-6-072231.jpg   Alpha
P-6-072232.jpg   Beta

I have added the filename to the code replacement dialog. I have added \{filename}#1\ to the keywords field in the IPTC Stationery Pad dialog. When I 'apply IPTC Stationery Pad to Photos', "\{filename}#1\" has been replaced by "\P-6-072231.jpg#1\". I had expected it to be replaced by "\Alpha\".

What am I doing wrong?

Thanks

[Hayo Baan]

I just tried your file and that is just fine. What I suspect has happened is that you have changed the code replacement character to something other than the default “\” (I personally have it set to “`”). Look at your code replacement delimiter found in the code replacement dialog where you also load the code replacement files (see attached screenshot for reference).