Apple iphone movie "create date" is wrong which is used by Adobe Lightroom

Started by mike9475, February 13, 2024, 04:43:47 PM

Previous topic - Next topic

mike9475

Dear Members

I'm having all my Fotos in Adobe Lightroom Classic and wanted to start to include my short Videos from my Iphone 13 pro max in the same workflow as with my Pictures.

So i export all the pictures and Videos from my Macs iphotos and then import into LRC. There i do a rename based on creation Date. unfortunately LRC use the Create Date and not the creation Date Exif Tag.

How should i fix this issue? Delete the wrong Tag or change it?

What would be your suggestions?

thanks a lot Michael

exiftool -a -G1 -time:all IMG_0002.mov
[System]        File Modification Date/Time    : 2024:02:11 22:44:00+01:00
[System]        File Access Date/Time          : 2024:02:13 15:02:30+01:00
[System]        File Inode Change Date/Time    : 2024:02:13 17:33:27+01:00
[QuickTime]     Create Date                    : 2024:02:11 21:43:51
[QuickTime]     Modify Date                    : 2024:02:11 21:44:00
[Track1]        Track Create Date              : 2024:02:11 21:43:51
[Track1]        Track Modify Date              : 2024:02:11 21:44:00
[Track1]        Media Create Date              : 2024:02:11 21:43:51
[Track1]        Media Modify Date              : 2024:02:11 21:44:00
[Track2]        Track Create Date              : 2024:02:11 21:43:51
[Track2]        Track Modify Date              : 2024:02:11 21:44:00
[Track2]        Media Create Date              : 2024:02:11 21:43:51
[Track2]        Media Modify Date              : 2024:02:11 21:44:00
[Track3]        Track Create Date              : 2024:02:11 21:43:51
[Track3]        Track Modify Date              : 2024:02:11 21:44:00
[Track3]        Media Create Date              : 2024:02:11 21:43:51
[Track3]        Media Modify Date              : 2024:02:11 21:44:00
[Track4]        Track Create Date              : 2024:02:11 21:43:51
[Track4]        Track Modify Date              : 2024:02:11 21:44:00
[Track4]        Media Create Date              : 2024:02:11 21:43:51
[Track4]        Media Modify Date              : 2024:02:11 21:44:00
[Keys]          Creation Date                  : 2023:07:25 22:18:48+01:00

exiftool -G1 -a -s -CreationDate IMG_0002.mov
[Keys]          CreationDate                   : 2023:07:25 22:18:48+01:00

exiftool -G1 -a -s -CreateDate IMG_0002.mov
[QuickTime]     CreateDate                     : 2024:02:11 21:43:51

StarGeek

You can't delete the Quicktime:CreateDate.  It's the same with the Quicktime:ModifyDate and the various Track timestamps.  They are required parts of the video.

I would suggest copying the CreationDate to the XMP:CreateDate. I don't believe that LR reads the Quicktime data, instead it will read XMP data in the video.  Something like this
exiftool "-XMP:AllDates<CreationDate /path/to/files/[/tt]

That will write the three major XMP timestamps that LR will use in images.
"It didn't work" isn't helpful. What was the exact command used and the output.
Read FAQ #3 and use that cmd
Please use the Code button for exiftool output

Please include your OS/Exiftool version/filetype

wywh

Quote from: StarGeek on February 13, 2024, 05:10:56 PMI don't believe that LR reads the Quicktime data

Lightroom Classic 13.1 reads QuickTime:CreateDate so it would be possible to copy the correct Keys:CreationDate to it with something like:

exiftool -m -P -overwrite_original -wm w -api LargeFileSupport=1 -api QuickTimeUTC=1 '-AllDates<Keys:CreationDate' '-Track*Date<Keys:CreationDate' '-Media*Date<Keys:CreationDate' .
Also this shorter command seems to work:

exiftool -m -P -overwrite_original -wm w -api LargeFileSupport=1 -api QuickTimeUTC=1 '-*Date<Keys:CreationDate' .
...but Lightroom reads QuickTime:CreateDate as UTC with no local time adjustment so that does not really work here (leaving QuickTimeUTC option off would write incorrect time if read in non-Adobe apps...).

But as you said, a copy to XMP dates works OK as far as Lightroom is concerned:

