Grouping of Supports Based on Common Tag Name

Overview

In OpenPlant Isometrics Manager Bill Off Material, to group Support based on common Tag name.

Problem Description

In OpenPlant Isometrics Manager, user wanted to group common support tag name irrespective of different support type. In order to achieve the desired setting, it should also display common PARTID for grouped support tags. For Example different Support classes contains different tag names, which generates different PARTID. User requirement is to have same PARTID for similar tag name.

Below has been described in context with OpenPlant/AutoPLANT Modeler & OpenPlant Isometrics Manager.

OpenPlant Modeler - OpenPlant Isometrics Manager

Steps to Resolve

1. In Class Editor, open OpenPlant_3D.01.07.ecschema & Supplement it with OpenPlant_3D_Supplemental_Isometrics_Isoextractor.01.07.ecschema
2. Navigate to SUPPORT class using Search. 
   
   
   
   
3. Check custom attribute "Isometric Component",
   
   
   
   & define the Item code field as this.NAME. See image below.
   
   
   
   
   
4. Save & Close Schema.
5. Open Report.def file, which by default can be found in this location:
   
       C:\ProgramData\Bentley\OpenPlantModeler V8i\WorkSpace\Projects\OPModeler_Imperial\DataSet\Isometrics\Styles\IFC\Config
   
   
6. Exclude supports from Shop Material list by adding below expressions.
   
   REPORT = SHP   
   # this to include only shop material
       INCLUDE = IE_FIELD = 0
       EXCLUDE = IE_TYPE = CT_WELD
       EXCLUDE = IE_TYPE = CT_SUPPORT
   
       COLUMN =  3: R : PARTID
       COLUMN = 19: C : QUANTITY
       COLUMN =  7: R : SIZE1
       COLUMN =  7: R : SIZE2
       COLUMN =  2:   :
       COLUMN = 60: W : IE_DESCRIPT
   
       GROUP  = PARTID
       SORT   = PARTID:N
       SEP    = @ 
       SORTHEADERS = 1
   
       TEXT = @ ----------------------------------------------------------
       TEXT = @                       Shop Materials
       TEXT = @ ----------------------------------------------------------
       Write =
   END
   
   
7. Create new support report by adding below expressions.
   

   REPORT = SUP
       # this to include only support material
       INCLUDE = IE_TYPE=CT_SUPPORT

       COLUMN =  3: R : PARTID
       COLUMN = 19: C : QUANTITY
       COLUMN =  7: R : SIZE1
       COLUMN =  7: R : SIZE2
       COLUMN =  10:   : IE_TAG
       COLUMN = 60: W : IE_DESCRIPT

       GROUP  = PARTID
       SORT   = PARTID:N
       SEP    = @ 
       SORTHEADERS = 0
   
       TEXT = @ ----------------------------------------------------------
       TEXT = @                       Support Materials
       TEXT = @ ----------------------------------------------------------
       Write =
   END
   
   

8. Define SUP report in Combi list.
   
   REPORT = combi
   WRITE = SUP
      WRITE = shp
      TEXT  = @
      TEXT  = @
      WRITE = fld
      NODE = 60
   END
   
   
9. Save & close Report.def file.
10. Generate ISO’s and verify results. See image below. 
    
    

AutoPLANT Modeler - OpenPlant Isometrics Manager

Steps to Resolve

1. In Class Editor, open OpenPlant_3D.01.07.ecschema & Supplement it with OpenPlant_3D_Supplemental_Isometrics_Isoextractor.01.07.ecschema
2. Navigate to SUPPORT class using Search.
   
   
   
   
3. Check custom attribute "Isometric Component",
   
   
   
   & define the Item code field as this.NAME. See image below.
   
   
   
   
   
4. Save & Close Schema.
   
   
5. Open Report.def file, which by default can be found in this location:
   
       C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\SAMPLE_IMPERIAL\Config\OpenPlant\Isometrics\styles\IFC\config
   
   
6. Exclude supports from Shop Material list by adding below expressions.
   
   REPORT = SHP   
   # this to include only shop material
       INCLUDE = IE_FIELD = 0
       EXCLUDE = IE_TYPE = CT_WELD
       EXCLUDE = IE_TYPE = CT_SUPPORT
   
       COLUMN =  3: R : PARTID
       COLUMN = 19: C : QUANTITY
       COLUMN =  7: R : SIZE1
       COLUMN =  7: R : SIZE2
       COLUMN =  2:   :
       COLUMN = 60: W : IE_DESCRIPT
   
       GROUP  = PARTID
       SORT   = PARTID:N
       SEP    = @ 
       SORTHEADERS = 1
   
       TEXT = @ ----------------------------------------------------------
       TEXT = @                       Shop Materials
       TEXT = @ ----------------------------------------------------------
       Write =
   END
   
   
7. Create new support report by adding below expressions.
   

   REPORT = SUP
       # this to include only support material
       INCLUDE = IE_TYPE=CT_SUPPORT

       COLUMN =  3: R : PARTID
       COLUMN = 19: C : QUANTITY
       COLUMN =  7: R : SIZE1
       COLUMN =  7: R : SIZE2
       COLUMN =  10:   : IE_TAG
       COLUMN = 60: W : IE_DESCRIPT

       GROUP  = PARTID
       SORT   = PARTID:N
       SEP    = @ 
       SORTHEADERS = 0
   
       TEXT = @ ----------------------------------------------------------
       TEXT = @                       Support Materials
       TEXT = @ ----------------------------------------------------------
       Write =
   END

8. Define SUP report in Combi list.
   
   REPORT = combi
   WRITE = SUP
      WRITE = shp
      TEXT  = @
      TEXT  = @
      WRITE = fld
      NODE = 60
   END
   
   
9. Save & close Report.def file.
10. Generate ISO’s and verify results. See image below. 
    
    

Still a Problem?

If above problem still persist, then please create a Service Request and contact the Bentley Product Advantage group. Please include a list of all relevant details to get in depth analysis for a solution or workaround. 

See Also

http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/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!