Normalize dates in extracted metadata from binaries

Question

Normalize dates in extracted metadata from binaries

ryangrimm opened this issue 13 years ago · 3 comments

Many binary formats include something along the lines of a creation date or a modification date. These dates can be under various names for various file formats. In order to support various queries and range indexes on this metadata, normalizing these dates into xs:dateTime values would be required.

To do so, the current plan is to attempt to parse the value of any piece of metadata that has date or time in its name. The parsing can be accomplished via the date parser that's already in use. New formats can easily be added if need be.

Answer 1 · 2011-12-12T21:24:20.000Z

Will want to normalize the element names as well. Content extracted from PDF ends up with corona:modDate while Word ends up with corona:lastSavedDate (which I believe are conceptually the same thing). I did a quick inventory of a half dozen other formats and that's the main one I saw.

Answer 2 · 2011-12-12T22:13:17.000Z

Discussion: http://markmail.org/thread/cenoooa7kmu7237n

Answer 3 · 2011-12-15T17:36:46.000Z

Normalizing last modification metadata to a corona:modDate element. Also running any piece of metadata that has "date" in the name through the date parser. If a date is extracted it's stored in a normalized-date attribute.