Preparing Native Files
Preferred Format
- 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 /
Metadata |
Description
|
Concordance
Field Name |
| 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 original environment. |
FILEPATH |
| Production Link | Relative path to production media of submitted native files. Example: FTC-001\NATIVE\001\FTC-0003090.xls |
NATIVELINK |
| Hash | The SHA (Secure Hash Algorithm) or MD5 Hash for the original native file if available | HASH |