ExifTool Forum

ExifTool => Archives => Topic started by: Archive on May 12, 2010, 08:54:42 AM

Title: importing csv data file into IPTC fields
Post by: Archive on May 12, 2010, 08:54:42 AM
[Originally posted by allenh on 2009-11-21 16:10:22-08]

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.
Title: Re: importing csv data file into IPTC fields
Post by: Archive on May 12, 2010, 08:54:42 AM
[Originally posted by exiftool on 2009-11-21 16:38:41-08]

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