Add timezone to MOV video containing IFD0 and ExifIFD tags

Started by Grouaaah, May 22, 2024, 07:32:11 PM

Previous topic - Next topic

Grouaaah

Hello,

While my MOV videos taken with an iPhone don't contain such tags as IFD0, ExifIFD... my Canon videos do:

What's weird is that I could not edit those tags in any way. I want to add a timezone to those stamps, so I have Date/time Original and Date/Time Numeric (in ExifIFD) with their timezone associated. I also have a IFD0 FileModifyDate with no timezone associated.
(On my most recent Canon I have in ExifIFD 3 tags: OffsetTime, OffsetTime Original and OffsetTime Digitized.)

I couldn't add any timezone to it on GraphicConverter 12 going through: Exif > Edit Exif Date > Define Exif timezone.

I didn't manage to do it with other manipulations.

Would you have any ideas to add this to my Canon videos please? Thank you very much,

StarGeek

EXIF data in video files is non-standard. Every camera company shoves it in there in different ways, sometimes even different between models from the same company. Because of this, exiftool can't always edit EXIF data in a video safely, though it can for a few types.

From a previous post by Phil regarding EXIF data in a Canon video
Quote from: Phil Harvey on February 18, 2023, 09:34:33 AMCanon specifically writes metadata to the thumbnailimage.  I think you may be able to write this by extracting the thumbnail, editing it, then writing it back again.

In case it matters, most other software won't even know this metadata exists.

I don't think exiftool can embed a thumbnail in a video, but I'm not sure. You might have to look for another program to do so.  Maybe ffmpeg?
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

wywh

I'd advise you to just ignore timestamps in Canon ThumbnailImage tags. None of my apps read it (some old GraphicConverter version did but not anymore).

If it causes trouble, you might delete it:

exiftool -m -P -overwrite_original -Canon:ThumbnailImage= movie.mov
Or write time zone to the Keys tag which overrides other movie date tags in Apple's apps (other OSs might prefer UserData:DateTimeOriginal instead Keys: CreationDate):

exiftool -m -overwrite_original -api LargeFileSupport=1 -api QuickTimeUTC=1 '-QuickTime:CreateDate=2001:01:01 12:00:00' '-Keys:CreationDate=2001:01:01 12:00:00-05:00' movie.mov
Or write UTC time for that location also to QuickTime:CreateDate etc if it is different from the computer's time zone (you can omit Keys from the command below because QuickTime:Time:All takes care of it while also automatically adjusting DST):

exiftool -m -overwrite_original -api LargeFileSupport=1 -api QuickTimeUTC=1 -api TimeZone=America/New_York '-QuickTime:Time:All=2001:01:01 12:00:00' '-Keys:CreationDate=2001:01:01 12:00:00-05:00' movie.mov
If you insist, you can clumsily edit the Canon thumbnail date:

There is no standard for embedding EXIF data in a movie but that has not stopped a lot of camera makers from forcing it into the file. If that kind of EXIF is inside an embedded ThumbnailImage (like in some Canon models), it might be edited or deleted if some app erroneously grabs it. The maker notes in most Canon movies are stored inside the ThumbnailImage, which is writable, so you can do something like this (it is 3 commands: the first to extract the thumbnail, the second to add metadata to the thumbnail, and the third to write the thumbnail back into the video):

exiftool -ThumbnailImage -b movie.mov | exiftool -Time:All='2020:01:01 12:00:00' -timezone='+02:00' -wm w - | exiftool -ThumbnailImage'<=-' movie.mov
https://exiftool.org/forum/index.php?topic=11100.msg59507#msg59507

- Matti

StarGeek

Quote from: wywh on May 23, 2024, 02:56:51 AMexiftool -ThumbnailImage -b movie.mov | exiftool -Time:All='2020:01:01 12:00:00' -timezone='+02:00' -wm w - | exiftool -ThumbnailImage'<=-' movie.mov

Good to know that ThumbnailImage is writable in this case, I hadn't paid much attention previously and my quick look over the Tags Names docs was inconclusive.

But I would suggest also including the OffsetTime* tags, e.g. '-OffsetTime*=+02:00'
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

wywh

Quote from: StarGeek on May 23, 2024, 11:21:25 AMI would suggest also including the OffsetTime* tags

That is a good point although there is already Canon:TimeZone tag.

...as I said, I ignore these Canon thumbnail tags but just for fun I experimented...

This nicely edits additional Canon movie thumbnail TimeZone, TimeZoneCity, and DaylightSavings tags as well as ExifIFD:DateTimeOriginal, CreateDate, and IFD0:ModifyDate:

