Script to extract EXIF Info from Photos

oshead

Just tought i'd share this with the group. This is a vbscript which extracts the EXIF information from all images in a folder and writes it to a text file. It's very easy to use.

Here is an example of the information extracted.

IMG_0422.jpg, Make: Canon, Model: Canon EOS 40D, Date/Time: 2008:09:05 13:09:40, Exposure Time: 1/30, Aperture: 8, Focal Length: 65, Flash: Yes
IMG_1650.jpg, Make: Canon, Model: Canon EOS 40D, Date/Time: 2009:01:30 12:55:06, Exposure Time: 1/160, Aperture: 5.6, Focal Length: 176, Flash: Yes

If you are interested, just download the the attached zip file and extract it to the local C:\ drive. When done the folder structure should be C:\JpegInfo\Images.

Simply place the images you want to work with into the images folder and double click on the file C:\JpegInfo\getJpegInfo.vbs. You get prompted if you want to open the the text file which is saved in C:\JpegInfo\Images. Choose yes to view the info.

I hope someone finds this useful. I use a variation of this to populate XML files for my website.

Dave OS

Ricky91t

Thanks works well except for one issue,It says all the images in there used a flash and only one did?
And when i remove the image with the flash used ot still says all images used flash even though i've deleted the text file.

oshead

Forgot to put the disclaimer on it. I'll see if I can fix it.

Dave OS

Ricky91t

oshead wrote: »

Forgot to put the disclaimer on it. I'll see if I can fix it.

Dave OS

No!Don't bother fixing it,unless it bothers others..It's fine for me it's fairly easy to tell if a flash was used or it.Very pleased with it though quick and easy

Thanks

oshead

OK.... I have updated the script. I've made a few changes listed below.

• Date/Time: It was showing the incorrect date time, sorted.
  
• Added Software tag used to process the image.
  
• I have added an additional way to run the script. You can now simply drag and drop any folder of images on to the script. It then runs and extracts the EXIF info and writes and saves a text file to that folder.
  
• I could not fix the flashed fired. Seems different camera makes return different values.

You can download the scripts below.

Dave OS

AnCatDubh

like that Dave - well done to you. Oh but you've put a yearning on me now to go back to my programming roots.

The first version you posted was neater for a subsequent import to excel as a comma delimited file. The second version has the header which confuses excel. Still all you have to do is delete it in notepad and then import.

A further tweak might be worth considering (if i do go back and do a little programming) would be to output a header of column titles, and detail rows of pure attribute values.

Thanks again for posting.

// Off to amazon to pick up "Learning to program again for Dummies" //

oshead

It's very tempting, once you get stuck in, to go deep. I'm trying to cram for a SQL exam at the moment. The test is tomorrow, so I'll have a look at putting the header info on it when I get back. That is, if you don't do it yourself.

Dave OS

Ricky91t

oshead wrote: »

It's very tempting, once you get stuck in, to go deep. I'm trying to cram for a SQL exam at the moment. The test is tomorrow, so I'll have a look at putting the header info on it when I get back. That is, if you don't do it yourself.

Dave OS

Good luck in the exam!:D

And i'll have a mess about with the newer one and post any issues here soon

towel401

w0w i didn't realise VBScript even still existed

oshead

towel401 wrote: »

w0w i didn't realise VBScript even still existed

You're showing your age.... :eek: