i4SCADA Knowledge Base

Using the Export Import Diff tool

Abstract

Learn how to use the i4SCADA Studio Diff tool to navigate and visualize the differences between database and the exported file.

The diff tool allows you to navigate and visualize the differences between database and the exported file.

  • White rows are the identical.

  • Yellow rows are present in database and in the file but some details differ. Changes can be seen in the Differences panel.

  • Red rows are present in the database but missing from the file (if red rows are marked for import they will be deleted from the database).

  • Green rows are present in file but missing from the database.

Organize below steps to start using the Export Import Diff tool:

  1. Open i4SCADA Export Import tool

  2. The login dialog is opened. Fill in your database credentials. Once the user credentials are filled in, the selection of Database is enabled and the desired Database can be selected.

    Login.jpg
  3. Press the button Login. The i4SCADA Export Import tool is opened. More details about the tool interface and the available options, you will find in article  i4SCADA Export Import Tool.

    Export_Import_tool_dialog.jpg
  4. Export your current Database, by clicking toolbar button Export.

  5. Save the XML Export file on your computer.

  6. Click toolbar button Diff, of the i4SCADA Export Import tool.

  7. Select the previously exported XML file, in the Open dialog and press button Open

    Diff_button.jpg
  8. The XML file is loaded in the Export Import tool and shows a progress bar for each loaded item, while running. 

    Diff_upload.jpg
  9. In case of failures, system stops the loading and displays a Failed status along with a Message for the failure.

    Failed_diff_load.jpg
  10. In case the Diff loads successfully all the Items, a pop-up window is displayed, where comparison between your Database and the XML file is shown. The interface is very similar with the Studio interface, split up in Signals, Alarms, Logging, Translations, Project Authorizations and Script Functions sections. 

    Diff_window.jpg
  11. Switch through each of the sections and identify the differences, based on the displayed colors: White, Yellow, Red and Green.