Export IPTC captions in DigiKam

troodon · March 23, 2020, 7:07pm

I’m trying to batch export IPTC captions to a text or spreadsheet file, preferably using DigiKam, but open to other software options. Any ideas?

paperdigits · March 23, 2020, 9:12pm

a simple exiftool script could probably dump a CSV file for you.

troodon · March 23, 2020, 9:34pm

I’m trying that, but struggling to get the right command.

paperdigits · March 23, 2020, 10:09pm

Post a photo that has the IPTC tags and tell us what info you want in the CSV file

troodon · March 23, 2020, 10:09pm

For example:
exiftool *.jpg -T -filename -Exif:Comment -aperture > out.txt

This creates the out.txt file, and lists the aperture, but I can’t get the caption as well. I’ve tried “Exif:Caption”, “Iptc:Comment” etc.but can’t get the right combo.

paperdigits · March 23, 2020, 10:11pm

If you do exiftool file.jpg it’ll dump a list of all tags it can see. You can grep 'em or look through them

troodon · March 23, 2020, 10:25pm

Thanks. I want the file name and caption. Seems like the caption has different names depending on the program, which contributes to the confusion. In Gimp it’s called “Description”, in Geeqie it’s “Comment” and in digiKam it’s called “Captions”.

paperdigits · March 23, 2020, 10:34pm

You can use:

exiftool -csv -Comment DSC_0029\ robson\ lowres.jpg to see it in the terminal.

and

exiftool -csv > your-spreadsheet.csv -Comment DSC_0029\ robson\ lowres.jpg to write the CSV file to disk.

troodon · March 23, 2020, 10:47pm

That did it! Thanks so much paperdigits!