How to Export Bill of Material In CSV Excel Format for AutoPLANT Modeler in CONNECT Edition


Applies To
Product(s):OpenPlant Isometrics Manager CONNECT Edition
Version(s):10.10.01.XXX
Environment:Windows 10 (64-bit)
Area:Processing
Subarea:-
Original Author:Evander Cabalagan, Bentley Global Technical Support

Background

Extraction of Bill of Material can be customized. It will make easier for the user to extract the report from Isometrics Bill of Material/Quantity report and generate to CSV file. It is applicable for 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. Open Project Administrator. Select Root and Project, Settings, and Isometric Styles.
  2. Select Isometric Style and go to Reports. Report.def will open.


    Note: User can navigate through the Root and Project folder for report.def file. Refer to image below.

  3. Add the given values in report.def file.
    #-----------------------------------------------------------------------------
    # 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
  4. This definition will create a CSV file as a comma separated list. This file can be open in EXCEL to handle it as a spreadsheet and can be available in ‘Isometrics’ project folder. Check the location mentioned below where the report is created.
    Note: Use the required Root and Project.

    D:\Piping Training\Metric Training\Isometrics\Styles\IFC\reports

  5. 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

communities.bentley.com/.../processing---openplant-isometrics-manager-for-autoplant

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!