This video shows how to use the “IP Data Query” tab.
Clicking “Current Value” allows you to configure a request to get the current value for some tags.
This will insert the result of the query you entered at the currently selected point in the spreadsheet.
If the data source you want to query isn't listed it may be because it's not authorized, it doesn't support tag read operations or you aren't authorized to read from the data source.
Clicking “Historical Values” allows you to configure a request to get the historical values for some tags.
This will insert the result of the query you entered at the currently selected point in the spreadsheet.
If the data source you want to query isn't listed it may be because it's not authorized, it doesn't support tag read operations or you aren't authorized to read from the data source.
Clicking “Write Data” allows you to write a value to a tag in a data source.
If you don't see the data source you want to write to listed it may be because it's not authorized, it doesn't support write operations or you don't have permission to write to that data source.
The write all button allows you to write multiple values to multiple tags instantly.
In order for this to work you must setup the workbook to have certain defined names. To setup a defined name:
You can edit these names later by clicking “Name Manager” then selecting a name and clicking “Edit”
To configure the “Write All” action created the following defined names:
Each value in the Values range will be written to the corresponding tag in the Tags range. Tags whose corresponding Values cell is empty will be ignored.
All text boxes can be evaluated as a formula if they begin with “=”
You can use the “Custom Tag” box to add tags that aren't listed, this is primarily useful if you want to query Alarm Analysis Meta tags.
Deselect “Enter As Formula” if you would like the result of the query to be added directly to the sheet. Leaving it selected generates a formula as described in the “Using Data Query Formulas” section