Questions & Answers Category

Is there a way to have the CSV collector create multiple hdb files?

I am trying to import a lot of tvq s from a csv but i want the date of the hdb file the tvq is put in to correspond to the date in the timestpamp of the tvq instead of it being put in the hdb file…

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

SAF Import Fails with Datetime Conversion

Hi, I have been trying to import a CSV to create some local data tags for use with the data entry tool in Axiom. However, every time that I drop the CSV file into the directory folder,…

• 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

CSV Collector Propertynames and PropertyOffsets

I'm a newbie, Can someone give me an example of how to use propertynames and propertyoffsets in SAF_Import.config file?

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

Migrate GE historian data to Canary

Hi folks, has anyone experienced such a data motion from GE to Canary? I was thinking at using HDA client but Canary lacks that, right? So it’s only CSV and SQL? The db is 10gb+ so CSV might be hard.…

CSV Collector only scans folder on service start

Hi - I have a CSV collector pulling in files from a remote site. The collector scans the folder when I start the service and correctly picks up the number of files to process.…

How to export trends as a CSV file with more DECIMALS?

Hello all, I am running into an issue regarding exporting trends to CSV files. I can easily export the values for the timeframe I need, but it won't export with any decimal places?…