I have written a small application to log defects found at the repair area within our PCB manufacturing pacility. I then log these defects in a textfile, tab delimited, as follows :-
161 156940 16/11/2003 AMC R901
161 is always three digits and is our model identifier
156940 is always six digits and is the unit serial number
16/11/2003 is the date the defect was logged
AMC is always three characters and is our fault code
R901 is the component the fault was found on (2 to 6 characters)
I now wish to write a second application to read in the textfile, select data from date x to date y as specified by the user, generate reports and charts for 1) total defects per day 2) defect breakdown for the period specified by fault code and by component. I then wish the report to be auto emailed (we currently use Lotus Notes) to a specified list. The email list should also be stored in a textfile or similair to make it easy to change. Data validation for the dates etc entered by the user would be expected.
As the fail log textfile is constantly being modified with new defects, this application may have to make a copy of the file first to generate it's reports, then delete the copy once complete.
Comments and explenations of code are essential as this is a tutorial to myself as well as getting a working program.
Main platform for viewing the report will be XP pro.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Windows XP, our current email is Lotus Notes 4.6