To Display New Line for each Attributes in BOM


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

Overview

In OpenPlant Isometrics Manager, to insert attributes in new line for BOM. 

Problem Description

While generating isometrics drawing, user requirement is to display attributes in a new line for some specific components. Below are the steps to resolve this by adding a NEWLINE in report.def or by modifying the expressions in schema.

OpenPlant Modeler-OpenPlant Isometrics Manager

Steps to Resolve

A. To Include NEWLINE in report.def file

  1. Launch OpenPlant Isometrics Manager. Select Project unit, say Metric here.



  2. Click on “Configuration” Icon to launch Isometric configuration dialog box.
  3. From Isometric configuration dialog, select “Advanced” node and click on “Open Report Definition” option. 



  4. Go to default shop report. Include expression shown below. 

    EXCLUDE = IE_TYPE=CT_SUPPORT



  5. Add a new report for support, say report type as SUPP. See image below. 

    #-----------------------------------------------------------------------------
    # A sample report that writes Support
    # Defintion is the same as for the SHP report except for the INCLUDE line
    #-----------------------------------------------------------------------------

    REPORT = SUPP

    # this to include only shop material
    INCLUDE = IE_TYPE=CT_SUPPORT
    EXCLUDE = IE_TYPE=CT_WELD

    COLUMN = 3: R : PARTID
    COLUMN = 19: R : QUANTITY
    COLUMN = 7: R : SIZE1
    COLUMN = 7: R : SIZE2
    COLUMN = 2: :
    COLUMN = 60: W :IE_DESCRIPT + NEWLINE() + NAME

    GROUP = PARTID
    SORT = PARTID:N
    SEP = @
    SORTHEADERS = 1

    Write =
    END


  6. Also add the report type SUPP in combi report. See image below. 

    #-----------------------------------------------------------------------------
    # The COMBI report combine the SHP and FLD report into a single report
    # and attaches it to textnode 60 in the isometric
    #-----------------------------------------------------------------------------
    REPORT = combi
    WRITE = shp
    TEXT = @
    WRITE = SUPP
    TEXT = @
    WRITE = fld
    NODE = 60
    END



  7. Save & Close report. 
  8. Generate Isometrics & Verify results. See image below. 

B. By Schema Customization

  1. In Bentley class editor, open OpenPlant_3D.01.07.ecschema & supplement it with OpenPlant_3D_Supplemental_Isometrics_Isoextractor.01.07.ecschema. 
  2. Search for PLANT_BASE_OBJECT. See image below. 



  3. Double click on PLANT_BASE_OBJECT to navigate the desired class. 
  4. Right click on PLANT_BASE_OBJECT and select copy as shown in image below. 



  5. Pull Default Bill of Material labels custom attribute & click on copy. See image below. 



  6. Navigate to SUPPORT class and paste it. See image below. 



  7. Modify the expression by adding &&&. This will add a new line  like shown in below image. 

    IM.GetValue("DESCRIPTION",IM.GetValue("NAME","NODESC")) & "&&&" & this.NAME



  8. Save & close schema. 
  9. Launch OpenPlant Isometrics Manager, generate isometrics & Verify Result. See image below. 

See Also

communities.bentley.com/.../12642.configuring-the-bom-and-reports

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!