When creating a parts database path on Setup, the following error message or similar is displayed:
WarningThe field types for the following fields do not match and cannot be mapped:Field Part_Number do not match to field Part_NumberField IsEquipment do not match to field IsEquipmentField Additional_Part do not match to field Additional_Part...
The software checks to make sure the properties of the fields/columns in the parts database being mapped match the project database fields to avoid potential problems when the data from the parts database gets copied to the project database during design work. The fields called out in the error message have been found to be the wrong data type or the wrong length.
Compare the field properties in the parts database being mapped to a table supplied with the software and make changes accordingly.
If creating a parts database path to an Access-style .MDB file, compare the properties of the fields in question to the properties of the fields in the parts_database table of the ANSI-IEEE_parts_database.mdb or iec_parts_database.mdb file using Microsoft Access. These files are typically found in the Databases subfolder of the Promise Data folder and Substation Data folder. Vanilla versions of these files can be found in the .zip file containing the default Data folder contents if necessary.
If creating a parts database path to a table in a SQL database, compare the properties of the fields in question to the properties of the fields in the parts_database table of the project database. This can be done using SQL Server Management Studio or by examining the "CREATE TABLE parts_database" section of the SqlServerProject.sql script file that creates the project database schema. The script can be found in the Promis.e program folder and in the Substation program folder on the workstation that has promis.e/Bentley Substation installed.
Converting to an SQL Parts Database
Creating and Updating the Project Database