|
TicketSchool.com is a website which allows people that have received traffic citations to take an on-line course to complete their driver improvement school, and have points removed from their driving record.
When TicketSchool.com went live, they received an overwhelming response that caused them to have trouble mailing out their certificates of completion. I was brought in to develop a VB application that would run on a PC in their offices, and automate their printing process. The application basically connected to their website via FTP, copied down their database export files, looped through the files and placed customer information on a Word document template, and then printed the template. At the end of each day, the application is run, and it loops through daily customer information and prints out certificates until they are completed. The printed certificates are then folded and mailed by an individual.
The application was researched, proposed, completed, tested and deployed within a 3 week period. Minor customer information changes were incorporated later. The application was developed in Visual Basic 6, using an internet control, FileSystemObject and Microsoft Word object. An InstallShield installer was also developed, so that they could easily install the application on any PC in the office later.
The application was an immediate success, remains in use today, and has streamlined their process as best that it could be.
* I included some code screens below as examples of my VB code. |