If you prefer not to browse the OPC UA Server to add tags to an OPC Collector logging configuration, you can instead copy and paste data from an Microsoft Excel table.
To begin, ensure your Excel document has column headers that match the headers in your logging group. By default those headers are 'CANARY TAG NAME', 'OPC NODE ID', 'TYPE', 'DEADBAND', and 'TRANSFORM'.
Note, in OPC UA sessions you can add multiple other meta deta properties which then become column headers. To do so, use the "TAG PROPERTIES" button above and to the right of the logging group table. You will need to create these columns prior to pasting the data from Excel.
Reading tags and Node IDs from your OPC UA Server and moving that data to Excel can be difficult without proper documentation for the OPC UA Server. The majority of OPC Servers will list the Node IDs within their configuration menus, however, not all do.
Once you have located the OPC Node ID's, paste them in the Excel sheet .
The Canary tag names can be derived from the Node ID's. To populate the tag names you will need to identify and copy the Node ID structure, for example:
OPC Node ID=
Canary Tag Name=
The Excel tool 'Text to Columns' can be used to isolate the tag name based on the '.' that precedes it. Find this tool under the 'Data' section of the Excel menu bar. In the above example, we would use the 'Delimited' setting and set our Delimiter to 'Other:' and indicate that we want to split the cell content at the '.'
Additionally, once you have populated tag names, feel free to adjust the tag name as desired.
Finally, enter data for the other columns, including TYPE and DEADBAND.
TYPE default is 'ServerDefault' and DEADBAND default is '0'. Both can be configured as necessary.
Once your table is complete, select all the row numbers you wish to copy. Do not select the column headers! With all the rows highlighted, use CTRL+C to copy the table.
Within the Canary Admin, select the OPC Collector panel and go to 'CONFIGURE'.
Create a new Session and enter the Session Settings below.
Click on the Group you wish to configure, by default this would be 'Group -1'
In the 'TAGS' window, click the button 'PASTE NEW', located in the upper right corner.
As long as the tags are formatted correctly the collector will accept the table. Verify the data is in the correct columns.
If you need to delete a row, click on the empty cell to the far left of the row. The row should highlight yellow. You can now click the 'REMOVE' button at the top of the window. You can also use the Shift key to multi-select rows or select the entire table by clicking the grey cell at the very top left corner of the table.
When finished, click 'APPLY' on the red bar at the top of the window to accept all changes. Begin logging when ready.