Need advise on adding tags to Ignition

[ryan.white]

@Grigory_Vogman

Can you tell me more or direct me to a resource to learn more about this?

system.dataset.toDataSet | Ignition User Manual

That's the manual page on the function to create a new dataset.

Just to confirm, is this an actual CSV file or is it an excel file (.xls or .xlsx) with the data formatted in the same way as a CSV?

You can do a search for CSV to dataset here on the forums and get some decent information.

https://forum.inductiveautomation.com/search?q=csv%20to%20dataset

This post looks like it has a basic script for converting csv to dataset:

Upload csv to dataset

Figured it out, Not sure why I got hung up like I did. If anyone else gets stuck: the following class can parse csv files and store as a dataset: class CSVParser: def __init__(self, file_in): self.file = file_in self.file_string = file_in.getString() self.rows = [row.split(',') for row in self.file_string.split('\r')] self.num_cols = max([len(row) for row in self.rows]) self.num_rows = len(self.rows) self.headers = self.rows[0] self.data = self.rows[1:] @property def extend…

That class is expecting the result from a file upload component, you would need to modify it to accept the output of system.file.readFileAsString

@Grigory_Vogman

I hope to create a script to populate the CSV periodically

What is the source of this CSV? Is it being exported from some other program? If so it may be worth seeing if you can get this program to dump this data into a database table. That would make things simpler as you could use a query tag to hold the information and eliminate the script on Ignition's side.

I also understand that you may be limited to only CSV files. My company has several CSV files that we use Ignition to parse and chuck into a DB table on a weekly or daily basis.