CreateSimpleDataMapping

Title  Create Simple Data Mapping

Description

This tool creates a spreadsheet you can use to map your current geodatabase schema to the schema of an asset package for a utility network.

Usage

          
Once you've used this tool to create a data mapping spreadsheet you will then manually populate it with the mappings from your current (source) data model to the new (utility network) model.
Once you've populated the spreadsheet you will run the 'Create Migration Workspace' tool to create a data loading workspace and data model suitable for performing the data conversion.

In the DataMapping workbook, the Exclude Copy Field sheet allows you to bypass adding fields to a target class when the copy field option is checked.  List the target class name(not qualified) and the name of the field that you do not want copied from the source.


License
Standard
Toolset
Data Migration

Syntax

CreateSimpleDataMapping (source_dataset, asset_package, output_folder, output_name, {count_features}, {source_type_table}, {existing_mapping})

Parameter Explanation Data Type
source_dataset Dialog Reference

The source feature dataset or workspace you want to migrate

 		GPComposite
asset_package Dialog Reference

The asset package you want to use as your base data model

 		DEWorkspace
output_folder Dialog Reference

Folder to contain the simple data mappings

 		DEFolder
output_name Dialog Reference

Name of the simple data mappings spreadsheet

 		GPString
count_features (Optional) Dialog Reference

Whether to calculate feature counts for each mapping

 		GPBoolean
source_type_table (Optional) Dialog Reference

List of field names to use to determine types in the source data. A row is created in the workbook for each type in this column. This is similar subtypes in the source data. Common values are:

  • bedmaterial
  • devicetype
  • dischrtyp
  • fittingtype
  • hydrflag
  • inlettype
  • largemeter
  • linetype
  • pumptype
  • servicetype
  • structtype
  • transmiss
  • valvetype
  • weirtype

 		GPRecordSet
existing_mapping (Optional) Dialog Reference

An existing Data Mapping workbook to copy the definitions from.

 		DEFile

Code Samples