You are currently reviewing an older revision of this page.
How do import multiple point pump curves into a model using modelbuilder?
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