In an instance when users want to add new custom columns to their database structure there is a need to add these into the Property Mapping Schema. This will discuss how to manually add these via Class Editor.
Turn on the ability to modify the database mapping directly via Class Editor. In order to accomplish this browse to and edit the ECClassEditor.exe.Config file located in the folder as shown below:Once open in NotePad or another editing software add the following line to the <appSettings><add key="IsDBStructureEditable" value="True" />
Make any customizations needed to the SQL Server database. In this example we will be adding the following custom field in the EQUIP table as shown below:
This new column will need to be added to the Project's Database Property Mapping Schema. This will make it available to be mapped to a property which will then enable it to have data written back and forth between OpenPLANT applications. Notice below that options are available once the database mapping is loaded in Class Editor Please follow the steps below to accomplish this:
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!