Incrementing a folder of jpg and mov files and the mov files are adding +10:00

[physicsfanatic]

Hi all,

I'm uploading a bunch of photos from an old digital camera to my iCloud drive and want them to be in the correct time period. I'm keeping it simple by time stamping them all as 2009 Jan 30th and aiming to increment them by 1 second based on the file name which is in order. I do this using the below code bearing in mind that I've already navigated to the directory hence why I'm using '*'.

Code Select Expand

exiftool -AllDates="2009:01:29 06:00:00" *Then

Code Select Expand

exiftool '-AllDates+<0:00:00$FileSequence' -fileorder filename -overwrite_original
The problem is that (unlike the jpg files) the .mov video files add a +10:00 to the Date/Time Original tag which makes them all show up at the end rather than in their correct spot.

Like so in bold:

Code Select Expand

exiftool -AllDates 100_1198.MOV
Date/Time Original              : 2009:01:29 06:00:00[b]+10:00[/b]
Create Date                     : 2009:01:29 06:00:00
Modify Date                     : 2009:01:29 06:00:00

Code Select Expand

exiftool -AllDates 100_1201.jpg
Date/Time Original              : 2009:01:29 06:00:01
Create Date                     : 2009:01:29 06:00:01
Modify Date                     : 2009:01:29 06:00:01
How can I get rid of this or set it to +00:00 so that they remain in the correct order?

[StarGeek]

I'm assuming that your time zone is +10:00?  By default, when writing the CreationDate and DateTimeOriginal in video files, exiftool will include the time zone of the computer.  This is because even though the standard (written by Apple, I believe) allows that a time zone does not have to be included, Apple programs will return wildly inaccurate time stamps if the time zone is not included.  An since you want to use these files with iCloud, then you definitely want the time zone added.

If you want to use +00:00 as the time zone, then add that to your initial write
exiftool -AllDates="2009:01:29 06:00:00+00:00" *

Finally, my standard copy/paste with regards to video time stamps
Most video time stamps are supposed to be set to UTC and the program is supposed to adjust this to the local time zone when displayed (see 4th paragraph on the Quicktime tags page), with the most common exceptions being the Quicktime:CreationDate (not to be confused with the Quicktime:CreateDate) and the Quicktime:DateTimeOriginal.

If your computer is in the same time zone as where the video was shot, ignoring differences for Daylight/Summer time, then you can add the -api QuickTimeUTC option.  Otherwise, you either have to figure out the UTC yourself or use the -api option and include the correct time zone, e.g. "2023:02:03 04:05:06±07:00".

[physicsfanatic]

I was hoping that your recommendation to add +00:00 to the end would resolve the issue, alas it is still adding +10 when adding them to iCloud for some reason even though when I view AllDates it shows:

Code Select Expand

exiftool -AllDates 100_1208.mov
Date/Time Original              : 2009:01:29 06:00:08+00:00
Create Date                     : 2009:01:29 06:00:08+00:00
Modify Date                     : 2009:01:29 06:00:08+00:00
Is the timezone added anywhere else in the tags for videos that I should be adjusting perhaps? Here is the full metadata - I couldn't see any glaringly obvious tags...

Code Select Expand

exiftool 100_1208.mov
ExifTool Version Number         : 12.57
File Name                       : 100_1208.mov
Directory                       : .
File Size                       : 13 MB
File Modification Date/Time     : 2023:02:26 11:37:00+10:00
File Access Date/Time           : 2023:02:26 11:38:40+10:00
File Inode Change Date/Time     : 2023:02:26 11:37:00+10:00
File Permissions                : -rwxr-xr-x
File Type                       : MOV
File Type Extension             : mov
MIME Type                       : video/quicktime
Movie Header Version            : 0
Time Scale                      : 5808000
Duration                        : 24.20 s
Preferred Rate                  : 1
Preferred Volume                : 100.00%
Preview Time                    : 0 s
Preview Duration                : 0 s
Poster Time                     : 0 s
Selection Time                  : 0 s
Selection Duration              : 0 s
Current Time                    : 0 s
Next Track ID                   : 3
Track Header Version            : 0
Track Create Date               : 2006:09:13 13:59:36
Track Modify Date               : 2006:09:13 13:59:36
Track ID                        : 1
Track Duration                  : 24.20 s
Track Layer                     : 0
Track Volume                    : 0.00%
Image Width                     : 640
Image Height                    : 480
Graphics Mode                   : ditherCopy
Op Color                        : 128 128 128
Compressor ID                   : mp4v
Vendor ID                       : Kodak
Source Image Width              : 640
Source Image Height             : 480
X Resolution                    : 128
Y Resolution                    : 128
Compressor Name                 : MPEG-4
Bit Depth                       : 24
Video Frame Rate                : 29.994
Matrix Structure                : 1 0 0 0 1 0 0 0 1
Media Header Version            : 0
Media Create Date               : 2006:09:13 13:59:36
Media Modify Date               : 2006:09:13 13:59:36
Media Time Scale                : 16000
Media Duration                  : 24.20 s
Balance                         : 0
Handler Class                   : Data Handler
Handler Type                    : Alias Data
Audio Format                    : ulaw
Audio Channels                  : 1
Audio Bits Per Sample           : 16
Audio Sample Rate               : 16000
Format                          : Digital Camera
Information                     : EASTMAN KODAK COMPANY  KODAK V610 DUAL LENS DIGITAL CAMERA
XMP Toolkit                     : Image::ExifTool 12.57
Create Date                     : 2009:01:29 06:00:08+00:00
Modify Date                     : 2009:01:29 06:00:08+00:00
Date/Time Original              : 2009:01:29 06:00:08+00:00
Media Data Size                 : 12565113
Media Data Offset               : 10895
Image Size                      : 640x480
Megapixels                      : 0.307
Avg Bitrate                     : 4.15 Mbps
Rotation                        : 0

[physicsfanatic]

Got it!

It wasn't enough to manually set my MacBook's timezone to London when I performed:

Code Select Expand

exiftool '-AllDates+<0:00:00$FileSequence' -fileorder * -overwrite_original
I had to also keep it manually set London whilst I uploaded them to iCloud. I'm assuming this was adding a creation timezone tag.

Thanks, StarGeek - appreciate your time.

[StarGeek]

Here is the full metadata - I couldn't see any glaringly obvious tags...

It's always best to use the command in FAQ #3, as there is often tags with duplicated names and you won't see all the date without the options included in the FAQ command.

To just view the date/time tags in a file, you can use -Time:All in addition to that command
exiftool -time:all -G1 -a -s File.mov

Of course, none of that matters if iCloud is altering the data on the upload.  Also, when writing, you might include the -api QuickTimeUTC I mentioned.