I have a few excel wordbooks which will be generating dozens of csv files which need to be imported in their corresponding receiving SQL tables every 5 minutes. I wonder which would be the elegant way to do this? Can SQL script be used to import multiple csv files into their respective tables in one batch run (we woudl upload all csv files in one ftp run)? What you would recommend?
How error–proof is this setup? We need this for a production environment – need to connect local excel models with interactive charts on the web - fAST.
Just to clarify we will be using wpdatatables plugin to draw charts using the imported csv data in WordPress - in combination with wpbakey you can create an responsive dashboard in a matter of minute using any result from your excel models of ANY COMPLEXITY - and without the need to pay thousands for any blackbox dashboard solutions.
will not constant BULK import of the csv tables corrupt the database? I assume you can run multiple sql commands in a stream?