Exporting a saved search or a folder with Access DB load file (MDB)

Note: The import and export workflows with Access DB (MDB) are designed for and are currently available for the Asia-Pacific region. For information on the possibility of enabling this flow in your instance, please contact your Account Representative.

You can use Import/Export to export a saved search or a folder with MDB load file out of RelativityOne.

If you want to use Import/Export with Express Transfer, which is the recommended method for data transfer, refer to Express Transfer overview for more information. With Express Transfer activated, you can run up to five concurrent export jobs on a single client machine. For more information, see Concurrent and consecutive jobs.

Refer to Access DB (MDB) load file specifications for more information regarding load files. Also see General recommendations for structured data import and export jobs.

To export a saved search or a folder 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.

3. On the Choose Workflow dialog, click the Export button, then click Saved Search or Folder.
   
   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.

4. On the Export Settings dialog, complete the following fields, then click Continue:
   
   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—the job configuration settings that were previously saved to a profile file (.ie or .kw*). They can be reused when creating future jobs with the same or similar settings in RelativityOne. This 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 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. This option is available for a saved search export.
   • Folders—choose which workspace folder to export. This option is available for a folder export.
   • Export Sub-folders toggle—select this option to export sub-folders of the previously selected folder. This option is available for a folder export.
   • Views—select the workspace view that you would like to use to export metadata. This option is available for a folder export.
   Location and Files:
   • Export Location Type—select one or both of these options:
     • 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. This is the recommended option when Express Transfer is activated.
       Note: This temporary non-Staging Area location is automatically deleted once the download is completed when using Express Transfer or is deleted after 5 days when using web mode for downloads. This data is not included in your Staging Area threshold.
   • Staging Area—select this option to create a copy of the data in the StructuredData folder in the Staging Area. You will need to use Staging Explorer later to download data. The exported data will not be compressed.
   • Local Disk and Staging Area—select both options to create a copy of the selected data in the StructuredData folder in the Staging Area, as well as download it to your local disk with Express Transfer or web browser.
     Note: The StructuredData folder is included in your Staging Area threshold. To avoid additional storage costs, you may want to delete the exported data from that folder once it is no longer needed.
     Note: For some combinations of job configuration and data, Windows system on your local machine may not be able to open ZIP archives due to too long file paths. You may receive an error message: “The compressed (zipped) folder is invalid.” For details, go to General recommendations for structured data import and export jobs.
     
   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.

5. 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 is displayed 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.
   • Generate MDB File—toggle on if you want to generate Access DB load file (MDB). This option is toggled off by default.
   • Data File Encoding—select the encoding type for the document-level load file from the drop-down.
   • Regional Settings (Date and Time)—select the desired format for the exported date and time data. A preview of the chosen format will appear below the next field. Your selection for this field will remain for future export jobs until you change it or clear the browser cache. Clearing the browser cache will default the format to "English (United States)."
   • Long Time (with seconds)—by default, this option is toggled off. Toggle it on if you want to export fullname date format with the exported date and time information. For example, when using Regional Setting set to "English (Australia) | en-AU", the date and time will export as 08/04/2025, 9:01 AM (DD/MM/YYYY HH:MM AM/PM) when the toggle is off. It will export as Tuesday, 8 April 2025 09:01:00 AM (Day name, DD Month YYYY hh:mm:ss AM/PM) when the toggle is on.
   • 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.

6. On the Select Fields dialog, configure how to populate individual columns and tables in the exported MDB file. Select options in the three tabs:
   • Export—on this tab, map the Relativity workspace fields to the corresponding columns in the Export table.
     
   • Export Extras—on this tab, select which Relativity workspace fields to export into the Export_extras table. There is also an option to rename a workspace field to a custom name. Label value in MDB file.
     
   • Parties—on this tab, select which Relativity workspace fields to export into the Parties table. There is also an option to rename a workspace field to a custom name. Correspondence_Type value in MDB file.
     
     
   Note: For multichoice fields or multiple values separated with a semicolon within a text field, there will be separate row entries created for each such value in the generated record in the Parties table.

7. On the Image Source dialog, select what images you want to export.
   
   Production Images Type:
   • Original Images—select to export only the original, non-produced images.
   • Produced Images—select to export a produced version of the images.
   Select Productions:
   • Include original images toggle—select to export original images for the documents that are not in a specified production.

8. 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.

9. 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, that is Opticon, IPRO, or IPRO (FullText), and the File Type for export images, that is Single-page TIFF/JPG, Multi-page TIFF/JPG, or Rendered PDF.
   • Export PDF toggle—select this option to include existing stored PDFs in the export. No document-to-PDF conversion functionality is performed in this step. The PDFs must already exist as PDF files. If this option is toggled on, then you must set the Data File Format for PDF-level load file, that is Opticon, IPRO, or IPRO (FullText).

10. 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 next to the field name and drag it to the proper ordering position.
      During an export, the system checks the first field in the list for text. If the field is null, it checks the next field in order of precedence for text, and so on. When Relativity finds a field that contains text, it adds the contents of that field to the Text Fields Precedence column in the document load file. 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.

11. Click Continue.
12. On the Export Job Configuration Summary dialog, review the export job settings and go back to make any corrections as needed.
    

13. (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). 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. The .ie profile file format is not supported in other RelativityOne data transfer tools.

14. Click the Export button to start the exporting process.

15. When it's complete, the job summary lists the records exported successfully, including Load files containing .mdb, .dat, opt, etc., errors found, and path to your exported files.
    • If using Import/Export with Express Transfer active, the exported files automatically start to download. You can track the download's progress in the Exporting dialog or in Express Transfer. For more information, see Express Transfer Job tracking and history.
      Note: If you ran the job with Express Transfer active, you can close the Import/Export application while the job is running. The transfer job will continue uninterrupted. You can monitor the progress and history of the job within Express Transfer. You do not have to be logged into RelativityOne to view information within the Express Transfer application.
      
    • If using Import/Export in web only mode, the application generates a zip file containing the exported data that can be download. Click the Download button to save the exported data zip file to your computer, or click the Close button to close the dialog without downloading the file.
      
      Note: When downloading zip files to your computer, you can configure your browser to allow you save the zip file to a custom file name of your choosing as well as to a specific folder destination instead of using the default file name and destination. In the Settings menu of your browser, select Downloads. Toggle on the option to ask where to save or what to do with each file before downloading. Now, when you click the Download button in the Exporting dialog, your browser will display a dialog that allows you to change the default zip file name and select a destination other than the default one. If needed, you can also create a new folder in the chosen destination for the exported data.
      
    • If you chose to Export to Staging Area when setting up your export job on the Export Settings dialog, the application automatically exports data to your RelativityOne file share and skips the downloading process. Go to the path listed on the dialog to access the exported data files.

For more information on where Import/Export saves files, see the Community article, Import/Export: Where Files Are Saved By The Import/Export Application.

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. The Job page also contains more details about all jobs.