exiftool -a -G1 -s -api QuickTimeUTC=1 -Time:All canon.mov
[QuickTime]     CreateDate                      : 2003:03:03 12:03:03+02:00
[QuickTime]     ModifyDate                      : 2003:03:03 12:03:03+02:00
[Track1]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track1]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track1]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track1]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Track2]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track2]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track2]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track2]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Track3]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track3]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track3]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track3]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Keys]          LocationDate                    : 2015:08:08 13:03:06+03:00
[IFD0]          ModifyDate                      : 2015:08:08 13:02:57
[ExifIFD]       DateTimeOriginal                : 2015:08:08 13:02:57
[ExifIFD]       CreateDate                      : 2015:08:08 13:02:57
[Canon]         TimeZone                        : +03:00
[Canon]         TimeZoneCity                    : Cairo
[Canon]         DaylightSavings                 : On
[ExifIFD]       SubSecTime                      : 55
[ExifIFD]       SubSecTimeOriginal              : 55
[ExifIFD]       SubSecTimeDigitized             : 55

exiftool -ThumbnailImage -b canon.mov | exiftool -Time:All='2020:01:01 12:00:00' -TimeZone='-05:00' -TimeZoneCity='New York' -DaylightSavings=Off -wm w - | exiftool -ThumbnailImage'<=-' canon.mov

exiftool -a -G1 -s -api QuickTimeUTC=1 -Time:All canon.mov
[QuickTime]     CreateDate                      : 2003:03:03 12:03:03+02:00
[QuickTime]     ModifyDate                      : 2003:03:03 12:03:03+02:00
[Track1]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track1]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track1]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track1]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Track2]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track2]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track2]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track2]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Track3]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track3]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track3]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track3]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Keys]          LocationDate                    : 2015:08:08 13:03:06+03:00
[IFD0]          ModifyDate                      : 2020:01:01 12:00:00
[ExifIFD]       DateTimeOriginal                : 2020:01:01 12:00:00
[ExifIFD]       CreateDate                      : 2020:01:01 12:00:00
[Canon]         TimeZone                        : -05:00
[Canon]         TimeZoneCity                    : New York
[Canon]         DaylightSavings                 : Off

But if I add OffsetTime* to the mix and leave '-wm w' off then lots of additional tags are written, huh  :o :

exiftool -ThumbnailImage -b canon.mov | exiftool -Time:All='2020:01:01 12:00:00' -TimeZone='-05:00' -TimeZoneCity='New York' -DaylightSavings=Off '-ExifIFD:OffsetTime*=-05:00' - | exiftool -ThumbnailImage'<=-' canon.mov

