Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenBuildings | AECOsim | speedikon | LEGION
  • Product Communities
  • Building
  • OpenBuildings | AECOsim | speedikon | LEGION
  • More
  • Cancel
OpenBuildings | AECOsim | speedikon | LEGION
OpenBuildings | AECOsim | speedikon | LEGION Wiki Creating a custom manufacturer's catalog for plumbing components
    • Sign in
    • Building Design - Wiki
    • +OpenBuildings Designer
    • -AECOsim Building Designer
      • +Annotation - AECOsim Building Designer
      • +Architectural Design - AECOsim Building Designer
      • +ASM (Analytical Space Model)
      • +Configuration - AECOsim Building Designer
      • +DataGroup System - AECOsim Building Designer
      • -Dataset and Content - AECOsim Building Designer
        • Add instance data to a graphic element
        • Adding National BIM Library Content to the UK Dataset
        • Catalog Item Manager - Moving DataGroup content
        • CONNECT Edition - "Add Instance Data" in AECOsim Building Designer
        • CONNECT Edition - Export Catalog items
        • CONNECT Edition - How to Download and Install different Dataset for AECOsim Building Designer
        • CONNECT Edition - Including Previous Family and Parts Files In The New Dataset
        • Corus Construction Parts
        • Create custom compound wall
        • Creating a custom manufacturer's catalog for plumbing components
        • Creating custom Drawing Seeds using a Wireframe Render Mode display
        • Creating Report Component Formulas for Quantify Reports
        • Dataset changes in the latest version of AECOsim Building Designer
        • Dataset Levels Required for DV Creation Are Not Copied into the Active File on Open
        • Defining a default insulation Part per component type
        • How to download Datasets for AECOsim V8i
        • How to upgrade/migrate BXF from Bentley Architecture to AECOsim
        • Is the UK Dataset based on Uniclass 2015?
        • Material Lost after Model is Merged into Master file
        • RFA Interpreter
        • The "Mark" Property On Structural Members Is Not Populating.
        • UK Structural Size Data Updated
        • Unwanted Levels in AECOsim Building Designer DGN Files
        • Updating/Migrating Datasets - General Advice
        • Updating/Migrating Legacy Building Datasets to AECOsim SS3
        • Updating/Migrating SS3 Datasets to SS4
        • Updating/Migrating SS4 Datasets to SS5
        • Updating/Migrating SS5 Datasets to SS6
        • What are some differences between the various DGN seed files?
        • What Is A Compound Cell?
      • +Drawing Extraction - AECOsim Building Designer
      • +Drawing Views - AECOsim Building Designer
      • +Electrical Annotation and Design - AECOsim Building Designer
      • +Floors - AECOsim Building Designer
      • +Form Modeling - AECOsim Building Designer
      • +General - AECOsim Building Designer
      • +Grid Systems - AECOsim Building Designer
      • +HVAC Design - AECOsim Building Designer
      • +i-model - AECOsim Building Designer
      • +Import/Export - AECOsim Building Designer
      • +Installation - AECOsim Building Designer
      • +Modify - AECOsim Building Designer
      • +Platform Tools - AECOsim Building Designer
      • +Plumbing Design - AECOsim Building Designer
      • +Print/Plot - AECOsim Building Designer
      • +ProjectWise Integration - AECOsim Building Designer
      • +Settings/Attributes - AECOsim Building Designer
      • +Space Planner - AECOsim Building Designer
      • +Structural Design - AECOsim Building Designer
      • +User Interface
      • +Utilities - AECOsim Building Designer
      • +Workspace - AECOsim Building Designer
    • +OpenBuildings Energy Simulator
    • +GenerativeComponents
    • +Bentley Facilities
    • +Bentley speedikon
    • +Bentley LEGION
    • +iModel Plugin for Revit Overview
    • +Special Interest Group (SIG) FAQs
    • CIS/2 Analysis Data
    • Managed Data Item
    • +Legacy Products
    • +Configuration Explorer

     
     Questions about this article, topic, or product? Click here. 

    Creating a custom manufacturer's catalog for plumbing components

      Product(s): AECOsim Building Designer
      Version(s): V8i
      Environment:  N/A
      Area:  Dataset and Content
      Subarea:  Database
      Original Author: Steve Cocchi, Bentley Technical Support Group

    I am starting a new project and would like to create a few custom manufacturer's plumbing databases. I would think that this should be possible by copying delivered MDB and XML files and modifying them as needed.  Are there any specific issues I should be aware of?

    Steps to Accomplish

    Yes, you should be able to copy the existing layout and structure used for an existing manufacturer's catalog, by default located under the C:\ProgramData\Bentley\AECOsimBuildingDesigner V8i Ss4\WorkSpace\BuildingDatasets\Dataset_Name\datagroupcatalogs\plumbing_lib folder, and modify it as needed to suit your new manufacturer's catalog. Just be sure that your XML and MDB files include a complete matching set of component types and properties.

    For example, let's assume you've defined these four main properties in your custom manufacturer.xml file:

    <Property definition="Properties" name="Properties/@ProductCode" value="CODE" dbname="PIECE_MARK" />

    <Property definition="Properties" name="Properties/@Manufacturer" value="MANUFACTURER" dbname="MANUFACT" />

    <Property definition="Properties" name="Properties/@Type" value="TYPE" dbname="SHORT_DESC" />

    <Property definition="EndSpec2_22" name="EndSpec2_22/End1/@diameter" value="D1" dbname="MAIN_SIZE" />

    You should also have have equivalent columns for all four of these properties in the matching *.mdb database file for that component type, and values populated for each row. In the above case the PIECE_MARK database column name is mapped to the DataGroup property "CODE". It is important that the CODE property, whatever it is mapped to, has a unique value for each corresponding entry (row) in the database in order to select the correct record values in the Manufacturer Catalog dialog box.

    Here is a simple example of the "StraightPipe" component from the delivered "generic" catalog.  This is the appropriate section defined in generic.xml:

     <Catalog name="BMP_StraightPipe">   

    <CodeSubstitutes>    

    <Property definition="Properties" name="Properties/@ProductCode" value="CODE" dbname="COMP_INDX"/>   

    <Property definition="Properties" name="Properties/@Manufacturer" value="MANUFACTURER" dbname="CATALOG"/>    

    <Property definition="Properties" name="Properties/@Material" value="MATERIAL" dbname="MATERIAL"/>   

    <Property definition="Properties" name="Properties/@Type" value="TYPE" dbname=""/>    <Property definition="EndSpec1_2" name="EndSpec1_2/End1/@diameter" value="D1" dbname="MAIN_SIZE"/>    

    <Property definition="CustomParamBMPPipe" name="CustomParamBMPPipe/PIPE_OD_M" value="PIPE_OD_M" dbname="PIPE_OD_M"/>   

    </CodeSubstitutes>   

    <Database Filename="$(BMECHDIR_PLUMBING_LIB)generic.mdb" TableName="PIPE" Unit="IM"/>   

    <SearchCriteria NumOfnames="4" name1="CODE" name2="D1" name3="PIPE_OD_M" name4="MATERIAL"/>  

    <QueryCriteria NumOfParams="2" Param1="D1" Param2="MATERIAL"/>  

    </Catalog>

    This section includes the Catalog Name; the applicable properties being mapped to database column names; the MDB file name, its location and the table name; and finally the sequence in which they should be displayed.

    Now here is the corresponding "Pipe" table from generic.mdb (some columns are hidden):

    You can see how the "dbname" properties defined in the XML file are the column names in the MDB file.

     

    Also, note that if the values used in the MDB file's MAIN_SIZE property include a unit string such as "mm"; e.g., 25mm, you will need to include the following conversion rule in your XML file:

     <CONVERSIONRULE>      

    <D1>        

    <IGNORE>          

    <Stringignore name="mm" />        

    </IGNORE>      

    </D1>    

    </CONVERSIONRULE>

    However, if the MAIN_SIZE value does not include the "mm" string (or any other) and instead uses only an integer value, you do not need to include the conversion rule.

     

    See Also

    See the section "Establishing Links to Delivered Databases" in the delivered AECOsim Building Designer help.

    • Dataset and Content
    • Catalog
    • Manufacturer
    • how to
    • AECOsim Building Designer
    • Database
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Steve Cocchi Created by Bentley Colleague Communities MVP Steve Cocchi
    • When: Thu, Dec 19 2013 10:54 PM
    • Steve Cocchi Last revision by Bentley Colleague Communities MVP Steve Cocchi
    • When: Wed, Aug 7 2019 3:48 PM
    • Revisions: 16
    • Comments: 1
    Anonymous
    • Tuan Le
      Offline Tuan Le over 4 years ago

      I might be wrong, but the example doesn't seem to work if <ConversionRule> is used for "D1" property with the shown database table. Because it seems the "mm" part is only "ignored" when the data is received from the database. When AECOSim queries a user-typed "D1" value from the Datagroup Instance dialog, "mm" won't be "un-ignored" and added to the query string that sent to the database, and thus, the query won't return any match.

      • Cancel
      • Up 0 Down
      • Reply
      • More
      • Cancel
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • User Management
    • Licensing Manager
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

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