Importing Data for use in Spline Chart

[mplekker]

Hey everyone. I'm trying to import data saved to a CSV file into a chart to try and graph the change over time. I've been trying different types of database files, and can't seem to get anything to work. Does anyone have any suggestions on the best method of doing this. Thanks.

[Archie]

What have you tried so far to read the CSV file?

[mplekker]

What have you tried so far to read the CSV file?

So far I've tried just importing the CSV directly, and converting it to an Access Database file. Apologies if it seems like I'm leaving out information, I'm a bit new.

[Archie]

Using some code, you can read the CSV file directly into an AdvancedHMI application. The processing and charting may be a bit more involved, but definitely possible. How are the CSV files created? Do they continuously receive additional data?

[mplekker]

We have a BRX plc using a FILELOG function to continuosly write points to the CSV file, so it would be updating while the program is running.

[mplekker]

Still having issues if anyone is able to help

[bachphi]

Archie is the world best mind reader or you can try post it at alt.read.my.mind

Now, if I can read your mind correctly,  your BRX already generate a CSV file. If you can have a batch file to run daily and move to a new location. New file is automatically generated.
Once the file is in the new location, just use excel with some macro, you should be able to generate a chart.
I dont see a need for AAHMI here.