OPC-UA CSV Import

OPC UA supports importing inputs from a CSV file. This section covers the import format. Below the columns for different inputs types as well as the common columns are outlined. A single CSV file can include all types by including all columns and leaving columns empty for a given row if it does not apply.

Limitations

  • OPC UA Connections in “Path” addressing mode are not supported
  • OPC UA Event and Method inputs are not supported
  • Template, Parameters, and Input Cache settings are not supported

Basic Input Columns

Column Description
name The name of the input.
qualifier.type The type of OPC UA input. Valid types are Tag, Branch, or Collection. This controls the remaining qualifier columns.

Tag Columns

Column Description
qualifier.collection.identifier.type Required. Must be NodeId.
qualifier.identifier.namespaceIndex The namespace index for the tag (ex. 2).
qualifier.identifier.identifierType The type of identifier for the tag. String and GUID are the most common types.
qualifier.identifier.value The identifier for the tag.
qualifier.samplingInterval.duration (optional) Override the default sampling interval for the tag.
qualifier.samplingInterval.units (optional) Units for the duration.
qualifier.isComplex (optional) Enable to include meta data with the tag.

Collection Columns

Collections are expressed as multiple rows, where the first row includes the Basic Input Columns and the first tag in the Collection. Proceeding rows leave the Basic Input Columns empty and fill in the collection columns with the remaining tags in the collection

Column Description
qualifier.collection.name The name of the tag in the collection.
qualifier.collection.identifier.type Required. Must be NodeId.
qualifier.collection.identifier.namespaceIndex The namespace index for the tag (ex. 2).
qualifier.collection.identifier.identifierType The type of identifier for the tag. String and GUID are the most common types.
qualifier.collection.identifier.value The identifier for the tag (ex. tag.path).
qualifier.samplingInterval.duration (optional) Override the default sampling interval for the tag.
qualifier.samplingInterval.units (optional) Units for the duration.

Branch Columns

Branches are much like single tags, but the reference is to an OPC UA branch.

Column Description
qualifier.identifier.type Required. Must be NodeId.
qualifier.identifier.namespaceIndex The namespace index for the tag (ex. 2).
qualifier.identifier.identifierType The type of identifier for the tag. String and GUID are the most common types.
qualifier.identifier.value The identifier for the tag (ex. tag.path).
qualifier.cacheInterval.duration (optional) How often to refresh the browse hierarchy.
qualifier.cacheInterval.units (optional) The units for how often to refresh the browse hierarchy.
qualifier.maxDepth (optional) Max depth to browse and read. 0 means one level, 1 means two levels, etc.
qualifier.browseVariableNodes (optional) Disabled by default. Browses variable node types.
qualifier.ignoreBadQuality (optional) Enable to ignore bad quality values.
qualifier.isComplex (optional) Enable to include meta data with each tag in the branch.