AdvancedHMI Software

General Category => Support Questions => Topic started by: mplekker on March 23, 2023, 01:29:27 PM

Title: Importing Data for use in Spline Chart
Post by: mplekker on March 23, 2023, 01:29:27 PM

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.

Title: Re: Importing Data for use in Spline Chart
Post by: Archie on March 23, 2023, 02:08:08 PM

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

Title: Re: Importing Data for use in Spline Chart
Post by: mplekker on March 24, 2023, 10:40:33 AM

Quote from: Archie on March 23, 2023, 02:08:08 PM

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.

Title: Re: Importing Data for use in Spline Chart
Post by: Archie on March 24, 2023, 12:39:22 PM

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?

Title: Re: Importing Data for use in Spline Chart
Post by: mplekker on March 24, 2023, 02:33:18 PM

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.

Title: Re: Importing Data for use in Spline Chart
Post by: mplekker on March 31, 2023, 11:23:06 AM

Still having issues if anyone is able to help

Title: Re: Importing Data for use in Spline Chart
Post by: bachphi on March 31, 2023, 12:49:13 PM

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.