Importing Reviewer table records (Defense Mapping)

Records in the Reviewer table can be imported from Reviewer 9.3 and later tables and the current Reviewer table. The import process copies the records from the existing workspace to the designated workspace.

When records are imported from one Reviewer 9.3 or later table to another, all the records from the table are included. To filter the records that are imported or exported, you can define a Structured Query Language (SQL) query. For example, if you only wanted to import records from session 2, you could define a query of 'SESSIONID=2'.

Note:

When records are exported using an SQL query, information from the RevBatchRunTable table is not included because that table contains a summary of which batch jobs have been run and when.

Steps:

1. Start ArcMap.
2. On the main menu, click Customize > Toolbars > Data Reviewer.
3. Start a Reviewer session in one of the following:
   • A file, personal, or SQL Server Express geodatabase
   • An enterprise geodatabase
   • An existing Reviewer workspace
4. On the Data Reviewer toolbar, click Data Reviewer > Table Importer/Exporter.

   The Reviewer Table Importer / Exporter dialog box appears.
5. Choose the Import option.

   If you are importing tables from the current version , proceed to step 7.

6. If you want to import the table records from a table created in the previous version, do the following:
   1. Choose the Reviewer 9.3 or 10 Table option in the Data Format area.
   2. Click Browse for 9.3 or 10 workspace.

      The Browse for Workspace dialog box appears.

   3. Navigate to the Reviewer workspace that contains the records you want to import.
   4. Click Add.

      The Reviewer Table Importer / Exporter dialog box appears.

   5. Click Import.

      A dialog box displays the total number of records that have been imported.

   6. Click OK.

      The table records are added to the current Reviewer table.

7. If you want to import the table records from a table created in the current version, do the following:
   1. Choose the Reviewer 10.1 Table option in the Data Format area.
   2. Click Browse for 10.1 Workspace.

      The Browse for Workspace dialog box appears.

   3. Navigate to the Reviewer workspace that contains the records you want to import.
   4. Click Add.

      The Reviewer Table Importer / Exporter dialog box appears.

   5. If necessary, click SQL Builder to create a query that filters the records imported into the current table.
   6. Click Import.

      A dialog box displays the total number of records that were imported.

   7. Click OK.

      The table records are added to the current Reviewer table.

8. Click Cancel to close the Reviewer Table Importer / Exporter dialog box.