| Applies To | |||
| Product(s): | WaterGEMS, WaterCAD, HAMMER | ||
| Version(s): | 08.11.03.77 and higher |
Problem
How do I import Multi-point pump curves into a model using ModelBuilder?
Solution
The general process is outlined in the following article: Updating Pump Definitions using ModelBuilder
The above article is about updating existing pump definitions, but importing new pump definitions is similar. If a matching pump definition label is not found when performing the sync-in with ModelBuilder, a new pump definition will be created (as long as the option "Add objects to destination if present in source" is set).
The following article contains an example and more details, specifically for multi-point pump curves. If you're importing other types of pump curves like 3-point or 1-point, only one worksheet is needed (with the Table Type set to "Pump Definition), and the required fields are mapped in that table type. See the above article for details.
Example of Importing Multi-point pump curves
1) You will need to create a spread sheet like the example below:
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 should be the label of the pump definition.
6) On the field mapping step you are going to map the sheet that called "Creating the Pump Definition" to the table type titled "Pump Definition". In the 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 or WaterGEMS. You will want to map this 'pump definition importing' column to the WaterCAD/WaterGEMS property 'Label' and map the "Type (Label)" column to the property of Pump Definition Type (Label).
7) On the field mapping step, select the sheet called "Importing Multipoint Curves" and set the Table Type to "Pump Definition, Pump Curve". In the 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 and Head fields.
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 spreadsheet 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 spreadsheet 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 (Tools > 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 the pump definition label. Click the next button.
7) On the field mapping step you are going to map the sheet called "Creating the Pump Definition" to the table type titled "Pump Definition". In the example, the "pump definition importing" column is the key field. This column name is the label name of your pump definitions in WaterCAD/WaterGEMs. You will want to map this 'pump definition importing' column to the WaterCAD/WaterGEMS 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 called "Importing Multipoint Curves", set the Table Type to "Pump Definition, Pump Curve". In the 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 the sheet to the Flow property in WaterCAD/WaterGEMS and map the Head column to the Head property in WaterCAD/WaterGEMS. 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.