Create modified Production Load Files without rerunning Production

SYMPTOMS

A large production has been run, however their are required metadata/document fields that were not configured when the production was created.  Creating another production would unnecessarily assign a new set of Bates Numbers and take a considerable amount of time.

CAUSE

Original production did not have all required fields configured to be included in the load files.

RESOLUTION

The easiest way to correct this is to create a small production with the required fields to be used as a example for the changes required for the large production. (SQLite Expert Personal is required)

• Create a small production that has the required fields.
• Navigate to the location of the Productions.sqlite database. The default location is: C:\ProgramData\Zylab\LegalProduction
• Find the small production and click on the Settings field, then click on [...] when it appears.
• Navigate to the <loadfiles> tag.
• Copy the <field identifier...> line for the fields that need to be added to the large production. 

Example: 

<field identifier="FILEDATELASTMOD" fieldtype="MetaData" originalidentifier="modified" format="MM/dd/yyyy" istextvalue="False" />
<field identifier="FILETIMELASTMOD" fieldtype="MetaData" originalidentifier="modified" format="HH:mm:ss" istextvalue="False" />
<field identifier="MIMETYPE" fieldtype="MetaData" originalidentifier="mimetype" istextvalue="True" ismultiline="True" />
<field identifier="EM_FROM" fieldtype="MetaData" originalidentifier="emailfrom" istextvalue="True" ismultiline="True" />

• Close the 'Text Editor: Settings', then open the same window for the large production and find the <loadfiles> tag.
• Copy the <field identifier...> lines to the each of the <metadata> section for each of the <loadfile> types.

Example:

<loadfile type="CSV" encoding="UTF8" target="[ProductionName].DAT" subdir="DATA" delimiter="20" textqualifier="254" listfieldseparator="59" newline="174">

or

<loadfile type="OPT" encoding="UTF8" target="[ProductionName].OPT" subdir="DATA" optseparator="44" volume=" ">

• Save the changes by clicking [OK].
• Double-click in the Status field for the large production and change the status from 4 to 3, then restart the 'ZyLAB Legal Produciton Service 2' service.

New load files will be created using the new field settings.

APPLIES TO

3.9, 3.11, 4.3, 4.4