AVEVA Integration Import Configuration

At least one configuration must be setup and be available for selection before the Compare/Update facility is used.

To create and edit configurations, click Setup > AVEVA Integration Services > Import Configuration from the Project Tab.

• If a service has been configured, the following message is then displayed (for example):

  

  Click Yes to connect to the configured service.

  The Service Import Configuration Settings window is then displayed.

• If the service has not been setup, the Configure Integration Service Location window is displayed, which is used to edit (if required), test and save the service setup:

  

  Once this has been done, click Exit.

  The Service Import Configuration Settings window is then displayed.

  

  Note:
  To edit the configured service, click the Service button to open the Configure Integration Service Location window.

Login to Source

Once the source is selected, the user must then login to it. Select the Login button. The appropriate project selection and login dialog is then displayed for the source.

For example:

Select the project for which the configuration will be created, edited or deleted. Enter a password if required. Click the Connect button.

Choose Mode of Operation

Once the login is complete, the options in the main part of the window become available.

Note:
Once the login is complete, the Login button is replaced by a Logout button. Use this to disconnect from a project without exiting the window.

Create Configurations

To create a new configuration:

1. Select the Create new configuration option, and click Next >.

2. The following configuration settings are then displayed:

   

   The source data is the data that will be the basis of comparison.

3. Enter the name of the configuration in the Configuration Name field and select the element type that the configuration is concerned with from the Element Type list.

4. Enter or select a group name in the Group field. Similar configurations can be collected into groups if required.

5. The user can create different configurations for different types of elements such as Equipment, Pipes etc.

   Select the appropriate object type of the source elements from the Object Type Mapping list.

   Note:
   Instead of a specific object type, Database Views may be selected when setting up mappings to Dabacon source databases. Using a DBView will enable access to any referenced object in the Dabacon database.

6. From the Name Attribute list, select the attribute of the selected element type which is to serve as the name attribute of items in the source.

7. From the Unique Attribute list, select the attribute which is to serve as the unique key attribute of source items.

8. Click Next >. The following configuration settings are then displayed:

   

   The target data is the data in the selected AVEVA Electrical database. Target data is compared against source data.

9. From the Object Type list select the type of object in the target database.

10. Select the name and unique attributes that will automatically get populated in the respective fields.

11. If the Compare/Update procedure finds unmatched objects, it can create corresponding new objects in the target database. Check Allow Insertion if this is to be enabled.

12. Click Next >. The following configuration settings are then displayed:

    

13. Add filters to limit the population of source data that will be used in the comparison.

14. Click Add Filter to add a filter condition and specify its details in the row that is then displayed.

15. To add a further filter condition, select either the AND or OR "join" as required, then click Add Filter again and enter the second condition.

16. Continue until all required conditions have been entered.

    Note:

    For filter conditions IN and NOT IN user will have to provide each string value in "double quotes".

    If there are multiple values, then values should be comma separated (for example for the IN condition, multiple values can entered as follows "AAA","BBB","CCC", and in case of a single value as follows "AAA").

    In the case of integer values, users do not need to enter double quotes.

    For all other conditions, the user will provide only a single value. Double quotes are not required for string values and integer values.

17. To delete a condition, select it and click Delete Filter. To delete all conditions. check the Delete all filters checkbox and then click Delete Filter.

18. Click Next >. The following configuration settings are then displayed:

    

19. Click on Add Mapping to add an empty attribute mapping row to the list, then select the source and target attributes in the dropdown lists.

    Note:
    The list of destination (AVEVA Electricall) attributes available for mapping is restricted to those fields specified in the Integration Grid View associated with the AVEVA Electrical list that the data will be imported into. This is so that users are not required to scroll through potentially very long lists to find the required attributes. Refer to AVEVA Integration Grid Views for further information.

20. If the data source is an AVEVA Engineering project, additional attribute mapping options relating to units are available.

    • Remove unit

      If this checkbox is checked for an attribute, then the unit of that attribute will be removed and only the value will appear.

      For example, the units of a line size attribute may be removed (100mm to 100).

    • Replace unit

      To remove a part of an attribute value, enter the part which is to be removed f in the Replace unit field and select the Remove unit checkbox.

      For example, the units of a line size attribute may be modified from 100.00mm to 100 if ‘.00mm’ is entered. Replace unit must be used in conjunction with Remove unit.

    • Convert unit

      If the Convert unit checkbox is checked for an attribute then the unit for that attribute will be converted into another unit based on the list (Metric/Imperial Equivalent Sizes) of value provided in P&ID Administrator application.

      For example, the units of a line size attribute may be changed from millimetres to inches.

21. Select a mapping row and click Delete Mapping to remove it. To delete all mappings. check the Select All Mappings checkbox and then click Delete Mapping.

22. Click the Finish button.

23. A message is then displayed to inform the user that the new configuration has been created.

    

24. Click the OK button to complete the procedure.

Edit Configurations

To edit an existing configuration, select the Edit existing configuration option.

A list of existing configurations set up for the selected data source type is then displayed.

Select the configuration to be edited and click Next >.

Step 2 of the configuration process is then displayed, as described above. The Source Element data in this step cannot be edited, nor can the Destination Element data in step 3.

Use the Next > button to step through to steps 4 and 5. The source filter and attribute mapping settings in these steps may be edited.

Delete Configurations

To delete a configuration, select the Delete existing configuration option.

A list of existing configurations set up for the selected data source type is then displayed (see above). Select the configuration to be deleted and click Finish.

The selected configuration is then deleted.

Copy Existing Configuration

To copy a configuration, select the Copy existing configuration option.

A list of existing configurations set up for the selected data source type is then displayed. Select the configuration to be copied and click Finish.

The selected configuration is then copied. A message is displayed to confirm this. The copied configuration can now be edited as required.

Rename Existing Configuration

To rename a configuration, select the Rename existing configuration option.

A list of existing configurations set up for the selected data source type is then displayed (see above). Select the configuration to be renamed. Its name then becomes editable in the list field. Type in the new name, and click Finish.

The selected configuration is then renamed. A message is displayed to confirm this.