exiftool -a -G1 -s -api QuickTimeUTC=1 -Time:All canon.mov
[QuickTime]     CreateDate                      : 2003:03:03 12:03:03+02:00
[QuickTime]     ModifyDate                      : 2003:03:03 12:03:03+02:00
[Track1]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track1]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track1]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track1]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Track2]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track2]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track2]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track2]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Track3]        TrackCreateDate                 : 2003:03:03 12:03:03+02:00
[Track3]        TrackModifyDate                 : 2003:03:03 12:03:03+02:00
[Track3]        MediaCreateDate                 : 2003:03:03 12:03:03+02:00
[Track3]        MediaModifyDate                 : 2003:03:03 12:03:03+02:00
[Keys]          LocationDate                    : 2015:08:08 13:03:06+03:00
[IFD0]          ModifyDate                      : 2020:01:01 12:00:00
[ExifIFD]       DateTimeOriginal                : 2020:01:01 12:00:00
[ExifIFD]       CreateDate                      : 2020:01:01 12:00:00
[ExifIFD]       OffsetTime                      : -05:00
[ExifIFD]       OffsetTimeOriginal              : -05:00
[ExifIFD]       OffsetTimeDigitized             : -05:00
[Canon]         TimeZone                        : -05:00
[Canon]         TimeZoneCity                    : New York
[Canon]         DaylightSavings                 : Off
[GPS]           GPSTimeStamp                    : 12:00:00
[GPS]           GPSDateStamp                    : 2020:01:01
[IPTC]          DateSent                        : 2020:01:01
[IPTC]          TimeSent                        : 12:00:00+02:00
[IPTC]          ReleaseTime                     : 12:00:00+02:00
[IPTC]          ExpirationDate                  : 2020:01:01
[IPTC]          ExpirationTime                  : 12:00:00+02:00
[IPTC]          ReferenceDate                   : 2020:01:01
[IPTC]          DateCreated                     : 2020:01:01
[IPTC]          TimeCreated                     : 12:00:00+02:00
[IPTC]          DigitalCreationDate             : 2020:01:01
[IPTC]          DigitalCreationTime             : 12:00:00+02:00
[XMP-DICOM]     PatientBirthDate                : 2020:01:01 12:00:00
[XMP-DICOM]     SeriesDateTime                  : 2020:01:01 12:00:00
[XMP-DICOM]     StudyDateTime                   : 2020:01:01 12:00:00
[XMP-Device]    CameraPoseTimestamp             : 2020:01:01 12:00:00.000+02:00
[XMP-Device]    EarthPosTimestamp               : 2020:01:01 12:00:00.000+02:00
[XMP-Device]    PlanePoseTimestamp              : 2020:01:01 12:00:00.000+02:00
[XMP-Device]    PoseTimestamp                   : 2020:01:01 12:00:00.000+02:00
[XMP-GPano]     FirstPhotoDate                  : 2020:01:01 12:00:00
[XMP-GPano]     LastPhotoDate                   : 2020:01:01 12:00:00
[XMP-getty]     OriginalCreateDateTime          : 2020:01:01 12:00:00
[XMP-iptcExt]   ArtworkDateCreated              : 2020:01:01 12:00:00
[XMP-iptcExt]   CircaDateCreated                : 2020:01:01 12:00:00
[XMP-iptcExt]   IPTCLastEdited                  : 2020:01:01 12:00:00
[XMP-iptcExt]   PublicationEventDate            : 2020:01:01 12:00:00
[XMP-iptcExt]   TemporalCoverageFrom            : 2020:01:01 12:00:00
[XMP-iptcExt]   TemporalCoverageTo              : 2020:01:01 12:00:00
[XMP-iptcExt]   MetadataLastEdited              : 2020:01:01 12:00:00
[XMP-MP]        RegionInfoDateRegionsValid      : 2020:01:01 12:00:00
[XMP-microsoft] DateAcquired                    : 2020:01:01 12:00:00
[XMP-cc]        DeprecatedOn                    : 2020:01:01 12:00:00
[XMP-dc]        Date                            : 2020:01:01 12:00:00
[XMP-digiKam]   CaptionsDateTimeStamps          : 2020:01:01 12:00:00
[XMP-dwc]       EventEarliestDate               : 2020:01:01 12:00:00
[XMP-dwc]       EventDate                       : 2020:01:01 12:00:00
[XMP-dwc]       EventTime                       : 2020:01:01 12:00:00
[XMP-dwc]       EventLatestDate                 : 2020:01:01 12:00:00
[XMP-dwc]       EventVerbatimEventDate          : 2020:01:01 12:00:00
[XMP-dwc]       HumanObservationEarliestDate    : 2020:01:01 12:00:00
[XMP-dwc]       HumanObservationEventDate       : 2020:01:01 12:00:00
[XMP-dwc]       HumanObservationEventTime       : 2020:01:01 12:00:00
[XMP-dwc]       HumanObservationLatestDate      : 2020:01:01 12:00:00
[XMP-dwc]       HumanObservationVerbatimEventDate: 2020:01:01 12:00:00
[XMP-dwc]       DateIdentified                  : 2020:01:01 12:00:00
[XMP-dwc]       MachineObservationEarliestDate  : 2020:01:01 12:00:00
[XMP-dwc]       MachineObservationEventDate     : 2020:01:01 12:00:00
[XMP-dwc]       MachineObservationEventTime     : 2020:01:01 12:00:00
[XMP-dwc]       MachineObservationLatestDate    : 2020:01:01 12:00:00
[XMP-dwc]       MachineObservationVerbatimEventDate: 2020:01:01 12:00:00
[XMP-dwc]       MeasurementDeterminedDate       : 2020:01:01 12:00:00
[XMP-dwc]       RelationshipEstablishedDate     : 2020:01:01 12:00:00
[XMP-exif]      DateTimeDigitized               : 2020:01:01 12:00:00
[XMP-pdf]       CreationDate                    : 2020:01:01 12:00:00
[XMP-photoshop] DateCreated                     : 2020:01:01 12:00:00
[XMP-plus]      FirstPublicationDate            : 2020:01:01 12:00:00
[XMP-plus]      LicenseEndDate                  : 2020:01:01 12:00:00
[XMP-plus]      LicenseStartDate                : 2020:01:01 12:00:00
[XMP-plus]      LicenseTransactionDate          : 2020:01:01 12:00:00
[XMP-prism]     CoverDate                       : 2020:01:01 12:00:00
[XMP-prism]     DateRecieved                    : 2020:01:01 12:00:00
[XMP-prism]     KillDateDate                    : 2020:01:01 12:00:00
[XMP-prism]     ModificationDate                : 2020:01:01 12:00:00
[XMP-prism]     OffSaleDateDate                 : 2020:01:01 12:00:00
[XMP-prism]     OnSaleDateDate                  : 2020:01:01 12:00:00
[XMP-prism]     PublicationDateDate             : 2020:01:01 12:00:00
[XMP-prism]     PublicationDisplayDateDate      : 2020:01:01 12:00:00
[XMP-pur]       EmbargoDate                     : 2020:01:01 12:00:00
[XMP-pur]       ExclusivityEndDate              : 2020:01:01 12:00:00
[XMP-pur]       OptionEndDate                   : 2020:01:01 12:00:00
[XMP-tiff]      DateTime                        : 2020:01:01 12:00:00
[XMP-xmp]       MetadataDate                    : 2020:01:01 12:00:00
[XMP-xmpDM]     AudioModDate                    : 2020:01:01 12:00:00
[XMP-xmpDM]     MetadataModDate                 : 2020:01:01 12:00:00
[XMP-xmpDM]     ShotDate                        : 2020:01:01 12:00:00
[XMP-xmpDM]     VideoModDate                    : 2020:01:01 12:00:00
[XMP-xmpMM]     DerivedFromLastModifyDate       : 2020:01:01 12:00:00
[XMP-xmpMM]     HistoryWhen                     : 2020:01:01 12:00:00
[XMP-xmpMM]     IngredientsLastModifyDate       : 2020:01:01 12:00:00
[XMP-xmpMM]     ManagedFromLastModifyDate       : 2020:01:01 12:00:00
[XMP-xmpMM]     ManifestReferenceLastModifyDate : 2020:01:01 12:00:00
[XMP-xmpMM]     RenditionOfLastModifyDate       : 2020:01:01 12:00:00
[XMP-xmpMM]     VersionsEventWhen               : 2020:01:01 12:00:00
[XMP-xmpMM]     VersionsModifyDate              : 2020:01:01 12:00:00

