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}, {all_classes})

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

The location to create a unique folder based on the value of the Output Folder Name parameter that will contain the DataMapping.xlsx.

 		DEFolder
output_name Dialog Reference

The name of the folder created in the location specified in the Output Location Parameter. If a folder already exist with provided name, a numerator will be appended to the end of the name.

 		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. The first type found in the class is used, so the order does affect the output. 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
all_classes (Optional) Dialog Reference

If true, all target table and featureclasses are added to the workbook dropdowns, if false, only Utility Network classes are added.

 		GPBoolean

Code Samples