Hi everyone,
Is it possible to select a specific meta data info in the output file?
When I run this exiftool -r >info2.txt directory, it will give me all the meta info of an image. See below
ExifTool Version Number : 9.28
File Name : 16873_77799__Y0I7777_MG_0295.jpg
Directory : d:/pixfiler
File Size : 12 MB
File Modification Date/Time : 2006:01:26 13:25:34+01:00
File Access Date/Time : 2013:04:22 11:21:28+02:00
File Creation Date/Time : 2013:04:22 11:21:28+02:00
File Permissions : rw-rw-rw-
File Type : JPEG
MIME Type : image/jpeg
JFIF Version : 1.02
Exif Byte Order : Big-endian (Motorola, MM)
Compression : Uncompressed
Make : Canon
Camera Model Name : Canon EOS-1Ds Mark II
Orientation : Horizontal (normal)
Samples Per Pixel : 3
X Resolution : 300
Y Resolution : 300
Planar Configuration : Chunky
Resolution Unit : inches
Software : Adobe Photoshop CS2 Macintosh
Modify Date : 2006:01:26 13:25:28
Exposure Time : 1/15
F Number : 9.0
Exposure Program : Manual
ISO : 100
Exif Version : 0221
Date/Time Original : 2006:01:25 01:00:00
Create Date : 2006:01:25 11:47:54
Components Configuration : Y, Cb, Cr, -
Shutter Speed Value : 1/16
Aperture Value : 9.1
Exposure Compensation : 0
Metering Mode : Multi-segment
Focal Length : 24.0 mm
User Comment :
Flashpix Version : 0100
Color Space : Uncalibrated
Exif Image Width : 4992
Exif Image Height : 3328
Focal Plane X Resolution : 3526.760563
Focal Plane Y Resolution : 3528.042328
Focal Plane Resolution Unit : inches
Custom Rendered : Normal
Exposure Mode : Manual
White Balance : Auto
Scene Capture Type : Standard
Thumbnail Offset : 1104
Thumbnail Length : 6569
Current IPTC Digest : 03b48dc7c4d4f5405a0e9222c3f24aab
Application Record Version : 2
Originating Program : FotoWare fotoweb
By-line : Hans Wretling
Caption-Abstract : Steen & Ström kontor..västra Trädgårdsgatan 2 i Stockholm
Owner ID : Eva Åberg
Document History : A=5001 N=0 E=TXT D=2012-04-11 T=15:42:43 U=15003
IPTC Digest : 03b48dc7c4d4f5405a0e9222c3f24aab
Displayed Units X : inches
Displayed Units Y : inches
Global Angle : 30
Global Altitude : 30
Copyright Flag : False
Photoshop Thumbnail : (Binary data 6569 bytes, use -b option to extract)
Photoshop Quality : 12
Photoshop Format : Optimised
Progressive Scans : 3 Scans
XMP Toolkit : XMP Core 4.4.0
Photometric Interpretation : RGB
Native Digest : 256,257,258,259,262,274,277,284,530,531,282,283,296,301,318,319,529,532,306,270,271,272,305,315,33432;DDE39D61C70DB8DB975B1051B933D482
Metadata Date : 2006:01:26 13:25:28+01:00
Creator Tool : FotoWare fotoweb
XMP File Stamps : 2012:04:11 17:42:43+02:00
Date/Time Digitized : 2006:01:25 11:47:54:00
Flash Fired : False
Flash Return : No return detection
Flash Mode : Off
Flash Function : False
Flash Red Eye Mode : False
Document ID : uuid:7D9D7C29900011DAB45995C5B22E73D8
Instance ID : uuid:7D9D7C2A900011DAB45995C5B22E73D8
Derived From Instance ID : uuid:97A0FF0E8F8511DAB57487F160766945
Derived From Document ID : uuid:9C0C87BC8F8411DAB57487F160766945
Format : image/jpeg
Creator : Hans Wretling
Description : Steen & Ström kontor.västra Trädgårdsgatan 2 i Stockholm
Color Mode : RGB
ICC Profile Name : Adobe RGB (1998)
Owner Id : Eva Åberg
History : A=5001 N=0 E=TXT D=2012-04-11 T=15:42:43 U=15003
Custom Field 17 : Exteriör
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
DCT Encode Version : 100
APP14 Flags 0 : [14]
APP14 Flags 1 : (none)
Color Transform : YCbCr
Image Width : 4992
Image Height : 3328
Encoding Process : Baseline DCT, Huffman coding
Bits Per Sample : 8
Color Components : 3
Y Cb Cr Sub Sampling : YCbCr4:4:4 (1 1)
Aperture : 9.0
Flash : Off, Did not fire
Image Size : 4992x3328
Scale Factor To 35 mm Equivalent: 1.0
Shutter Speed : 1/15
Thumbnail Image : (Binary data 6569 bytes, use -b option to extract)
Circle Of Confusion : 0.030 mm
Field Of View : 73.8 deg
Focal Length : 24.0 mm (35 mm equivalent: 24.0 mm)
Hyperfocal Distance : 2.13 m
Light Value : 10.2
I only want the following: File Size, Date/Time Original, By-line, Owner ID, Creator, Description and Image size.
I tried reading this article http://www.exiftool.org/exiftool_pod.html but I couldnt find any.
Any help is appreciated. I have to do this for all 15,000 images.
Thank you and have a great day!
Regards,
Ed
Hi Ed,
exiftool -filesize -datetimeoriginal -by-line -ownerid -creator -description -imagesize -r DIR > info2.txt
- Phil
Hi Phil,
Thank you so much for your reponse.. YOu juz saved me.. :)
Regards,
Ed :D
Hi Phil,
Is it possible to have the results by columns instead of by row? I need to do this coz im going to import the data in the database?
Thank you and have a great day!!
Regards,
Ed
Hi Ed,
Does the -csv option give you want you want? See FAQ 12 (https://exiftool.org/faq.html#Q12) for more information.
- Phil
Hi Phil,
Thanks for your response. This is what I needed. However, I noticed that if some info are too long, it will go to the next line. Like this
u:/SUPPORT/SUP-19523/EPS_bilder/SS/Bilder/Personal som slutat/39724_Amilia Ripa-2.eps,192 kB,2008:06:11 11:22:03,,Adobe Photoshop Version 12.0.4x20110407 ,""080611"
Foto: Mark Earthy
"www.photographer.se"",200x300"
d:/pixfiler/images/16873_77799__Y0I7777_MG_0295.jpg,12 MB,2006:01:25 01:00:00,Hans Wretling,Hans Wretling,"Steen & Ström kontor
västra Trädgårdsgatan 2 i Stockholm",4992x3328
Is it possible to have the all the outputs as one line?
Best regards,
Ed
Hi Ed,
The only way it will go to the next line is if the text contains a newline character. But this is legal CSV. You need to parse the quotes.
Try the -T option instead of -csv if you don't like this behaviour.
- Phil
Hi Phil,
Good morning.. :) Thank you so much for your time and effort in answering my queries.. :) I really do appreciate it. Ive got what I needed. Enjoy mate and have a great day
Regards,
Ed
I'm trying to use tethered photography to produce images that I can key to landmarks in my area for the purpose of establishing survey reference azimuths.
I have a Canon A620 which works as a tethered camera.
I have a script file that appends the date time to a log file, then takes a photo, then appends the date time to a log file.
****** tptime.sh
date +%F_%T.%N >>timestamps.txt
gphoto --capture-image-and-download
date +%F_%T.%N >>timestamps.txt
********* end tptime.sh
I would like to write these two time stamps to the .jpg meta data and use a median time to rename the file. It would be nice if I could fudge the median time with a simple + / - factor.
i've used the time date and time gphoto commands to time the individual lines and its taking some 7 seconds or more to complete the capture. I still don't know the actual time the photo is taken and I suspect that this will depend on focus times and shutter speed etc so a precise time of capture may still elude me. Since my camera does not seem to be recording the TimeSubSec information into the exif meta data this would be a way to determine the exact time a photo was taken. But I realize there may be many factors involved focus time, temperature, exposure settings etc.