-
Excel Add-In Only pull when needed
Right now, if I pull historical data for the previous month (say, raw values). Then I go to a new cell and type in '=1+1'. When I hit enter, Canary will repull the previous month data.…
-
Excel Add-In Missing API Token Option
I've been trying to connect through Excel. I'm on the same local network, have the admin client installed on this same machine and I can access the admin service and see the main historian machine.…
- Answered
-
Custom defaults for Add-In settings
I know it's all personal preference, but for my customers and I, it feels like the default settings applied to a new data pull (like Processed Data) are always the exact opposite of what we want.…
-
Search for tags by properties
In Axiom, if you enable properties in the tag picker list, search queries will look in both the tag name and the properties (like description). In the Excel Add-In,…
-
Defined Method for Editing Excel Add-In Data Pull
If I pull data into Excel using the Add-In, then I want to edit it. My options are to edit the formula directly, or, select a cell in the output array, then select a button at the top (and I have to…
-
v24 Excel Locked if user doesn't authenticate
If a user opens an Excel v24.0.1 workbook, or opens a new workbook and interacts with the Excel Add-In, it will open a browser. If the user closes the browser without authenticating (not knowing what…
-
Cache Credentials
I don't know if that's exactly the right term. But with Kerberos of OpenID authentication, laptops and machines usually have the ability to cache credentials.…
-
Aggregate List (version 24)
Aggregates According to the OPC Foundation, aggregates "are methods that summarize data values. Common aggregates include 'average over a given time range', 'minimum over a time range',…
-
Settings (version 24)
The Settings function allows the user to choose which Historian to connect to as well as the time zone in which to present data. The endpoint must be set before any requests can be made.…
-
Option to filter raw/processed data
In Canary's Excel Add-In, we would like to be able to get the raw or processed data for one tag based on a filter expression. For example, I want to see the values of RSX-02.…
-
Canary Excel Add IN LINK for download
This website has not been too clear on how to download the canary plug in for excel. Can someone please help me? I have the axiom desktop (which is not letting me log in - as soon as I click enter…
-
Field labels in Canary Excel Add-In difficult to read with "Dark Gray" office theme
This might be more of an MS Office issue than it is Canary where Excel doesn't use the write label text color to play nicely with the Dark Gray office theme but I noticed it looked like this (white…
-
Find Events (version 23)
The 'Find Events' function returns any events that have been pre-configured within the Canary Admin (See How To Create An Event). Event Type Will return any event type that matches the specified…
-
Find Events (version 22)
The 'Find Events' function returns any events that have been pre-configured within the Canary Admin (See How To Create An Event). Event Type Will return any event type that matches the specified…
-
Find Events (version 24)
The Find Events function returns any events that have been pre-configured within the Canary Admin (See How To Create An Event). Event Type Will return any event type that matches the specified event…
-
Google Sheets Plugin
Add a plugin for Google Sheets.
-
ComAddin Error with Excel
Excel displays a security warning and returns a ComAddin Error after installing Canary's Excel Add-in. How can I resolve this?
-
Set Endpoint (version 23)
Before the user can request data from the Historian, the client must point their add-in to the Views service residing on the historian server. This initial set up should only need configured once…
-
Set Endpoint (version 22)
Before the user can request data from the Historian, the client must point their add-in to the Views service residing on the historian server. This initial set up should only need configured once…
-
Getting Started (version 24)
Installing the Add-in Run the CanaryInstaller-*.*.*.exe and select Custom Install. Select Excel Add-in and deselect any other components if only wishing to install the Add-in.…
-
Overview (version 24)
The following is a brief description for each function contained within the Excel Add-in. Tag List - creates a tag list to be used in other add-in functions Tag Properties - returns all property…
-
Overview (version 22)
The following is a brief description for each function contained within the Excel Add-in. Tag List - creates a tag list to be used in other add-in functions Tag Properties - returns all property…
-
Overview (version 23)
The following is a brief description for each function contained within the Excel Add-in. Tag List - creates a tag list to be used in other add-in functions Tag Properties - returns all property…
-
AdHoc Events (version 23)
The 'AdHoc Events' function allows the user to search for events on the fly that are not already configured within Canary's Calcs & Events service. View Select an available 'View' from the drop down…
-
AdHoc Events (version 22)
The 'AdHoc Events' functions allows the user to search for events on the fly that are not already configured within Canary's Calcs & Events service. View Select an available 'View' from the drop…
Welcome to the community!