This Technote describes the process of updating pump definitions from an Excel spreadsheet into a model using ModelBuilder.
Note: if you need to transfer pump definitions from one model to another, you could make use of the Pump Definition Engineering Library (purple book icon in the Pump Definitions Manager).
The first thing you would need to do, if this isn't already done, is create a spreadsheet. This workbook contains two spreadsheets. The first has the pump definition name, the design flow, design head, and a column for the pump definition type (Label), such as Multiple Point, Design Point (1 Point), Design Point (3 Point), Custom Extended, Standard Extended, etc.... The second sheet contains the pump definition label, the flow, and head data for a multiple point pump curve.
1. Go to Tools > ModelBuilder.
2. Select a Data Source type: (This would be the Excel spreadsheet that you have created.) Make sure the sheet(s) is checked on the left of the dialogue box. Click on Next.
3. The next screen will have the spatial and connectivity options. Specify whether the coordinate unit in your data source is in feet or meters. Uncheck the box next to "Create nodes if none found at pipe endpoint". Click on Next.
4. Select the check boxes as shown below then click the Next button.
5. Select the scenario you want to update and specify "Label" for the key field. Click Next.
6. For the Table Type select Pump Definition. For the key field select Pump Definition. On the bottom part map "Pump Definition" to "Label", as shown, "Flow" to "Design Flow", "Head" to "Design Head", and "Pump Definition Type Label" to "Pump Definition Type (Label)".
7. On the "Flow-Head Curves" spreadsheet set the table type to "Pump Definition, Pump Curve" and set the "Flow" field to "Flow" and the "Head" field to "Head" as shown in the screen shot above. Set the key field to "Pump Definition" Click the 'Next' button.
8. On the screen asking you if you'd like to build a model now, select "Yes" and click on "Finish".
The pump definitions can be checked by going to Components > Pump Definitions. These are before the update.
The design flow and design head have been updated.
Product TechNotes and FAQs
OpenFlows Product Tech Notes And FAQs
General WaterGEMS V8 FAQ
Hydraulics and Hydrology Forum
Bentley LEARN Server