i4SCADA Knowledge Base

 Export Import Diff Tool

Abstract

The Diff Tool is integrated in the Export Import Tool with scope to display differences between the database information and the XML file.

The Export Import Diff Tool displays differences between the information in the database and the information in the xml file and allowing to select just certain selected information to be imported.

The Diff tool uses the Green-Yellow-Red color code to mark the items with different statuses:

  • Green - items that exist only in the xml import file.

  • Yellow - items that exist in the database and in the xml import file, but have different data.

  • Red - items that don't exist in the database, but exist in the xml file.

The function of the Diff tool is synchronizing the selected items between the database and the xml file.

Capture55.jpg

Diff tool synchronization mode

Main View

In the main view, the items from the database and the xml file are displayed in a grid. Each of the grids column represent a property of the item.

The main view will display the items that correspond to the selected category. The functionality of the main grid stays the same, even if the category is changed. It is not category-bound.

Capture1352.jpg

Diff Tool main view

The differences between the database and the xml file are outlined using the color code:

  • Green - items that exist only in the xml import file.

  • Yellow - items that exist in the database and in the xml import file, but have different data.

  • Red - items that don't exist in the database, but exist in the xml file.

The user has the ability to mark any item for synchronization (File > Synchronize the checked items).

Capture1353.jpg

Diff tool main view

Differences panel

In the Differences panel, the details of an item that are not shared by the database and xml file are displayed.

The Differences panel displays the properties that have different values in the database and xml file for any item. Like the main view, the panel is not category-bound.

The Differences panel opens when an item that has different values for a property in the database and xml file. If the item has the same values for its properties in both database and xml file, the Differences panel will not open.

Capture1354.jpg

Differences panel

UI Option

Description

Property

The property that is not shared by the database and xml file.

File Value

The value of the property in the xml file.

Database Value

The value of the property in the database.

File Menu

The File menu allows the user to Import, Update or Delete items based on their status.

Capture44.jpg

Diff Tool - File Menu

UI Option

Description

Synchronize the checked items

Synchronizes the items that are selected (checked) based on their status:

  • Imports the items that are existing only in the import file.

  • Updates the items with the data from the import file.

  • Deletes the items that don't exist in the import file.

Capture45.jpg

Synchronize the checked Items

Synchronize all items

Synchronizes all the items (checked and unchecked) based on their status:

  • Imports items missing from the database.

  • Updates items from the database with data from the import file.

  • Deletes items missing from the import file.

Capture46.jpg

Synchronize all Items

Close

Exits the application.

Categories

The Diff tool category menu shows the categories and subcategories of items (signals, alarms, logging conditions, etc) from both database and xml file.

When a subcategory is selected, the contained items are displayed in the main view (using a grid) and the differences between the database and the xml file are outlined.

Capture48.jpg

Categories

Category

Subcategory

Signals

The structure of the Signals tab follows the one from the Studio, the items being listed in the same structure:

  • Server

  • Write Groups

  • Discrete Values

  • Discrete Value Types

Capture49.jpg

Signals

Alarms

The structure of the Alarms tab follows the one from the Studio, the items being listed in the same structure:

  • Alarm Groups

  • Alarm Types

  • Alarm Conditions

  • Alarms

Capture50.jpg

Alarms

Logging

The structure of the Logging tab follows the one from the Studio, the items being listed in the same structure:

  • Log Conditions

  • Logging

Capture51.jpg

Logging

Translations

The structure of the Translations tab follows the one from the Studio, the items being listed in the same structure:

  • Languages

  • Symbolic Texts

  • Text Translations

Capture52.jpg

Translations

Project Authorizations

Capture53.jpg

Project Authorizations

Script Functions

Capture1350.jpg

Script Functions

Properties filtering

The main view grid offers the possibility of filtering the items by their properties. The filtering is done by clicking on the Capture60.jpg button, under the columns header.

Capture1355.jpg

Properties filtering

The filter allows the user to use several operators for filtering, including regular expressions and wildcards.

State filtering

The listed items can be filtered by their state:

  • Database items

  • Detail mismatch items

  • File items

  • Same items

  • Only different items

The state filtering option is located in the status bar of the Diff tool, next to the Legend.

Capture1376.jpg

State filtering

Legend

The Diff tool legend is located in the bottom status bar. It displays the explanation of the color code.

Capture63.jpg

Legend