To Export the BOM to a CSV File
The following
procedure details how to export a Bill of Materials report to a CSV formatted
file which could be opened in Excel and viewed as a spreadsheet if desired.
- From the Isometrics Manager, open the Isometrics Style Configuration interface.
- Click the Reports option to open the Report Definition file. Optional: As an option, you can also navigate to this file directly using the File Explorer. Below is a suggested path using the IFC style as an example: C:\ProgramData\Bentley\OpenPlant CONNECT Edition\Configuration\Workspaces\WorkSpace\WorkSets\OpenPlantImperial\Standards\OpenPlant\Isometrics\styles\As-Built\config\report.def
-
In the Report.def file add a new report definition to the file
(see example 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
-
Save the changes and close the file.
When the isometric is run, the report is
generated in the isometrics 'Project Folder' See the sample below for where the
report is written to:
C:\ProgramData\Bentley\OpenPlant CONNECT Edition\Configuration\Workspaces\WorkSpace\WorkSets\OpenPlantImperial\WorkFiles\Isometrics\Styles\IFC\reports\
When opened in Excel, the report displays similar to the image below: