---
title: "Migration Export – Reveal"
slug: "migration-export-reveal"
tags: ["Migration Export", "Open Discovery"]
updated: 2025-05-22T17:13:03Z
published: 2025-05-22T17:13:03Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.revealdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Migration Export – Reveal

## Exporting your data

The migration process begins by exporting your data from Review. The goal of this process is to prepare your archive for easy upload into Logikcull and preserve any existing work product. Work product such as tags, notes, comments, etc., from existing databases can be mapped to new fields in Logikcull. However, redaction coordinates made from existing database cannot be migrated.

**Produced records with Bates stamped images will need to be uploaded separately, as these cannot be associated with the original version of the document.**

## Review Export Workflow

1. #### **Work Folders** - Identify the records to migrate and create a Work Folder containing those records.
  1. This process is outlined in Reveal knowledge base documentation online below. [https://docs.revealdata.com/knowledgebase/reveal/how-to-create-a-production-set](/reveal/docs/create-a-production-set)
  2. Work Folders
    1. Populate a Work Folder with all records with redactions.

1. Navigate to **Filters->Annotations->Has Redactions** in the Sidebar.

![243 - 01 - Has Redactions Filter](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2001%20-%20Has%20Redactions%20Filter.png?width=351&quality=high)
    2. Populate a Work Folder with all records to be migrated.
    3. Populate Work Folders with all records that have images in image sets.

1. Create a multi value field called “***Image_Set_List***” under **Project Admin -> Fields -> Add Fields**.

![243 - 02 - Create Multi-Value Field](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2002%20-%20Create%20Multi-Value%20Field.png?width=741&quality=high)

2. Run the below script to populate “***Image_Set_List***” field. If a record has an image in an image set, this will be populated with the name of the image set.

*CREATE TABLE IMAGE_SET_TEMP (ITEM_ID BIGINT,*

*IMAGE_SETS NVARCHAR(4000))*

*insert into IMAGE_SET_TEMP*

*select DIS.ITEM_ID, ISI.Name*

*FROM DOCUMENT_IMAGE_SETS ISI, DOCUMENT_IMAGES DIS*

*WHERE ISI.Document_Image_Set_Id = DIS.Document_Image_Set_Id*

*and DIS.Page_Id = 1*

*insert into IMAGE_SET_TEMP*

*select DIS.ITEM_ID, 'Original Image Set'*

*FROM IMAGE_ANNOTATION DIS*

*WHERE DIS.Page_Id = 1 and dis.image_exists = 1*

*select distinct item_id*

*into IMAGE_SET_TEMP3*

*from IMAGE_SET_TEMP*

*CREATE TABLE IMAGE_SET_TEMP2 (ITEM_ID BIGINT,*

*IMAGES_SET_LIST NVARCHAR(MAX))*

*insert into IMAGE_SET_TEMP2*

*select distinct DIS.ITEM_ID,*

*STUFF((SELECT ';' + ISI.IMAGE_SETS FROM IMAGE_SET_TEMP ISI*

*WHERE ISI.ITEM_ID = DIS.ITEM_Id*

*order by ISI.IMAGE_SETS*

*FOR XML PATH (''))*

*, 1, 1, '') AS IMAGES_SET_LIST*

*FROM IMAGE_SET_TEMP3 DIS*

--create multi value custom field, in update assumes field name is IMAGE_SET_LIST, length can be 4000 assuming no long image set names

*update ID SET ID.IMAGE_SET_LIST = IST.IMAGES_SET_LIST FROM IMPORT_DOCUMENTS ID JOIN IMAGE_SET_TEMP2 IST ON ID.ITEMID = IST.ITEM_ID*

*DROP TABLE IMAGE_SET_TEMP*

*DROP TABLE IMAGE_SET_TEMP2*

*DROP TABLE IMAGE_SET_TEMP3*

3. Run the Query against the chosen Project in the Review Manager **Advanced Options -> Query** tab.

![243 - 03 - Review Manager Query](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2003%20-%20Review%20Manager%20Query.png?width=937&quality=high)

4. Rebuild multi-values for the chosen Project in the Review Manager **Advanced Options -> Refresh Document Records** tab.

![243 - 04 - Refresh Document Records](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2004%20-%20Refresh%20Document%20Records.png?width=686&quality=high)

iv. Reindex document metadata for all Imports in Review Manager **Create -> Indexes**.

![243 - 04a - Begin Number-Image Set List](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2004a%20-%20Begin%20Number-Image%20Set%20List.png?width=620&quality=high)

v. Filter for each image set and populate a Work Folder with the Image Set Name.

![243 - 05 - Image Set List](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2005%20-%20Image%20Set%20List.png?width=519&quality=high)

vi. You’ll now have Work Folders populated for “All Records”, “Redacted Records” and one for each image set.

![243 - 06 - Migration Work Folders](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2006%20-%20Migration%20Work%20Folders.png?width=324&quality=high)

#### 2. **Production Jobs** - Create production jobs built upon the above Work Folder.

a. This process is outlined in Reveal knowledge base documentation online below.

[https://docs.revealdata.com/reveal/docs/create-a-production-job](/reveal/docs/create-a-production-job)

b. **Migration Productions**

i. **Create a Native Only Production Job, with all records to be migrated.**

**Documents** – Select the “All Records” Work Folder as the source.![243 - 07 - Add Production Job - Migration All Records](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2007%20-%20Add%20Production%20Job%20-%20Migration%20All%20Records.png?width=739&quality=high)

**Imaging** - Select ***None – Natives Only***.

![243 - 08 - Production Job - Natives Only](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2008%20-%20Production%20Job%20-%20Natives%20Only.png?width=738&quality=high)

**Numbering** - Select ***Use Existing Numbers*** and the ***Original*** Image Set. This will number the records with their Begin Number.

![243 - 09 - Production Job - Numbering](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2009%20-%20Production%20Job%20-%20Numbering.png?width=696&quality=high)

Select ***Save As New***.

ii. **Create an image Production comprised of the records with images in the Original Image set.**

**Documents** – Select the “***OriginalImageSet***” Work Folder as the source.

![243 - 10 - Add Production Job - Original Image Set](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2010%20-%20Add%20Production%20Job%20-%20Original%20Image%20Set.png?width=721&quality=high)

**Imaging** - Select **Existing** and the ***Original*** Image Set. Remove the check next to ***Always Image Redacted Docs***. We will export these in the next production.

![243 - 11 - Production Job - Imaging Settings](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2011%20-%20Production%20Job%20-%20Imaging%20Settings.png?width=935&quality=high)

**Numbering** - Select ***Use Existing Numbers*** and the **Original** Image Set. This will number the records with their Begin Number.

![243 - 12 - Production Job - Image Numbering](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2012%20-%20Production%20Job%20-%20Image%20Numbering.png?width=708&quality=high)

**Stamping** - No stamping will be needed.

iii. **Create an image Production comprised of the records with redactions.**

**Documents** – Select the ***Redacted Records*** Work Folder as the source.

![243 - 13 - Add Production Job - Redacted Records](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2013%20-%20Add%20Production%20Job%20-%20Redacted%20Records.png?width=758&quality=high)

**Imaging** - Select ***Existing*** and the Image Set that has the redactions. Typically, this will be the ***Original*** Image Set.

![243 - 14 - Production Job - Imaging Settings - Redacted set](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2014%20-%20Production%20Job%20-%20Imaging%20Settings%20-%20Redacted%20set.png?width=748&quality=high)

**Numbering** - Select ***Use Existing Numbers*** and the ***Original*** Image Set. This will number the records with their Begin Number.

![243 - 15 - Production Job - Redacted Set Numbering](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2015%20-%20Production%20Job%20-%20Redacted%20Set%20Numbering.png?width=733&quality=high)

**Stamping** - No stamping will be needed.

![243 - 16 - Migration Production Jobs](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2016%20-%20Migration%20Production%20Jobs.png?width=913&quality=high)

b. **Productions** – Previously produced records will get exported; *these production jobs will already exist*.

1. ***Skip to step 5)b)iii) below.***

