.....................................................................................................................................2 Problem Description / Motivation ...............................................................................................7 Previous Work .............................................................................................................................8 Lemming Scheduler .................................................................................................................8 Lemmings schedulers feature set: .........................................................................................8 similar work .............................................................................................................................9 DRoster...............................................................................................................................10 ScheduleWall ......................................................................................................................11 TimeCurve ..........................................................................................................................12 Requirements ...........................................................................................................................13 Design .......................................................................................................................................15 Goal .......................................................................................................................................15 Process ..................................................................................................................................16 My approach ......................................................................................................................17 Two Components of Design: Desktop Changes and Web Client ..........................................17 Time Line ............................................................................................................................18 4 Solving Design Problems .....................................................................................................19 Tradeoffs ...............................................................................................................................19 Technology .........................................................................................................................19 Features .............................................................................................................................21 Design .................................................................................................................................22 Implementation ........................................................................................................................25 Process ..................................................................................................................................25 Implementation Stages ..........................................................................................................27 Stage 1: GWT web client + desktop changes .......................................................................27 Stage 2: Applet as web client ..............................................................................................27 Stage 3: GWT web client + database integration .................................................................28 Testing ......................................................................................................................................29 Problems Encountered ..............................................................................................................29 Issue 1: GWT – need servlets to access Google docs ..............................................................29 Issue 2: Applets – Google Spreadsheet API cannot connect to Google Doc servers through Applets ..................................................................................................................................30 Issue 3: Applets – database access through an Applet is Unsecure .........................................30 5 Results ......................................................................................................................................31 Known Issues .........................................................................................................................31 General Feelings ....................................................................................................................32 Current Feature Set ...............................................................................................................32 Did we meet requirements? ..................................................................................................33 Sample Usage ........................................................................................................................33 Desktop Application ............................................................................................................33 Web Client ..........................................................................................................................33 Future Work ..............................................................................................................................34 Adapting for businesses .........................................................................................................34 Email Support & Google Calendar Support .............................................................................35 Lessons Learned ........................................................................................................................35 Prototype and Research Everything .......................................................................................36 Steps I will take in the future .................................................................................................36 Conclusion ................................................................................................................................36 Bibliography ..............................................................................................................................37 Appendices ...............................................................................................................................38 6 Installation Guide ...................................................................................................................38 Desktop Application ............................................................................................................38 Web Client ..........................................................................................................................38 Tomcat Deployment ...........................................................................................................38 Database Setup ...................................................................................................................39