Compare/Update User Guide
Compare and Update Data : Update the Target Database
Update the Target Database
Click Update Database to review and apply all the accepted changes to the target database.
The following sub-sections describe the process of updating the target database for a selection of supported database types.
Note:
The Update Database window adapts to the different results so as to show only relevant sections. For example if there are no linked items to update then that section will not appear.
Update the Schematic Database
This example shows an update of a schematic database with instrument data from AVEVA Instrumentation. The Update Database dialogue shows the statistics from the compare process and the choices that have been made for accepting changes.
Click UpdateDB to apply these updates. Once the update process has completed, the results summary will be displayed.
Note:
If an update error occurs for a particular attribute, only that attribute will fail to update. Other attributes on the same element will still be updated if possible.
The grid view will be updated to display any messages and errors, highlighting in the appropriate feedback colours.
Update the Catalogue Database
This example shows an update in Paragon of cable catalogue data from AVEVA Instrumentation.
Selecting Owner for an Element
In order to add a new cable catalogue entry, four elements need to be created in the Catalogue database and one element in the Property database. Owners must be selected under which new elements will be created.
The button next to an element will when clicked display the Select Database Element window for owner selection.
The following table lists the element to be added along with its valid owner
Element Type
Valid Owner(s)
TABITEM
CTABLE
GPART
PRTWLD or PRTELE
SCOMPONENT
SECTION or CATEGORY
CCORSET
SECTION or CATEGORY
CABDATA
CMPTYPE
Update the Design Database
A similar process can be used to update a design database with cable, equipment and instrument data from AVEVA Instrumentation, or cable and equipment data from AVEVA Electrical.
Note:
Before adding a cable element in the design database, make sure that the associated cable catalogue, start equipment and end equipment are present in the database. Without the associated elements a cable cannot be added to the design database and an error message will be displayed in the grid.
Note:
Even if there are no attribute updates to be made, there may still be data updates for source or target database references or internally mapped elements, resulting from the matching process. Refer to Instrumentation, Electrical and P&ID Elements Matching for further details.
Update one Dabacon Database from Another Dabacon Database
This example shows update of a design database with equipment data from an engineering database. The process is similar to those described above with the addition of options to handle linking.
Updating between Dabacon sources includes options for linking. Select from the following:
•
Link inserted items - when creating a new item in the target database, automatically link it to the source item.
•
Link matched items - automatically link a matched target item to the source item.
•
Update attributes for linked items - only use this if you want that data directly on the target item. Once the item is linked, you can reference that data from the linked source, e.g. from Design, use description of schlnk to get the linked schematic item's description in a report.
•
Unlink selected items - use this option if you have selected items in the grid that you want to unlink.
Note:
When unlinking selected items, it is the destination item that is unlinked. For example, when design, schematic and engineering items are linked together, performing the unlink operation in Design will unlink the design item from the other two (irrespective of the source database selection), leaving the schematic and engineering items linked to each other.
Click Update to apply these updates.
1974 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.
AVEVA Logo