2. You should now have two productions built as well as any prior productions. The below example shows one previous production “Prod001”.

![243 - 17 - Production Jobs List with Prior Job](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2017%20-%20Production%20Jobs%20List%20with%20Prior%20Job.png?width=931&quality=high)

3. **Preprocessing**

a. This process is outlined in Reveal knowledge base documentation online below:

[**https://docs.revealdata.com/knowledgebase/reveal/docs/run-production-job-preprocessing**](/reveal/docs/run-production-job-preprocessing)

b. Migration Productions

i) Native Only Production - All records to be migrated.

ii) Image Production - Records with redactions.

Click the drop down and select **Start Preprocessing – All Documents** for both the native and redaction production.

![243 - 18 - Start Production Job Preprocessing](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2018%20-%20Start%20Production%20Job%20Preprocessing.png?width=913&quality=high)

4. Create an image Production for any other image set that has images.

![243 - 19 - Work Folders for additional image productions](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2019%20-%20Work%20Folders%20for%20additional%20image%20productions.png?width=320&quality=high)

5. **Run Productions**

a. This process is outlined in Reveal knowledge base documentation online below:

[**https://docs.revealdata.com/knowledgebase/reveal/docs/run-a-production-job**](/reveal/docs/run-a-production-job)

b. Migration Productions

i. Native Only Production - All records to be migrated.

ii. Image Productions

(1) Original Image Set.

(2) Records with redactions.

(3) All other image sets.

Click the drop down and select **Start Full Processing – Imaging and Stamping**for all productions.

![243 - 20 - Start Full Production Processing](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2020%20-%20Start%20Full%20Production%20Processing.png?width=906&quality=high)

6. **Export Productions**

a. This process is outlined in Reveal knowledge base documentation online below: [https://docs.revealdata.com/knowledgebase/reveal/docs/run-a-production-job-export](/reveal/docs/run-production-job-export)

b. Migration Productions

i. **Native Only Production** - All records to be migrated.

**Productions** – Select the “**Migration_All_Records**” production.

![243 - 21 - Production Export Setup](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2021%20-%20Production%20Export%20Setup.png?width=751&quality=high)

**Files** – Use the below settings.

![243 - 22 - Production Export Files Settings](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2022%20-%20Production%20Export%20Files%20Settings.png?width=920&quality=high)

**Fields** – We recommend you export **ALL available fields** for preservation.

Create a Field Profile with all fields in it, then select this field profile and check all fields.

![243 - 23 - Production Export Fields](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2023%20-%20Production%20Export%20Fields.png?width=924&quality=high)

As mentioned in the migration export requirements above, the paths in the load files need to have a relative path starting with “.\”. To achieve this we need to add the “.\”to the Prefix as shown below.

![243 - 24 - Production Export Volume](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2024%20-%20Production%20Export%20Volume.png?width=623&quality=high)

Click add at the bottom right of the screen to complete the export settings.

Start the production export.

![243 - 25 - Start Production Export](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2025%20-%20Start%20Production%20Export.png?width=855&quality=high)

ii. Image Productions – **Below is an example for the Records with redactions. You will run through this process for all the image productions.**

**Productions** – Select the “**Migration_Redacted_Records**” production.

![243 - 26 - Production Export Setup - Redacted Records](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2026%20-%20Production%20Export%20Setup%20-%20Redacted%20Records.png?width=851&quality=high)

**Files** – Use the below settings.

![243 - 27 - Production Export Files Settings - Redacted set](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2027%20-%20Production%20Export%20Files%20Settings%20-%20Redacted%20set.png?width=924&quality=high)

**Fields** – Metadata was already exported in the native export, so you should just export the default fields.

![243 - 28 - Production Export Fields - Redacted Set](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2028%20-%20Production%20Export%20Fields%20-%20Redacted%20Set.png?width=930&quality=high)

Select **Add** on the bottom right and run the production.

iii. Previous Productions – For every previously produced production go through the steps below.

Select the previous production “Prod001”.

![243 - 29 - Previous Production Export](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2029%20-%20Previous%20Production%20Export.png?width=769&quality=high)

Use the below settings.

![243 - 30 - Previous Production Export Files Settings](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2030%20-%20Previous%20Production%20Export%20Files%20Settings.png?width=922&quality=high)

Select the fields you would like. The minimum is shown below.

> [!NOTE]
> Note
> 
> Begin Number is important as this will be the cross reference between the produced and original records.

![243 - 31 - Previous Production Export Fields Settings](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2031%20-%20Previous%20Production%20Export%20Fields%20Settings.png?width=932&quality=high)

Select **Add** on the bottom right and run the production.

7. **Download each export**

![243 - 32 - Production Export Download select](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2032%20-%20Production%20Export%20Download%20select.png?width=934&quality=high)

![243 - 33 - Production Export Files](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2033%20-%20Production%20Export%20Files.png?width=933&quality=high)

You will now have zips for each of the downloads above. Extract the combined load files from their zip containers.

![243 - 34 - Production Load Files](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2034%20-%20Production%20Load%20Files.png?width=244&quality=high)

The paths in the load files will start with “\Vol” but the folder paths in the zips to the Natives, Text and Images will start with the name of the production. Example below:

**Migration_Redacted_Records\Vol01\**

The folder paths in the load files to the Natives, Text and Images must be updated to start with the production name. Example Below:

![243 - 35 - Production Load File Update Example](https://5796933.fs1.hubspotusercontent-na1.net/hub/5796933/hubfs/DOCUMENTATION/ARTICLE%20SCREENSHOTS/243%20-%2035%20-%20Production%20Load%20File%20Update%20Example.png?width=937&quality=high)

## Related

- [Review Tracking](/review-tracking.md)
- [Find Stories Using Entities](/find-stories-using-entities.md)
- [Migration Import - Reveal](/migration-import-reveal.md)
- [Export Documents from the Review Grid](/export-documents.md)
- [Migration Import - Logikcull](/migration-import-logikcull.md)