Print Page - Data Extract for all files

Title: Data Extract for all files
Post by: dataops on March 13, 2023, 09:42:00 PM

Hi all,

I am trying to extract specific data from all different files types eg from; word, excel, pdf etc.

I am trying to extract file Details

Origin: Authors, Last saved by, Content created, Date last saved.

File: Date created, Date modified, Date accessed, Shared with, Computer.

I have been searching in forums but was unable to find anything under: "Origin" or "Last saved by" etc.

Thank you,

Title: Re: Data Extract for all files
Post by: Phil Harvey on March 14, 2023, 07:28:15 AM

Try running ExifTool on the files to see what it shows you.

- Phil

Title: Re: Data Extract for all files
Post by: StarGeek on March 15, 2023, 11:40:57 AM

There is no standardization in metadata across various file types. The tags in a video file has different names than the tags in a image file, which are different from an audio/document/pdf/etc file.

As Phil says, run exiftool on each file type and look at the results. The command in FAQ #3 (https://exiftool.org/faq.html#Q3) is recommended because it will show you all tags including tags with duplicate names. From there, you will have to reconcile any difference in the tag names in your workflow.

ExifTool Forum

ExifTool => Newbies => Topic started by: dataops on March 13, 2023, 09:42:00 PM