Compare Data

1. On the Compare/Update tab, in the Source Selection group check the Local checkbox if data is to be compared with data in a locally installed AVEVA product or locally available Excel spreadsheet.

   If data is to be compared using a service with data in another AVEVA P&ID product, or an Excel spreadsheet, the checkbox should be unchecked.

2. In the Source Selection group, from the list below the checkbox select the data source type. If the Local checkbox was unchecked, the list will consist of AVEVA P&ID and Excel. If the checkbox is checked, the list will consist of AVEVA Electrical, Instrumentation, Engineering and Schematics and Excel.

3. Once the source is selected, the user must then login to it (or in the case of a local Excel file, browse for the file). Click Login in the Source group. The appropriate login dialog is then displayed for the source. For example, is the source is AVEVA P&ID, the Select an AVEVA P&ID Project dialog is then displayed:

   

   Complete the login procedure as required. for example, for an AVEVA P&ID source, select the project for which the configuration will be created, edited or deleted, and click Select.

   For details of the various different login procedures, refer to Specifying Database Settings - Compare/Update Tab - Log In/Select a File.

   Note: Once the source has been logged into, the Login option changes to a Logoff option. This can be used to log-off from a source. The option then changes back to Login, and can be used again to login to a different source, such as a different AVEVA P&ID project

4. In the Source Selection group, from the bottom list, select the compare/update configuration or configuration group. The list will consist of the configurations and groups set up using the Compare/Update tab of the Options dialog for the selected data source type.

5. The compare operation will then take place. The results of this are then displayed in grids below the Compare/Update tab. For example:

   

   If a configuration group was selected, results for all the configurations in the group are displayed. For example:

   

   The rows which are matched are shown in the tab named after the selected data source. The attributes of these rows are shown in the Attribute Details tab.

6. To re-run the compare operation select the Refresh option in the Source group of Compare/Update tab.

   Note: The background colours of the rows indicate the status of the data in the rows, for example, new, matched, linked etc. Refer to Compare/Update Row Colours for the meaning of these colours and how to change then.

The current AVEVA P&ID database may now be updated with the differences found by the compare process. Refer to Update Data.

Source and target attribute values may be viewed side by side if required.