- Matti

StarGeek

I always feel that writing directly to Time:All is a bad idea because it writes so many tags. Using it with the -wm w is about the only reasonable exception.

And the reason I suggest writing the -OffsetTime* tags over the Canon (and Nikon) specific TimeZone is due to the interaction with the DaylightSavings tag. TimeZone is supposed to contain the base time zone without regards to any possible Daylight Savings time change. For example, for Eastern time zone, it should always remain set at -05:00.  The DaylightSavings is the indicator for when the camera is supposed to add an hour or not.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

wywh

Quote from: StarGeek on May 23, 2024, 04:45:38 PMTimeZone is supposed to contain the base time zone without regards to any possible Daylight Savings time change. For example, for Eastern time zone, it should always remain set at -05:00.  The DaylightSavings is the indicator for when the camera is supposed to add an hour or not.

For a while I was confused to read that because many eastern countries like Japan do not use DST. But then it crossed my mind that you refer to the U.S. east. Doh!

[rant]I wish DST was no longer used anywhere. A few  years ago Finland proposed that EU should stop using DST and it was favorably greeted. But then it was buried in EU bureaucrazy and sadly it also locally spurred heated debates whether we should then stick to standard "winter" time or "summer" time  >:( [/rant]

Quote from: StarGeek on May 23, 2024, 04:45:38 PMwriting directly to Time:All is a bad idea because it writes so many tags. Using it with the -wm w is about the only reasonable exception.

I try to keep that in mind although sometimes -wm w -Time:All makes the command much shorter  :)

- Matti

StarGeek

Quote from: wywh on May 24, 2024, 07:57:17 AMFor a while I was confused to read that because many eastern countries like Japan do not use DST. But then it crossed my mind that you refer to the U.S. east. Doh!

Heh, sorry.  You used -05:00 in your example, so I was trying to indicate that time zone without reference to Standard or Daylight time.

Quote[rant]I wish DST was no longer used anywhere.

I'm with you.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

Grouaaah

Hello,

Thank you both guys for your answers, very useful.
So what does it change when there is a [DaylightSavingTime] like in my recent Canon camera? Is the timezone still useful? Or should the timezone be edited in consequence (like if the DST is ON, retrieve one hour on the UTC tag or not?)


Indeed, I tried to use this command that I remember having noted some time ago but it didn't work for videos taken by Canon 600D. I was hoping I could solve the issue otherwise.
When passing the 3 commands (extract, write, insert), there is "1 file updated" displayed but the time without the timezone in ExifIFD.
Here is the info. Maybe you will find why the Canon Thumbnail cannot be written.

Desktop % exiftool 20180802_130814.MOV

