How do I import/export multiple point pump curve pump definitions into a model using ModelBuilder?

 

  Applies To 
  Product(s): SewerGEMS, WaterGEMS, SewerCAD, WaterCAD, CivilStorm
  Version(s): 08.11.03.77+, 10.XX.XX.XX
  Area:  Output and Reporting
  Original Author: Mark Pachlhofer, Bentley Technical Support Group

 

 

 How do I import multiple point pump curves into a model using modelbuilder?

Background

1) You will need to create a spread sheet like the one I have attached.

Pump Definition File


2) One sheet will be set up for importing the pump definition label name and the pump definition type. ( For this example this sheet is named "Creating the Pump definition")

The second sheet will be for importing the actual multiple point curve data for flow vs. head. (For this example this sheet is named "Importing Multipoint Curves") **Please Note** that the cells which contain the values for head and flow need to be formatted as text cells, otherwise the import from modelbuilder will not work.


3) After you get your excel sheets set up you can open modelbuilder and create a new modelbuilder run

4) You will want to select the check boxes on step 3 of the modelbuilder wizard to "Add objects to destination if present in source" and "Update existing objects in destination if present in source".

5) On step 4 you will want to specify your key field, which is likely just going to be "Label".

6) On the field mapping step you are going to map the sheet that I called "Creating the Pump Definition" to the table type titled "Pump Definition". In my example, the" pump definition importing" column is the key field. This is the label that you are going to call your pump definition in WaterCAD/GEMs. You will want to map this 'pump definition importing' column to the WaterCAD/GEMS property 'Label' and map the "Type (Label)" column to the property of Pump Definition Type (Label).

7) On the field mapping step for the sheet that I called "Importing Multipoint Curves" to the table type titled "Pump Defintion, Pump Curve". In my example, the" pump
definition label" column is the key field and contains the label names for the pump definitions you are having modelbuilder create in step 6. In the column mapping you will only map the Flow column on my sheet to the Flow property in WaterCAD/GEMs and map the Head column to the head property in WaterCAD/GEMS.

8) Click the "Next" button and the proceed to build your model. This should create all your pump definitions as Multiple Point with the values for flow vs. head for each definition.

Exporting pump definitions to an Excel spreadsheet

1) Download the spread sheet attached to step 1 of importing process above. Have a look at it and you'll get an idea of what you're going to see when you export your pump definitions. The first sheet in the workbook will contain the pump definition label and the type of definition it is, while the second will contain the pump definition label and the actual values in the curve.

2) In the spread sheet delete all the information except for the column headers, which are located in first rows of both sheets. Now save the file and close it.

3) Open Modelbuilder (Tolls > Modelbuilder) and create a new run by clicking the second icon on top of the window that looks like a sheet of paper.

4) In step one set the data source type to "Excel 2003/XP/2000/97 (8.0)" and then click the "Browse" button to go and select the sheet you saved from step 2. Click the Next button at the lower right side twice to proceed to step 3.

5) You will want to select the check boxes on step 3 of the modelbuilder wizard to "Add objects to destination if present in source" and "Update existing objects in destination if present in source" if they are not already checked. Then click the Next button.

6) On step 4 you will want to specify your key field, which is likely just going to be "Label". Click the next button.

7)  On the field mapping step you are going to map the sheet that I called "Creating the Pump Definition" to the table type titled "Pump Definition". In my example, the "pump definition importing" column is the key field. This column name is the label name of your pump definitions in WaterCAD/GEMs. You will want to map this 'pump definition importing' column to the WaterCAD/GEMS property 'Label' and map the "Type (Label)" column to the property of Pump Definition Type (Label). See the screen shot below.

7) On the field mapping step for the sheet that I called "Importing Multipoint Curves" to the table type titled "Pump Defintion, Pump Curve". In my example, the" pump definition Label" column is the key field and contains the label names for the pump definitions you are having modelbuilder create in step 6. In the column mapping you will only map the Flow column on my sheet to the Flow property in WaterCAD/GEMs and map the Head column to the Head property in WaterCAD/GEMS. Make sure to select the correct units. See the screen shot below.

8) Click the "Next" button and on the last step when asked, "Would you like to build a model now?" choose 'No' and hit the "Finish" button.  

9) With the Modelbuilder run highlighted in blue click the  "Sync Out" button to export your definitions to your spreadsheet.

 

Recommended
Related