Questions & Answers Category

Conditional Regex - Add a space?

There might be an obvious answer that I'm missing, but I've got a minor issue and I'm hoping there's a simple way through it. We have a DataSet in which the tag names either just say what they are,…

Transfer historical data from Wonderware Historian to Canary Historian

Is it possible to transfer historical data from Wonderware Historian & continue to store the same tags in the canary historian ?

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,…

Linear gauge scripts for start time and scale max

Hello, I am trying to use scripts to use a date time picker value as the start time for a linear gauge and a value box as the scale max in the same linear gauge, but I am getting errors for both.…

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…

Connecting to Axiom Via Talk2M Connection

We are currently running Canary version 24 on our PLC. For security purposes, the PC with the server is not connected to the internet. I am trying to connect the client to remote computers that are…

Axiom Time Stamp Math

Hello All, I am building a data source diagnostics page in Axiom and would like to calculate the age of the last TVQ for each data source. I have two parts of this I am having trouble with.…

Using custom time picker entries in value boxes

Is it possible to use the custom time picker entry as the aggregate interval or aggregate start time values in a value box? i.e. use the start time of the custom time picker as the aggregate start…

Obsolete Tags

Hi, I have a tag that I deleted, however, I want to use the name of this tag without resetting the old data, how can I do it? Thanks

A tag that's value is the year data started

This is related to not being able to manually create tags. For filtering reasons in Axiom, I want to be able to have a tag that's value is the year the tags were added (i.e.…

v24 Axiom does not maintain imported Chart title

In Axiom v23, if you imported a Chart into a Trend Graph control in an application, the default title would be the path/name of the imported chart. If you do the same thing in v24,…

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

EventTable Download Option

Hi, I have created some event calculation and made some Event Properties to be calculated when the event trigger. Is there any option to send the event report to client with event property data.…

• Answered

Mapping Windows External Groups to Canary Group v24

We've installed a new v24 Canary server and I'd like to know if there is a way to map our existing Windows Groups to Canary Groups in Identity ahead of time? I was able to map one that I belong to,…

• Answered

Duration a Tag is Greater than a value

Hello, I am trying to create a calculation that will tell me the total time in the last 24 hours when a tag has a value greater than a set value (example 50) Has anyone done this already?…

Search Filter in MQTT Tags Working Correctly?

It seems to be ignoring slashes and auto-wildcard on spaces. You can see in this screenshot the tag path search does not match correctly. "BESSs/BESS 6/" seems to be converted to "*BESSs*BESS*6*"

Restrict Data Type in Data Entry Control

Is there a way to restrict values entered into a Data entry Control? For instance, I only want people to put a 0 or a 1.

Automatic sign in to Canary Admin when authenticated to Windows AD

With our v23 Canary install, launching Canary Admin while logged into our AD it automatically authenticates us to the app and we're not prompted to sign in.…

• Answered

MQTT payload includes ALL Tags of view, want to create one topic for each Tag

Hi. When i publish data coming from a view, using jsonmqtt, via publisher, i am getting one topic on the MQTT Server including all datapoints. Is there a configuration possibility to publish…

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…

Pass Asset Type up to Dependent View

We have 2 business units, each with their own slightly different View. Then we have a 3rd View that combines them. From my testing, if I create an Asset Rule in a View,…

Need help with simple script to change IsVisible property

I am looking for some help with a simple script to set the IsVisible property of a Symbol. For instance, let's say The source of the Symbol1 is set to a value box (ValueBox1),…

Possible to Correct Timestamps?

One of our sites had an issue where it wasn't syncing to our NTP server properly for a few days so all our data for those days is in UTC time instead of local.…