[Originally posted by chewbears on 2008-08-15 16:02:38-07]
I have been a user of Exifutils and up until recently I have never needed to do large "batch" inputs of data. Currently on my deask I have 5000+ photos and I was wondering if ExifTool could help me. I have a table in excel that contains a unquie ID and the Latitude and Longitude of the photos. I need to be able to link the unquie ID (which is the photo name) with the table so that I can batch all of the Lat Long information without hand typing it. Can ExifTool do this for me?
[Originally posted by exiftool on 2008-08-15 16:20:35-07]
There are 2 ways to do this:
1) Write a simple Perl script to read your database information
(output as a CSL file or something similar I would suggest).
2) Use excel to output a text file which contains the required exiftool commands.
Number 2 is probably easier for you if you know Excel and not
Perl. It should be possible to create columns in excel to give you
a brute-force batch file that will call exiftool for each image. You
should be able to output a table like this directly from Excel:
exiftool -gpslatitude= 47.31515 -gpslongitude= 82.29920 image1.jpg
exiftool -gpslatitude= 47.98798 -gpslongitude= 82.32120 image2.jpg
Then use a word processor to remove the spaces (or tabs) after the "=" signs.
(Or maybe you know how to avoid these when exporting from Excel.)
You could then run this as a Windows .BAT file.
Maybe this helps.
- Phil