Showing a .csv table from the server in the perspective

Ignition
1

I have a power automate script that every hour refreshes a table in C:\SCADA\orders.csv with new orders. The csv file just have a simple table with the list of orders, with it’s date, number, description, qty, etc…
I want to show this table in a perspective view, I been trying with chatgpt to get a script that reads the csv file and put the contents into a dataset tag, but how is normal with chatgpt, the script doesn’t work, and it doesn’t seem to be able to find a solution.

The biggest problem seems to be that ignition can’t just access C:\SCADA at all. The user that is running the service in the computer is a local admin, and the folder is shared with the ignition service, but still reports that there’s no file.

I’m trying to find information about this but I can’t. Is there anything special that needs to be done for the gateway to be able to read local files?

Thank you.

PS: This is the script:

import csv

def getOrders():
path = r"C:\SCADA\orders.csv"
rows = []
headers = []
with open(path, 'r') as f:
reader = csv.reader(f)
for i, row in enumerate(reader):
if i == 0:
headers = row
else:
rows.append(row)
return system.dataset.toDataSet(headers, rows)

Also tried with path = r"C:\Program Files\Inductive Automation\Ignition\data\orders.csv" with no luck.
This function is called by a timer script:

`def handleTimerEvent():

try:
    dataset = project.readorders.getOrders()
    system.tag.writeBlocking(["[default]orders/OrdersDataset"], [dataset])
except Exception as e:
    system.util.getLogger("getorderstimer").error("Timer error: " + str(e))`
2

Are you calling it from a gateway timer event?

If not, move it there.

Also double the backslashes in the path, and then write the results to a dataset tag in the call itself.

path = r"C:\\SCADA\\orders.csv"

blah blah

system.tag.writeBlocking("[default]orders/OrdersDataset", system.dataset.toDataSet(headers, rows))

3

image
image952×859 61 KB

image
image1128×877 70.3 KB

This is how it looks right now, as you can see the tag is still null. The double \\ didn’t seem to help. I don’t know if this may be a file access problem more than a code problem.

4

As a sanity check, see if you can write a file.

It should at least let you know if it’s a permissions issue.

1 Like
5

tip: csv.reader is iterable, so you can use

headers = next(reader)
rows = list(reader)

using next will consume the first line, so it won't appear in rows.
I usually do something like

headers = next(reader)
data = [dict(zip(headers, row)) for row in reader]

This builds a list of dicts that you can pass directly to a perspective table.

6

As another sanity check, is the project enabled?

1 Like