ExifTool Forum

ExifTool => Newbies => Topic started by: BrianTurner on January 11, 2014, 10:47:53 AM

Title: A CSV file that can be imported directly into a database
Post by: BrianTurner on January 11, 2014, 10:47:53 AM
I am seriously impressed with Exiftool and am taking my first steps. The following line works, but I get more than what I want.
  exiftool G:\Pictures\PicsIN -FileName -DateTimeOriginal -coordFormat %+.6f -dateFormat %Y/%m/%d" "%H:%M:%S -GPSLatitude -GPSLongitude> G:\Pictures\Kmls\Test.csv
The Test.csv contains the following repeated for each image in the folder:
======== G:/Pictures/PicsIN/13600001.jpg
File Name                       : 13600001.jpg
Date/Time Original              : 2013/12/27 08:45:04
GPS Latitude                    : -25.724099
GPS Longitude                   : +28.256220
This is all good except for the labels on each field followed by a : colon. Is there a way of producing a file that looks something like this:
13600001.jpg,2013/12/27,08:45:04,-25.724099,+28.256220
and so forth for each image in the folder?

Title: Re: A CSV file that can be imported directly into a database
Post by: Phil Harvey on January 11, 2014, 12:53:33 PM
You could try adding the -csv option to your command.

- Phil
Title: Re: A CSV file that can be imported directly into a database
Post by: BrianTurner on January 13, 2014, 05:56:26 AM
Thanks a million Phil. I could not see the wood for trees!
Thanks again.