How do I know what type of data field or what values to enter when using Modelbuilder to populate my model data?

  Applies To 
Bentley WaterGEMS, Bentley SewerGEMS, Bentley CivilStorm, Bentley StormCAD, Bentley PondPack, Bentley SewerCAD, Bentley HAMMER, Bentley WaterCAD
  Version(s): 08.11.XX.XX
  Environment:  N/A
  Original Author: Mark Pachlhofer, Bentley Technical Support Group


How do I know what type of data field or what values to enter when using Modelbuilder to populate my model data? 


1) Open the software that you're using and layout some elements that you have questions about the properties for. The example below uses SewerGEMS as the program and manholes as the element of interest.  

2) Create an Excel spreadsheet and title one column 'Label' this will let you identify the elements that you're importing

3) Any other columns that you add should contain the name of the property as it's listed in the software that you're interested in learning more about the data type. For example, you might another column header for 'Structure Type' if you want to see the type of input Modelbuilder needs in order to define a manhole as circular structure, box structure, or transition structure. Save the Excel spreadsheet and close it after you've finished. 

4) Now open the SewerGEMS and layout 3 manhole structures in a blank model. Set the 'Structure Type' differently for each one (1 circular, 1 box, and 1 transition).

5) Open Modelbuilder (Tools > Modelbuilder) and create a new run. Select the correct Excel datasource type and then browse out to locate your file. Skip to the field mapping step of Modelbuilder, step 5,  as shown below. Map the fields in the green square to their names in the red square.  The data in the red square are the columns that are being read from your Excel sheet and the data in the green square are the properties in SewerGEMS that you're going to be matching to these columns to populate the sheet after you sync the data out. After you're done with this click the "Next" button on the bottom right to proceed.

6)  In the last step of Modelbuilder choose "No" for the question that asks, "Would you like to build a model now?" and then click the "Finish" button. 

7) On the main window for Modelbuilder make sure you have the row you're exporting highlighted in blue by single clicking on it and the click the "Sync Out" icon, which is highlighted by a red box in the screen shot below.

8) Finally open your Excel spreadsheet and you can see the data type the field needs to be, as well as, how to enter the values you want to import. 

See Also

Building a model using Modelbuilder

  • Created by
  • When: Fri, Aug 14 2015 12:09 PM
  • Last revision by
  • When: Fri, Aug 14 2015 12:10 PM
  • Revisions: 2
  • Comments: 0