Correct time based on GPX TIMESTAMP info

Started by b193709, December 28, 2023, 08:45:17 PM

Previous topic - Next topic

b193709

Hi all:

I'm using GPSlogger (https://gpslogger.app/) on my Android for my DSLR. DSLR is set always on UTC, therefore I need to change all data according to TIMESET, for matching other photos/videos from Mobile that are already on the correct time.

Finally GPSlogger add TIMEZONE on the time format on each entry, I.E, of the CSV file. This is an example (masked location):

time,lat,lon,elevation,accuracy,bearing,speed,satellites,provider,hdop,vdop,pdop,geoidheight,ageofdgpsdata,dgpsid,activity,battery,annotation,timestamp_ms,time_offset,distance,starttimestamp_ms,profile_name,battery_charging

2023-12-29T01:19:48.367Z,XX.XXX1206,-Y.YYY0013,748.1000366210938,13.387,,,0,network,,,,,,,,92,,1703812788367,2023-12-29T02:19:48.367+01:00,0.0,1703812788261,Default Profile,fa


I'm looking for Geotag correctly my photos (ARW) and change create date and date info inside of the exif info with the correct time (in my example case UTC+1).

Thanks


Phil Harvey

GPSLogger can write GPX format as well as CSV.  ExifTool can be used to geotag from either format.  See the geotagging page for documentation.

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

b193709

Thanks Phil. My biggest issue (doubt is):

1) How can I take on exiftool the TimeStamp from the CSV/GPX I posted and modify all creation date based on it?.
2) Will Exiftool understand correctly time since it has 2 entries, one for UTC and another for TimeZone?. I guess it will work without issues.. but I want to know if Exiftool will recognize Timezone from the GPX/CSV and will be able to use it on first case (change creation data for my photos and videos)

Thanks

Phil Harvey

Quote from: b193709 on December 29, 2023, 01:25:09 PM1) How can I take on exiftool the TimeStamp from the CSV/GPX I posted and modify all creation date based on it?.

There is some confusion here...

I'm assuming the CSV contains many lines, each with different times.  The timestamps in the image are used to look up the appropriate line in this file (to obtain the GPS coordinates) -- they can't be used to change the time in a file.

Quote2) Will Exiftool understand correctly time since it has 2 entries, one for UTC and another for TimeZone?.

In the CSV, ExifTool will use the one with the column heading named "GPSDateTime".  You need to name the columns appropriately for use in the ExifTool -geotag option:  read here.

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

b193709

My objetive IS having all my photos sync on the same time zone and with the correct gps info. Mobile does all for me.DSLR doesn't. I can perform Geotag with exiftool, I know how to do it. After, I can write an bash script that reads the timezone info and I can apply this modification also with exiftool.

But all this process will take many steps and will be surely long.

I taught that the process of reading the timezone from the CSV/GPX and apply the timezone (+1 hour in my case from UTC) can be done in one liner