OpenUtilities Wiki Adding Manufacturer Data

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.

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.
Click the Clear All button at the bottom of the filter bar on the left.
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.
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".
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.
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

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.
Use the Setup dialog to add a new catalog path.

Merge Parts Databases

Extract the database file from the compressed file.
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.