Exporting a production set load file via Import/Export

You can use Import/Export to export a production set load file out of RelativityOne.

If you want to use Import/Export with Express Transfer, refer to Express Transfer overview for more information.

To export a production load file:

  1. Use tabs, search, or the quick nav bar to navigate to the Import/Export Job page.

  2. On the Import/Export Job page, click the New Import/Export Job button to start a new job.

  1. On the Choose workflow dialog, click the Export button, then click Production Set.

Choose workflow Export

Note: If Express Transfer has been activated, the Express Transfer section will display a status of Active. See Activating and deactivating Express Transfer for more information.

  1. On the Export Settings, complete the following fields and click Continue.

Export Settings for Production Sets

Data Source:

  • Job Name—provide a descriptive job name so that you can quickly identify and track that job on the Import/Export Job page. The Job name field accepts up to 50 characters.

  • Profile—are job configuration settings that were previously saved to a profile file (.ie or .kw*) so they can be reused when creating future jobs with the same or similar settings in RelativityOne, which saves time and effort as well as helps prevent data entry errors when you're mapping fields, for example.

    • None—select this option if you do not desire to use a profile for this export or if you intend to create a new profile based on the settings entered in the upcoming steps. You will be able to save the profile settings later on the “Export Job Configuration Summary” dialog. The file extension for the new profile created will be “.ie”.

    • From Local Disk Profiles—use this option to select a previously saved Import/Export profile (.ie file) or an existing .kw* profile (created via the RDC application) to reuse the job settings for this workflow. Use the drag and drop feature or browse for a file to choose it. All job settings provided within the selected profile file will be automatically entered where applicable in the succeeding workflow dialogs.

  • Production—choose the desired production set to export.

Location and Files:

  • Export Location Type—select one of these options:

    • Download to Local Disk—select this option to export the selected production set data to the Staging area and compress it to a single zip file. Once complete, you can download the zip file with your web browser directly to a local disk by clicking the Download button.

    • Export to Staging Area—select this option to export data to a dedicated folder in the Staging area. The exported data will not be compressed.

Note: When you export data from RelativityOne with Import/Export, the exported files are stored in the Staging area location indicated in the Exporting modal. After downloading data to your local computer, you may want to consider manually deleting exported files from the Staging area location to avoid additional storage costs.

Notifications:

  • (Optional) Notification Addresses—enable email notifications by providing the email addresses of those who should get notified once the job completed, failed, or canceled.

  1. On the Load File Settings dialog, select the data file format and data file encoding, then click Continue.

Load File Settings dialog

  • Data File Format—select one of the formats below for the load file you are exporting:

    • .dat (Concordance)—load file exports with the standard Concordance delimiters.

    • .csv (Comma separated)—load file exports with comma separated delimiters

    • .html (HTML)—load file is in HTML format and contains hyperlinks to launch any exported files.

    • .txt (Custom)—load file exports with the custom delimiters that you select in the Load File Characters section that displays.
      Load File characters fields on the Load File Settings

  • Start Line—select a line (record number) that identifies the initial document for export. The application begins by exporting the document with this number and continues by exporting documents with subsequent record numbers.

  • Data File Encoding—select the encoding type for the document-level load file from the drop-down.

  • Regional Settings (Date and Time)—the default date and time format is "English (United States)," which is MM/DD/YYYY and HH:MM:SS AM/PM. If you want date and time data to be exported using a different format, choose the appropriate one from the drop-down list. A preview of the chosen regional setting will appear below the selection.

  • Export Multiple Choice Fields as Nested—select this option to maintain the hierarchy of RelativityOne multiple-choice lists, when applicable. The nested value delimiter, a backslash, separates child choices.

  1. On the Select Fields dialog, choose the Workspace Fields that you want to export by moving them to the Selected Fields box, then click Continue. The Workspace Fields box displays all available fields, but only the fields in the Selected Fields box will be exported.

Note: The Production::Begin Bates and Production::End Bates fields automatically populate in the Selected Fields column.

You can do the following to move fields:

  • Highlight a field and click one of the directional arrow buttons in the center to move it between boxes
  • Double-click on a field to move it left and right between boxes
  • Use CTRL+ left mouse click to select multiple fields, then choose the desired directional arrow to move between boxes
  • In Selected Fields column, drag fields up and down to set the load file column order

Selected fields

  1. In order to include native files and/or images in the exported data, select the corresponding options on the File Settings dialog, then click Continue.

File settings

Natives:

  • Export Native Files toggle—select this option to export native files.

Images:

  • Export Images toggle—select this option to include images in the export. If this option is toggled on, then you must set the Data File Format and the File Type for export images.

  • Data File Format—select one of the formats for image-level load file: Opticon, IPRO, or IPRO (FullText).

  • File Type—select one of the file types: Single-page TIFF/JPG, Multi-page TIFF/JPG, or Rendered PDF.

  1. On the File And Folders dialog, choose the desired naming convention and folder structure for the exported files, then click Continue.

Export production load file Files and Folders

