Problem Description

In OpenPlant Modeler, the requirement is to create a Spool Numbering in an alphabetic sequence. Currently, OPM creates spool ID's in number format as shown

In this wiki article, we will see how to set these numbers to alphabets.

Steps to Resolve

1. Launch Schema Editor.
   
   
2. Open the OpenPlant_3D.01.08.ecschema.xml  & Supplement it with OpenPlant_3D_Supplemental_Isometrics_Isoextractor.01.08.ecschema.xml. Refer to the attached wiki article to do so.
   
   how-to-open-schema-supplement-it-with-desired-schema-in-bentley-class-editor-connect-edition
   
   
3. Go to Piping Component class & create a new property
   
   
   
   
4. Do right click on the property & add the Custom Attributes, Calculated EC Property specification as shown
   
   
   
   
5. In the Calculated ECproperty custom attribute add the following expression as shown along with the information
   
   IIF(this.SPOOL_NUMBER = 0, "", IIF(this.SPOOL_NUMBER = 1, "A", IIF(this.SPOOL_NUMBER = 2, "B", IIF(this.SPOOL_NUMBER = 3, "C",IIF(this.SPOOL_NUMBER = 4, "D",IIF(this.SPOOL_NUMBER = 5, "E",IIF(this.SPOOL_NUMBER = 6, "F",IIF(this.SPOOL_NUMBER = 7, "G",IIF(this.SPOOL_NUMBER = 8, "H",IIF(this.SPOOL_NUMBER = 9, "I",IIF(this.SPOOL_NUMBER = 10, "J",IIF(this.SPOOL_NUMBER = 11, "K",IIF(this.SPOOL_NUMBER = 12, "L", "")))))))))))))
   
   
   
6. Also click on SPOOL_ID property and change expression as below
   
   OLD:
   IIF(this.SPOOL_NUMBER = 0, "", this.GetRelatedInstance("SEGMENT_HAS_PIPING_COMPONENT:1:PIPING_NETWORK_SEGMENT").GetRelatedInstance("PIPELINE_HAS_SEGMENT:1:PIPING_NETWORK_SYSTEM").SPOOL_PREFIX & "-" & this.SPOOL_NUMBER)
   
   NEW
   IIF(this.SPOOL_NUMBER = 0, "", this.GetRelatedInstance("SEGMENT_HAS_PIPING_COMPONENT:1:PIPING_NETWORK_SEGMENT").GetRelatedInstance("PIPELINE_HAS_SEGMENT:1:PIPING_NETWORK_SYSTEM").SPOOL_PREFIX & "-" & this.SPOOL_LETTER)
   
   
   
   
7. Save the Schema & Relaunch OpenPlant Modeler.
   
   
8. Check in pipeline Manager. Both Spool ID and Spool Letter gets changed.
   
   
   
   Notice that, Spools are assigned with the alphabetes A,B,C..........
   
   

See Also

Still a Problem?

If above problem still persists, 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