Problem Description

During Conversion of PSDS Nozzle data in OpenPlant Modeler spec, user sometimes not able to get the nozzle information after conversion. There might be several cases of unsuccessful conversion, but one of the common issue modeler might expect is the missing fields which are mandatory while conversion. Below steps describe one scenario where missing field gets resolved by following guidelines.

Steps to Resolve

1. Open PSDS Catalog mdb file in MS Access.
   
   
2. Search for Nozzle table. Say PIPE_PNOZ_SPEC. See image below.
   
   
   
   
3. Switch to Design View.
   
   
   
   
4. Add PAR_UNITS as Field Name & Data Type as “Short Text” and change Field size to 2.
   
   
   
   
5. Save it & switch back to Datasheet view.
   
   
6. Similarly do it for table PIPE_PNOZ_ENDS_SPEC. See image below.
   
   
   
   
7. Add value “IN”  to PAR_UNITS to all rows.
   
   Note – User can take reference to other table where PAR_UNITS value exists and Copy whole column & paste it to these tables.
   
   
8. Check for Type Present for Nozzle spec under PIPE_PNOZ_ENDS_SPEC table. See image below. 
   
   
   
   
9. Open “PSDS Mapping Information.mdb” file to check correct mapping of Type. Check below default path to get this file.
   
   C:\ProgramData\Bentley\OpenPlantModeler V8i\WorkSpace\Projects\ OPModeler_Imperial\ DataSet\Mapping Databases
   
   
10.  In MAPPING_INFO table, filter for PIPE_PNOZ_ENDS table, & verify Property Name and Value as mentioned in below image. 
    
    
    
    Note –Property Name & Value as TYPE & “#” is mandatory here.
    
    
11. (Optional) Check if CATALOG_TABLES contain PIPE_PNOZ_ENDS available here. 
    
    
    
    
12. Save & Close MDB File.
    
    
13. In Class Editor, Open “OpenPlant_Catalogue.01.06.ecschema”. Check Default path below.
    
    C:\ProgramData\Bentley\OpenPlantModeler V8i\WorkSpace\ OPModeler\ schemas
    
    
14. Navigate to PSDS Component Table. Right click on it and select “Add Derived Class” to add a new missing Class PIPE_PNOZ_ENDS.
    
    
    
    
15. Define new class PIPE_PNOZ_END. See below image. 
    
    
    
    
16. Add new Property “TYPE” under this class. For easy way, copy it from any existing class, say PIPE_PGKT like shown in below image.
    
    
    
    
17. Paste it on new class created. See image below. 
    
    
    
    
18. Save & Close Schema.
    
    
19. Launch OpenPlant Specification Generator. Select Project unit.
    
    
20. From Main Menu “File” option select “Exchange” to start the conversion process. See image below.
    
    
    
    
21. Create new definition, say Nozzle, apply settings for source details like shown in image below. 
    
    
    
    
22. Similarly enter the details for Target location & options. See image below. 
    
    
    
    
23. Add Query using PIPING_COMPONENT class. 
    
    
    
    
    
    
    
    
24. Click on Execute to start the conversion process.
    
    
    
    
25. After conversion, navigate to project folder where OpenPlant Modeler specs get saved.
    
    
26. Open Spec and verify specs. Nozzle Data converted successfully. 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/.../13021.how-to-convert-psds-catalogspec-to-openplant-format

communities.bentley.com/.../27126.gaskets-not-converted-from-psds-spec-to-openplant-modeler-spec

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!