Program that sorts through folder of raw files and lists focal length of pics...

Started Feb 14, 2013 | Questions thread
jtan163
Contributing MemberPosts: 977Gear list
Like?
Re: Program that sorts through folder of raw files and lists focal length of pics...
In reply to Stephan J, Feb 19, 2013

ExifTool:

http://www.sno.phy.queensu.ca/~phil/exiftool/

There are mac and windows versions. Oh yeah Linux/Unix too - not sure how relevant that would be here.
I have a Mac so I'll give an example for Mac.
Windows should be broadly similar and there is some help on the download site.

It reall is a cool tool.

Hope it helps.

Example:

On a mac you'd do it like this:

1) Open the terminal and type:

exiftool

Don't hit return.

2)Drag an example image you want to process to the terminal window.
The path to the image file should appear after the "exiftool" that you typed. E.g.:
exiftool /Users/a1155344/Desktop/Photos/AugiesJPEG/_C25000920121225.jpg

3) Now hit return.

You should get something like this (scroll down - instructions continue after the output below):

exiftool /Users/a1155344/Desktop/Photos/AugiesJPEG/_C25000920121225.jpg
ExifTool Version Number : 9.18
File Name : _C25000920121225.jpg
Directory : /Users/a1155344/Desktop/Photos/AugiesJPEG
File Size : 5.4 MB
File Modification Date/Time : 2012:12:25 20:34:23+10:30
File Access Date/Time : 2013:02:19 23:14:49+10:30
File Inode Change Date/Time : 2012:12:25 20:34:23+10:30
File Permissions : rw-r--r--
File Type : JPEG
MIME Type : image/jpeg
Exif Byte Order : Little-endian (Intel, II)
Image Description : OLYMPUS DIGITAL CAMERA
Make : OLYMPUS IMAGING CORP.
Camera Model Name : E-M5
X Resolution : 200
Y Resolution : 200
Resolution Unit : inches
Software : Adobe Photoshop Lightroom 3.4.1
Modify Date : 2012:12:25 20:34:23
Artist : Jason Tan
Copyright : Some Geezer
Exposure Time : 1/3200
F Number : 8.0
Exposure Program : Aperture-priority AE
ISO : 25600
Sensitivity Type : Standard Output Sensitivity
Exif Version : 0230
Date/Time Original : 2012:12:25 13:37:14
Create Date : 2012:12:25 13:37:14
Shutter Speed Value : 1/3200
Aperture Value : 8.0
Exposure Compensation : 0
Max Aperture Value : 3.5
Metering Mode : Center-weighted average
Light Source : Shade
Flash : On, Did not fire
Focal Length : 12.0 mm
Focal Plane X Resolution : 266.1021423
Focal Plane Y Resolution : 266.1021423
Focal Plane Resolution Unit : mm
File Source : Digital Camera
CFA Pattern : [Red,Green][Green,Blue]
Custom Rendered : Normal
Exposure Mode : Auto
White Balance : Manual
Digital Zoom Ratio : 1
Focal Length In 35mm Format : 24 mm
Scene Capture Type : Standard
Gain Control : High gain up
Contrast : Normal
Saturation : Normal
Sharpness : Normal
Lens Model : OLYMPUS M.12-50mm F3.5-6.3
Compression : JPEG (old-style)
Thumbnail Offset : 1050
Thumbnail Length : 13958
Displayed Units X : inches
Displayed Units Y : inches
Current IPTC Digest : f0ae4cf3fea86a2fc7d5ef0cfd8d84f4
Coded Character Set : UTF8
Application Record Version : 4
Keywords : Adelaide, Australia, EM-5, OMD, Olympus, SA, South Australia
Time Created : 13:37:14
Digital Creation Date : 2012:12:25
Digital Creation Time : 13:37:14
By-line : Jason Tan
Province-State : South Australia
Country-Primary Location Code : AU
Country-Primary Location Name : Australia
Copyright Notice : Some Geezer
Caption-Abstract : OLYMPUS DIGITAL CAMERA
Copyright Flag : True
URL : meh.com
Photoshop Thumbnail : (Binary data 13958 bytes, use -b option to extract)
IPTC Digest : f0ae4cf3fea86a2fc7d5ef0cfd8d84f4
Profile CMM Type : ADBE
Profile Version : 2.1.0
Profile Class : Display Device Profile
Color Space Data : RGB
Profile Connection Space : XYZ
Profile Date Time : 1999:06:03 00:00:00
Profile File Signature : acsp
Primary Platform : Apple Computer Inc.
CMM Flags : Not Embedded, Independent
Device Manufacturer : none
Device Model :
Device Attributes : Reflective, Glossy, Positive, Color
Rendering Intent : Perceptual
Connection Space Illuminant : 0.9642 1 0.82491
Profile Creator : ADBE
Profile ID : 0
Profile Copyright : Copyright 1999 Adobe Systems Incorporated
Profile Description : Adobe RGB (1998)
Media White Point : 0.95045 1 1.08905
Media Black Point : 0 0 0
Red Tone Reproduction Curve : (Binary data 14 bytes, use -b option to extract)
Green Tone Reproduction Curve : (Binary data 14 bytes, use -b option to extract)
Blue Tone Reproduction Curve : (Binary data 14 bytes, use -b option to extract)
Red Matrix Column : 0.60974 0.31111 0.01947
Green Matrix Column : 0.20528 0.62567 0.06087
Blue Matrix Column : 0.14919 0.06322 0.74457
XMP Toolkit : Adobe XMP Core 5.2-c004 1.136881, 2010/06/10-18:11:35
Format : image/dng
Creator Tool : Adobe Photoshop Lightroom 3.4.1
Metadata Date : 2012:12:25 20:34:23+10:30
Serial Number : BEM504172
Lens Info : 12-50mm f/3.5-6.3
Lens : OLYMPUS M.12-50mm F3.5-6.3
Lens Serial Number : ABP260123
Approximate Focus Distance : 1.5
Flash Compensation : -1
Date Created : 2012:12:25 13:37:14
Country : Australia
City : Adelaide
State : South Australia
Document ID : xmp.did:088011740720681183D1A49412342193
Original Document ID : 7838DAD78C3073571B11CC9E481251F2
Instance ID : xmp.iid:088011740720681183D1A49412342193
Country Code : AU
Marked : True
Web Statement : Eat my shorts
Version : 6.4.1
Process Version : 5.7
Color Temperature : 7350
Tint : -2
Exposure : 0.00
Shadows : 5
Brightness : +50
Luminance Smoothing : 40
Color Noise Reduction : 25
Chromatic Aberration R : 0
Chromatic Aberration B : 0
Vignette Amount : 0
Shadow Tint : 0
Red Hue : 0
Red Saturation : 0
Green Hue : 0
Green Saturation : 0
Blue Hue : 0
Blue Saturation : 0
Fill Light : 0
Vibrance : 0
Highlight Recovery : 0
Clarity : 0
Defringe : 0
Hue Adjustment Red : 0
Hue Adjustment Orange : 0
Hue Adjustment Yellow : 0
Hue Adjustment Green : 0
Hue Adjustment Aqua : 0
Hue Adjustment Blue : 0
Hue Adjustment Purple : 0
Hue Adjustment Magenta : 0
Saturation Adjustment Red : 0
Saturation Adjustment Orange : 0
Saturation Adjustment Yellow : 0
Saturation Adjustment Green : 0
Saturation Adjustment Aqua : 0
Saturation Adjustment Blue : 0
Saturation Adjustment Purple : 0
Saturation Adjustment Magenta : 0
Luminance Adjustment Red : 0
Luminance Adjustment Orange : 0
Luminance Adjustment Yellow : 0
Luminance Adjustment Green : 0
Luminance Adjustment Aqua : 0
Luminance Adjustment Blue : 0
Luminance Adjustment Purple : 0
Luminance Adjustment Magenta : 0
Split Toning Shadow Hue : 0
Split Toning Shadow Saturation : 0
Split Toning Highlight Hue : 0
Split Toning Highlight Saturation: 0
Split Toning Balance : 0
Parametric Shadows : 0
Parametric Darks : 0
Parametric Lights : 0
Parametric Highlights : 0
Parametric Shadow Split : 25
Parametric Midtone Split : 50
Parametric Highlight Split : 75
Sharpen Radius : +2.4
Sharpen Detail : 43
Sharpen Edge Masking : 42
Post Crop Vignette Amount : 0
Grain Amount : 0
Luminance Noise Reduction Detail: 50
Color Noise Reduction Detail : 50
Luminance Noise Reduction Contrast: 0
Lens Profile Enable : 0
Lens Manual Distortion Amount : 0
Perspective Vertical : 0
Perspective Horizontal : 0
Perspective Rotate : 0.0
Perspective Scale : 100
Convert To Grayscale : False
Tone Curve Name : Medium Contrast
Camera Profile : Adobe Standard
Camera Profile Digest : CCCFF98213C6ABE7CE43CE603C9047F8
Lens Profile Setup : LensDefaults
Has Settings : True
Has Crop : False
Already Applied : True
Description : OLYMPUS DIGITAL CAMERA
Creator : Some Geezer
Rights : Some Geezer
Subject : Some thing or other
History Action : derived, saved
History Parameters : converted from image/x-olympus-raw to image/dng, saved to new location
History Instance ID : xmp.iid:088011740720681183D1A49412342193
History When : 2012:12:25 19:54:28+10:30
History Software Agent : Adobe DNG Converter 7.1 (Macintosh)
History Changed : /
Derived From Document ID : 7838DAD78C3073571B11CC9E481251F2
Derived From Original Document ID: 7838DAD78C3073571B11CC9E481251F2
Creator Work Email : jtan163@gmail.com
Usage Terms : All rights reserved. Email jtan163@gmail.com for rights.
Tone Curve : 0, 0, 32, 22, 64, 56, 128, 128, 192, 196, 255, 255
DCT Encode Version : 100
APP14 Flags 0 : [14]
APP14 Flags 1 : (none)
Color Transform : YCbCr
Image Width : 4608
Image Height : 3456
Encoding Process : Baseline DCT, Huffman coding
Bits Per Sample : 8
Color Components : 3
Y Cb Cr Sub Sampling : YCbCr4:4:4 (1 1)
Aperture : 8.0
Date/Time Created : 2012:12:25 13:37:14
Digital Creation Date/Time : 2012:12:25 13:37:14
Image Size : 4608x3456
Scale Factor To 35 mm Equivalent: 2.0
Shutter Speed : 1/3200
Thumbnail Image : (Binary data 13958 bytes, use -b option to extract)
Circle Of Confusion : 0.015 mm
Field Of View : 73.7 deg
Focal Length : 12.0 mm (35 mm equivalent: 24.0 mm)
Hyperfocal Distance : 1.20 m
Light Value : 9.6

