Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenBuildings | AECOsim | Speedikon
  • Product Communities
  • Building
  • OpenBuildings | AECOsim | Speedikon
  • Cancel
OpenBuildings | AECOsim | Speedikon
OpenBuildings | AECOsim | Speedikon Wiki Scheduling Element Coordinates - Structural Steel or Concrete Piles Example
    • Building Design - Wiki
    • -OpenBuildings Designer
      • +What's New
      • FAQ - OpenBuildings Designer CONNECT Edition
      • Released Versions - OpenBuildings Designer
      • IFC4 Self-certification
      • +Installation - OpenBuildings Designer
      • +Migration - Upgrading from earlier versions
      • +Configuration - OpenBuildings Designer
      • +General - OpenBuildings Designer
      • +User Interface - OpenBuildings Designer
      • +Architectural Design - OpenBuildings Designer
      • +Structural Design - OpenBuildings Designer
      • +ProStructures Interoperability - OpenBuildings Designer
      • +Electrical Annotation and Design - OpenBuildings Designer
      • -Datasets and Content - OpenBuildings Designer
        • Available Regional Datasets
        • Dataset installation options
        • Dataset Strategies - Local or Network
        • New and modified files in OpenBuildings Designer Update 7 datasets
        • Upgrade existing elements and their properties to the current Catalog Schema
        • Dataset changes in the latest version of OpenBuildings Designer
        • Catalog Item Manager - Moving DataGroup content
        • Creating new Catalog Sub Group Catalog in OpenBuildings Designer
        • Dataset files needed to support custom Spaces
        • Enabling and configuring the Standardized File Naming Utility for WorkSets
        • Family/Part Editor, storing column display settings
        • How can I add / modify a new / existing Definition in a Catalog?
        • How to create custom compound wall
        • How to create wiremesh fence
        • Scheduling Element Coordinates - Structural Steel or Concrete Piles Example
        • UK Dataset - Changed Files in Update 5
        • Unwanted Levels in OpenBuildings Designer DGN Files
        • A series of ATF***FAMILY errors are generated and the Family/Part drop-down lists are empty
        • Existing element is not accepting new definition value
        • Report Component Formulas for Quantify Reports
        • Resolving the BB_PROGRAMMANAGER_DATA error for a newly created WorkSpace
        • Simplest way to create a new cell in OpenBuildings Designer
        • While modifying pipes OBD is crashing
      • +DataGroup System - OpenBuildings Designer
      • +Floor Management - OpenBuildings Designer
      • +Grid Systems - OpenBuildings Designer
      • +Drawing Views - OpenBuildings Designer
      • +Annotation - OpenBuildings Designer
      • +Import/Export- OpenBuildings Designer
      • +ProjectWise Integration - OpenBuildings Designer
      • +Customization - OpenBuildings
      • +Platform Tools - OpenBuildings Designer
      • +Plumbing Design
      • Electrical Designer
      • +Learning Tips
      • +HVAC Design - OpenBuildings Designer
      • +Bentley i-model Composition Server
      • OpenBuildings Designer - Support for IFC Singapore
      • +OpenBuildings Designer Accreditation Program
    • +OpenBuildings Energy Simulator
    • +GenerativeComponents
    • OpenBuildings Station Designer
    • +OpenBuildings Speedikon + Bentley Speedikon V8i
    • +Bentley Facilities Space Planner CONNECT Edition
    • +AECOsim Building Designer
    • +iModel Plugin for Revit
    • +Social Distance Assessments
    • Working from home with OpenBuildings products
    • Working from home with Speedikon
    • +Special Interest Group (SIG) FAQs
    • +Structural Modeler_PS
    • +Configuration Explorer
    • +Legacy Products
    • +OpenBuildings Speedikon

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

    Scheduling Element Coordinates - Structural Steel or Concrete Piles Example

      Product(s): OpenBuildings Designer (and AECOsim Building Designer)
      Version(s): CONNECT Edition and V8i
      Environment: N/A
      Area: Datasets
      Subarea: Properties

    Currently the DataGroup System does not store coordinates for structural elements, however they are stored as EC data accessible to the Items dialog. Methods to schedule coordinates using Power Platform (MicroStation) reporting tools are covered below for both CONNECT Edition and V8i versions.

    OpenBuildings Designer method

    OpenBuildings Designer is able to use the Power Platform Reports functionality to schedule information that is not accessible to the OpenBuildings DataGroup. Reports can combine DataGroup and EC Schema data into one report. DataGroup objects are listed as Item Types in the Reports dialogs. Note that the Item Types and their Properties listed in Reports dialogs are populated by the elements present in the Active File or it's attachments (if the Report Definition is set to include reference attachments, as shown in the video below). More information on Reports can be found in the MicroStation Wiki.

    Play this video

    This method can be applied to any other building elements or reportable properties that are amenable to sorting in Excel.

    V8i SS6 method

    This example will look at extracting the start and end point coordinates of a group of piles from the model to Excel.

    The ABD SS6 Edit In/Update From Excel feature has been used to populate the 'ID | Asset Tag' field ready for them to be exported along with the coordinates:

    Open the Item Browser, ABD Elements will be listed by type.

    1. Highlight Piles:Concrete
    2. Click 'here' to list the details
    3. Once the Details dialog opens right-click on the grey background to export to Excel, choose 'Excel Workbook (*.xlsx)'

    The resulting Excel workbook will contain a raw output of the properties listed in the Details dialog. This can then be manipulated with Excel VBA to produce a neatly formatted schedule containing selected columns.

    This ABD Excel Macro Examples is an example that will work with Concrete or Steel Piles with the resulting output:

    To use the example file, ABD_MacroExamples.xltm:

    1. Copy it to your Excel personal templates folder (the location will vary with version).
    2. Create an new Workbook from this template
    3. Copy the raw output from ABD into Sheet1 of the new Workbook
    4. Run Macro 'ABD_CopyItemColumns'

    This will create a new WorkSheet named PileSchedule as shown above.

    Note: this macro will only work for structural piles as the columns output from Catalog Items vary, this macro is a very simple (and thus accessible to non-programmers!) example that uses particular column ranges to rearrange and format the data.

    • reports
    • export to excel
    • Item Browser
    • Item Types
    • datagroup
    • OpenBuildings Designer
    • AECOsim Building Designer
    • Share
    • History
    • More
    • Cancel
    • Marc Thomas Created by Bentley Colleague Marc Thomas
    • When: Tue, Oct 27 2015 4:20 PM
    • Marc Thomas Last revision by Bentley Colleague Marc Thomas
    • When: Wed, Mar 24 2021 4:23 PM
    • Revisions: 7
    • Comments: 0
    Recommended
    Related
    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