Create a curve diagramm automatically with CSV files

PLCnext Technology & PLCnext Controls
1

Hello,

I am currently logging data from my PLC Next controller with the Datalogger_Library. This library creates CSV files and stores them on the controller. Now I have the task to automatically generate a curve diagram from this data. The data should be observable from the web and must also be archived. Has anyone already had something to do with this and can help me with it or is there an example project for this? My first considerations were to send the CSV data automatically via FTP to a computer. Now I am looking for a program that automatically displays the CSV files in a curve diagram when they arrive. Does anybody know a program for this that meets my requirements?
I have also added a picture of the logged data. I would be very grateful for your suggestions or solutions. Kind Regards robo7795

2

Hello Robo7795,

there are a lot of possibilities
1. You can either move it to a PC that will do the work,
2. Do it directly on the PLC and forward the plot.
3. Publish the CSV via html and let the browser do it.

With PLCnext Engineer 2021.0 our eHMI will support basic Trending.
You will be able to couple the Internal Firmware Datalogger to these trends.
From the sqlite Database you can also generate CSV exports.

You could also work with eHMI Support files for example some Java Script " csv to Diagram" tool.
There are a lot of toolkits on the market there.
Store a copy of your CSVs to the /var/www area to make them Available to browsers.
And you will be able to use nginx + javascript to view the trends in a browser.

Another solution could be using OPC UA and historical Data for this purpose.
Or a scada system like Visu+.

Maybe running a tool like „gnuplot“ regulary when a file changed could be a solution as well.

kind regards,
Oliver

3

Hello Oliver, Thank you for your suggestions. Is there already a release date for PLCnext Engineer 2021.0 because I need this function urgently. Best Regards robo7795

4

Hello Robo7795, it will be available for download probably about ~12.12.2020