# Tagged Digital Images- simple way to get EXIF and IPTC tags? **URL:** \ **Category:** Factual Questions\ **Created:** [December 24, 2008, 4:49pm UTC](https://boards.straightdope.com/t/tagged-digital-images-simple-way-to-get-exif-and-iptc-tags/478563 "2008-12-24T16:49:35Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Stan\_Doubt](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@Stan\_Doubt](https://boards.straightdope.com/u/Stan_Doubt)\ **Post date:** [December 24, 2008, 4:49pm UTC](https://boards.straightdope.com/t/tagged-digital-images-simple-way-to-get-exif-and-iptc-tags/478563/1 "2008-12-24T16:49:35Z")
Inspired by[this thread](http://boards.straightdope.com/sdmb/showthread.php?t=485420) and what I’ve read on [Controlled Vocabulary](http://www.controlledvocabulary.com/) I’d like to add some Description (caption) and keyword information to some sets of images. I’ve found Microsoft Pro Photo Tools and Irfanview both seem to do this well enough for my purposes and seem to create metadata that is interoperable with other programs I tried. Both programs have the ability to edit metadata for multiple images at a time which is useful for things that don’t change, like copyright, etc. The question I have is what I can then **do** with that tag information. These image libraries will be used by a large number of people and I’m reluctant to lock into any one particular gallery program or anything that is too complicated. Windows Explorer (XP) can access some EXIF tag information, but not the IPTC tags (At least the ones I mentioned). This is fixed using something called PixVue, which has a context menu and shell extension so that the caption can be selected in the detail folder view. PixVue really seems to slow down my machine though. But what if I want to be able to access the tags and organize the images in a more general use database (Access or MySQL)? ---
**Author:** ![Duckster](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/duckster/32/1244_2.png) [@Duckster](https://boards.straightdope.com/u/Duckster)\ **Post date:** [December 24, 2008, 10:43pm UTC](https://boards.straightdope.com/t/tagged-digital-images-simple-way-to-get-exif-and-iptc-tags/478563/2 "2008-12-24T22:43:19Z")
[Take a look here](http://graphicssoft.about.com/od/exifsoftware/EXIF_IPTC_XMP_Software_Metadata_Readers_Editors_Extraction_Tools.htm). It appesars a couple of the programs listed allow you to export the data to a CSV file, HTML and even text. ---
**Author:** ![Nanoda](https://avatars.discourse-cdn.com/v4/letter/n/ce73a5/32.png) [@Nanoda](https://boards.straightdope.com/u/Nanoda)\ **Post date:** [December 25, 2008, 4:55pm UTC](https://boards.straightdope.com/t/tagged-digital-images-simple-way-to-get-exif-and-iptc-tags/478563/3 "2008-12-25T16:55:39Z")
That’s a pretty comprehensive link. I was going to suggest jhead (mentioned there), which is a utility used in [Gallery](http://gallery.menalto.com/) among other things, and should take well to scripting, which it sounds like you want to do. ---
**Author:** ![Stan\_Doubt](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@Stan\_Doubt](https://boards.straightdope.com/u/Stan_Doubt)\ **Post date:** [December 26, 2008, 9:07pm UTC](https://boards.straightdope.com/t/tagged-digital-images-simple-way-to-get-exif-and-iptc-tags/478563/4 "2008-12-26T21:07:33Z")
Jhead is almost doing it, only when I run it with the [-c] option it only returns a small amount of data, rather than all data on one line as described in the instructions. I can certainly parse through this output in a later step, but it would be better if the program generated output on one line for each image then I could just dump that to a table in my database. > [@](#): > > -c > > Concise output. This causes picture info to be summarized on one line instead of several. Useful for grep-ing through images, as well as importing into spread sheets (data is space delimited with quotes as text qualifier). Looking further, I found a Perl library called [ExifTool](http://www.sno.phy.queensu.ca/~phil/exiftool/index.html#running) by Paul Harvey which looks like it is doing the trick. I just have to test it on different input files/directories.