Loading data into a geodatabase (Production Mapping)

With Esri Production Mapping, you can load data into a geodatabase using a template that corresponds to the data model or product specification you are using. This template, named a cross-reference database, contains mapping information between the data being loaded (the source workspace) and the database into which the data is being loaded (the target workspace). The cross-reference database contains information that controls mapping information between the source and target workspaces. This includes which source features should be loaded into a target dataset with WHERE clauses and, if applicable, the appropriate subtype. In addition to that, it also contains tables that define field mapping and value substitution.

Learn more about the cross-reference database

Using the Data Loader tool, you can load data from one geodatabase, coverages, or set of shapefiles into another geodatabase that may or may not have the same schema. This can append data to existing databases or load it into an empty schema. The target workspace must contain the schema referenced in the cross-reference database, at a minimum.

The loading process is completed in a series of steps that are presented in a wizard. The first part of the process requires you to navigate to the cross-reference database, the source workspace, the target workspace, and an output location for the log file created. This sets up the mapping information between the data that is going to be loaded and the database into which the data is going to be loaded. The log file is generated as a text file that contains the results of the loading process for each subtype.

The next part of the process is to choose the feature classes that are going to be loaded into the target database. You can choose to load either all or only some of the features from the source workspace. You can choose to perform all the dataset mappings located in the cross-reference database or only a subset. The list in the Data Loader wizard is dependent on the DatasetMapping table in the cross-reference database, not the actual feature classes contained in the source or target.

The last part is actually loading the data. After the data is loaded, a log file of the results is also generated that allows you to see the number of features that have been loaded.

Before using the Data Loader, it is recommended that you do the following:

• Verify that the datasets listed in the DatasetMapping table match the feature classes in the source and target workspace.
• Verify that the fields listed in the FieldMapping table match the fields in the source and target workspaces.
• Validate the source and target workspaces against the cross-reference database using the Preload Validate tool.

Steps:

1. Start ArcCatalog.
2. On the main menu, click Customize > Toolbars > Production Mapping.
3. Click the Data Loader button on the Production Mapping toolbar.

   The Data Loader dialog box appears.

4. Click the ellipsis (…) next to the Select cross-reference database field.

   The Select cross-reference database dialog box appears.

5. Optionally, if you have one of the Esri Mapping and Charting solutions installed, navigate to the appropriate cross-reference database. Depending on your platform, choose one of the following:

   For 32-bit Windows operating systems	<Installation location>\Program Files\ArcGIS\Esri<SolutionName>\Desktop10.1\<ProductName>\DataConversion
   For 64-bit Windows operating systems	<Installation location>\Program Files(x86)\ArcGIS\Esri<SolutionName>\Desktop10.1\<ProductName>\DataConversion

6. Click Open.
   Tip:

   A message appears asking if you want to upgrade if the database is out of date. Click Yes.

   The path to the cross-reference database appears in the Select cross-reference database field.

7. Click the ellipsis (…) next to the Select source workspace field.

   The Select source workspace dialog box appears.

8. Navigate to the geodatabase or shapefile workspace that contains the data you want to load.
9. Click Open.

   The path to the source workspace appears in the Select source workspace field.

10. Click the ellipsis (…) next to the Select target geodatabase field.

    The Select target workspace dialog box appears.

11. Navigate to the database into which you want to load the data.
12. Click Open.

    The path to the target workspace appears in the Select target geodatabase field.

13. Click the ellipsis (…) next to the Select log file field.

    The Specify log file dialog box appears.

14. Navigate to the directory in which you want to store the log file.
15. Type a name for the file in the Name text box and click Save.

    The path to the log file appears in the Select log file field.

16. Optionally check the Log row level errors check box to include individual features and table rows that have failed to load in the log file.

    This check box is checked by default. When the Log row level errors check box is unchecked, the log file still shows the source and target tables that are loaded and the number of records.

17. Click Next.

    The Data Loader dialog box appears with the names of the source and target feature classes and the where clauses for each subtype.

    Note:

    To sort the feature classes by name, click the Source Dataset or Target Dataset column headers. This displays them in descending or ascending order based on their names.

18. Check the check boxes next to the feature classes you want to load into the target workspace.

    You can also click Select All or Clear All to check or uncheck all the check boxes next to the feature class names.

19. Click Next.

    The Data Loader dialog box appears with a summary that shows the cross-reference database, source workspace, target workspace, and log file paths.

20. Click Finish.

    The Data Loader window appears with a progress bar that displays the features and subtypes as they are loaded.

    When the loading process is finished, a message appears to notify you that loading is complete.

21. Click Yes to view the log file or No to close the message and the Data Loader progress window.