Posted on 2009-11-21 16:10:22-08 by allenh
importing csv data file into IPTC fields
This seems like an extremely strong application/tool, but I'm having a problem reading the information and finding the solution to my needs. I'm sure it's there, but I could really use the help. Thank in advance for any guidance.

I have 100k+ images, all my keywords, captions, copyright etc, are in Filemaker, I can export them as csv files (rename/reorder fields if necessary, etc), but I want to write the info to the IPTC fields in the JPGS so that I can use Lightroom or Aperature - so how do I write/copy the data from the exported file to jpgs?

I would prefer to export the data on per directory basis (to keep the number of files to a few thousand at a time) rather than have to export individual data for each file/image.

Any thoughts on how to do this efficiently is greatly appreciated.

Direct Responses: 11802 | Write a response
Posted on 2009-11-21 16:38:41-08 by exiftool in response to 11801
Re: importing csv data file into IPTC fields
ExifTool will not read CSV files. You have two options:

1) import the CSV file into a spreadsheet or some other program and use this program to generate an exiftool command line for each of the files you want processed.

2) write a simple Perl script to process your CSV file and use the exiftool API functions to do all the hard work.

See this thread for an example of the 2nd technique.

- Phil
Direct Responses: Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.