Batch IPTC to jpg from xl (excel) file

[danielpetrescu]

Hello there,

I am new here and I have a question if someone can help me with.
My database contains more than 60.000 images and I keep it in a folder structure well organized. I also use ACDsee pro to manage files. The structure of file structure database is as follows:
Mainfolder
- sub folder
-folder
- File.jpg (tiff or cr2 raw)

As most of the files are pictures of wildlife species, I need to upload into caption, names in 8 different languages ex: En.Bird, Lat. Aves, Ro. Pasari etc.
All this names are in a XL spreadsheet. I have seen scripts that can write to IPTC on individual files but that is too complicated for me. What I would like is to write to certain IPTC field to all files in a specific folder at once? Is it possible? If so can anyone help with such script?

To be more spcific if I have a folder named - BIRDS_EAGLES containing 100 jpg files can I find a way to write to all 100 pictures at once without needing to type names into xl spreadsheet?

Thank you...
Daniel

[oops66]

Hello,
You can use exiftool, so concatenate into the proper way the exiftool commands into excel, then copy the result to a batch.bat file, then execute it.
Exiftool link:
http://www.sno.phy.queensu.ca/~phil/exiftool/
The .bat file (command to add IPTC Keywords):

Code: Select all

exiftool -iptc:keywords+=bird -iptc:keywords+=red -o a-english.jpg a.jpg
exiftool -iptc:keywords+=oiseau -iptc:keywords+=rouge -o a-french.jpg a.jpg
...