search

MediaArea / MediaInfo

Convenient unified display of the most relevant technical and tag data for video and audio files.
https://MediaArea.net/MediaInfo
BSD 2-Clause "Simplified" License
1.39k stars 160 forks source link

Export as CSV is missing some data #586

Open larsen0815 opened 2 years ago

larsen0815 commented 2 years ago

This is displayed in text mode:

com.apple.quicktime.make                 : Apple
com.apple.quicktime.model                : iPhone 12 mini
com.apple.quicktime.software             : 14.6
com.apple.quicktime.creationdate         : 2021-06-26T14:14:20+0200
com.apple.photos.originating.signature   : AfUM3rw2hB2SlNdNEoYVIBhyqcPC

Though, it is not exported into CSV. "creationdate" is the important part here, as EncodedDate is not the same.

Using MediaInfo 21.09

JeromeMartinez commented 2 years ago

For the moment default CSV output does not provide unsupported fields i.e. the fiels you are looking for (they are extracted "as is" from the file). But com.apple.quicktime.creationdate could be mapped to Encoded_Date MediaInfo field so exported. But... How could the current Encoded_Date be different from com.apple.quicktime.creationdate? Seems to be same, maybe just more precise

Please share a sample file so I can have a view on the differences.

larsen0815 commented 2 years ago

Guess there is some Apple-magic involved... https://mega.nz/file/pl1mVCqb#6V0dfS6yJWOoegMB70Hx2trX70DP4MlLiWzNYoTbrM0

JeromeMartinez commented 2 years ago

So you recorded the content ("The date the movie file content was created.", fun fact: the example provided by Apple is not same, the example is "4/21/2012" so another formatting, so easy) on August 26, right? What did you do with this file on September 23?

I have another field Recorded_Date, I guess it would be a good mapping.

larsen0815 commented 2 years ago

This is a recording from my wife, so I'm not sure about the exact date, but August 26 should be correct. I guess she copied the file from her iPhone on September 23 (don't know if that was via iTunes or anything else).

JeromeMartinez commented 2 years ago

A copy should not change the file content, only the file modification date (another field). Apple mystery...

eSavior commented 1 year ago

Just wanted to add some additional info on my personal findings. The com.apple.quicktime.creationdate attribute, if present, actually is the MOST accurate attribute that represents the original video creation date. The reason why this can get out of sync with the Encoded_Dateattribute and/or the file creation date is that Apple mobile devices can be configured to re-encode video files to different (more compatible) formats when they are exported from the devices.

When this option to re-encode videos is set by the user on an Apple mobile device, then the com.apple.quicktime.creationdate attribute becomes the ONLY remaining attribute that properly keeps track of when the video was originally captured. The Encoded_Date attribute and the file creation dates change in this condition to be the date that the video was exported from the mobile device (useless information as far as I'm concerned, but unfortunately information that is preserved in the video's Encoded_Date standard attribute that is commonly checked when the file creation date can no longer be trusted).

FYI, to other users who stumble here wishing they could export the com.apple.quicktime.creationdate attribute using MediaInfo, you have an alternative called "ExifTool" created by Phil Harvey that will export this attribute into a variety of user-specified output formats.