150 likes | 234 Views
Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC. Web-Based Application Solutions. Applicability : Redundant/Repetitious Minimize : Duplication of Work Effort. Integrated Automation. Automation. Considerations. Current Process
E N D
Automated-Integrated Registration William J. Obermeyer B.S. Computer Science/Mathematics, PUC
Web-BasedApplication Solutions Applicability: Redundant/Repetitious Minimize: Duplication of Work Effort IntegratedAutomation Automation
Considerations Current Process • MailMyForm • Email to Excel (copy/paste) • Excel to Database (import) • Generated by Need • Email • SQL Reports • Excel Spread Sheets Proposed Process Registration Form Data Validation Automated Reporting
Current Process http://education.calumet.purdue.edu/sciolympiad/2009registrationform.html
MailMyForm Script <!-- Start of Mail My Form.com Error Display --> <script type="text/javascript"> var str = location.search.substring(1, location.search.length); var recup = '<scr‘ +‘ipt language=JavaScript src="http://errors.mailmyform.com/‘ +'?mailmyform_username=trekles‘ + str+'"></scr' +'ipt>'; document.write(recup); </script> <!-- End of Mail My Form.com Error Display -->
Copy and Paste Email School: G.R. Clark High School Phone: 219 659-3522 County: Lake School_Address: 1921 Davis Ave. City: Whiting School_ZIP: 46394 Individual_Name: School City of Hammond Division: Div C 2008Compete-YES: on Morethanone-NO: on CoachName: Joanne Oros CoachPhone: 219 947-5981 CoachAddress: 672 Quail Drive CoachCity: Hobart CoachState: IN CoachZip: 46342 CoachEmail: jeoros@hammond.k12.in.us CoachYears: 4 AddCoaches: Michele Parsley Region-PUC: on MemberFee: 225.00 LateFee: ManualFee: 2 GrandTotal: 225.00 MailMyForm email data
Proposed Process http://sciolympiad.calumet.purdue.edu/sciolympiad/stateregistration
ProposedIntegrated System Email Data Verification Registration Entry Form Live User Data Updates • Data Verification • Email Validation • Data Integrity Coordinator Data Access Standardized Reports Science Olympiad Registration Database On PUC Server Excel Table Data Export Data Integration/Security
Proposed System Future Service • Maintenance • Enhancement • Documentation Longevity • PHP-MySQL • Available Expertise • Reliable Equipment • Data Security • Data Integrity
Budget/Contract Registration Entry Form Email Validation Data Integrity Checks Email Notification User Data Access Coordinator Data Access Coordinator Reports Team Registration List Regional Teams List Batch Email Facility Total 100 Hours