Import, Compare and Update Data

To import data, and to compare and update data, use the facilities in the Service Integration group of the Manage Tab in AVEVA Instrumentation.

1. Select the product from which data is to be imported from the Products list, and the click Connect.

2. Select the configuration group from the Group list. If the required group is not available, the list may be refreshed by clicking Refresh Groups.

   Note: A configuration must have been setup for the selected product and group. Refer to AVEVA Integration Import Configuration for details.

   Two import options are available:

   • The Standard Import during which imported data is compared with existing data and the results displayed for you to view and either accept or reject.

   • The Quick Import which skips the compare stage of the import. All data is automatically accepted for import.

Standard Import

3. Click Import Data.

   The results of this are then displayed in the Compare/Update window. For example:

   

   The imported objects shown in the tab named after the selected data source. By default, 1000 records are displayed at once.

4. Use the Next button to view the next page of records, and the Previous button to view the previous page.

   The current page and total number of pages is displayed next to these buttons.

   Note: The number of records displayed per page is controlled by the No of records per page setting on the Integration Settings tab of the Preferences window in AVEVA Instrumentation Engineer.

   Note: The background colors of the object rows indicates the status of the objects in the rows. For further information on the meaning of these colors and how to change them, refer to Specify Compare/Update Row Colors.

5. To view all the attributes of a specific object, select the All Mapped Attributes option from the Side-by-Side View menu (see above). To view only attributes that have different source and target values, select the Differences Only option instead.

6. To select an object to be imported, check its Accept checkbox. To check all of the Accept checkboxes, click Accept All.

   The attributes of all the objects are shown in the Attribute Details tab.

   

   This tab displays the attributes of source objects alongside the attributes of the source (AVEVA Instrumentation) objects.

7. The Accept checkboxes of objects that have their Accept checkboxes checked on the other tab are checked automatically. Check and uncheck attribute checkboxes as required.

8. When all required Accept checkboxes are checked, click Update Database to import the selected data.

   The Update database dialog is then displayed:

   

   The window displays a summary of the changes that will be made to the database.

9. To implement these changes, select the UpdateDB button.

   The update then takes place. A summary of the changes is then displayed:

   

10. Click Close to exit the window.

Quick Import

11. Click Import Data > Quick Import.

    The import then starts immediately, without going through the compare process as described above. All valid data is accepted for import automatically.

    The import first fetches data on the records in the selected database. The Quick Import pop-up displays the progress of this process:

    

    The Update database window is then displayed:

    

    The window displays a summary of the records in the selected source database and changes that will be made to the AVEVA Instrumentation database if these are imported.

12. To implement these changes, select the UpdateDB button.

    The update then takes place. The Quick Import pop-up displays the progress of this import:

    

    Once the import is completed, the following is displayed:

    

13. Click OK.

    A summary of the changes is then displayed:

    

14. Click Close to exit the window.