Write EXIF from CSV to TIFFs

Started by stevenjssanders, January 31, 2017, 01:46:01 PM

Previous topic - Next topic

stevenjssanders

Hello all!

I've been scanning large technical drawings into a TIFF format.  I've been separately making a XLS of filename, author, title, date, etc that I want to embed into the TIFF's EXIF.  Rather than doing this manually for hundreds of files, how could I get exiftool to do the work for me?  Is there something in exiftool that already does that?  Like if the filenames match, write this metadata? 

Phil Harvey

Are you talking about importing a database and writing these values to the TIFF image?  If so, see FAQ 26.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

stevenjssanders

Phil, I got that far, but it seems like some of the tags I want to add don't exist and I can't seem to write them. 

C:\Users\ssanders\Documents\EXIFS>exiftool.exe -Classification="TEST" sample.tif

Warning: Sorry, Classification is not writable
Nothing to do.

Is this where I'd need to try an exiftool config file to add them? 

Phil Harvey

You don't give me much information to go on, but I think the answer to your question is "yes".

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

csantiago5

Phil,

New to ExifTool so thank you for creating it and making it available.  I would also raise my hand for the ability to write to tags for MS Word and Excel.  This post is a little old so I don't know if something has changed but I did try to find another program to write tags for these types of files but didn't really see anything useful.  I'm somewhat surprised because I would think there would be a need for it (easy for me to say since I'm not the one building it). 

Thanks,

Carlos

Phil Harvey

Hi Carlos,

This post is about writing EXIF tags from a CSV file to a TIFF image, which ExifTool could already do.

It sound like you are talking about writing either DOC or DOCX files, which isn't yet supported.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).