Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | OpenPlant | PlantWise
AutoPLANT | OpenPlant | PlantWise Wiki To Fix Multiple Duplicate Records Showing in Catalog Editor Interface
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise 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 set Priority For Selected Branched Components present in Branch Table
            • +How to Use AutoPlant Catalogs to Create OpenPlant Spec using SpecGen
            • Lap Joint Stub End Not Converted from PSDS Spec to OpenPlant Modeler Spec
            • Missing EC_CLASS_NAME Data-AutoPLANT to OpenPlant Spec conversion
            • Olet Section Doesn't Show All Sizes From Catalog in Specification Generator
            • OpenPlant End Condition Long Descriptions
            • PSDS Conversion Does Not Convert Additional Schedule in OpenPlant Modeler.
            • 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
      • +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
    • How to Associate the Specification Based on Service in OpenPlant Modeler Connect

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

    To Fix Multiple Duplicate Records Showing in Catalog Editor Interface

    Applies To 
    Product(s): OpenPlant Modeler
    Version(s):

    8.11.11.87/96 (SS6) & above

    Environment:  Windows 7 (64-bit) | Windows 10
    Area:  OpenPlant Specification Generator
    Subarea:  Data
    Original Author: Deepak Singh, Bentley Product advantage Group

    Problem Description

    In OpenPlant Specification Generator, catalog editor shows multiple duplicate records for a component size however in access database for that particular component it shows only one record.

    Pipe records showing in Microsoft Access Database

    Notice that for Pipe with above filtering constraints there is a single record.

    Pipe records showing in Catalog Editor.



    With same filtering parameter in catalog editor it shows 22 records

    Steps to Resolve

    1. Navigate to Catalogs Databases folder of specific project, here metric project.

      Folder path for default project : C:\ProgramData\Bentley\OpenPlantModelerV8i\WorkSpace\Projects\OPModeler_Metric\DataSet\Catalogs Databases

    2. Open your catalog in Microsoft access database. Open CatalogTables table as shown below.



      Note: Fundamental Knowledge of Microsoft Access is required

    3. Filter CatalogTableName field with Pipe records. Notice that PIPE shows 22 records, thus multiplying each single pipe record to 22 times and creating duplicate records in catalog editor.



    4. In CatalogTables section there should be only one record for each class. Delete all PIPE records except one as shown below.



    5. Similarly delete all unnecessary records for different classes. Save database.

    6. Open the corrected access database in catalog editor, notice that records show same as per record in access database.

    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. 

    See Also

     

    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!

    • Catalog editor Shows Duplicate Records
    • Duplicate Records
    • SpecGen Shows Multiple Duplicate Records
    • Share
    • History
    • More
    • Cancel
    • Deepak Singh Created by Bentley Colleague Deepak Singh
    • When: Fri, Nov 18 2016 8:31 AM
    • Deepak Singh Last revision by Bentley Colleague Deepak Singh
    • When: Fri, Nov 18 2016 8:33 AM
    • Revisions: 2
    • 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

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