-
Querying the Historian using a Linked Server in Microsoft SQL Server (version 24)
Configuring the Linked Server Ensure the ODBC Service is installed/licensed on the Canary Historian and the ODBC client is installed on the SQL server. Open Microsoft SQL Server Management Studio and…
-
Consume csv files without the Engineering units row
Hi everyone, I have an operator's logs screen in Ignition processed as a dataset, which I later export as a csv file for Canary's csv collector to consume.…
-
Connecting Canary to Power BI (version 24)
This article will take you through the process of reading data out of the Historian and into Power BI using Canary's web Read API. The Read API connects to the Views secure endpoint (55236) over…
-
Connecting Canary to Power BI (version 25)
This article will take you through the process of reading data out of the Historian and into Power BI using Canary's web Read API. The Read API connects to the Views secure endpoint (55236) over…
-
Edit Tag Properties from Views Tag Property Pane
Currently you can only view the properties in the Views Property Pane for a selected tag. It would be nice to be able to edit values of properties right from the pane
-
Tag Creation
Tag creation should initialize to a zero value.
-
Data Type return from GetTagData, GetTagData2 WebAPI Methods
Would it be possible to add an additional return parameter "Data Type" to the GetTagData, GetTagData2 WEB API methods? This seems to be available as an option from within the Excel Addin when I use…
-
How to Get Tag Data type via the API
Is there a way to get the data type of a tag via the Web API, or even a way to export the tag data type manually. I am trying to integrate with Canary with the Seeq analytics application?…
-
Release V22.3.3
Requires Ignition 8.1.5+ Released on: 5/3/2023 Bug Fixes Fixed issue with reading Boolean tag history.
-
Scripting value box property changes with an asset template
I have some controls at the top where users can select a date and shift. I have scripting on the controls to update the aggregateinterval and aggregatestarttime on some value boxes.…
-
Save controls when changing asset type in Asset Template
Right now, when you create an Asset Template with a specific asset type, then change that asset type, all controls inside of the Asset Template Panel get removed.…
-
Embed the URL of the application or chart in an automated report
Include the URL of the application that created an automated report in the report. This would allow users to quickly open the application and conduct further analysis if needed.…
-
Limits on a Bar Chart
Add controls to show limits on a bar chart. The bar will change colors based on whether its above or below the limit(s). For instance, say I have a target of 50 widgets per hour.…
-
Sunsetting Services
Starting in version 24, the following applications will no longer be included or compatible with the rest of the Canary suite: Mirror HDA Server Trend Link If wishing to use these services,…
-
Publisher
Open Canary Admin application Select Publisher tile Click 'Configuration' from the bottom tab menu Select 'NEW' Configure based on the information below,…
-
ODBC Driver - Auto Pivot Option
Is it possible to add a feature in Canary ODBC driver that automaticly pivots the tag names to columns. See the SQL PIVOT below. SELECT * FROM ( SELECT tag_name, time_stamp,…
-
Specifying timestamp in MQTT payload
Hello, I have an MQTT SpB payload coming in from HighByte where one of the fields is a "Date & Time". Is there a way to have Canary take this value as the timestamp and not the value of the…
-
Cross Reference Table to turn operator id number into name
We have a tag with the numeric employee number of the operator on the machine. We have a simple table (e.g. Excel file) with columns for that number and the employee name.…
- Answered
-
Configuring the Canary System to Send Email Alerts (version 23)
By configuring the Canary System to send email alerts, users can be notified if: a DataSet stops receiving data for x minutes disk space is running low a data file was improperly closed and taken…
-
Configuring the Canary System to Send Email Alerts (version 25)
By configuring the Canary System to send email alerts, users can be notified if: a DataSet stops receiving data for x minutes disk space is running low a data file was improperly closed and taken…
-
Configuring the Canary System to Send Email Alerts (version 24)
By configuring the Canary System to send email alerts, users can be notified if: a DataSet stops receiving data for x minutes disk space is running low a data file was improperly closed and taken…
-
Removing commas from string values shown as numbers
I have a tag that is setup as a string but in Events in Canary shown in Axiom using an event table control, it is shown with commas. Is there a way to setup my event property calculation or…
-
Aggregate Interval Picker
I have 2 x DateTime pickers that return the start and end values of motor run hours correctly in 2 x Value Boxes. I need to either:- Subtract ValueBox1 From ValueBox2 and put results into ValueBox3…
-
Time-zones in chart URL parameter
Dear Canary team, It would be nice to be able to specify the timezone for the TimeEnd parameter in the Chart URL, similar to how the API format supports timezone format.
Welcome to the community!