Aldolex Irl ltd: Software For Business - AutoFileProcessor

By: Aldolex Irl  05/12/2011

Bausch & Lomb manufacture contact lenses in their Waterford manufacturing facility. The process is highly automated with very little human intervention. The manufacturing machinery collects data on all of the manufacturing parameters, including yield at various stages throughout the cycle (approximately 100 different fields). This information is presented in a flat file structure that is of little benefit for analysis purposes. The files are saved automatically to a specific location at the end of every shift.

The brief was to develop a system that would automatically detect the creation of the files in the specified folder and process the data. The data requires processing to split it by Date, Manufacturing Line, Process Position, Defect Type etc and highlight any data that didn’t meet specification.


The solution was to develop a service that was installed on the server. The service uses a filewatcher service that constantly monitors a folder where the datafiles are dropped by the manufacturing system. When a new file is detected, the service starts the processing: it extracts the required information from the files, transforms the data into the required structure and then saves it to the database.

Services run, in general, without a user interface because there is no necessity to interact with the operations that are being executed. To view the data and generate reports etc., a user interface was developed to interact with the data held in the database. This solution solved the issues in an effective, efficient manner:

  • There was no longer a need to manually import large numbers of individual files into Excel to view the data
  • There was no longer a need to re-organise and aggregate the data to perform analysis
  • The data was stored in a secure environment and gave more visibility to interested parties

Other products and services from Aldolex Irl


Aldolex Irl ltd: Software For Business - RailTemperature

Temperature is one of the largest contributors to variance in laid rail: its influence is even greater with the advent of continuous welded rail sections because there are fewer expansion joints available to counteract fluctuations in ambient temperature. The intention of RailTemperature is to monitor the temperature of sections of track prone to the largest temperature fluctuations and alert the relevant personnel to the imminent dangers.


Aldolex Irl ltd: Software For Business - CustomSoftware

Full custom applications based on SQL Server/ MySQL Databases and .Net providing secure desktop/ web applications to fully manage business processes. We have a huge range of experience in both formally modelling business processes and designing/ installing custom software. MS Access databases to arrange data, print reports, analyse trends, filter data etc. How many repetitive tasks do you come across in your daily business life.


Aldolex Irl ltd: Software For Business - EngTechConsultancy

Whether you need advice on a small Process Change or management of transition from Project Phase to Operation of a new Plant, we have the experience and procedures to ensure success. Our roots are in Engineering: our Principal, Declan O'Brien holds an Honour's Degree in Mechanical Engineering and a Master in Engineering from University of Limerick.