ExifTool Version Number         : 12.65
File Name                       : 20180802_130814.MOV
Directory                       : .
File Size                       : 198 MB
File Modification Date/Time     : 2024:05:23 01:09:54+02:00
File Access Date/Time           : 2024:05:24 21:42:00+02:00
File Inode Change Date/Time     : 2024:05:24 21:42:21+02:00
File Permissions                : -rwxrwxrwx
File Type                       : MOV
File Type Extension             : mov
MIME Type                       : video/quicktime
Major Brand                     : Apple QuickTime (.MOV/QT)
Minor Version                   : 2007.9.0
Compatible Brands               : qt  , CAEP
Compressor Version              : CanonAVC0005
Exif Byte Order                 : Little-endian (Intel, II)
Make                            : Canon
Camera Model Name               : Canon EOS 600D
Orientation                     : Horizontal (normal)
Resolution Unit                 : inches
Artist                          :
Y Cb Cr Positioning             : Co-sited
Copyright                       :
Exposure Time                   : undef
F Number                        : undef
Exposure Program                : Program AE
Sensitivity Type                : Recommended Exposure Index
Recommended Exposure Index      : 0
Exif Version                    : 0230
Components Configuration        : Y, Cb, Cr, -
Shutter Speed Value             : 0
Aperture Value                  : 16.0
Flash                           : Off, Did not fire
Focal Length                    : 200.0 mm
Macro Mode                      : Normal
Self Timer                      : Off
Quality                         : n/a
Canon Flash Mode                : n/a
Continuous Drive                : Movie
Focus Mode                      : Manual Focus (3)
Record Mode                     : MOV
Canon Image Size                : 1920x1080 Movie
Easy Mode                       : Manual
Digital Zoom                    : None
Contrast                        : Normal
Saturation                      : Normal
Camera ISO                      : Auto
Metering Mode                   : Center-weighted average
Focus Range                     : Not Known
Canon Exposure Mode             : Program AE
Lens Type                       : Canon EF-S 18-200mm f/3.5-5.6 IS
Max Focal Length                : 200 mm
Min Focal Length                : 18 mm
Focal Units                     : 1/mm
Max Aperture                    : 5.7
Min Aperture                    : 36
Flash Activity                  : 0
Flash Bits                      : (none)
Zoom Source Width               : 0
Zoom Target Width               : 0
Manual Flash Output             : n/a
Color Tone                      : Normal
Auto ISO                        : 100
Measured EV                     : 11.38
Target Exposure Time            : 1
Exposure Compensation           : 0
White Balance                   : Auto
Slow Shutter                    : None
Shot Number In Continuous Burst : 0
Optical Zoom Code               : n/a
Camera Temperature              : 24 C
Flash Guide Number              : 0
Flash Exposure Compensation     : 0
Auto Exposure Bracketing        : Off
AEB Bracket Value               : 0
Control Mode                    : Camera Local Control
Measured EV 2                   : 11.375
Bulb Duration                   : 0
Camera Type                     : EOS High-end
ND Filter                       : n/a
Canon Image Type                : MVI:Canon EOS 600D
Canon Firmware Version          : Firmware Version 1.0.2
Canon Model ID                  : EOS Rebel T3i / 600D / Kiss X5
Frame Count                     : 845
Frame Rate                      : 25
Audio Bitrate                   : 1.54 Mbps
Video Codec                     : avc1
Thumbnail Image Valid Area      : 0 159 15 104
Bracket Mode                    : Off
Bracket Value                   : 0
Bracket Shot Number             : 0
Raw Jpg Size                    : Large
Long Exposure Noise Reduction 2 : Off
WB Bracket Mode                 : Off
WB Bracket Value AB             : 0
WB Bracket Value GM             : 0
Live View Shooting              : On
Focus Distance Upper            : 4.5 m
Focus Distance Lower            : 3.85 m
Shutter Mode                    : Mechanical
Flash Exposure Lock             : Off
Internal Serial Number          : ZC0069399
Crop Left Margin                : 0
Crop Right Margin               : 0
Crop Top Margin                 : 0
Crop Bottom Margin              : 0
Exposure Level Increments       : 1/3 Stop
ISO Expansion                   : Off
Flash Sync Speed Av             : Auto
Long Exposure Noise Reduction   : Off
High ISO Noise Reduction        : Standard
Highlight Tone Priority         : Enable
AF Assist Beam                  : Emits
Mirror Lockup                   : Disable
Shutter-AE Lock                 : AF/AE lock
Set Button When Shooting        : Normal (disabled)
LCD Display At Power On         : Display
Add Original Decision Data      : Off
Aspect Ratio                    : 3:2
Cropped Image Width             : 2592
Cropped Image Height            : 1728
Cropped Image Left              : 0
Cropped Image Top               : 0
Tone Curve                      : Standard
Sharpness                       : 3
Sharpness Frequency             : n/a
Sensor Red Level                : 0
Sensor Blue Level               : 0
White Balance Red               : 0
White Balance Blue              : 0
Color Temperature               : 5200
Picture Style                   : Auto
Digital Gain                    : 0
WB Shift AB                     : 0
WB Shift GM                     : 0
VRD Offset                      : 0
Sensor Width                    : 5344
Sensor Height                   : 3516
Sensor Left Border              : 152
Sensor Top Border               : 56
Sensor Right Border             : 5335
Sensor Bottom Border            : 3511
Black Mask Left Border          : 0
Black Mask Top Border           : 0
Black Mask Right Border         : 0
Black Mask Bottom Border        : 0
Picture Style User Def          : Auto; Auto; Auto
Picture Style PC                : None; None; None
Custom Picture Style File Name  :
Peripheral Illumination Corr    : Off
Auto Lighting Optimizer         : Off
User Comment                    :
Flashpix Version                : 0100
Color Space                     : sRGB
Exif Image Width                : 160
Exif Image Height               : 120
Interoperability Index          : THM - DCF thumbnail file
Interoperability Version        : 0100
Related Image Width             : 1920
Related Image Height            : 1080
Focal Plane X Resolution        : 176.7955801
Focal Plane Y Resolution        : 201.6806723
Focal Plane Resolution Unit     : inches
Custom Rendered                 : Normal
Exposure Mode                   : Auto
Scene Capture Type              : Standard
Owner Name                      :
Serial Number                   : 143066001887
Lens Info                       : 18-200mm f/?
Lens Model                      : EF-S18-200mm f/3.5-5.6 IS
Lens Serial Number              : 0000494c79
Encoding Process                : Baseline DCT, Huffman coding
Bits Per Sample                 : 8
Color Components                : 3
Y Cb Cr Sub Sampling            : YCbCr4:2:2 (2 1)
Thumbnail Image                 : (Binary data 22915 bytes, use -b option to extract)
XMP Toolkit                     : XMP Core 6.0.0
Date/Time Original              : 2018:08:02 13:08:14-06:00
Movie Header Version            : 0
Create Date                     : 2018:08:02 19:08:14
Modify Date                     : 2018:08:02 19:08:14
Time Scale                      : 25000
Duration                        : 0:00:34
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               : 2018:08:02 19:08:14
Track Modify Date               : 2018:08:02 19:08:14
Track ID                        : 1
Track Duration                  : 0:00:34
Track Layer                     : 0
Track Volume                    : 0.00%
Image Width                     : 1920
Image Height                    : 1080
Graphics Mode                   : srcCopy
Op Color                        : 0 0 0
Compressor ID                   : avc1
Source Image Width              : 1920
Source Image Height             : 1080
X Resolution                    : 72
Y Resolution                    : 72
Bit Depth                       : 24
Video Frame Rate                : 25
Matrix Structure                : 1 0 0 0 1 0 0 0 1
Media Header Version            : 0
Media Create Date               : 2018:08:02 19:08:14
Media Modify Date               : 2018:08:02 19:08:14
Media Time Scale                : 48000
Media Duration                  : 0:00:34
Balance                         : 0
Handler Class                   : Data Handler
Audio Format                    : sowt
Audio Bits Per Sample           : 16
Audio Sample Rate               : 48000
Layout Flags                    : Stereo
Audio Channels                  : 2
Handler Type                    : Metadata Tags
Creation Date                   : 2018:08:02 13:08:14-06:00
GPS Coordinates                 : 27 deg 11' 23.32" S, 109 deg 26' 32.17" W, 289.2 m Above Sea Level
User Rating                     : 0
Media Data Size                 : 197778576
Media Data Offset               : 104121
Drive Mode                      : Continuous Shooting
Lens                            : 18.0 - 200.0 mm
Shooting Mode                   : Program AE
Aperture                        : undef
Image Size                      : 1920x1080
Lens ID                         : Canon EF-S 18-200mm f/3.5-5.6 IS
Megapixels                      : 2.1
Scale Factor To 35 mm Equivalent: 1.6
Shutter Speed                   : undef
Avg Bitrate                     : 46.8 Mbps
GPS Altitude                    : 289.2 m
GPS Altitude Ref                : Above Sea Level
GPS Latitude                    : 27 deg 11' 23.32" S
GPS Longitude                   : 109 deg 26' 32.17" W
Rotation                        : 0
Lens                            : 18.0 - 200.0 mm (35 mm equivalent: 28.3 - 314.6 mm)
Circle Of Confusion             : 0.019 mm
Depth Of Field                  : 0.00 m (4.17 - 4.17 m)
Field Of View                   : 6.6 deg
Focal Length                    : 200.0 mm (35 mm equivalent: 314.6 mm)
GPS Position                    : 27 deg 11' 23.32" S, 109 deg 26' 32.17" W
Hyperfocal Distance             : Inf m


