Import/Export Functionality\ \ \

As of Automation_Builder 1.1 (CBP >= 2.4) configuration of control stations and substations can be exported/imported via CSV file. Open the CSV file with a spreadsheet software (e.g. Microsoft Excel) and modify the values within the file to your convenience:

  1. Export configuration data: right-click the node of the control station or substation to be exported.

    ⇒
    ../_images/9b3791455f9898ab0a33139000c361dc1
  2. Click Export ‣ IEC 60870-5-104 information objects (CSV) and store the CSV file

    to a desired directory.

  3. Open the CSV file with a spreadsheet software (e.g. Microsoft Excel) and change the values to your convenience. Added table columns are only accepted after the last column.

  4. Import configuration data: right-click the node of the control station or substation that has been exported previously.

  5. Click Import ‣ IEC 60870-5-104 information objects (CSV) and select the CSV file

    from the file system. Configuration data is imported.

As of Automation_Builder 1.1.1 during file import the project data is compared with the project data that is already available. In order to prevent data from being overwritten inadvertently, you can select the data that shall be imported in the Project Compare - Differences window:

../_images/3530fb475f98ba7d0a33139001ae531e1

Data on the left side of the window refers to already available project data. This data is displayed under Control station ‣ Information objects tab. Data on the right side of the window refers to new data that can be imported after your confirmation. Decide whether to import (and overwrite) the data or not.

  • Data in black color means the existing data and the data to be imported is identical.
  • Data in red color means the existing data and the data to be imported differ. Decide whether to import the new data (and to overwrite the existing data) or not.
  • Data in blue color means, the data to be imported is new and will be added to the existing data.
  • Data that has been confirmed for the import already is displayed in green color (after clicking the Accept Single button).

In order to move data from one side of the window to another, select the data and click the Accept Single button. Data is highlighted in yellow.

../_images/fc6273bf5f98df990a33139001f8126e1

To confirm the import of all new data, click the top entry (here: All: ASDU name - ASDU tpye - Common addr - …). Then, click the Accept Single button.

Close the Project Compare - Differences tab, save your project and confirm the message. The changes are displayed in the Information objects tab.

../_images/c49350185f98cf830a331390011d74911