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

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

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!