Camera Labs

Bonjour,

I'm looking for an EXIF batch extractor running under Mac OS 10.4

• input: the directory with the pictures
• output: a text file (comma separated or better, tab separated) with name, date, time, speed, aperture, ISO, focal length

I've found one EXIF extractor (EXIF-O-Matic), but I obtain one text file per image , with all the EXIF info, much more than I need. Extracting the data I need and copy-pasting them is much of a hassle .

The purpose is to ease my posting at the CameraLabs forum

Thank you for your help

_________________
--- rei_vilo
Pentax K-5 + BG4 + DA* 16-50 + DA* 50-135 + DA* 60-250 + AF-540FGZ
reivilophotography.weebly.com

ExifTool by Phil Harvey
http://www.sno.phy.queensu.ca/~phil/exiftool/
may be worth a try for you.
I have only used the Windows version, not the Mac OS one.

It writes one text file for all the exifs of all the files in a directory.
It has lots of options for selecting which exif tags to be extracted and all sorts of other formatting options,
I do not know if it will do tab separated though

I have only used it in a 'one line per file' mode with commas inserted between chosen extracted tags, like this example :
P1000228.JPG 2007:11:28 19:34:36(f/2.8, 60s, ISO 100)
P1000229.JPG 2007:11:28 19:42:03(f/2.8, 60s, ISO 100)
P1000230.JPG 2007:11:28 19:47:53(f/2.8, 60s, ISO 100)

Bonjour Malcolm,

Thank you very much for the link

The output example you provide suits my needs

I started reading the extensive documentation but I'm a little lost with so many parameters...

Which is the line (exiftools + parameters) you type to obtain the output you provide

Thank you and best regards,

_________________
--- rei_vilo
Pentax K-5 + BG4 + DA* 16-50 + DA* 50-135 + DA* 60-250 + AF-540FGZ
reivilophotography.weebly.com

Yes, me too ! It is quite a steep learning curve ! I dont understand it all yet !!


This is an example of one of the command lines that I have used :
(e is the name of my exiftool executable, I shortened it to save a few letters typing each time when I was experimenting with it in the early days ! )
e -p " $filename $dateTimeOriginal (f/$Aperture, ${ShutterSpeed}s, ISO $ISO)" -q C:\1Panasonic\exif\P*.jpg > C:\1Panasonic\exif\index10.txt

good luck, I hope I have picked out the right example command line for you, my file system is in a bit of a mess and I'm a bit short of time at the moment, we have had a late chrismass present of some newborn lambs which need attending to, hope the above example gets you going,, I'll be back later,,,

Malcolm,

Thank you so much for sharing your parameters The result is exactly what I've been looking for for more than 3 months

On my old PC, I adapted the command-line to


And the result is

This TXT file is easily imported by Excel, just specifying space as a field delimiter, or by remplacing the spaces by tabs.
That will gratly ease my posting on CameraLabs forum But now, I should translate it back to Mac

By the way, I've found a Windows GUI for EXIFTool : ExifTool GUI for Windows v2.23 [27. Dec. 2007]. But it doesn't seem to allow picking specific parameters.

Thank you again and take care of the newborn lambs (do you plan to take pictures of them)

Best regards,

_________________
--- rei_vilo
Pentax K-5 + BG4 + DA* 16-50 + DA* 50-135 + DA* 60-250 + AF-540FGZ
reivilophotography.weebly.com

My pleasure, glad to be of service and it is good news that you have got it working.

I have just tried an experiment with TABs, I replaced my commas, in the command line I showed erlier, with TABs and it has worked ok, like this :
(snip) a bit(/snip)
Oh! looks like the forum gets messed up with tabs so I can't show what I am seeing, but I expect you get the idea !

Thanks for the link to the GUI, I'll have a look at that later, I did try a GUI (can not remember if it was that one) but, as you say, Windows was too limiting and so I went back to playing with the much more flexible command line original.

Yes, got a load of pics, have not had time to sort them yet ! If some turn out to be semi-respectable I may allow my arm to be twisted and post some in the pets section

twisting MacolmP's arm

_________________
Thomas (beware: Nikon-fanboy and moderator!) My Lens Reviews, My Pictures, My Photography Blog
D800+assorted lenses

:) yelp! ow! I yield >posted>

Playing with fields gives incredible results

With this

assuming the SD card is in the drive D: under Windows

We get that

with my K10D

How easy now to give technical data when publishing pictures on CameraLabs

Thanks again, Malcolm, and don't get your arm hurt

_________________
--- rei_vilo
Pentax K-5 + BG4 + DA* 16-50 + DA* 50-135 + DA* 60-250 + AF-540FGZ
reivilophotography.weebly.com

Oops, sorry mate! I didn't want to apply too much force
But where's the LINK

_________________
Thomas (beware: Nikon-fanboy and moderator!) My Lens Reviews, My Pictures, My Photography Blog
D800+assorted lenses

Yes, where's the link with the pictures with EXIF data

_________________
--- rei_vilo
Pentax K-5 + BG4 + DA* 16-50 + DA* 50-135 + DA* 60-250 + AF-540FGZ
reivilophotography.weebly.com

Ahhh, there it (the LINK) is: http://www.cameralabs.com/forum/viewtopic.php?t=2720.
Thanks, Malcolm, for sharing!

_________________
Thomas (beware: Nikon-fanboy and moderator!) My Lens Reviews, My Pictures, My Photography Blog
D800+assorted lenses

Ooops, sorry folks, I think my one remaining brain cell must have still been suffering from hypothermia !

Hmmm, yes, very good question ! It seems that when I used IrfanView to resize my sheep pics for the forum it did not preserve the exif :-!(

I'm sure it used to, but recently I updated to v4.10. I cant find an option to set though. May have to revert to older version.

Version 4.1 still does. When you save your resized image make sure the "Show options dialog" checkbox is checked and in the options dialog which appears to the right of the Save dialog there is an option to "Keep original EXIF data".

Bob.

_________________
OM-D E-M5 + ED 12-50mm, H-PS14042E, H-F007014E, L-RS014150E, M.ZUIKO DIGITAL 45mm 1:1.8.
Gitzo GT1541T, Arca-Swiss Z1 DP ball-head.
Astrophotography: TEC 140 'scope, FLI ML16803 camera, ASA DDM60 Pro mount.