Displaying .csv file content in perspective

[Josh_Hoover]

Hello,

I need to display the contents of a .csv file in a table using perspective. Could anyone advise on some ways this can be accomplished?

Thanks,

[PGriffith]

You need to use the file upload component to upload it to the gateway (even if only held in memory), then parse the CSV, translate it to an Ignition dataset or a list of dictionaries, then return that value to the session and display it in a table.

[josborn]

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…

Travis' code worked great for me when i needed to do this.

[Josh_Hoover]

I'm a little confused on where to put the CSVParser class in ignition.

[josborn]

Put it in your script library

[Josh_Hoover]

Ah, thank you. That worked great. Much appreciated.