3.06 Data Files

The following files must reside in the Data folder on every delivery by the vendor:

1.       Database load file,

2.       Database structure file, and

3.       Imagebase cross-reference load file.

1. Database Load File:

1.       Delimiters – Although this document does not truly favor one application over another, the Concordance standard delimiter characters have proven reliable time and again. They are:   

·         Comma (020), Quote (254), Newline (174)

2.       The first line of the database load file should be the field names.

3.       The name of the database load file should match the volume name.

2. Database Structure File:

The Firm has a standard database structure we use for all databases (electronic and paper). We understand that software restrictions may result in a non-standard product. If the vendor is unable to then post-process their data to match our standard, Litigation Support will have to perform this work as billable time to the firm’s clients. As one can imagine, knowing the database structure as relates to the database load file is critical.

This is a text file showing a sample structure file. The following is just for illustration and does not match Firm standards. Please refer to the Bibliographic Coding Manual for this information.

3. Imagebase Load File.

The following are the rules governing a good load file:

1.       The imagebase load file name should match the volume name

2.       All images referenced in the load file must be contained on the same volume

3.       Document breaks

4.       Page counts

5.       Image path:

D:\IMAGES\[CLIENT#]\[MATTER#]\[DATABASE]\[VOLUME]\IMAGES\…

Note: While the path may seem long, it provides everyone with a standard everyone can understand. The database folder may seem redundant at first. That is until there are 12 databases for a given matter number. At that time, one becomes grateful for the database subfolder. The firm uses this structure for many reasons. When the load file does not match this path, the vendor will have to this. If Litigation Support has to fix this, then the client may be paying twice for the same work.

Sample Opticon Load File:

Please note the path, image key matching the file name, doc breaks and page counts. Please refer to Section 4, to see examples for other types of load files.

Here is an explanation of the Opticon load file format:

Each of these fields is “separated”, or “delimited”, from the others, by a comma.  When a technician imports a load file into Opticon, the content for each field is divided by the commas.  Therefore, one can not have a directory named "\5,312,591 PATENT" since Opticon will view each comma as the start of the next field, per below: