In this step, data source tables are mapped to the desired modeling element types, and data source fields are mapped to the desired model input attributes. You will assign mappings for each Table/Feature Class that appears in the list; Step 1 of the wizard can be used to exclude tables, if you wish.
• Tables (list)—This pane, located along the left side of the dialog box, lists the data source Tables/Feature Classes to be used in the ModelBuilder process. Select an item in the list to specify the settings for that item.
Tip: The list can be resized using the split bar.
There are two toolbar buttons located directly above Tables list (these buttons can be a great time saver when setting up multiple mappings with similar settings). – Copy Mappings (button)—This button copies the mappings (associated with
the currently selected table) to the clipboard.
– Paste Mappings (button)—This button applies the copied mappings to the currently selected table.
• Settings Tab—The Settings tab allows you to specify mappings for the selected item in the Tables list.
The top section of the Settings tab allows you to specify the common data mappings:
– Table Type (drop-down list)—This field allows you to specify the target modeling element type that the source table/feature class represents. For example, a source table that contains pipe data should be associated with the Pressure Pipe element type.
There are three categories of Table Types: Element Types, Components, and Collections. For geometric data sources, only Element Types are available. However with tabular data sources all table types can be used. The catego- rized menu accessed by the [>] button assists in quicker selection of the desired table type.
- Element Types—This category of Table Type includes elements symbol- ically represented in the drawing view such as pipes, junctions, tanks, etc. - Components—This category of Table Type includes the supporting data items in your model that are potentially shared among elements such as patterns, pump definitions, and controls.
- Collections—This category of Table Type includes table types that are typically lists of 2-columned data. For instance, if one table in your connection consists of a list of (Time From Start, Multiplier) pairs, use a Pattern collection table type selection.
Note: Each table in your data source can be assigned to a single element type. For this reason, individual tables in your data source should contain only data that will be assigned to items of the same type. For instance, the source data table that will be designated as the Pressure Junction element type should contain only data that will be applied to Pressure Junctions, not data relating to pressure valves, tanks, etc.
– Key/Label Field (drop-down list)—This required field allows you to asso- ciate a row in this table to a particular element in the model. The model refer- ences each element using a unique alphanumeric label. Your data source must have a field that can be used to uniquely identify all elements in the model.
Note: If you do not have a field that can be used to uniquely identify each element, you may use the <label> field (which is
automatically generated by ModelBuilder for this purpose).
These optional fields are available for Pipe element types:
– Start/Stop—Select the fields in your pipe table that contain the Label of the start and stop nodes. For more information, see “Specifying Network Connec- tivity in ModelBuilder” on page 5-149. This field only applies to polyline table types.
These fields are available for Node element types:
– X/Y Field—These fields are used to specify the node X and Y coordinate data. This field only applies to point table types.
Note: The Coordinate Unit setting in Step 2 of the wizard allows you to specify the units associated with these fields.
These optional fields are available for Pump element types:
– Downstream Edge (drop-down list)—For tables that define pump or valve data, select a pipe label or other unique identifier to set the direction of the pump or valve.
The bottom section of the Settings tab allows you to specify additional data mappings.
– Field—Field refers to a field in the selected data source. The Field list displays the associations between fields in the database to attributes in the model.
– Attribute (drop-down list)—Attribute refers to a Bentley SewerCAD V8i attribute. Use the Attribute drop-down list to map the highlighted field to the desired attribute.
To map a field in your table to a particular SewerCAD V8i attribute: 1. In the Field list, select the item you would like to update.
2. In the Attribute drop-down list, select the desired SewerCAD V8i attribute. You can also click the flyout button to access a submenu that categorizes attributes by type.
3. If the attribute is unitized, specify the unit of this field in your data source in the Unit drop-down list.
To remove the mapping for a particular field: 1. Select the field you would like to update. 2. In the Attribute drop-down list, select <none>.
– Preview Tab—The Preview tab displays a tabular preview of the currently highlighted source data table when the Show Preview check box is checked.