A CSV file that can be imported directly into a database

Started by BrianTurner, January 11, 2014, 10:47:53 AM

Previous topic - Next topic

BrianTurner

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?


Phil Harvey

You could try adding the -csv option to your command.

- 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 ($).

BrianTurner

Thanks a million Phil. I could not see the wood for trees!
Thanks again.