Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How to Convert PSDS Catalog/Spec to OpenPlant Format
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • -OpenPlant Modeler v8i
          • +Component - OpenPlant Modeler
          • +Drawing Generation- OpenPlant Modeler
          • +Errors, Logs, Messages, Crashes - OpenPlant Modeler
          • +Import/Export- OpenPlant Modeler
          • +Installation - OpenPlant Modeler
          • OpenPlant HVAC-OpenPlant Modeler
          • OpenPlant Modeler [FAQ]
          • -OpenPlant Specification Generator
            • Error in Spec Gen does not load EC Class Name when Catalog is loaded
            • Field Reference Description in OpenPlant Modeler
            • Gaskets Not Converted from PSDS Spec to OpenPlant Modeler Spec
            • How to Convert AutoPLANT PDW Catalog to OpenPlant Modeler Format Using Exchange Option of SpecGen
            • How to Convert PSDS Catalog/Spec to OpenPlant Format
            • How to Correct Spec Changes Using Spec Validation Tool
            • How to Create New Spec in OpenPlant Specification Generator
            • How to Delete-Modify Sections in Specification Generator
            • How To Filter data with Multiple Selection in Specification Generator
            • How to Fix Unit Conversion Issue in OpenPlant Specification Generator
            • How to Include Branch Code Inside Branch Table For Specification Generator in OpenPlant Modeler
            • How to Modify Static Text of Custom Description in OpenPlant Specification Generator
            • +How to Use AutoPlant Catalogs to Create OpenPlant Spec using SpecGen
            • Lap Joint Stub End Not Converted from PSDS Spec to OpenPlant Modeler Spec
            • Olet Section Doesn't Show All Sizes From Catalog in Specification Generator
            • OpenPlant End Condition Long Descriptions
            • To Add Custom Description in a Field to Populate in OpenPlant Modeler
            • To Add EC_CLASS_NAME for Component Table in Catalog Editor
            • To Add LookUp Value in Spec Grid during Placement of Component in OpenPlant Modeler
            • To Add Support Class Property to be Read by Specification in OpenPlant Modeler
            • To Convert Nozzle Data from PSDS to OpenPlant Modeler Spec
            • To Create Missing FLOW_METER Class data in OpenPlant Modeler
            • To Create Missing SIGHT_GLASS Class data in OpenPlant Modeler
            • To Define Default Value of Branch Code for Piping Component
            • To Fix Multiple Duplicate Records Showing in Catalog Editor Interface
            • To Import Access Specification Reports in Excel
            • To Modify Default Outside Diameter Value for End Types in OpenPlant Modeler
            • To Pick Reduced Half Coupling under Branch Table Automatically in OpenPlant Modeler
            • Use Of Reinforced Branch Connection Types Using Branch Table
          • +ProjectWise - OpenPlant Modeler
          • +Properties - OpenPlant Modeler
          • +Release Notes - OpenPlant Modeler
          • +Schema - OpenPlant Modeler
          • +Settings/Attributes - OpenPlant Modeler
          • +Structural Modeling Components (SMC)- OpenPlant Modeler
          • +Tasks - OpenPlant Modeler
          • +Training - OpenPlant Modeler
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
        • How to get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
        • How to Package WorkSpace to be Shareable to Users for OpenPlant Projects
        • How to find iModel.dgn file of another domain in PlantSight
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!

     
     Questions about this article, topic, or product? Click here. 

    How to Convert PSDS Catalog/Spec to OpenPlant Format

    Applies To 
    Product(s): OpenPlant Modeler
    Version(s): 08.11.09.383 & above
    Environment: 
    Area:  OpenPlant Specification generator
    Subarea: 
    Original Author: Justinas Lipnickas, Bentley Product Advantage Group

    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!

    • OpenPlant Modeler
    • Convert PSDS Catalog
    • OpenPlant Specification Generator
    • OpenPlant format
    • Convert PSDS Spec
    • Share
    • History
    • More
    • Cancel
    • JustinasL Created by JustinasL
    • When: Thu, Apr 10 2014 8:40 AM
    • Kestutis Mitkus Last revision by Bentley Colleague Kestutis Mitkus
    • When: Wed, Nov 16 2016 2:53 AM
    • Revisions: 8
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies