Creating a CSV import file - OPC Client 3.1

OPC Client Plugin Guide 3.1

series
OPC Client 3.1
revised_modified
2019-03-25

Create a CSV file to map OPC tags to the properties defined in the XML type definition file, so that entities can be created in Security Center.

What you should know

  • Use a spreadsheet application, such as Microsoft Excel, to create and edit the CSV file. If you use Microsoft Word, the auto correct feature might remove commas that are required for the CSV to be valid.
  • Read the rules for creating a valid CSV file.
  • You can refer to Template.csv.template, which is located in $\Program Files (x86)\Security Center Plugins\OPCClient\Extensions.

Procedure

  1. Open a spreadsheet application like Microsoft Excel.
  2. In the first row, enter the CSV headers listed in Headers in the CSV import file for OPC Client.
    Most of the headers are mandatory and must be included. You can omit the optional headers, if they are not used by any of the entities listed in the file.
  3. For each OPC entity, add a separate line for each property (PROPERTY_ID) that you want displayed in Security Center.
    In the following example, an OPC entity named EntityA has two properties, Property1 and Property2. Notice that the ENTITY_NAME and TYPE_NAME are the same for both lines that define the properties of the same entity.

  4. Save the file as a CSV (comma separated values).
    OPCEntities.csv

    You can save the file to any location on your network that the plugin server can access.

After you finish

Import the entities.