Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | OpenPlant | PlantWise
AutoPLANT | OpenPlant | PlantWise Wiki How to Export Bill Of Material In CSV/Excel Format for AutoPLANT
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • +OpenPlant Modeler v8i
        • -OpenPlant Isometrics Manager v8i
          • +OpenPlant Isometrics Manager for OpenPlant
          • -OpenPlant Isometrics Manager for AutoPLANT
            • Installation/Upgradation Steps of OpenPlant Isometrics Manager for AutoPLANT
            • +Errors, Logs, Messages, Crashes - OpenPlant Isometrics Manager for AutoPLANT
            • +Open/Save - OpenPlant Isometrics Manager for AutoPLANT
            • -Processing - OpenPlant Isometrics Manager for AutoPLANT
              • How to Create Special Stamps using Detail Sketches in OpenPlant Isometrics Manager
              • How to Create Special Stamps using Reports in OpenPlant Isometrics Manager
              • How to Compress Welds for Slip On Flange
              • How to Change Color, Line Style and Line Weight for OpenPlant Isometrics DWG Output
              • How to Set Required Line Weight in DWG Format Isometrics Model
              • How to Map OPIM (MicroStation) Line Style with dwg (AutoCAD) Line Style
              • How to Export Bill Of Material In CSV/Excel Format for AutoPLANT
              • How to Fix Mating Flange Orientation Direction in DWG for AutoPLANT - OpenPlant Isometrics
              • How to Map New AutoPLANT Component
              • How to Map New AutoPLANT Relationship in OpenPlant Isometrics Manager Schema
              • How to Map PDW To OpenPlant Isometrics Manager Classes
              • How to Map Tracing Property for Use in Open Plant Isometrics
              • How to Map Pipe Nozzle Properties for use in OpenPlant Isometrics Manager
              • How to Run AutoCAD Script (.SCR) on Generated dwg Isometrics
              • How to Use the Isometric Cleanup When the Output Format is DWG, PDF
            • +Settings/Attributes - OpenPlant Isometrics Manager for AutoPLANT
          • +Release Notes - OpenPlant Isometrics Manager
          • OpenPlant Isometrics Manager [FAQ]
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
    • How to Associate the Specification Based on Service in OpenPlant Modeler Connect

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

    How to Export Bill Of Material In CSV/Excel Format for AutoPLANT

    Applies To
    Product(s): OpenPlant Isometrics Manager
    Version(s): 08.11.09.XXX (SS5) | 08.11.11.XXX (SS6)
    Environment: Windows 7/8.1/10 (64 bit)
    Area: Processing
    Subarea:
    Original Author: Rahul Kumar, Bentley Product Advantage Group

    Background

    Extraction of Bill of material can be customized. It will make it easier for the user to extract the report from isometrics Bill of Material/Quantity report and to generate CSV file thus providing flexibility to use. It can be experienced using both OpenPlant modeler and AutoPLANT Modeler. This has been shown in context with AutoPLANT Modeler and OpenPlant Isometrics Manager. However similar approach could be utilized for OpenPlant Modeler and OpenPlant Isometrics Manager.

    Steps To Accomplish

    1. Launch OpenPlant Isometrics Manager, to open Isometric Configuration dialog.
    2. Launch Project Administrator and browse working project  ->OpenPlant Isometrics->Settings->Create/Modify.See image below.


    3. For launching OUT-Session, click on icon and select Tools-> Configuration button on launch.


    4. Open Configuration manager. See image below.


    5. Go to "Advanced" option, click on "Report definition". It will open report definition file. See image below:


      Note: User can also navigate through the project folder for report.def file. Below is the suggested path for user:
      C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\SAMPLE_METRIC\Config\OpenPlant \Isometrics \styles\IFC\config\report.def

    6. In report definition file add new definition to report.def file. See below:
      #-----------------------------------------------------------------------------
      # A sample report that writes a CSV file
      #-----------------------------------------------------------------------------
      REPORT = CSV
      # this to exclude welds
      EXCLUDE = IE_TYPE=CT_WELD
      COLUMN = 3: R : PARTID
      COLUMN = 19: R : QUANTITY
      COLUMN = 7: R : SIZE1
      COLUMN = 7: R : SIZE2
      COLUMN = 60: W : "\"" + IE_DESCRIPT + "\""
      GROUP = PARTID
      SORT = PARTID:N
      SEP = ,
      TEXT = @PARTID,QUANTITY,SIZE1,SIZE2,"DESCRIPT"
      Write =
      END

    7. This definition will create a CSV file as a comma separated list. This file can be opened with EXCEL to handle it as a spreadsheet. And can be available in ‘Isometrics’ project folder. See path mentioned below where a report gets created:
      C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\SAMPLE_METRIC\Isometrics\Styles\IFC\reports

      Note:
      With different culture settings on computers, the separation character (SEP) may need to be changed for something else. Sometimes it needed a “;” as column separator instead of a “,”.

    See Also

    Comments or Corrections?

    Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this Comments or Corrections?" section. THANK YOU!

    • Excel
    • Export BOM
    • AutoPLANT Modeler
    • OPIM
    • Excel Format
    • Export
    • CSV
    • OpenPlant Isometrics Manager
    • Share
    • History
    • More
    • Cancel
    • Kestutis Mitkus Created by Bentley Colleague Kestutis Mitkus
    • When: Thu, Dec 13 2018 9:40 AM
    • Kestutis Mitkus Last revision by Bentley Colleague Kestutis Mitkus
    • When: Wed, Dec 19 2018 5:57 AM
    • Revisions: 6
    • 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

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