admincbf
asked on
Import CSV File to HTML Table
Hi
Our warehouse team would like displayed on a big telly mounted on the wall the packing stats for each individual packer.
We can export as a CSV or tab delimited text file the packer's username, full name and number of parcels despatched from our ERP system every minute so that the file has up-to-date data in it. What I need to do is figure out a way of presenting this data on the big screen ideally in a nicely formatted table.
Does anyone know of a simple way of doing this (I have no experience of writing any sort of code)? Or a third party software solution than can do such a thing?
I have attached an example output file from our system.
Many thanks
pick.csv
Our warehouse team would like displayed on a big telly mounted on the wall the packing stats for each individual packer.
We can export as a CSV or tab delimited text file the packer's username, full name and number of parcels despatched from our ERP system every minute so that the file has up-to-date data in it. What I need to do is figure out a way of presenting this data on the big screen ideally in a nicely formatted table.
Does anyone know of a simple way of doing this (I have no experience of writing any sort of code)? Or a third party software solution than can do such a thing?
I have attached an example output file from our system.
Many thanks
pick.csv
Your best bet is to use some kind of server side language to do this, although there are straight JavaScript solutions out there, which, IMO, are not as straightforward to follow. There are a lot of examples on the net for php, .net,, classic asp, etc. Once you decide on a technology, I can better help you.
Is your ERP database accessible via ODBC? If it is, the best way may be to interface directly into the tables using SQL to extract the data directly to a JSP page and just refresh the page automatically every minute or so. Much more efficient than parsing and displaying CSV data all the time.
What software/database hosts the ERP system? Is it Oracle, MS SQL Server or something similar?
What software/database hosts the ERP system? Is it Oracle, MS SQL Server or something similar?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You might want to look into any hooks the ERP system may have. Sometimes there area API's and you can use javascript to hit that ERP and send some data to your screen. Otherwise, Rob's solution is the way to go and will probably be the easiest in the end.
ASKER
Thanks very much for the thorough solution