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

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!