Severn Trent Services


I developed a system which collects water meter test data from 10 machines and loads it to a central MySQL database. Front end display is using a web server and ASP.NET. Collector programs, which are MS Access databases, run as a scheduler job to collect text files of test data from testing PCs 10 in all. The data is then loaded by MS Access Loader programs into the central MySQL database using ADO. The data is then organised for display by several MySQL queries and displayed using simple ASP.NET screens for the manufacturing unit.