I am going crazy with one problem in my web app.
I have a SCADA system that everyday dumps excel files to my server with data from one thermal plant.
I have a web app in PHP / Jquery that reads this data from a MySQL database and show this in charts and tables.
But I have to manually import the excel files to MySQL. What I want to do, is to build a PHP script, that will do as follow:
The user tries to make a chart, and if the data is not on MySQL it will ask if he wants to import the data from the excel files in the server. Than the excel files are copied into MySQL temporary tables and inserted into the correspond table. Then the data can be displayed to the user and will keep stored in the MySQL database.
All its working, but I need make an automatic way to import this data from the excel files to MySQL tables.
Thanks in advance for your help