How to Convert PSDS Catalog/Spec to OpenPlant Format

When moving from a current PSDS system, users could require migrating their existing PSDS Catalogs / Specifications to OpenPlant format. For that Exchange software, included in OpenPlant Specification Generator V8i can be used.

Background

To enable the migration, you need to have OpenPlant SS5 or later installed, including PSDS migration tools. Also, access to PSDS database, including your catalogs is required.

Steps to Accomplish

1. Open OpenPlant Specification Generator, select OpenPlant Project where you have your PSDS migration mappings configured.
   
   
2. Launch Exchange software by going File -> Exchange...
   
   
3. In the Exchange dialog, click New. Enter a Definition Name and click OK.
   
   
4. In the Details section, select a Source type from the drop down list. This is the source database that you want to import/export. Select PSDS Catalog(s) for source and OpenPlant for a target.
   
   
5. Click the browse button (...) next to Source to define your PSDS data source and other settings. For this article, I'll use PSDS_Imperial_sample project and it's PSDS database english.mdb:
   
   
   1. If you'll migrating catalogs, leave 'Read Spec Data' unchecked;
      
      
   2. In Spec Name field, enter the Catalogs/Specs you'd like to convert. Leaving this field empty would convert all of the catalogs in the PSDS database, what could take a long time. To add multiple entries, separate them by semicolon (;)
      
      
   3. Select your Spec Units (IN);
      
      
      
      NOTE: If you are converting your PSDS catalog from SQL database, then you must add below connection string to connect to your ODBC driver.
      
      
      
      
      
6. Define settings for target, similar to a source. Make sure to select the target OPP folder, the folder where you would like to store the results.
   
   
7. Finally, we need to create a query, by which components should be selected from PSDS catalog. Generally, if you want to include all components from the Catalog/Spec you defined, just use PIPING_COMPONENT, and it will include all of Piping components with-in the catalog. If you need only some specific components from your PSDS spec, use an OpenPlant equivalent of that component in the Query, for example, PIPE_ELBOW for your PIPE_PELB PSDS components.
   
   
   
   
8. When done adding your queries, click Execute to begin conversion. Usually, it will take some time to complete the conversion. The progress window is displayed with details about the conversion progress.
   
   
   
   
9. Once completed review the generated .mdb files within the target folder to see your converted Catalogs.

See Also

OPPID - Using PSDS Specs

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!