Free Shipping on ALL Products
camera reviewsbest cameraslens reviewsphotography tipscamera forumvideo toursphotography bookssupport me
It is currently Sat Dec 20, 2014 4:12 am

All times are UTC




Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Author Message
PostPosted: Fri Jan 04, 2008 1:10 pm 
Offline
User avatar

Joined: Sun May 27, 2007 12:39 pm
Posts: 601
Location: France
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


Last edited by rei_vilo on Mon Jan 07, 2008 8:40 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Sun Jan 06, 2008 12:25 am 
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)


Top
  
 
 Post subject:
PostPosted: Sun Jan 06, 2008 8:07 am 
Offline
User avatar

Joined: Sun May 27, 2007 12:39 pm
Posts: 601
Location: France
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


Top
 Profile  
 
 Post subject:
PostPosted: Sun Jan 06, 2008 1:34 pm 
rei_vilo wrote:
I started reading the extensive documentation but I'm a little lost with so many parameters...

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

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

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,,,


Top
  
 
 Post subject:
PostPosted: Sun Jan 06, 2008 2:31 pm 
Offline
User avatar

Joined: Sun May 27, 2007 12:39 pm
Posts: 601
Location: France
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
Quote:
exiftool -p "$filename $dateTimeOriginal f/$Aperture ${ShutterSpeed}s iso$ISO $FocalLength" -q D:\DCIM\100PENTX\IMGP*.jpg > D:\DCIM\100PENTX\EXIF.txt


And the result is
Quote:
IMGP0368.JPG 2008:01:06 15:04:55 f/4.0 1/20s iso400 50.0mm
IMGP0369.JPG 2008:01:06 15:05:18 f/4.0 1/20s iso400 50.0mm
IMGP0370.JPG 2008:01:06 15:05:22 f/4.0 1/20s iso400 50.0mm
IMGP0371.JPG 2008:01:06 15:05:35 f/4.0 1/30s iso400 50.0mm
IMGP0372.JPG 2008:01:06 15:06:19 f/4.0 1/30s iso400 135.0mm
IMGP0373.JPG 2008:01:06 15:07:05 f/2.8 1/45s iso400 135.0mm
IMGP0374.JPG 2008:01:06 15:07:18 f/2.8 1/45s iso400 135.0mm
IMGP0375.JPG 2008:01:06 15:08:22 f/2.8 1/45s iso400 50.0mm
IMGP0376.JPG 2008:01:06 15:08:32 f/2.8 1/45s iso400 50.0mm

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 :wink: But now, I should translate it back to Mac :!:

By the way, I've found a Windows GUI for EXIFTool : :arrow: 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


Top
 Profile  
 
 Post subject:
PostPosted: Sun Jan 06, 2008 6:36 pm 
rei_vilo wrote:
Thank you so much for sharing your parameters :)
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.

Quote:
the newborn lambs (do you plan to take pictures of them) :!:
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 :wink: :)


Top
  
 
 Post subject:
PostPosted: Sun Jan 06, 2008 8:38 pm 
Offline
Moderator
User avatar

Joined: Sun Nov 05, 2006 11:08 pm
Posts: 7972
Location: Germany
:oops: twisting MacolmP's arm :oops:

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


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 07, 2008 1:35 am 
Thomas wrote:
:oops: twisting MacolmP's arm :oops:
:) yelp! ow! I yield :) >posted>


Top
  
 
 Post subject:
PostPosted: Mon Jan 07, 2008 8:45 pm 
Offline
User avatar

Joined: Sun May 27, 2007 12:39 pm
Posts: 601
Location: France
Playing with fields gives incredible results :!:

With this
Quote:
exiftool -p "$filename $dateTimeOriginal f/$Aperture ${ShutterSpeed}s iso$ISO $FocalLength (${LensType})" -q D:\DCIM\100PENTX\IMGP*.jpg > D:\DCIM\100PENTX\EXIF.txt

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

We get that
Quote:
IMGP0114.JPG 2007:12:23 14:00:23 f/5.6 1/125s iso100 16.0mm (smc PENTAX-DA* 16-50mm F2.8 ED AL [IF] SDM)

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


Last edited by rei_vilo on Mon Jan 07, 2008 9:24 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 07, 2008 9:10 pm 
Offline
Moderator
User avatar

Joined: Sun Nov 05, 2006 11:08 pm
Posts: 7972
Location: Germany
Malcolm wrote:
:) yelp! ow! I yield :) >posted>

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

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


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 07, 2008 9:26 pm 
Offline
User avatar

Joined: Sun May 27, 2007 12:39 pm
Posts: 601
Location: France
Thomas wrote:
But where's the LINK :?:

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


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 07, 2008 9:47 pm 
Offline
Moderator
User avatar

Joined: Sun Nov 05, 2006 11:08 pm
Posts: 7972
Location: Germany
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


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 07, 2008 10:50 pm 
Thomas wrote:
But where's the LINK :?:
:oops: Ooops, sorry folks, I think my one remaining brain cell must have still been suffering from hypothermia ! :cry:


Top
  
 
 Post subject:
PostPosted: Wed Jan 09, 2008 1:20 am 
rei_vilo wrote:
with EXIF data :) :?:
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.


Top
  
 
 Post subject:
PostPosted: Wed Jan 09, 2008 9:53 am 
Offline
Moderator
User avatar

Joined: Sat Sep 30, 2006 4:30 pm
Posts: 9833
Location: UK
MalcolmP wrote:
...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.

_________________
Olympus OM-D E-M1 + M.Zuiko Digital ED 12-40mm f/2.8, Lumix 7-14mm f/4, Leica DG Summilux 15mm f/1.7 ASPH, M.Zuiko Digital 45mm 1:1.8, M.Zuiko Digital ED 75mm 1:1.8.
Leica D Vario-Elmar 14mm-150mm f/3.5 - f/5.6 ASPH.
OM-D E-M5, H-PS14042E, Gitzo GT1541T, Arca-Swiss Z1 DP ball-head.
Astrophotography: TEC 140 'scope, FLI ML16803 camera, ASA DDM60 Pro mount.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron

All words, images, videos and layout, copyright 2005-2012 Gordon Laing. May not be used without permission.
/ How we test / Best Cameras / Advertising / Camera reviews / Supporting Camera Labs

Webdesign by Alphabase IT
Powered by phpBB® Forum Software © phpBB Group