Laszlo wrote, on 06/20/2005, 18:48:19:

Hi!

This is a fairly simple and FREE way to bulk insert IPTC info into your jpeg images from an Excel table. The Excel table will have to have one column containing the file names, and four more columns for the Title, Caption, Keywords, and Category fields. Doing the following does require familiarity with your computer, excel, and a text-editor.

An example implementation is included, for two images. The images are named 0309M08.jpg and 0309M11.jpg. The title, caption, keyword, and category data to be inserted into the IPTC fields for each image can be found in the sample excel file, batch_iptc.xls, on the worksheet named "OzImages IPTC Tags". For setting the IPTC fields of your own images, follow the procedure below.

The procedure to set the IPTC fields for your images is as follows:

1. Copy the images you want to set the IPTC info for into the directory where you unzipped the files (i.e. where this readme.txt file is).
2. Insert the filenames of each image and your own title (ObjectName column), caption (Caption column), keywords (Keywords column), and OzImages category numbers (Category column) into the worksheet "batch_iptc.xls".
3. Go to the worksheet titled "Batch File to Clear IPTC Tags" and copy each line from it.
4. Open the batch file "clear_iptc.bat" in a text-editor (notepad will do), delete everything in the file
5. Paste what you copied from the excel worksheet into the batch file.
6. Similarly, go to the worksheet titled "Batch File to Set IPTC Tags", copy each line from it, open the file "set_iptc.bat" in a text-editor, delete everything from the file, and paste what you copied.
7. Now run the two files: first "clear_iptc.bat", then "set_iptc.bat".

Done!!!

-----------------------------------
The "crux" of this procedure is the batch program, exiv2. I did not write it! It is a freeware program, you can find out more about it here:
http://home.arcor.de/ahuggel/exiv2/

-----------------------------------
A great tool to set the IPTC data for an image straight from windows explorer is IPTCExt. Use it to double-check that the above procedure correctly inserted the IPTC data into your images! It is freeware and can be downloaded from:
http://photothumb.com/IPTCExt/index.shtml

Regards,
Laszlo Lieszkovszky

Follow-ups:

• Neteller Online Janice Dowen 14:39:57 1/30/106 (0)