Importing Local CSV

[Pico_Sankari]

I'm trying to import a local CSV to serve as a reference table on a component in perspective. I've run this line in both the script console and as part of a script that runs on the component:

	filePath = "C:/myfile.csv"
	isFile = system.file.fileExists(filePath)

In the console, isFile returns True. When run on a component script, it returns False. I think that this is because of the restricted access in Perspective. Is there a way to write my data to the component from the script console? This only needs to be done once. Any other ideas for making a static table that a component can reference (other than manually creating and filling in a table) would be appreciated.

[josborn]

Scripts in Perspective are run on the gateway. The script console is running code on your local computer.
You wont directly be able to access a file on your local machine in perspective, you would need to upload it to the gateway, or otherwise make the data accessible to the gateway.

[Pico_Sankari]

How can I upload it to the gateway? FileUpload Component?

[josborn]

Yes, that would work.

[josborn]

I copied @Travis_Opperud's code from here, which quite nicely parses the csv from the file upload without needing to save the file to the gateway's disk.

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…