Importing Reviewer table records

Available with Data Reviewer license.

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.

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 Previous version of Reviewer table option in the Data Format area.

      Note:

      Supported previous versions are 9.3 to 10. There are no schema differences between the 10.1 and 10.3 versions of the Reviewer workspace. Use the Current version of the Reviewer table option to import 10.1 or 10.3 records.

   2. Click Browse.

      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 Current version of Reviewer table option in the Data Format area.

      Note:

      There are no schema differences between the 10.1 and 10.3 versions of the Reviewer workspace. Use the Current version of the Reviewer table option to import 10.1 or 10.3 records.

   2. Click Browse.

      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.