XMP Toolkit                     : XMP Core 6.0.0 => I see this in every of my videos. Is there any way to delete this? The "delete XMP Tool" option on GraphicConverter 12 does not work for this one (the "Delete every writable XMP tag/"Delete all XMP except IPTC" option doesn't work either)
Date/Time Original              : 2018:08:02 13:08:14-06:00
Movie Header Version            : 0
Create Date                     : 2018:08:02 19:08:14
Modify Date                     : 2018:08:02 19:08:14
=> There is no timezone, only the UTC time. I guess I'll have to let it as is, as Matti said, Exif is not standard in videos so this "UTC" time (instead of local here?) should not be a problem. I just wanted to know if that UTC time here in [ExifIFD] was non standard too? I am asking this question because on my most recent Canon camera, there is the timezone in this ExifIFD in case no [Keys] comes to override the whole thing. Should I rather delete only those 2 lines with a command in my 600D, or not according to you? Thank you!



Lastly, I wanted to know if that "use -b option to extract..." I see everywhere was stored in the file metadata. And how to get rid of this if it is? Isn't this something that creates useless bytes into an image? Thank you very much for your answer

Have a nice evening,

StarGeek

Quote from: Grouaaah on May 24, 2024, 03:59:47 PMSo what does it change when there is a [DaylightSavingTime] like in my recent Canon camera? Is the timezone still useful? Or should the timezone be edited in consequence (like if the DST is ON, retrieve one hour on the UTC tag or not?)

The TimeZone tag is specific to the MakerNotes of Canon and Nikon files.  It is supposed to be set to the time zone where the picture is taken.  On my Nikon, it looks like this in the settings

You do not change the TimeZone tag when Daylight Savings occurs.  Instead, you change the Daylight Savings setting in the camera and that turns the DaylightSavings tag to ON. This tells the camera to set the time one hour ahead without having to change the actual time setting.

As this is a MakerNote tag, it's only really useful when you want to look at the settings for when you took the picture.  The number of programs that actually read and use any MakerNotes tags is extremely low.

QuoteXMP Toolkit                    : XMP Core 6.0.0 => I see this in every of my videos. Is there any way to delete this? The "delete XMP Tool" option on GraphicConverter 12 does not work for this one (the "Delete every writable XMP tag/"Delete all XMP except IPTC" option doesn't work either)

Try
exiftool -XMPToolkit= /path/to/files/

QuoteDate/Time Original              : 2018:08:02 13:08:14-06:00
Movie Header Version            : 0
Create Date                    : 2018:08:02 19:08:14
Modify Date                    : 2018:08:02 19:08:14
=> There is no timezone, only the UTC time. I guess I'll have to let it as is, as Matti said, Exif is not standard in videos so this "UTC" time (instead of local here?) should not be a problem. I just wanted to know if that UTC time here in [ExifIFD] was non standard too? I am asking this question because on my most recent Canon camera, there is the timezone in this ExifIFD in case no [Keys] comes to override the whole thing. Should I rather delete only those 2 lines with a command in my 600D, or not according to you? Thank you!

You're not seeing all the data in the file because there are multiple tags with the same name. If you use the command in FAQ #3, you will see the duplicate tags, the actual names of those tags (not the descriptions, FAQ #2), and the groups they belong too.

My standard copy/paste regarding 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 5th 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 and exiftool will automatically adjust the time to/from UTC when writing/reading.  Otherwise, you either have to figure out the UTC yourself or use this -api option and include the correct time zone, e.g. "2023:02:03 04:05:06±07:00".


QuoteLastly, I wanted to know if that "use -b option to extract..." I see everywhere was stored in the file metadata. And how to get rid of this if it is? Isn't this something that creates useless bytes into an image? Thank you very much for your answer

This phrase does not actually exist in the file.  It is telling you that if you want to extract the data associated with the tag it appears next to, you have to use the -b (-binary) option.  That is because, as it says, the data in that tag is binary, not texts or numbers.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

Grouaaah

Okay, this is clear, thanks! So for a picture located in France in winter (UTC+1) we do agree on the fact that if DST is "On" in the metadata, but that the "UTC+01:00" is present in the picture, there is no need to have this DST tag in the metadata? This is why you were talking about getting rid of that DST thing?

Quote from: StarGeek on May 24, 2024, 05:16:01 PMYou're not seeing all the data in the file because there are multiple tags with the same name. If you use the command in FAQ #3, you will see the duplicate tags, the actual names of those tags (not the descriptions, FAQ #2), and the groups they belong too.
I did "exiftool -a -G1 -s image.jpg" and I see the same tags as with "exiftool image.jpg" command, I didn't understand what you meant here? Actually, I was just wondering if I could leave the [IFD0] ModifyDate and [ExifIFD] DateTimeOriginal and [ExifIFD] CreateDate in local time without any timezone associated, as the 3-times extract command doesn't work on this type of file?

"But I would suggest also including the OffsetTime* tags, e.g. '-OffsetTime*=+02:00'" I realize I don't really know the difference between timezone and OffsetTime. Isn't offset used to refer to a difference between two times? How can it be used in a fixed file metadata.

Thank you,

StarGeek

Quote from: Grouaaah on May 25, 2024, 07:30:47 AMOkay, this is clear, thanks! So for a picture located in France in winter (UTC+1) we do agree on the fact that if DST is "On" in the metadata, but that the "UTC+01:00" is present in the picture, there is no need to have this DST tag in the metadata?

You can't remove the DaylightSavings tag. Individual MakerNotes tags can't be deleted or created. The value of this tag is set to either "ON" or "OFF". Using your example, the TimeZone will be set to +01:00 and will not change. Then you would change the Daylight Savings setting in the camera when Daylight Savings starts/ends and this will change the value of the DaylightSavings.

QuoteThis is why you were talking about getting rid of that DST thing?

I don't believe I said that, as you can't remove this tag. Let me know where I said that, so I can clarify it.

QuoteI did "exiftool -a -G1 -s image.jpg" and I see the same tags as with "exiftool image.jpg" command, I didn't understand what you meant here?

You should see duplicate CreateDate and ModifyDate entries at the very least. For example, here the ModifyDate appears in Quicktime and IFD0, and CreateDate appears in Quicktime and ExifIFD
C:\>exiftool -time:all --system:all -G1 -a -s 2012-03-17_14.44.10.MOV"
[IFD0]          ModifyDate                      : 2012:03:17 14:44:11
[ExifIFD]       DateTimeOriginal                : 2012:03:17 14:44:11
[ExifIFD]       CreateDate                      : 2012:03:17 14:44:11
[QuickTime]     CreateDate                      : 2012:03:17 21:44:11
[QuickTime]     ModifyDate                      : 2012:03:17 21:44:11
[Track1]        TrackCreateDate                 : 2012:03:17 21:44:11
[Track1]        TrackModifyDate                 : 2012:03:17 21:44:11
[Track1]        MediaCreateDate                 : 2012:03:17 21:44:11
[Track1]        MediaModifyDate                 : 2012:03:17 21:44:11
[Track2]        TrackCreateDate                 : 2012:03:17 21:44:11
[Track2]        TrackModifyDate                 : 2012:03:17 21:44:11
[Track2]        MediaCreateDate                 : 2012:03:17 21:44:11
[Track2]        MediaModifyDate                 : 2012:03:17 21:44:11

QuoteActually, I was just wondering if I could leave the [IFD0] ModifyDate and [ExifIFD] DateTimeOriginal and [ExifIFD] CreateDate in local time without any timezone associated, as the 3-times extract command doesn't work on this type of file?l

The EXIF tags are supposed to be set to local time and by themselves, cannot include a time zone. The EXIF standard stores the time zone in three separate tags (see below).

My advice is the same as in @wywh's first post. Just ignore the EXIF tags in videos. Almost nothing will read this data. I know of one program that will, but that's only because it uses exiftool on the backend.

Quote"But I would suggest also including the OffsetTime* tags, e.g. '-OffsetTime*=+02:00'" I realize I don't really know the difference between timezone and OffsetTime. Isn't offset used to refer to a difference between two times? How can it be used in a fixed file metadata.

The three OffsetTime* tags, OffsetTime, OffsetTimeOriginal, and OffsetTimeDigitized, are used to show the actual local time zone at the time when the picture was taken. So, for your images, they would be set to either +01:00 or +02:00. These are part of the EXIF specs. They do not indicate if the time zone was Daylight savings or not, they are just the actual time zone.

TimeZone is a proprietary MakerNotes tag, specific to certain cameras.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

Grouaaah

Quote from: StarGeek on May 24, 2024, 10:19:55 AM
QuoteI wish DST was no longer used anywhere.

I'm with you.
Sorry, I thought you were talking about this by saying that the DST thing was a problem. Maybe it's not related.

Quote from: StarGeek on May 25, 2024, 11:20:19 AMThe EXIF tags are supposed to be set to local time and by themselves, cannot include a time zone. The EXIF standard stores the time zone in three separate tags (see below).
(I assume this sentence applies to videos only) Thank you, this is more clear now. I was asking all these questions because I have a Canon camera that creates the three OffsetTime tags as you said, and another one just a bit older that doesn't create any OffsetTime tag at all. This was weird to me, I wanted to know if that was an error or inconsistency or anything. Now I know that it is not, just something I have to leave as is. Anyway, I cannot edit those tags with a simple "exiftool -OffsetTime*=+01:00 test.jpg"



Thank you!

StarGeek

Quote from: Grouaaah on May 25, 2024, 07:56:41 PM
Quote from: StarGeek on May 24, 2024, 10:19:55 AM
QuoteI wish DST was no longer used anywhere.

I'm with you.
Sorry, I thought you were talking about this by saying that the DST thing was a problem. Maybe it's not related.

Heh, we do consider it a problem. And by "it" I mean Daylight Savings as a concept.

Quote
Quote from: StarGeek on May 25, 2024, 11:20:19 AMThe EXIF tags are supposed to be set to local time and by themselves, cannot include a time zone. The EXIF standard stores the time zone in three separate tags (see below).
(I assume this sentence applies to videos only)

No, it is a blanket statement about EXIF tags.  Remember, EXIF is not a generic term for metadata, it is a very specific type of metadata.  All EXIF data is metadata, but not all metadata is EXIF data.

QuoteI was asking all these questions because I have a Canon camera that creates the three OffsetTime tags as you said, and another one just a bit older that doesn't create any OffsetTime tag at all. This was weird to me, I wanted to know if that was an error or inconsistency or anything.

The addition of the OffsetTime* is... well, I can't say new anymore, but the adaptation of the tags is still relatively new. They were added to the EXIF spec in 2016 and didn't see widespread usage until about 2020.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).