Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenFlows | Water Infrastructure
  • Product Communities
  • More
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Wiki How do I import/export multiple point pump curve pump definitions into a model using ModelBuilder?
    • Sign in
    • OpenFlows | Water infrastructure Wiki
    • +OpenFlows CivilStorm
    • +OpenFlows CulvertMaster
    • +OpenFlows FLOOD
    • +OpenFlows FlowMaster
    • +OpenFlows HAMMER
    • +OpenFlows PondPack
    • +OpenFlows SewerCAD
    • +OpenFlows SewerGEMS
    • +OpenFlows StormCAD
    • +OpenFlows WaterCAD
    • +OpenFlows WaterGEMS
    • +OpenFlows WaterSight
    • +OpenFlows WaterOPS
    • +OpenFlows SewerOPS
    • +Bentley HEC-PACK
    • +General
    • +Help and Documentation
    • +Installation
    • +Licensing / Activation
    • +Integration
    • +Modeling
    • +Layout and Data Input
    • +Calculations
    • +Output and Reporting
    • +Other
    • +OpenFlows Product TechNotes And FAQs
    • Check boxes do not appear in tables such as Control Sets dialog
    • Consuming ContextCapture production files within your hydraulic model
    • Convergence NOT achieved Message when computing StormCAD or SewerCAD model
    • Converting Junctions or Hydrants to Isolation Valves
    • Displaying Shapefile Labels (Text) As a Background
    • Enhancing OpenFlows multi-user workflows with ProjectWise Share
    • Error "System.TypeInitializationException"
    • Error 32768 when opening model while integrated with ProjectWise
    • Errors installing patch set
    • Error when opening PondPack: "Object reference not set to an instance of an object" or "Application has generated an exception that could not be handled."
    • Error when saving or validating: System.AccessViolationException: Attempted to read or write protected memory.
    • File Open Dialog does not appear
    • Flextable Report of Multiple Element Types
    • Get to know OpenFlows CONNECT Edition
    • Get to know WaterGEMS, WaterCAD and HAMMER CONNECT Edition
    • How do I import/export multiple point pump curve pump definitions into a model using ModelBuilder?
    • How do you save backup files, so they save at different times and multiple levels?
    • How does the intermediate geodatabase (.MDB or .GDB) file function with ArcMap and ArcGIS Pro integration?
    • How to Delete Engineering Libraries if you get a message about a Read-only database
    • How to receive alerts on new version availability?
    • How to register DAO360.dll or a dll file?
    • How to search using wild cards on a sqlite type of database
    • How to See Hebrew or Arabic text in a .DXF file that was exported from WaterGEMS/WaterCAD
    • Hydraulic grade discontinuity at steep pipes or across nodes (frontwater analysis)
    • I get a red user notification that says, "Inlet guttter mannings n should be greater than 0".
    • Importing .HLB library files from old product versions into format used in the V8 product versions
    • Importing External Data in Geographic Coordinate Systems
    • Importing storm data and other library information from older versions
    • Changing element symbols in the AutoCAD platform
    • Interchange
    • Locating OpenFlows product error log file
    • Locating OpenFlows Product Version Number and License Information
    • Model backward / forward compatibility
    • Multi-user Workflows
    • Modeling a closed loop system
    • Modeling a flow split (diversion) with the SewerCAD or StormCAD numerical solver
    • Modeling turbine load acceptance plus load rejection
    • Multiple CN numbers for a catchment and multiple catchments with a single outlet node
    • Network Navigator Trace Upstream/Downstream does not return any elements
    • OpenFlows software numerical solver theory
    • Percent Connected Impervious Areas and Percent Unconnected Impervious Areas
    • Performing a hydrosanitary design in WaterGEMS or WaterCAD
    • PondPack user notification: "The composite outlet structure is either not selected or deleted."
    • PondPack: How to perform a critical duration analysis?
    • Pressure pipe vs. conduit between pump and wetwell
    • Print Preview > Fit to Page shows blank page
    • Properties not working when using MicroStation integration with ProjectWise
    • Properties, Flextables, user notifications, or other dialog is missing or will not open in standalone
    • Properties, user notifications, or other tool managers not showing up in Integrated version of AutoCAD
    • Reusing Pump Definitions (Import / Export)
    • Reversing orientation of Pipes and Conduits in Bulk
    • Saving a hydraulic model when using the AutoCAD platform (i.e. integrated)
    • Important License Update for OpenFlows Users
    • Setting the invert elevation for multiple conduits coming into one manhole
    • Simple Controls vs. Logical Controls
    • Sorting and relabeling a flextable based on upstream-downstream order
    • Source of the default Specific Speed for pumps and turbines
    • Step by step procedure for finding the curb length needed to capture 100% of gutter flow in a curb inlet with a continuously depressed gutter with no clogging
    • System.Reflection.TargetInvocationException crash when trying to open the application
    • Test Wiki Page - A1
    • Text, cells/blocks and line styles do not display correctly in a DXF background layer
    • The flow annotation (label) in my WaterGEMS for ArcMap isn't reflecting the value displayed in my Geotable or Flextable
    • The total area in the CN/Area Collection does not equal the total catchment area
    • Time tolerance setting in SCADAConnect Simulator
    • Troubleshooting ArcMap / ArcGIS Integration
    • Turbine Efficiency
    • Understanding Flow (Additional Subsurface) and Flow (Additional Carryover)
    • Upcoming training and release dates for OpenFlows products
    • User notification "Downstream TW out of range..."
    • User notification "Pump exceeds the maximum operating point specified for the pump curve"
    • User Notification - The captured surface flow at this node does not connect a valid subsurface network. The flow is lost from the system.
    • User Notification: "There is an error in the data for this pipe. The associated data is incorrect"
    • User Notification: Cross section maximum elevation is above the maximum headwater elevation
    • User Notifications: "Pump On elevation is not in the range of upstream ...." and "Off elevation of pump is lower than ..."
    • Using batch pipe split to fix nodes that overlay a pipe instead of connecting to it
    • Using PondMaker with different tailwater for each return event
    • Valve "Status (Initial)" Definitions
    • Velocity Calculations and the Average Velocity Methods in SewerCAD and StormCAD
    • Viewing graph data for multiple scenarios
    • Water age results in a pipe are different from the age in the downstream junction
    • Water Loss Management
    • Water quality Analysis during transient events
    • WaterGems Tips
    • What are the limitations of importing/exporting EPANET files?
    • What is the dotted line that is associated with the isolation valves? Can I turn them off?
    • What's new in WaterCAD, WaterGEMS and HAMMER V8i SELECTseries 6 with CONNECT Integration?
    • What's New in WaterOPS CONNECT Edition 2.3 (Build 10.02.03.06)
    • When the user changes the fluid, why doesn't the calculated pump head change?
    • Working From Home With Your OpenFlows Software
    • "An error occurred when trying to calibrate the model"
    • "COM Error Not Documented" when opening OpenFlows product
    • "Default license feature configuration not found. Product features may be limited. Please run the License Administrator."
    • "The Depth-Flow, Depth-Flow (Simulated Variable Speed) and Volume-Flow pump definition types are unsupported"
    • "Unable to assign attribute ... for element because enumeration value ... is not valid."
    • Add custom data to profile with User Data Extensions
    • After computing a model with the SWMM solver, what does the following warning mean: "Maximum depth increased for node CB-XX"?
    • After computing the model, the pump efficiency results are listed as N/A
    • After running loadbuilder I get a message that says "The layer <Layer_Name> could not be opened."
    • At what point does OpenFlows product license usage start when integrated with MicroStation?
    • Background image quality poor on some computers or Crash when opening models with background layers
    • Blocky stepwise pattern is displayed instead of a continous smooth pattern that was entered when using the SWMM engine
    • Can User Data Extensions be shared between elements in a model?
    • Catch basins imported as manholes from LandXML
    • Change in results before turbine load rejection occurs
    • Custom quadrant curve not being recognized
    • Date-time based query not working
    • Default license configuration not retaining setting
    • Do inactive elements count against the license count?
    • Does HAMMER support initially negative pressures?
    • Does the friction method affect local minor loss in pipes?
    • Does WaterGEMS and WaterCAD report pressures as gauge pressure or absolute pressure?
    • Efficiency Curve vs. Wire-to-Water Efficiency Curve
    • Error message when validating model: "Elevation (Relative) values within the Irregular shape definition must be non-negative."
    • Error message: "Unrecognized database format ..." when trying to open model
    • Error Saving: "Custom results path is invalid"
    • Find if pump operates off of the pump curve during an automated fire flow scenario
    • Flow arrows are not included in an exported DGN file when using the Save Symbology option in the MicroStation platform
    • Flow from pump is delayed after pump startup
    • GeoPak - StormCAD errors - GEOPAK runtime environment not found / Error writing GEOPAK/PowerCivil node
    • HEC-22 2nd edition energy loss calculations with the Implicit solver
    • How are "pipe sets" and "nodes of interest" used in a flushing analysis to get auxiliary results at other elements?
    • How can I see the amount of inflow or outflow occuring for a particular surge tank during the transient simulation in HAMMER?
    • How do I filter a column in my flextable using a custom query that retrieves all records with a <None> attribute?
    • How do I know if and when my pond is overtopping and how to quantify it?
    • How do I save my model files when working in the ArcMap or ArcGIS Pro platform?
    • How do the channel slopes and velocity effect the headloss formulas in SewerCAD and StormCAD?
    • How does StormCAD handle gutter flow from an active catch basin to an inactive catch basin?
    • How does the diameter of an isolation valve effect the calculated results?
    • How to add comments on custom pump and turbine quadrant curves
    • How to find volume of water coming from a trace element?
    • Hydropneumatic tank atmospheric pressure not changing results
    • Hydropneumatic tank profile animation and time history shows zero gas volume
    • Initial surge when using turbine load acceptance operating case
    • Initial turbine HGL the same as the final HGL after load acceptance
    • Irregular Weir Flow Calculations in a Composite Outlet Structure
    • Is it possible to create old PondPack style text reports?
    • Is it possible to have a storm event start at a different time than the model simulation?
    • Is it possible to use point cloud information to populate elevations in Terrain Extractor (TRex)?
    • Is there a recommended level of Skelebration for different modeling conditions?
    • Junctions are created on top of one another after using ModelBuilder with the GIS-ID property
    • License usage in the ArcMap and ArcGIS Pro platform
    • LoadBuilder applying demands or loads to inactive elements
    • LoadBuilder importing zero flow loads
    • Long time to load background layers
    • Manage Pump Speed Series
    • Manage Pump Time Series
    • Managing large number of scenarios
    • Missing Young's Modulus and Poisson's Ratio values in the material library
    • Modeling Arch section shapes in SewerGEMS
    • Modeling closed or pressurized pipes in PondPack
    • Modeling treatment for pollutants at nodes or ponds in SewerGEMS and CivilStorm
    • MrSid files are not available as a background layer type or an error is generated when loading MrSid files
    • New User Learning Resource Guide for WaterSight
    • Pipe Renewal Planner Vs OpenFlows WaterCAP
    • Pipes connecting to the wrong element after submodel import
    • Pipes not merging when using Skelebrator with series pipe merging
    • PondPack error: Unable to open user roster
    • Problems opening GEOPAK Drainage file exported from StormCAD
    • Query, alert or formula UDX not working correctly with "=" (equals)
    • SCADAConnect in SewerGEMS
    • SCADAConnect Simulator in WaterCAD and WaterGEMS V8i SELECTseries 5
    • Series Pipe Merging in Skelebrator not working for pipes with zero diameter
    • Small difference in gutter worksheet result between US and SI units
    • The concentration at the stop node directly after a constituent source in a tank is decreasing rapidly
    • The control symbol, check valve symbol, and dashed lines connecting customer meters, isolation valves, and SCADA elements are not visible in the ArcMap or ArcGIS Pro platforms
    • The headloss in a pipe downstream of a parallel VSP is higher than expected
    • The result field "Depth (Flooding)" is listed as N/A after computing a model with the SWMM engine. Is there a way to see the depth of flooding for a node?
    • Translated version still showing as English
    • Troubleshooting making a SCADA connection to Oracle database
    • Troubleshooting ModelBuilder issues and errors connecting to an Oracle database
    • User Data Extension not appearing in the Post-Calculation Processor's "Output Property" field
    • User Data Extensions in the Fireflow report
    • User Notification "More than one VSPB cannot control the same control node"
    • User notification when computing: IDF data is not supported by SWMM. Storm event is excluded from export.
    • User notification: "Conduit has a Stop control structure, but this is not supported next to the connected outfall element."
    • User notification: "Transition from CONCENTRATED to EXTENDED"
    • Using US Survey feet
    • Warning about outlet hydrograph not cresting
    • WaterGEMS and WaterCAD Data Import FAQ
    • WaterSight - Pump Overview
    • What can I do to speed it up a file I need to extract elevations from is taking a long time to process in TRex?
    • What does Entrance Control mean?
    • What is the best way to model an orifice plate inside a catchbasin with surface storage above the catchbasin rim?
    • What is the difference between a stand pipe and an inlet box?
    • What is the purpose the Rainfall File, Runoff File, and RDII File in the Calculations Options?
    • What is the workflow for setting up pre and postdeveloped conditions for multiple return events?
    • What kind of demands should be used as the initial conditions of a transient simulation?
    • What's new in HAMMER V8i SELECTseries 6?
    • When running a query, why is it not picking up the elements that it should?
    • Why are there 2 entries for the same alternative in the dropdown menu in the properties of a scenario? One with an "i" and one without it.
    • Why are there so many extra element types listed for WaterGEMS and WaterCAD, such as surge tank, rupture disk, Periodic head-flow?
    • Why does the precipitation(cumulative) field for catchments show N/A at the 24 hour time step after computing ?
    • Will SCADA Results Publishing work with only OPC sources?

    You are currently reviewing an older revision of this page.

    • History View current version

    How to import/export multiple point type - Pump Definitions using ModelBuilder

       
      Applies To 
       
      Product(s): Bentley SewerGEMS, Bentley WaterGEMS, Bentley SewerCAD, Bentley WaterCAD, Bentley CivilStorm
      Version(s): 08.11.03.77+
      Environment:  N/A
      Area:  Output and Reporting
      Subarea: 
      Original Author: Dan Iannicelli, Bentley Technical Support Group
       

     

     

     How do 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 Sync Out button to export your definitions to your spreadsheet.

     

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies