Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How To Create Catalog From Given Excel File Using OpenPlant Specification Generator
    • 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
          • Copy Joint Map from OPPA CE U10
          • Difference between Setup, Upgrade and iModel Link in OpenPlant Project Administrator CONNECT Update 9.
          • +Errors, Logs, Messages, Crashes in CONNECT - OpenPlant Project Administrator
          • Fundamentals of Reporting Designer 2: Report Selector and Tools Box
          • Fundamentals of Reporting Designer 3: Field List and Report Explorer
          • Fundamentals of Reporting Designer Using OpenPlant Project Administrator CONNECT Edition
          • How to Change Set of Bolts into Total Quantity of Bolts in BOM by Line Number Reports in OPM through Reporting Designer in OPPA CE
          • How to add a derived class using OpenPlant Project Administrator
          • How to add a Network Drive WorkSpace to OPPA CE & Activate it for OPM CE
          • How to add a property using OpenPlant Project Administrator
          • How to Add COUNT in Reports via Reporting Designer
          • How to Add custom attribute on a double type property in OpenPlant PID CONNECT Edition
          • How to Add Filter to Existing Report Template in Reporting Designer
          • How to Add Groups via Reporting Designer and its Significance
          • How to Add Some Spec Properties for the Existing Component in OpenPlant Modeler Connect
          • How to Add SR NO in Reports via Reporting Designer
          • How to Add the Plant Area Property Name in Tag Name For Equipment
          • How to add Various Grades of Material to Lookup Table.
          • How to Add Weight & Sum of Weight of Piping Component in Reports.
          • How to Associate WorkSet from a Custom WorkSpace to a CONNECT Project
          • How to Change Sequence of Unit, Plant, Service in OpenPlant Project Administrator CE
          • How to Change the Unit for Main Size in a Mixed Metric Environment
          • How to Collaborate WorkSet with ProjectWise using OpenPlant Project Administrator
          • How to Connect with Bentley Technical Support Team using TeamViewer
          • How to convert Cable Tray Specification to a Catalog in OpenPlant Specification Generator.
          • How to Convert Spec to different Unit via SpecGen.
          • How To Create Catalog From Given Excel File Using OpenPlant Specification Generator
          • How to Create Configuration via ProjectWise Share for OpenPlant Modeler CONNECT Edition Update 7
          • How to Create New Associated Item using OpenPlant Project Administrator Update 10
          • How to Create New Spec Using OpenPlant Specification Generator CONNECT Edition.
          • How To Create Specs From Converted Catalog of AutoPlant to OpenPlant Catalog using Specification Generator
          • How to Create WorkSpace & WorkSet in OpenPlant Project Administrator CONNECT Edition
          • How To Enable Other Openplant Applications For Project in OPPA CONNECT Edition
          • How to Generate specification report to other file format.
          • How to Get Customized Bend Point Radius Data in OpenPlant Modeler Connect
          • How to get Iso Sheet Name in Piping MTO via Reporting Designer
          • How to get TOTAL in Reports via Reporting Designer
          • How to Import Existing Custom Report Template from One Project to Another via Reporting Designer
          • How to Include End Condition in OOTB Elbow Reports through Reporting Designer in OpenPlant Modeler Connect Edition
          • How to Include End Condition in OOTB Flange Reports through Reporting Designer in OpenPlant Modeler Connect Edition
          • How to Include Nominal diameter Branch in OOTB Weldolet through Reporting Designer in OpenPlant Modeler Connect Edition
          • How to install OpenPlant Project Administrator with Class Editor and Specification Generator
          • How To Install or Enable Specification Generator Using OpenPlant Project Administrator CE
          • How to make fields editable/ read only in OpenPlant Project Administrator Connect Edition.
          • How to Modify Piping Report in OpenPlant CONNECT Edition to Display Pipe Quantity in Meters Instead of Millimeters
          • How to Modify Tags Using IIF Expression in OpenPlant Project Administrator.
          • How to Modify Value Map Using OpenPlant Project Administrator
          • How to Move a Property from One Category to Other
          • How to move property to another category in OpenPlant Project Administrator Connect Edition.
          • How to Open Schema & Supplement it with desired Schema in Bentley Class Editor CONNECT Edition.
          • How To Perform Exchange Operation in OpenPlant Specification Generator
          • How to Provision Schemas to CONNECT Project using OpenPlant Project Administrator
          • How to Reroute Workset Level Folders to Workspace Level
          • How to Upgrade OpenPlant Modeler V8i WorkSpace to OpenPlant Modeler CONNECT Edition
          • How to Upgrade Schema From OpenPlant CONNECT Update 4 to Update 5 Version
          • How to use AutoPlant Catalogs to create OpenPlant Spec using OpenPlant Specification Generator.
          • How to Use LOADINSTANCES Input Method for Standard Preference in OpenPlant Modeler CONNECT Edition
          • How To Use Merge Option To Combine Two Catalogs using Specification Generator
          • How to Use Spec Default Feature in OpenPlant Modeler CONNECT Edition
          • To Create Custom Support MTO Report Using Reporting Designer Tool
          • [FAQ] - OpenPlant Project Administrator CONNECT Edition
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • +OpenPlant Modeler v8i
        • +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
      • +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 Create Catalog From Given Excel File Using OpenPlant Specification Generator


    Applies To 
    Product(s): OpenPlant Project Administrator
    Version(s):

    10.07.00.32

    Environment:  Windows 7/8.1/10 (64-bit)
    Area:  Customization
    Subarea: 
    Original Author: Harshavardhan K,Bentley Product Advantage Group

    Background

    Sometimes user needs to create their own Catalog using some excel file which has all the data. In this exercise we will try to import data from given excel file . Below is the illustrative example for the same.

    For More Information please check the help content file in OpenPlant Project Administrator and search for Catalog Editor.

    Steps to Accomplish

    1. Launch OpenPlant Project Administrator CONNECT Edition.



    2. Click on Desired workset and expand the node, select OpenPlant Modeler and then click on Tools Tab and launch specification generator.



    3. From OpenPlant Specification Generator window, navigate to tools tab and click on Catalog editor.



    4. Click NEW to create new catalog as we will save our imported excel data in this catalog. Give the name to Catalog let’s say TEST_CATALOG and save the catalog as .mdb file.

    5. In Edit Schema window, click on Add tables or press “Ctrl +”, lets say we want to add new table for Relief Valve for this exercise and hit Ok.



    6. After pressing OK, we will see Fields column are populated on the right-hand side.



    7. Now click on Import Data option and select import from excel and select excel file from the desired location.



    8. A dialog will open asking which sheet(s) can be selected, select sheet and click on Import.



    9. Once the importing is done, a field mapping window will be opened. Click on green + button and select the sheet for mapping.

      NOTE : Fields Mapping dialog display when you are importing data into a catalog from a Excel spreadsheet. Before the data can be imported, the fields in the Excel worksheet must first be mapped to their corresponding column of the table in the catalog.



    10. Click on + icon on the Right-hand side, which will start adding, below fields are shown for illustration.



    11. Now click on Import Button and this will import data from excel and Export Successful message will pop up. Like shown below.





    12. Click on Close button and in Catalog Editor windows, in select  table select Relief valve and verify opening the newly create catalog by clicking on Open Button.

      NOTE : Before saving mdb file, we can use preview button as well to see how the catalog looks like after adding fields.

    See Also

    How To Perform Exchange Operation in OpenPlant Specification Generator
    Applies To OpenPlant Modeler Connect Edition Product(s): OpenPlant Project Administrator CE Version(s): 10.07.00.32 (CONNECT Edition) Environment: Windows 7/8.1/10 (64 bit) …
    Last edited over 2 years ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki

    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

    • Catalog Builder
    • Excel
    • OpenPlant Specification Generator
    • catalog editor
    • Share
    • History
    • More
    • Cancel
    • Harshavardhan Kaduru Created by Bentley Colleague Harshavardhan Kaduru
    • When: Mon, Jun 8 2020 3:27 PM
    • Revisions: 1
    • 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