alistair. frith

Basic web API usage

I'm trying to write a little tool to put data into Canary tags through the Web API but am hitting my lack of knowledge on such things. Looking at the endpoints in the Identity tile,…

Collecting data from a Web API (api.openweathermap.org)

We want to collect local weather information from openweathermap.org and store it in Canary. I could write a little tool to get the data and put it into a CSV for Canary to read with the CSV…

Date/time arithmetic in Calculations

Apologies if this is a silly question or if I'm repeating something I've already asked (I'm sure I asked something like this a while ago) but what is the best way to do date and time arithmetic in…

Asset properties question

We have a database monitoring solar PV generation. We have several inverters, each connected to several strings of solar panels. We want to monitor the output of each string of panels and compare…

Dataset storage questions

I'm trying to understand how Canary 'knows' what tags it has. As far as I can tell, if a collector sends data for a tag name then that tag is created in the relevant dataset file for that day,…

• Answered

SQL connection issue for tag attributes in views configuration

I have a test installation with data in a SQL database that is already sending time-series data through the SQL collector. I'm trying to connect to the same DB in the Views configuration to pick up…

Rollup calculation syntax

I'm trying to create a rollup calculation but I don't really understand he syntax and I can't find any examples. I have a virtual view with these asset types: one Company, with multiple Sites,…

• Answered

Asset hierarchy definition help

I have a dataset populated by a CSV collector and I am trying to create a virtual view to put the tags into an asset hierarchy. The tag names are of the form CsvTag.<site>.…

• Answered

UFL collector fails to start

I have installed the UFL collector, following https://helpcenter.canarylabs.com/t/m1y8gkj/how-to-configure-the-csv-collector-version-24 but after installation, the install folder looks different:…

• Answered

Calculations stuck in Backfilling

I have several calculations that are stuck in 'Backfilling' and never go to Live Mode. This obviously means calculations that depend on them can't start.…

• Answered

Button or link to a specific page within another application

I see that a button can link to another Axiom application, but I want to go to a specific page within that application rather than just the first page. Is this possible either with a button or a link…

• Answered