Import CSV and isolate single data point

Given your time constrained challenge, I would look at running Node-RED on that PC.
It takes about 2 minutes to install on Windows: Running Node-RED locally : Node-RED

Once installed, using any PC browser on the same network, I would set up my flow something like this:
Inject node set to 30 minutes, file in node to read the CSV, CSV node to get the column you want, PAC Write node to send the value to the R1 controller.

Terry has a video on CSV files here:
https://www.opto22.com/support/resources-tools/videos/video-node-red-logging-csv-files-to-usb-with-gro

Here is his video on sending values to a PAC Controller:
https://www.opto22.com/support/resources-tools/videos/playlist-node-red-workshops?wchannelid=svmge9iq73&wmediaid=54djnup9w5

His whole play list is here:
https://www.opto22.com/support/resources-tools/videos/playlist-node-red-workshops

2 Likes