Best Practices

Best Practices for Importing Historical Data from CSV Files

I’m planning to import a large number of CSV files containing historical data into our system. To ensure a smooth process, I’d like to understand the best practices for this import.…

Exporting Large Volumes of Raw Historian Data Efficiently via Canary API

I'm working on exporting a large amount of raw historian data using the Canary API (/getData2) over a long time range. Due to the tag count limitations per API call,…

Most efficient way to export large volumes of data with API

I’m working with a customer who needs about six months of historical data at a 10-second resolution for approximately 1,200 tags. I'm writing a script using continuation to retrieve the data,…

Value Box AggregateInterval/AggregateStartTime Configuration

What is the best way to configure AggregateInterval and AggregateStartTime to accurately display the current shift's total production and current total load count?…

Ignition - Backfill data from SQL database

We are hoping to use Canary historian for our existing Ignition system but are concerned about access to our existing data. Does anyone know if there's an accepted way to backfill existing data from…

• Answered

Remote Historian/Views/Architecture Options

I have multiple historians and a remote Axiom server. Is it better for Axiom to be pointed at a local Views instance which is connected to the remote historians,…

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…

Events Table Optimization

We are trying to optimize performance of the Events and Event Properties table, is it advisable to add Indexing and table partitions to achieve this?

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

Scaling on Virtual View

Hi all- I currently have some tags I am historizing that have a different scale associated with them as I store (10x / 100x / 500x). I am currently using virtual views and I am looking for a way to…

Accessing Calculated Tags

I have created a few calculations within my Cals & Events Tab. I was wondering if it was possible to access these tags within Axiom. If so, how would I be able to do this?

Wonderware (AVEVA) historian to Canary? Options?

I've been tasked with collecting Wonderware Galaxy Objects' process values into Canary via a Wonderware/AVEVA historian data source. I know the AVEVA historian has a SQL interface,…

Data Compression

Hi Everyone, I have some data showing that during the night, the hourly scheduled calculations give me a result of zero. When I check the data the next day,…

Get Tag Data Given a list or array?

Hi all, I'm currently working on a project that involves retrieving specific tag data from the historian. I have a list or array of timestamps for a particular tag,…

Using Axiom for Line Display

I want to use Axiom to show live time progress above production lines. Ideally, they will be on 24/7 and reset data at shift change Is there any issues with Axiom timing out if it is up on a screen…

Moving data between historians

Hello community! I'm exploring the Redundant Logging architecture, where a data collector+sender pair will move data to a primary and redundant historian servers.…

• Answered