Agenda Class Timetabling

I received a message from Leslie (from the history department) regarding O sequences, within the agenda application. I incorrectly allowed the database to insert it as tuesday-friday instead of tuesday-thursday and I have corrected the error.

On Wednesday I attempted to transfer the development version of the Agenda account to the lang account and in doing so transmit somehow messed up the transfer. I had to download filezilla to transfer the data correctly. Therefore, as of the 21st I have completed all of the revisions presented by the history department except for point 4 which I will continue with on Monday.

"4. You are working on suppressing the second line on the timetable view when the professor is the same for both sessions. When professors are different for each session, we still need to differentiate between them e.g. who is doing fall and who is doing spring. It was suggested that something like:HIST 105 Y03-F Fennema, Norman HIST 105 YO3-S Wender, Andrew"

Today I was able to look into three new revisions presented by the history department on Thursday.

First, the ordering of the offerings List view presents the offerings list based on course code and offering primary key and therefore presents fall, spring and year courses mixed together. So the history department was wondering if we can switch the ordering to reflect the following order: Year, Fall, Spring. However, after investigating this further it is not possible to change the ordering of the offerings list as the suppression of certain data requires the current ordering.

Second on the Audit list report I failed to put in a unique identifier for spring terms of Year courses. So I added a -S after every year spring term course. I also replaced the daggers in the Offerings list and the timetable view that identified spring terms

Lastly, On the Timetable view page the courses were ordered incorrectly and I changed it so that it is ordered both my start time and course number.

While doing some research into some of the changes requested for Agenda I have realized that the following change is not possible: Providing watermarks that identify the sequence in the timetable view. (This is because the HTML table structure has changed drastically from the older versions and providing a watermark would require a complete redesign of the programming for timetable printing.)

As for changes I have made to the system (as of Nov.9) I have been able to remove the course type and title from the list view when printing the report. I have also changed 'zz' to 'other' while printing the list view report. (Changing 'zz' to 'other' throughout the application would require a redesign of the data structure used in the application as well as database field.) And I have also added employee number information to the database and added a way for agenda to save that information.