Ignition Edge Store and Forward

[R.Alamsha]

@PRAMANJ

I am not conversant with FTP over Telemetry if you can give some references I can explore it.

The objective of FTP based S&F is to collect and download the remote time stamped RTU datalogs into the SCADA Tag Historain . This can be accomplished in 2 ways.

OPC UA alternatives (aka Kepserver)?

This script will parse your CSV and enter it into the ignition historian with your RTU timestamp. #convert the csv into an ignition dataset import csv path = system.file.openFile("csv") if path != None: f = open(path,'rb') reader = csv.reader(f) csvlist = list(reader) ds=[] row = 0 for x in csvlist: if row == 0: headers = x if row > 0: ds.append(x) row += 1 csvdataset = system.dataset.toDataSet(headers, ds) #parse the dataset and enter the data into the historian for row in r…

1. Run jython script on Ignition and download as explained above.
2. Import the csv files directly into the database like MySQL / PostgreSQL etc.

I haven't tested option 1 yet. Personally, i prefer option 2, because MySQL takes care of rejecting duplicate tags automatically and it's very fast. When you automate this process, your script must select the latest table partition and import.

Automatic IOT data collection by FTP

I would like to automate historical data collection (data logs) from 100’s of remote RTUs. These devices can send timestamped CSV/JSON files upon exception or periodically by secured FTP to designated folders on a Linux server. I want to monitor/scan these folders periodically for any new file arrival and automatically import/merge these data logs to Ignition Historian. I found these 2 links interesting. http://ignitiontips.blogspot.ae/2016/08/import-historical-data-from-csv-to.html I am NO…