Text and Native File Names:

  • Named after—select one of the following naming conventions for exported files:

    • Control Number—select this option to name the files after the control number.

    • Production Begin Bates—select this option to name the files after the production number.

    • Custom name—select this option to customize native and text file names. If this option is selected, enter data in the following fields that display:
      • Prefix—choose whether to have the prefix be the Control Number or Production Begin Bates.

      • Select spacing—select the desired spacing option from the drop-down list.

      • Select field—choose a field from your workspace or choose Custom Text and provide your text.

      • Preview—you will be able to view a Preview of the custom file name at the top of the dialog to see if it's what you want and make changes in the fields as needed.
  • Append original filename toggle—select this option to append the original file name, which is defined as the file name as it was on disk, to the end of the exported file name.

Folder Structure:

  • Group files by—select one of the options below for how to group the exported file:

Note: Depending on the structure of your exported data, export job performance degradation may result and be several times longer when using Workspace Structure compared with using File Type. Unless it is necessary to use Workspace Structure, we recommend using the File Type option for the export job.

  • File Type—select this option to group files by their type and place them in separate folders based on type (such as in Natives, Images, Text, and PDFs folders).
  • Workspace Structure—select this option to preserve the workspace folder structure. This option may reduce the time of preparing production data since the files will not need to be manually realigned later to replicate the folder structure in the workspace.
  1. On the Text File Settings dialog, you can select to export text field as files and then choose the text file encoding as follows.
    Text file settings

  • Export Text Field as Files toggle—determines the export method of the extracted text or OCR. Select this option if you want to export files as individual document-level text files, with one file per document. Deselect it to include text as part of your load file.

  • Text File Encoding—if Export Text Field as Files is toggled on, then select the encoding format for the document-level text files.

  • Text Fields Precedence—select and assign an order to long text fields that Relativity checks for text when performing an export. Relativity adds the Text Fields Precedence column as the last column in the load file. You must select at least one long text field to use this functionality. Choose the fields from the Add Fields drop-down, then click Add. To delete a selected field, click its trashcan icon.
    Text file settings dialog for Text fields precedence section

To order the precedence of the fields, click the six-dot handle left of the field name and drag it up or down to the proper ordering position. During an export, the system checks the topmost (first) field in the list for text, and if the field is null, it checks the next field in order of precedence for text, and so on. When it finds a field that contains text, Relativity adds the contents of that field to the Text Fields Precedence column in the document load file, and then continues checking the fields for the next document and so on. For example, if you listed the Extracted Text field first and the Production OCR field second, the system would first check the Extracted Text field for content, and if it was null, it would move on to the Production OCR field, and so on.

The Text Fields Precedence column displays the file path to the exported files if you select the Export Text Field as Files checkbox above.

  1. Click Continue.

  2. (Optional) In the Advanced Settings dialog, toggle on Set Custom Information if you want to customize the volume and folder information using the fields below. Otherwise, leave the toggle off.
    Advanced Settings

Volume Information—this section controls the naming and size of the volume identifier. Set the following options in this section:

  • Prefix—enter the alpha prefix for the volume identifier.
  • Start—enter the first number used for the numeric section of the volume identifier. Multiple volumes increment numbers during export creating unique volume identifiers.
  • # of digits—enter the number of digits attached to the prefix. For example, if you enter 3, the output is VOL001, VOL002, and so on.
  • Max Size (MB)—enter the maximum size allowed for each volume.

Subdirectory Information—this section controls the naming and size of volume sub-folders. Set the following options in this section:

  • Image Prefix—enter the alpha prefix for the subdirectory that stores exported images.
  • Native Prefix—enter the alpha prefix for the subdirectory that stores exported native files.
  • Text Prefix—enter the alpha prefix for the subdirectory that stores exported extracted text files.
  • PDF Prefix—enter the alpha prefix for the subdirectory that stores exported extracted PDF files.
  • Start—enter the starting number for the subdirectories.
  • # of digits—select the number of digits of the subdirectory prefix. For example, if you enter 3, the output is IMG001, IMG002, and so on.
  • Max Files—select the number of files to store in each subdirectory.
  1. Click Continue.

  2. On the Export Job Configuration Summary, review the export job settings and go back to make any corrections as needed.

Export job configuration summary

  1. (Optional) Click Save Settings on the Export Job Configuration Summary dialog to export the job configuration settings entered thus far to its own profile file (.ie file extension) and save it on your computer so you can reuse these settings when creating a new export job with Import/Export.

    Note: Import/Export saves job configuration settings to its own profile file format (.ie file extension). Comparing to the legacy .kw* standard, it brings more flexibility as you now can apply saved job settings across various workspaces. Other Data Transfer tools, like Relativity Desktop Client, do not support the new profile file format (.ie file extension).

  2. Click the Export button to start the exporting process.
  1. The Exporting dialog tracks the job's progress. When it's complete, the job summary which lists the records exported successfully, errors found, and path to your exported files. If desired, click the Download button to download the exported data zip file to your computer. Otherwise, click the Close button to close the dialog.

    Note: You can always view the job's Exporting dialog information after it's closed by going to the Import/Export Job page and clicking the job name link.

    Exporting progress bar

You can review the Import/Export Job page to see more information about the job. Refer to Import/Export Job tracking and history for details.

Note: If you ran the job with Express Transfer active, you are able to close the Import/Export application while the job is running, if desired, and the transfer job will continue uninterrupted. You can monitor the progress and history of jobs within Express Transfer (see Express Transfer Job tracking and history). You do not have to be logged into RelativityOne to view information within the Express Transfer application.