Engineering Data

In order to create instances of IEC61850 devices, you must create the engineering data in the form of a comma-separated value (CSV) file. A CSV file contains data in which values are represented as text and separated using a separator such as comma a (,). The file in the CSV format can be edited in text editors such as Wordpad or Notepad. More elaborate editing can be done using advanced word processing tools, like Excel. The Importer can only parse CSV files which use a comma (,) as a separator.

The CSV file contains mandatory, as well as non-mandatory data. The following table provides more information related to the parsing of data with reference to mandatory and non-mandatory information in the CSV file.

Error Condition

Result

Value of a mandatory field is incorrect in a CSV file row

The data in the entire row is not allowed for import.
The information is logged as an error message in the Analysis Log and Trace Viewer.

Value of a mandatory field is blank in a CSV file row

The data in the entire row is not allowed for import. Information is logged as error message in the Analysis Log and Trace Viewer.

Value of a non-mandatory field is incorrect in a CSV file row

The value of that particular field is not allowed for import. However, the other values in the row are imported. Information is logged as a warning message in the Analysis Log and Trace Viewer.

Value of a non-mandatory field is blank in a CSV file row

The entire row is imported. However, if the Discipline or Type fields are empty, then the corresponding Subdiscipline and Subtype fields are ignored. This information is logged as a warning message in the Analysis Log and Trace Viewer.

For some mandatory fields, such as Port Number, if the value is not entered or is incorrect, then the default port value of 102 is used and the data for that row is imported, as long as all the other mandatory fields have correct data.

The Importer parses the CSV file row by row and imports the data in that row if it does not have any of the above mentioned error conditions. On successful import, the objects are created below the IEC61850 network node in the System Browser.

Validations for Parsing the CSV File Entries for Device Connections

  1. If the number of tokens is less than the required number, which is essential for validation (in this case, 6), then the line is invalid.
  2. If the token value is empty or null, then it is treated as invalid.
  3. If the given device connection name contains invalid characters, then it is treated as invalid.
  4. If the given device connection name contains special characters other than underscore( _ ), then it is treated as invalid.
  5. If the given device connection name already exists in the same CSV, then the newer entry of the interface is treated as invalid.
  6. If the IP address token is not in the format xxx.xxx.xxx.xxx where xxx is 0 through 255, then it is treated as invalid.
  7. If the port number is of a type other than a number, then it is treated as invalid.

 

Validations for Parsing the CSV File Entries for Logical Devices

  1. If the number of tokens is less than the required number which is essential for validation, then the line is invalid.
  2. If a token value is empty or null, then it is treated as invalid.
  3. If the given logical device name contains invalid characters, then it is treated as invalid.
  4. If the given logical device name contains special characters other than underscore( _ ), then it is treated as invalid.
  5. If the given logical device name already exists in the same CSV file, then the new entry is treated as invalid.
  6. If a token value is empty or null, then the value is ignored.
  7. If an ObjectModel that is mentioned in the CSV file does not exist in the system, then it is treated as invalid
  8. In the CSV file, if only the device connection or logical device entries are present, then those entries are ignored.
  9. If any logical device entry is present above Device Connection entry, then that device entry is ignored. A Logical Device is always present below the Device Connection entry.
  10. If two consecutive entries of Device Connections are present without the logical device entry below the second Device Connection entry in the CSV file, then both the Device Connection entries of the Device Connection are ignored.
  11. If two consecutive entries of Device Connections are present with the logical device entry below the second Device Connection entry in the CSV file, then first entry of the Device Connection is ignored.
  12. If there are any logical device entries present without parent entry of the Device Connection, then those logical device entries are ignored.
  13. There can be multiple logical device entries under a Device Connection entry in the CSV file.