Preparing Native Files
- Submit Microsoft Excel and PowerPoint files in native format with extracted text and metadata.
- Submit Microsoft Access files and other multimedia files in native format with metadata.
- Submit other files and attachments as images with extracted text and metadata.
Metadata & Other Information Requirements
Include the following metadata fields and information in the delimited data load file. Alongside each piece of information, we've recommended a corresponding field name for the delimited data load file.
Document Info /
|Beginning Bates number||The beginning bates number for the document||BEGBATES|
|Ending Bates number||The ending bates number for the document||ENDBATES|
|Page Count||The total number of pages in the document||PGCOUNT|
|Custodian||The name of the original custodian of the file||CUSTODIAN|
|Creation Date||The date attachment was saved at the location on the electronic media for the first time||CREATEDATE|
|Creation Time||The time the attachment was saved at the location on the electronic media for the first time||CREATETIME|
|Modified Date||The date/time the attachment was last changed, and then saved||MODDATE|
|Modified Time||The time the attachment was last changed, and then saved||MODTIME|
|Last Accessed Date||The time the attachment was last opened, scanned, or even “touched” by a user or software activity||LASTACCDATE|
|Last Accessed Time||The time the attachment was last opened, scanned, or even “touched” by a user or software activity||LASTACCTIME|
|Size||The amount of space the file takes up on the electronic media. Usually recorded in kilobytes, however may be reported in single bytes||FILESIZE|
|File Name||The name of the attachment including the extension denoting the application in which the file was created||FILENAME|
|Originating Path||File path of the file as it resided in its
|Production Link||Relative path to production media of
submitted native files. Example: FTC-001\NATIVE\001\FTC-0003090.xls
|Hash||The SHA (Secure Hash Algorithm) or MD5 Hash for the original native file if available||HASH|