4) You can choose whichever tags you want to output.
The tags may vary with your camera, so check one of your files.
For me to output the Focal Length and File Name you need type:

exiftool -FocalLength -FileName

5) Don't hit return.
Note I removed the spaces and and preceded the tag names with a dash ('-').

6) Then drag the folder you want to process onto the terminal window.
That should cause the path to the folder to appear after the "exiftool -FocalLength -FileName".
E.g. it should look like that:

exiftool -FocalLength -FileName /Users/a1155344/Desktop/Photos/AugiesJPEG/
7)Hit return.

E.g.:

exiftool -FocalLength -FileName /Users/a1155344/Desktop/Photos/AugiesJPEG/
======== /Users/a1155344/Desktop/Photos/AugiesJPEG/_C25000920121225.jpg
Focal Length : 12.0 mm
File Name : _C25000920121225.jpg
======== /Users/a1155344/Desktop/Photos/AugiesJPEG/_C25001020121225.jpg
Focal Length : 12.0 mm
File Name : _C25001020121225.jpg
======== /Users/a1155344/Desktop/Photos/AugiesJPEG/_C25001120121225.jpg
Focal Length : 12.0 mm
File Name : _C25001120121225.jpg
======== /Users/a1155344/Desktop/Photos/AugiesJPEG/_C25001220121225.jpg
Focal Length : 12.0 mm
File Name : _C25001220121225.jpg

etc etc etc

 jtan163's gear list:jtan163's gear list
Olympus C-740 UZ Nikon D7000 Olympus OM-D E-M5 Nikon AF-S DX Nikkor 16-85mm f/3.5-5.6G ED VR Nikon AF-S DX Nikkor 35mm f/1.8G +13 more
Reply   Reply with quote   Complain
Keyboard shortcuts:
FForum PPrevious NNext WNext unread UUpvote SSubscribe RReply QQuote BBookmark post MMy threads
Color scheme? Blue / Yellow