Strange Metadata in Microsoft OneDrive

Started by Bernie, October 13, 2022, 11:00:40 AM

Previous topic - Next topic

Bernie

Hi,
thanks to the help I received in this forum I was able to resolve most of my tagging problems when uploading my photos to MS OneDrive.
But now I have a behavior I can't explain.
For some photos OneDrive generates correct date tags (like Testfile01.jpg, see left side of the screenshot attached) and others not. My problem is that when I check them with exiftool everything seems to be alright.
In the attached picture you can see a screenshot how OneDrive shows the tags compared to exiftool. In Testfile01 there is a "Date Taken" tag which doesn't exist in Testfile02. And I don't know why.
I also compared the two files with jExiftoolGui (see attached PDF). But also there I see no differences that could cause a different interpretation (from my opinion).
Does anyone had such a problem before or knows what could be the reason?

Here is the output from exiftool in textform:
bernie@Bernie-Mint:/media/bernie/Daten/tmp/Mist$ exiftool -time:all -s .
======== ./Testfile 01.jpg
FileModifyDate                  : 2006:03:18 17:36:54+01:00
FileAccessDate                  : 2022:10:13 16:11:21+02:00
FileInodeChangeDate             : 2022:10:13 16:26:51+02:00
ModifyDate                      : 2006:03:18 17:36:56
DateTimeOriginal                : 2006:03:18 17:36:56
CreateDate                      : 2006:03:18 17:36:56
======== ./Testfile 02.jpg
FileModifyDate                  : 2006:03:18 18:00:11+01:00
FileAccessDate                  : 2006:03:18 18:00:11+01:00
FileInodeChangeDate             : 2022:10:13 16:27:00+02:00
ModifyDate                      : 2006:03:25 20:31:09
DateTimeOriginal                : 2006:03:18 18:00:11
CreateDate                      : 2006:03:18 18:00:11
    1 directories scanned
    2 image files read

StarGeek

First, try adding -G1 to your command to make sure those tags are in the correct location.  You should see something like this
[IFD0]          ModifyDate                      : 2022:10:13 08:17:03
[ExifIFD]      DateTimeOriginal                : 2022:10:13 08:17:03
[ExifIFD]      CreateDate                      : 2022:10:13 08:17:03

If the tags are in the correct places, try this command to see if there's problems with the structure
exiftool -g1 -a -s -warning -validate /path/to/files/

Otherwise, there's not much else to do, it would be a OneDrive problem.
* 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).

Bernie

Thanks for your help.
I tried it and...

-G1 gives the following output:
bernie@Bernie-Mint:/media/bernie/Daten/tmp/Mist$ exiftool -time:all -s -G1 .
======== ./Testfile 01.jpg
[System]        FileModifyDate                  : 2006:03:18 17:36:54+01:00
[System]        FileAccessDate                  : 2022:10:13 17:21:26+02:00
[System]        FileInodeChangeDate             : 2022:10:13 17:31:01+02:00
[IFD0]          ModifyDate                      : 2006:03:18 17:36:56
[ExifIFD]       DateTimeOriginal                : 2006:03:18 17:36:56
[ExifIFD]       CreateDate                      : 2006:03:18 17:36:56
======== ./Testfile 02.jpg
[System]        FileModifyDate                  : 2006:03:25 20:31:10+01:00
[System]        FileAccessDate                  : 2022:10:13 17:21:26+02:00
[System]        FileInodeChangeDate             : 2022:10:13 17:31:08+02:00
[IFD0]          ModifyDate                      : 2006:03:25 20:31:09
[ExifIFD]       DateTimeOriginal                : 2006:03:18 18:00:11
[ExifIFD]       CreateDate                      : 2006:03:18 18:00:11
    1 directories scanned
    2 image files read

With the second command I get some warnings. But I don't know what they mean or how I could eliminate them...
bernie@Bernie-Mint:/media/bernie/Daten/tmp/Mist$ exiftool -g1 -a -s -warning -validate .
======== ./Testfile 01.jpg
---- ExifTool ----
Validate                        : OK
======== ./Testfile 02.jpg
---- ExifTool ----
Warning                         : [minor] Odd offset for ExifIFD tag 0x829a ExposureTime
Warning                         : [minor] Odd offset for ExifIFD tag 0x829d FNumber
Warning                         : [minor] Odd offset for ExifIFD tag 0x9003 DateTimeOriginal
Warning                         : [minor] Odd offset for ExifIFD tag 0x9102 CompressedBitsPerPixel
Warning                         : [minor] Odd offset for ExifIFD tag 0x9201 ShutterSpeedValue
Warning                         : [minor] Odd offset for ExifIFD tag 0x9202 ApertureValue
Warning                         : [minor] Odd offset for ExifIFD tag 0x9204 ExposureCompensation
Warning                         : [minor] Odd offset for ExifIFD tag 0x9205 MaxApertureValue
Warning                         : [minor] Odd offset for ExifIFD tag 0x920a FocalLength
Warning                         : [minor] Odd offset for ExifIFD tag 0x927c
Warning                         : [minor] Odd offset for ExifIFD tag 0x9286 UserComment
Warning                         : [minor] Odd offset for InteropIFD tag 0x0001 InteropIndex
Warning                         : [minor] Odd offset for ExifIFD tag 0xa20e FocalPlaneXResolution
Warning                         : [minor] Odd offset for ExifIFD tag 0xa20f FocalPlaneYResolution
Warning                         : [minor] Odd offset for ExifIFD tag 0xa404 DigitalZoomRatio
Validate                        : 15 Warnings (all minor)
    1 directories scanned
    2 image files read

Phil Harvey

All of those warnings would be fixed by writing anything with ExifTool.  In general, even though the TIFF specification mandates even offsets for stored values, I don't think that any reader really cares about this, so it is unlikely that this is related to the problem you are having.

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

Bernie

Hi Phil.
this hint All of those warnings would be fixed by writing anything with ExifTool was the solution.
First I copied all the Exifdates to the Filedates (because some of the Filedates weren't correct)
exiftool '-FileModifyDate<DateTimeOriginal' .
Then I copied back the Filedates to the Exifdates to correct the offset
exiftool '-FileModifyDate>DateTimeOriginal' .
Moved them to OneDrive and: Voila
All of them are now in the correct timeline.

Thanks a lot.   :D