exiftool -m -P -overwrite_original '-XMP:AllDates<CreationDate' .           

exiftool -a -G1 -s -api LargeFileSupport=1 -api QuickTimeUTC=1 -Time:All .
[QuickTime]     CreateDate                      : 2024:02:14 09:54:00+02:00
[Keys]          CreationDate                    : 2024:02:01 12:00:00+02:00
[XMP-exif]      DateTimeOriginal                : 2024:02:01 12:00:00+02:00
[XMP-xmp]       CreateDate                      : 2024:02:01 12:00:00+02:00
[XMP-xmp]       ModifyDate                      : 2024:02:01 12:00:00+02:00

p.s. I wonder how the OP got QuickTime:CreateDate and Keys:CreationDate out-of-sync? One way to do it is to edit date in iOS: it edits just Keys:CreationDate and leaves QuickTime:CreateDate intact.

- Matti

mike9475

#3
Wow that's amazing. After spending days in the Chat with Adobe (did some other stuff in between too) and they recommended to change permissions reboot check my iphone etc etc.

You guys helped me in under two hours  8)

I test the XMP copy and it was recognised from LRC.

exiftool -m -P -overwrite_original '-XMP:AllDates<CreationDate' ./IMG_0002.mov
    1 image files updated

exiftool -a -G1 -s -api LargeFileSupport=1 -api QuickTimeUTC=1 -Time:All ./IMG_0002.mov
[System]        FileModifyDate                 : 2024:02:11 22:44:00+01:00
[System]        FileAccessDate                 : 2024:02:13 15:02:30+01:00
[System]        FileInodeChangeDate            : 2024:02:14 15:58:27+01:00
[QuickTime]     CreateDate                     : 2024:02:11 22:43:51+01:00
[QuickTime]     ModifyDate                     : 2024:02:11 22:44:00+01:00
[Track1]        TrackCreateDate                : 2024:02:11 22:43:51+01:00
[Track1]        TrackModifyDate                : 2024:02:11 22:44:00+01:00
[Track1]        MediaCreateDate                : 2024:02:11 22:43:51+01:00
[Track1]        MediaModifyDate                : 2024:02:11 22:44:00+01:00
[Track2]        TrackCreateDate                : 2024:02:11 22:43:51+01:00
[Track2]        TrackModifyDate                : 2024:02:11 22:44:00+01:00
[Track2]        MediaCreateDate                : 2024:02:11 22:43:51+01:00
[Track2]        MediaModifyDate                : 2024:02:11 22:44:00+01:00
[Track3]        TrackCreateDate                : 2024:02:11 22:43:51+01:00
[Track3]        TrackModifyDate                : 2024:02:11 22:44:00+01:00
[Track3]        MediaCreateDate                : 2024:02:11 22:43:51+01:00
[Track3]        MediaModifyDate                : 2024:02:11 22:44:00+01:00
[Track4]        TrackCreateDate                : 2024:02:11 22:43:51+01:00
[Track4]        TrackModifyDate                : 2024:02:11 22:44:00+01:00
[Track4]        MediaCreateDate                : 2024:02:11 22:43:51+01:00
[Track4]        MediaModifyDate                : 2024:02:11 22:44:00+01:00
[Keys]          CreationDate                   : 2023:07:25 22:18:48+01:00
[XMP-exif]      DateTimeOriginal               : 2023:07:25 22:18:48+01:00
[XMP-xmp]       CreateDate                     : 2023:07:25 22:18:48+01:00
[XMP-xmp]       ModifyDate                     : 2023:07:25 22:18:48+01:00

No idea how that could go wrong.
My Workflow is as follow:
1) iphone take video
2) Video will be imported automaticlly into ICloud photos and synced to my iMAC
3) export on my iMAC to the filesystem
4) import to LRC


mike9475

Here how it looks inside LRC and the export Settings in Photos.



StarGeek

Quote from: wywh on February 14, 2024, 07:06:59 AMLightroom Classic 13.1 reads QuickTime:CreateDate

Good to know. I'll have to make I include that in future answers   
"It didn't work" isn't helpful. What was the exact command used and the output.
Read FAQ #3 and use that cmd
Please use the Code button for exiftool output

Please include your OS/Exiftool version/filetype