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 Scheduling Element Coordinates - Structural Steel or Concrete Piles Example
    • Sign in
    • Building Design - Wiki
    • -OpenBuildings Designer
      • +Annotation - OpenBuildings Designer
      • +Architectural Design - OpenBuildings Designer
      • +Configuration - OpenBuildings Designer
      • +Customization - OpenBuildings
      • -Datasets and Content - OpenBuildings Designer
        • Changed Files in Update 5 UK Dataset
        • 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 apply Cut Plane hatch/patterning in a drawing
        • Scheduling Element Coordinates - Structural Steel or Concrete Piles Example
        • Upgrade existing elements and their properties to the current Catalog Schema
      • +Drawing Views - OpenBuildings Designer
      • +Electrical Annotation and Design - OpenBuildings Designer
      • +General - OpenBuildings Designer
      • +Grid Systems
      • +Import/Export - OpenBuildings Designer
      • +Installation - OpenBuildings Designer
      • +ProjectWise Integration - OpenBuildings Designer
      • +Structural Design - OpenBuildings Designer
    • +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. 

    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.

    Click here to 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: Mon, Apr 29 2019 11:56 AM
    • Revisions: 7
    • Comments: 0
    Anonymous
    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