I know I must be doing something fundamentally boneheaded here, but I'm too boneheaded to see what it is.
I'm trying to geotag using a track log - I'd like to have the image geotags (lat, lon, alt, hdg) set using values interpolated from the track log data. I'm getting a track log with a series of points from another source and generating a new CSV track log in a format (headings, formats, etc.) that exiftool can understand. Documentation says that the required columns are GPSDateTime (or GPSDateStamp and GPSTimeStamp), GPSLatitude and GPSLongitude. My CSV data looks like this:
GPSDateTime,GPSLatitude,GPSLongitude,GPSAltitude,GPSTrack
2020:10:03 23:40:55-00:00,51.362,-114.459,2316,359
2020:10:03 23:41:55-00:00,51.391,-114.458,2317,358
2020:10:03 23:42:55-00:00,51.421,-114.459,2315,0
2020:10:03 23:43:55-00:00,51.451,-114.458,2283,359
2020:10:03 23:44:55-00:00,51.478,-114.471,2344,334
2020:10:03 23:45:55-00:00,51.503,-114.489,2347,348
2020:10:03 23:46:55-00:00,51.533,-114.489,2347,1
2020:10:03 23:47:55-00:00,51.563,-114.490,2358,358
2020:10:03 23:48:55-00:00,51.594,-114.492,2338,358
2020:10:03 23:49:55-00:00,51.624,-114.491,2318,3
2020:10:03 23:50:55-00:00,51.654,-114.491,2310,356
Most of the other similar posts to this seem to deal with problems in the data format (spacing, mispellings, date formats) for the GPX/KML files, etc. I had thought that trying to encode using the CSV format would be the most straightforward. But it seems that no matter what I do to tweak the CSV format, I keep getting the same same "No track points found in GPS file" warning - exiftool doesn't like my data and I can't quite figure why.
$ exiftool -geotag=exportedTracks-exiftool.csv testImages/G0021242.JPG
Warning: No track points found in GPS file 'exportedTracks-exiftool.csv' in File:Geotag (ValueConvInv)
Warning: [minor] Unrecognized MakerNotes - testImages/G0021242.JPG
Warning: No writable tags set from testImages/G0021242.JPG
0 image files updated
1 image files unchanged
Any thoughts are greatly appreciated.
- Chris
You have a timing issue. I created a csv from your example, set the time on three files and accounted for the difference between UTC and my time zone and the data embedded correctly. By default, exiftool is going to read the DateTimeOriginal tag and the local time zone (unless DateTimeOriginal contains a time zone as it would in the XMP:DateTimeOriginal tag).
Account for any time zone differences and maybe set the Geotime tag (https://exiftool.org/geotag.html#geotime) if need be.
Many thanks.
I managed to solve the issue by converting my data to GPX instead of the CSV and it worked fine. The offset between the device and GPS was 03:25 for this set of images and -geosync worked amazingly for me.
<?xml version="1.0" encoding="UTF-8"?>
<gpx xmlns="https://www.topografix.com/GPX/1/1" creator="CSVtoExiftoolGPX.sh" version="1.1" xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<metadata>
<name>Exported Track</name>
</metadata>
<trk>
<number>1</number>
<trkseg>
<trkpt lat="51.101" lon="-114.370">
<ele>1202</ele>
<time>2020-10-03T23:08:19.000Z</time>
</trkpt>
<trkpt lat="51.101" lon="-114.370">
<ele>1205</ele>
<time>2020-10-03T23:09:18.000Z</time>
</trkpt>
<trkpt lat="51.101" lon="-114.370">
<ele>1205</ele>
<time>2020-10-03T23:10:18.000Z</time>
</trkpt>
<trkpt lat="51.101" lon="-114.370">
<ele>1203</ele>
<time>2020-10-03T23:11:18.000Z</time>
</trkpt>
.
.
.