Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenUtilities
  • Product Communities
  • More
OpenUtilities
OpenUtilities Wiki Adding Manufacturer Data
    • Sign in
    • +OpenUtilities
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • -Component Management - Promis.e
        • Adding Manufacturer Data
        • +Catalog Manager - Component Management - Promis.e
        • +Create Macro - Component Management - Promis.e
        • +Create Symbol - Component Management - Promis.e
        • +Family Creation - Component Management - Promis.e
        • +Parts Database - Component Management - Promis.e
        • Sharing content across multiple sites
        • +Terminal_Pin_Plug Manager - Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Adding Manufacturer Data

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.13.140
      Environment: N/A
      Area: Component Management
      Subarea: N/A

    Background

    A default symbol catalog and a sample parts database are automatically installed when you install the software. The symbol catalog contains the general symbols for the standard that you are using (i.e. push buttons, relays, etc.). The parts database contains a small sample of parts (about 1700 parts) that works well for a trial of the software or going through our tutorial and sample projects. You will probably want to customize these to be more relevant to what your company actually uses.  

    Adding Bentley provided symbols and part numbers to your system

    Download the Content

    While we could never have every part number there is, we do have many different manufacturers and parts available for our SELECT subscribers on the Bentley website. Any other custom parts or symbols that you might need that we do not already have can be created within the software.

    1. Go to http://select.bentley.com/FulfillmentCenter/ and log in.
      If you are redirected to a site for downloading free Bentley iWare and Bentley Apps, you do not have download rights for the Fulfillment Center.  Contact your site administrator for Bentley products to request download rights. The site administrator is an employee of your company, not Bentley Systems.
    2. Click the Clear All button at the bottom of the filter bar on the left.
    3. In the search box, enter "promis.e" and press Enter. Some content will be available in the resulting list. Be aware that this is IEC (metric) content.
    4. Click on the All Downloads link under "Promis.e Enterprise" (or Standard or Professional). You may need to click Next at the bottom of the results list to find "Promis.e Enterprise".


    5. There are typically files for both the MicroStation (DGN) and AutoCad (DWG) formats and files for both inch and metric. Choose the proper files for your platform (DGN/DWG) and standard (inch/metric). Bentley Substation users would always download the MicroStation format.
    6. Place a check in the check box for each item to download then click the Download Queue button, or click the green button at the right side of each item to download individually.

    Incorporate Symbol Catalogs

    1. Double-click the downloaded catalog file and extract it to the desired location.  Catalogs are typically stored in the "Catalogs" subfolder of the promis-e Data folder or Substation Data folder, but there is no restriction preventing them from being located elsewhere.

    2. Use the Setup dialog to add a new catalog path.

    Merge Parts Databases

    1. Extract the database file from the compressed file.

    2. With Promis.e/Bentley Substation closed, add any records that you want to use from the downloaded database into the main parts database.

      Option 1: For Importing or Exporting from MS Access Database to MS SQL Database. 

      Use the Import and Export Data tool which is present in MS SQL Management Studio. This tool can merge records from one Access database to SQL Database. The steps for installing MS SQL Management Studio can be found from the below Wiki Link.



      The Import & Export Data can be selected by following the below steps as highlighted in below image.

      Select Database >> Right Click on Database and Select Task >> Next select either Import Data or Export Data according to requirement.



      Option 2:  For Importing or Exporting from MS Access Database to MS Access Databas

      Copy and paste records from the downloaded database into the main parts database using Microsoft Access.

    The "main" parts database, or the parts database currently in use, can be determined by clicking the Edit button next to Parts database path on Setup > System Paths.

    After merging the downloaded parts database into the main parts database, those part numbers will be available to assign to devices.

    If you prefer to add parts to an empty parts database, you can delete all the records from the parts_database table in the destination parts database using Microsoft Access before merging. Or, an empty parts database is available here.

    See Also

    Empty parts database

    Add Catalog Path

    Copy items to another catalog

      Original Author: Tani_S
    • Catalog Manager
    • parts database
    • download
    • promis.e
    • administration
    • Bentley Substation
    • en
    • Installation_Configuration
    • Component Management
    • Share
    • History
    • More
    • Cancel
    • Jordan Stierly Created by Bentley Colleague Jordan Stierly
    • When: Thu, Jun 3 2010 10:09 AM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Mon, Mar 4 2019 12:51 PM
    • Revisions: 33
    • Comments: 8
    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