Exporting a saved search load file via Import/Export
You can use Import/Export to export a saved search 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 saved search load file:
Use tabs, search, or the quick nav bar to navigate to the Import/Export Job page.
On the Import/Export Job page, click the New Import/Export Job button to start a new job.
On the Choose workflow dialog, click the Export button, then click Saved Search.
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.
On the Export Settings, complete the following fields, then click Continue:
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.
Saved Search—choose the desired saved search 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 dialog in the last step of this process. 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.
(Optional) Notification Addresses—enable email notifications by providing the email addresses of those who should get notified once the job completed, failed, or canceled.
On the Load File Settings dialog, select the data file format and data file encoding, then click Continue.
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 when this option is selected.
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.
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
On the Production Image Type dialog, select the images you want to export.
Production Image Type:
Original Images—select to export only the original, non-produced images.
- Produced Images—select to export a produced version of the images.
- Include original images toggle—select to export original images for the documents that are not in a specified production.
- Move the productions that you want to export from the Available Productions box to the Selected Productions box.
Note: Any produced native files will be exported as a native instead of an image. Only one produced image is exported based on precedence in the list. If the document is in the topmost production, that version is exported. If not, Relativity checks for the document in the second production and so on. If the document is not a part of any of the selected productions, and "Include original images" toggle is enabled, then the original document is produced.
On the File Settings dialog, select the options to include native files, images, and/or PDFs in the exported data, then click Continue.
Export Native Files toggle—select this option to export native files.
Export Images toggle—select this option to include images in the export. If toggled on, then you must set the Data File Format for image-level load file (Opticon, IPRO, or IPRO (FullText)) and the File Type for export images (Single-page TIFF/JPG, Multi-page TIFF/JPG, or Rendered PDF).
Export PDFs toggle—select this option to include PDFs in the export. If toggled on, then you must set the Data File Format for PDF-level load file (Opticon, IPRO, or IPRO (FullText)).
On the File And Folders dialog, choose the desired naming convention and folder structure for the exported files, then click Continue.
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 using the document identifier/control number.
Custom name—select this option to customize the file names. If 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 enter 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.
- Group files by—select one of the options below for how to group the exported files:
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.
On the Text File Settings dialog, you can select to export text field as files and then choose the text file encoding as follows.
- 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 the 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.
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.
- Click Continue.
(Optional) In the Advanced Settings dialog, toggle on Set Custom Information if you want to customize the volume and folder information. Otherwise, leave the toggle off.
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.
On the Export Job Configuration Summary, review the export job settings and go back to make any corrections as needed.
(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 import 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).
- Click Export to begin the exporting process.
- 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.
You can review the Import/Export Job page to see more information about the job. Refer to
Note: If you ran the job with Express Transfer active, you can 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 the job 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.