Product(s): OpenPlant PowerPID V8i, Class Editor
Version(s): SELECTseries 3+
The Plant Project Database Mapping Extension has the ability of validation and repairing of mappings. At this time it covers only one area: inconsistency between Database structure and mappings. E.g. a property is mapped to a non-existing column or a class references a database that is not loaded in the mapping file. To run the mapping validation tool select "Database Mapping > Validate and Repair" from the main menu. The "Mapping Validate and Repair" dialog box is displayed.
On the left pane the list of class or relationship mappings that have inconsistencies is shown. On the top of right pane a list of errors of the selected class/relationship mapping is shown. The list has two columns: error description and error location. He location can be one of the mapping for properties or some section of a class mapping (e.g. "Obligatory Columns" or "Class Specification Columns").
There are two ways of fixing those problems:
Manual editing of class or relationship or property mapping - To open the corresponding class mapping dialog box double click the class in list or select "Action > Edit Mapping..." from the menu of this dialog box.
Batch update of all mappings - This intends search & replace for either Database or Table or Column Name. Select an error from the list. The tab on the bottom of right pane will switch to relevant one. Under that tab define replacement rule (E.g. replace "TAG_REG1" to "TAG_REG") and click the "Replace" button.
Note: Replace option is applied to all mappings. Not just selected one.