Import CSV columns to IPTC in JPG and/or EPS

[Morphart]

Hi!

I would like to import IPTC data of my files from a CSV with columns containing: FILENAME (a .jpg or .eps), TITLE, DESCRIPTION, KEYWORDS and if possible also add the same Author info for all files.

How would I import the correct columns in their right place from a CSV to all the files in a folder? Is this possible?

(Basically I want a team to keyword my images and send me a CSV instead of sending them the files so they put the IPTC manually in each files and need to open and save and send back all files).

If it's complex work you can PM and I can pay or hire to have this custom line, unless it's common use?

Thanks very much for your help!

[StarGeek]

FAQ #26

The basic command would be
exiftool -sep ", " -csv=/path/to/csvfile.csv /path/to/target/Directory

From the sound of it, there are probably some changes that will need to be done to your csv file, though.

The first column must be named SourceFile and contain the full path to the file.  Filename is not enough.

The headers of your columns are fine, though the tag names are mixing Legacy IPTC (Keywords) and IPTC Core (Title and Description), which is actually XMP.  Odds are that you actually want the IPTC Core in which case Keywords would have to be changed to Subject. 

Since you have keywords, I'm assuming they are separated by a comma.  This is the most likely scenario.  If they are separated by something else, you would need to change the -sep ", " to reflect what they are separated with.

Here's an example of what your CSV file should look like:

Code Select Expand

SourceFile,Description,Title,Subject
X:/!temp/Test3.jpg,My Description,Super Great Title,"Keyword 1, Keyword 2"

[Morphart]

Wow this looks awesome. My CSV is not created yet I wanted to make sure 100% it was possible before putting a team on it.

I will do a test CSV today and let you know how it went, thanks so much for this!

[Morphart]

Hi!

I managed to make this work perfectly on the JPG by running this command:

Code Select Expand

exiftool -sep ", " -copyrightNotice="Morphart Creations inc." -xmp:copyrightstatus=protected -xmp-xmprights:marked=true -csv=C:\Users\Utilisateur\Desktop\Ray\Book1.csv C:\Users\Utilisateur\Desktop\Ray\
or simply:

Code Select Expand

exiftool -sep ", " -csv=C:\Users\Utilisateur\Desktop\Ray\Book1.csv C:\Users\Utilisateur\Desktop\Ray\

I tried add .EPS also and I get warning error : Warning: Can't write XMP to PostScript-format Illustrator files

Is it because exiftool don't accept EPS files made from Illustrator?

[Phil Harvey]

Yes.  It will write EPS files from other sources, and PDF files from Illustrator, but not EPS files from Illustrator.

- Phil