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.
Basic Input Columns
| Column | Description |
|---|
name | The name of the input. |
cacheLifetime.enabled | (optional) True if input caching is enabled for the input. |
cacheLifetime.interval.duration | (optional) The duration of the cache (ex 1 minute) |
cacheLifetime.interval.units | (optional) The units for the duration. Milliseconds, Minutes, Hours. |
template.name | (optional) Name of the templated input. |
template.type | (optional) Type of template; Static or Dynamic. |
template.reference | (optional) For Dynamic types only, the reference (ex. {{Connection.CSV.headers}}) |
template.params.paramName | (optional) Template parameters, where paramName is the template parameter name and the value is the range (ex. 1-10). Add a column for each parameter. |
qualifier.type | The type of OPC UA input. Valid types are Tag, Collection, or Method. This controls the remaining qualifier columns |
Tag Columns
| Column | Description |
|---|
qualifier.samplingInterval.duration | (optional) Override the default sampling interval for the tag. |
qualifier.samplingInterval.units | (optional) Units for the duration. |
qualifier.namespaceIndex | The namespace index for the tag (ex. 2) |
qualifier.identifierType | The type of identifier for the tag. String and GUID are the most common types. |
qualifier.identifier | The identifier for the tag. |
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.namespaceIndex | The namespace index for the tag (ex. 2) |
qualifier.collection.identifierType | The type of identifier for the tag. String and GUID are the most common types. |
qualifier.collection.identifier | The identifier for the tag. |
Branch Columns
Branches are much like single tags, but the reference is to an OPC UA branch.
| Column | Description |
|---|
qualifier.namespaceIndex | The namespace index for the tag (ex. 2) |
qualifier.identifierType | The type of identifier for the tag. String and GUID are the most common types. |
qualifier.identifier | The identifier for the tag. |
qualifier.maxDepth | (optional) Max depth to browse and read. 0 means one level, 1 means two levels, etc. |
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.ignoreBadQuality | (optional) Enable to ignore bad quality values. |
Method Columns
| Column | Description |
|---|
qualifier.namespaceIndex | The namespace index for the parent object that has the method (ex. 2) |
qualifier.identifierType | The type of identifier for the parent object. |
qualifier.identifier | The identifier for the parent object. |
qualifier.method.namespaceIndex | The namespace index for the method. |
qualifier.method.identifierType | The identifier type of the method. |
qualifier.method.identifier | The identifier for the method. |