Grouping of Supports Based on Common Tag Name


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

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

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!