Main Menu

CSV

Started by Franksen, September 04, 2013, 03:38:42 AM

Previous topic - Next topic

Franksen

Thank you Phil for this nice software.
I have only little experience with EXIFtool since 3 days but what I have seen so far is great.

I want to read out GPS tags (lat, lon, heading) from Exif into CSV file.
After this I will add some coordinates in CSV (lat,lon, heading, new_lat, new_lon) and write it back into Exif. All should be done in a batch (with ca. 200 images).
(I am not sure if I can write the new coordinates into other tags (comment, author, etc.) )

I found this thread here, and it looks good for my problem:
https://exiftool.org/forum/index.php/topic,4740.msg22688.html#msg22688

I am not sure if I understand everything in this thread. What means :
#[Head]SourceFile, XPComment  ?

Another question is:
if I write back the information from CSV into Exif, what is the algorithm ? Will it check and compare the file name before writing the information ? If I delete one image, will Exiftool write all CSV information in wrong images ?

Best regards
Frank

Phil Harvey

Hi Frank,

You don't need to use the -p option unless you need to do special formatting.  Just use the CSV option:

exiftool -gps:all -csv DIR > out.csv

where DIR is the name of a directory containing the images.

Writing back the information is done like this:

exiftool -csv=out.csv DIR

ExifTool will look up each specified file in the CSV database and write the tags to the appropriate file.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

Franksen

Thanks a lot, I will try this.

Frank