Overlaying Metadata

<< Click to Display Table of Contents >>

Navigation:  Review  >

Overlaying Metadata

Data sets provided from other eDiscovery systems are often produced with an associated DAT file containing fielded data from the produced documents.  Incorporating that fielded data into DWR is accomplished by overlaying the metadata.

Right-click on the filter tree and select Overlay Metadata.

overlay_menu

Using the Browse button, navigate to the location of the load file (either .dat or .csv). Once the load file has been specified, the source fields are auto-populated in the Overlay Metadata dialog. Drag and drop the Source fields into the DWR field to which the data should be incorporated. (see below for more details)

From the Load File Key Column drop down, select the field of the load file that contains the unique record identifier in order to map to the records in the database; typically this is the document’s starting Bates number. The Load File Key Column must contain values unique to each file in the collection.

overlay

The "Use region and language"check box allows for the selection from a drop down of different cultures that reflect different naming conventions for fields such as dates. For example, the date January 1st, 2018 would appear in English (United States) as 1/31/2018 whereas the date in French would appear as 31/1/2018.

Create the mappings between fields in the load file and data column by dragging the load file’s Source field names to the right-hand side and dropping them in the First or Second columns. This is aided by having some familiarity with the load file’s contents. For example, knowing that document file extensions were included in a load file field called EXT, one would pair EXT with the "Extension" DWR column.   Check the Show Preview box to preview the first 5 rows of the DAT file.  As fields are matched with DWR fields the text is in bold in the show preview panel.

clip0045

DWR maintains file names and email subjects in the Title field to allow for a single column on which to sort.  When overlaying metadata DWR will automatically update the Title field with Filename and then subject when provided in two separate fields. BegAttach matches to Family and the tool automatically calculates the EndAttach and thus not needed. Text and Native Paths are also not needed for loading data in DWR but are included as standards for other tools.

clip0046

When providing a mapping in both the First and Second columns of any given row, the specified source fields will be concatenated together into the single DWR column. This action is most commonly used for load files providing Date and Time in two separate fields where it is displayed in DWR in a single field.

clip0016

When done identifying mappings, click Apply to update the database. The dialog’s progress bar will show that the process is complete.