Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenFlows | Water Infrastructure
  • Product Communities
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Wiki Importing an AutoCAD or MicroStation CAD file 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
      • +CivilStorm TechNotes and FAQs
      • Combining models with Submodel Import
      • Error publishing to i-model
      • For a modified basket handle shape conduit why is Area (Full Flow) equal to zero after computing?
      • +Hammer TechNotes and FAQs
      • Importing an AutoCAD or MicroStation CAD file using ModelBuilder
      • Learning Resource Guide for new users of HAMMER
      • Platform Compatibility
      • +PondPack TechNotes and FAQs
      • Scenario and Alternative Management
      • +SewerCAD TechNotes and FAQs
      • +SewerGEMS TechNotes and FAQs
      • Silent installation for Bentley OpenFlows Products
      • +StormCAD TechNotes and FAQs
      • Understanding the Modified Rational Method
      • Using Fit To Page Printing In The Standalone Platform
      • +WaterGEMS and WaterCAD TechNotes and FAQs
      • What's New in SewerGEMS V8i SELECTseries 5?
      • What's new in SewerGEMS, SewerCAD, StormCAD and CivilStorm CONNECT Edition Update 1 (Build 10.01.01.04)
      • What's New with HAMMER CONNECT Edition
      • What's New with WaterGEMS and WaterCAD CONNECT Edition
    • 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."
    • Pressure pipe vs. conduit between pump and wetwell
    • Print Preview > Fit to Page shows blank page or Reports will not print
    • Properties not working when using MicroStation integration with ProjectWise
    • Properties, Flextables, user notifications, or other dialog is missing or will not open or appears to freeze the program 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
    • 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 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."
    • Arch section shape modeling limitations
    • 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
    • Calculating ellipse coefficients in CulvertMaster
    • Calculation of Side Flow factor with grate width less than gutter width
    • 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
    • Conduit "Size" attribute does not appear correctly in annotations or reports
    • 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 importing a LandXML file from StormCAD into Civil 3D "A pipe or conduit had an unsupported geometry"
    • 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
    • HAMMER error: "Zero initial head from pump (turbine). Change at least one of the heads at the pump ends of the adjacent pipes."
    • 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 can I speed up computing a model that I need to extract elevations from - it is taking a long time to process in TRex?
    • 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 do you define the starting conditions of the transient simulation?
    • 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?
    • How to open a .PRNX report file created on exporting custom report in OpenFlows product
    • 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?
    • Is there a way to model a rectangular pipe in WaterCAD, WaterGEMS or HAMMER?
    • Junctions are created on top of one another after using ModelBuilder with the GIS-ID property
    • Learning Resource Guide for WaterSight
    • License usage in the ArcMap and ArcGIS Pro platform
    • LoadBuilder applying demands or loads to inactive elements
    • LoadBuilder importing zero flow loads
    • Log4net issues appear in security scans for OpenFlows products
    • 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 closed or pressurized pipes in PondPack
    • Modeling culverts in series in CulvertMaster
    • 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
    • My scenario label is not in my report preview when I run the report builder
    • +OpenFlows Academic Books
    • 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
    • Purpose of the Virtual Flow Depth Calculation Option
    • Query, alert or formula UDX not working correctly with "=" (equals)
    • Red user notification, "Post engine loading process encountering unexpected data. Please rectify any validation errors and try again."
    • Reporting pressure available at the exact total needed fire flow
    • SCADAConnect in SewerGEMS
    • Series Pipe Merging in Skelebrator not working for pipes with zero diameter
    • Sharing Queries for use in other models
    • 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 ArcGIS Pro Integration
    • Troubleshooting making a SCADA connection to Oracle database
    • Troubleshooting ModelBuilder issues and errors connecting to an Oracle database
    • Unexpected small flow in pipes that should have zero flow
    • Use of the Gas Law Exponent During Initial Conditions vs. Transient simulation
    • 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 Imperial and Metric Hydro International Vortex Valves
    • Using US Survey feet
    • Warning about outlet hydrograph not cresting
    • WaterGEMS and WaterCAD Data Import FAQ
    • WaterSight - Pump Overview
    • +WaterSight Learning Resource Guide
    • Wetwell flooded warning in steady state with GVF Convex (SewerCAD) solver
    • 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 do I get a warning message about the rational method being used for the modified rational method?
    • Will SCADA Results Publishing work with only OPC sources?

    You are currently reviewing an older revision of this page.

    • History View current version

    Importing an AutoCAD or MicroStation CAD file using ModelBuilder

    Product(s): WaterCAD, WaterGEMS, HAMMER, StormCAD, SewerCAD, SewerGEMS, CivilStorm
    Version(s): 08.11.XX.XX and 10.00.00.XX
    Area: Layout and Data Input

    Overview

    Some older versions of the Hydraulics and Hydrology product line (WaterCAD, WaterGEMS, StormCAD and SewerCAD) used a much different procedure for converting "polylines to pipes", compared to the 08.XX.XX.XX versions. This TechNote provides tips and techniques for effectively importing a CAD drawing into V8 XM, V8i, or CONNECT Edition using the new method. This procedure is similar for WaterCAD, WaterGEMS, HAMMER, StormCAD, SewerCAD, SewerGEMS, and CivilStorm.

    NOTE: if you need to import ESRI Shapefiles, the process is similar to the below. The main differences is that you would need to select multiple shapefiles at the same time (hold down the CTRL or Shift key to multi-select) in the first Modelbuilder step, as you would have one set of shapefiles for each element type (polyline shapefile for pipes, point shapefile for junctions, point shapefile for pumps, etc). This will allow you to map each element type to each shapefile, in the table mapping step. Shapefiles also typically have more attributes exposed which can be mapped in the field mapping step. For example diameter as a field in a single pipe polyline shapefile, compared to a DXF that may have one layer for each diameter (and would need to be imported in passes with the use of prototypes as explained further below).

    Background

    In older versions of WaterCAD, WaterGEMS, StormCAD and SewerCAD (circa 2006), the user would import a CAD drawing (.dxf or .dwg) via File > Import > Polyline to Pipe. Upon release of the V8 XM edition, this functionality was merged into ModelBuilder, which is a powerful tool used to import many different types of data. Since the steps in the ModelBuilder process are very similar for most data source types, there are some extra options involved for a CAD drawing, which could initially cause some confusion to new users of V8 XM, V8i, and CONNECT Edition.

    Preparing the CAD Drawing

    1.  First, you should take some time to clean up your CAD drawing prior to performing the conversion. Look for entities that should not be converted, such as leader lines, and move them to their own layer. Turn off or remove layers that you do not wish to convert. Ensure that linework is in Model Space (or in MicroStation, Model Type = Design) Do a quick review of your drawing and correct any potential conversion problems that you may find.

    Note: It is recommended that you perform a "save-as" before cleaning up the drawing, so that you can retain the original.

    2.   Next you will need to save your CAD drawing to one of the supported CAD file types listed in the next section of this article.

    Supported CAD File Types

    Starting in the CONNECT Edition version of the products (10.00.00.XX), ModelBuilder accepts the CAD formats .dxf, .dgn, .idgndb, and .imodel.

    Prior to the release of the CONNECT Edition version (10.00.00.XX), the only CAD format accepted by ModelBuilder was the .dxf file type. DXF is the "drawing exchange format", so almost all CAD programs have the ability to save to it. Whenever possible, try to save to the earliest DXF format, for better compatibility. For example, in AutoCAD, go to File > Save As, and choose "2004 DXF" as the format.

    Importing Your CAD Drawing Using ModelBuilder 


    Note: This process remains the same whether you are in the standalone, AutoCAD, MicroStation, or ArcGIS platform. This process was developed from and the screenshots were taken from the V8i version of the products. It is assumed that certain pipe diameters are separated by layer. If you're using V8 XM or CONNECT Edition instead, the steps in the ModelBuilder process will look slightly different, but basic procedure remains the same.

    1.  Open WaterCAD/GEMS and start a new project. Ensure that the correct unit system is specified. Go to Tools > User Data Extensions.

    2.  Right click on "Pipe" and choose to create a new user data extension. We will import the layer name into this field so that we can assign diameters at a later point. Give it a name, keep the default data type of "Text" and click OK.




    3.  Start ModelBuilder by going to Tools > ModelBuilder. In the main window, click the "New" button to start a new ModelBuilder run.

    4.  In the first step, select "CAD Files" as the Data Source type and browse to your .dxf file. Alternatively in the CONNECT Edition of the products, you can select Bentley Drawing File and browse to a .dgn, .idgndb, or .imodel file. Once selected, a table will be displayed in the lower left corner, showing all the layers that exist in the drawing. Layers that you would like to be imported should be checked. Unchecked layers will not be imported. The layer type will be displayed after the name of each layer, showing you if the layer contains points, lines, or polygons. In this example, we have checked only the layers that represent water distribution pipes of various diameters. Layers containing roads, annotations, and other irrelevant items have been unchecked:




    Note: If you have a lot of layers that need to be unchecked, you can right-click anywhere in the list and choose "clear selection".
    Note: In many cases, nodal elements such as tanks, pumps, etc are represented in a CAD drawing as a series of lines. In this case, they cannot be imported as their respective nodes in the ModelBuilder process. The user must enter these elements later on after the import.

    5.   Click the 'Next' button to proceed to the second step. In this step, you should select the appropriate unit and also make sure the check box next to "Establish connectivity using spatial data" is checked. This option allows ModelBuilder to use the spatial information inside the CAD file (lengths, coordinates of endpoints/bends, etc) to build the model, instead of the user needing to explicitly specify the start/stop node (which is typically not possible for a CAD drawing.)

    In addition to this, the "Tolerance" field will allow ModelBuilder to automatically connect pipe end points that are within the specified value. Make sure "Create nodes if none found at pipe endpoint" is checked. In most cases, only polylines are imported from a CAD drawing, so you'll want junctions to be created at the ends of these.




        1. For the "Tolerance" options, take the following CAD line for example





        1. In this zoomed-in view, notice that a gap exists due to drawing imperfections. This gap is 1.5ft wide. Now, if we import this CAD file with 1 ft. set as the tolerance it will create two nodes at the actual end points of these pipes





        1. This is because the distance between the end points was not within the tolerance. If we were to instead import this drawing with a 2ft tolerance, it would connect these end points and join them at a junction:





    6.   Next, you will only need to keep the "Add objects to destination if present in source" box checked, since we are creating new elements based on the CAD drawing data.

    7.  In step 4, accept the defaults of  "Current scenario" and "Label".

    8.  In step 5, you must configure how the data in each layer is mapped to WaterCAD/GEMS. Click each layer from the list on the left and then configure the attributes on the right:


    "Table Type"

    This is used to select the type of element that a layer will be imported as. For a CAD file, you will most likely be importing polylines only. So, this field will be set to "Pipe" (for WaterCAD, WaterGEMS and HAMMER) or "Conduit" (for SewerCAD, SewerGEMS and CivilStorm).

    "Key/Label"

    This is the field used to create labels for the elements created by the ModelBuilder process. It is also used to link up elements when updating existing ones. In the case of importing a CAD drawing, most likely a field containing unique labels does not exist for the polylines. So, you should select "<label>" for each layer. This will cause ModelBuilder to automatically generate unique labels, utilizing a combination of an element's layer type label, its shape type, and a numeric ID that represents the order in which it was created.

    "Start"/"Stop"

    Choosing the "Establish connectivity using spatial data" causes the connectivity information to be taken from the CAD drawing, so you do not need to specify a start/stop node field for the pipes/lines. So, simply leave these as "<none>".

    "Attribute"

    At the bottom right corner of this ModelBuilder step, the user can link fields in the source data to fields in the program. In the case of a CAD drawing, typically there are no additional, useful attributes. However, you could link the "Layer" field to the user data extension attribute that you created in step 2. In this example, the user data extension was named "AutoCADLayer":

    By linking this field, there will be an attribute in the WaterCAD/GEMS model that contains the name of the layer that the pipe came from. Later on this will be useful.

    Note: Make sure that you set the key/label field and "layer" mapping for each layer. If your CAD file contains points, they will show up as separate layers on the left side. You can then click and assign them to a node element type such as Junction.

    9.  In the last ModelBuilder step, choose to build the model. ModelBuilder will then import the layers and provide you with a summary, including a "Messages" tab that you can use to view informational messages about the import process. In this case, there are some messages about nodes being created due to missing start/stop nodes. This is expected since we were only importing polylines, with the "Create nodes if none found at endpoint" option selected.





    10.   After closing the summary and closing ModelBuilder you will be prompted to synchronize the drawing. Choose "Yes" and your model should show up in the drawing area.  If it does not, then go to View > Zoom > Zoom Extents.



    Note: Upon completion of your ModelBuilder run, it is suggested you use the Network Navigator tool to identify any connectivity or topological problems in your new model.

    Assigning Pipe Diameters

    Now that our model has been created, we can assign diameters to the pipes, based on the layer attribute that we imported.

    1.   Open the pipe FlexTable via View > FlexTables.

    2.   Click the yellow Edit button ( ) and add your user data extension. To do this, first find it in the list on the left side, click on it, and then click the single arrow button pointing to the right side. Click OK and you will now see a column in the FlexTable, containing the layer that each pipe came from. In our example case, the layer "12_WATER" represents 12" pipes, "16_WATER" represents 16" pipes, and so forth.





    3.  Right click on any of the column headers, choose "Filter", and select "Custom". In the query window, double click on your user data extension field from the list on the left and click the equals sign button. Then, click the green button on the top-right corner to retrieve a list of unique values from this field. Double click on one of the diameters (layer names) shown. In our example case, we'll start with the 10" layer:

    When you click OK in the query window, the FlexTable will be filtered to only show pipes that came from the layer that you queried on (those from the "10_WATER" layer in our example case.)

    Note: After performing your filter, the bottom left corner of the FlexTable will show you how many pipes met the query condition and are displayed (for example "68 of 4714 elements displayed")

    4.   Now, assign the correct diameter by right clicking on the "Diameter" column header and choosing "Global Edit". Keep the operation as "Set", and enter the appropriate diameter as the value. Click OK and your diameters will be assigned.

    5.   Repeat steps 3 and 4 for each layer, assigning out all your diameters.


    Note: When done, you can reset your filter by right clicking on any column header and then choosing Filter > Reset.

    Note: An alternative way to assign diameters would be to bring each layer in one by one. Instead of using the user data extension, create a Prototype under View > Prototypes, and set the pipe diameter to the smallest one in your CAD Drawing. Next, uncheck all layers in the first ModelBuilder step except for the one corresponding to that diameter. Import the pipes per above and they'll be assigned the diameter specified in the prototype. Next, change the pipe prototype diameter to the next size, open the ModelBuilder run again, uncheck the first diameter and check the next one. Continue on like this for each diameter.

    Troubleshooting

    When importing a layer which contains only lines or polylines, ModelBuilder recognizes the layer as a polygon instead of polylines.

    Make sure all polylines have a length. The layer may contain a point (line without length). Other applications such as MicroStation and AutoCAD may recognize the element as a polyline, but ModelBuilder does not since the endpoints are at the same location. Either delete these points or replace them with a line that has a length. This is also discussed in this article.

    See Also

    Building A Model Using ModelBuilder [TN]

    Updating A Model Using Model Builder

    Not all the layers in my DXF file are showing up in ModelBuilder

    Polylines show as Polygon in ModelBuilder

    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

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