...
The hurdle in this case is that all pages of the final grading tool are designed to read a specific cookie when resolving course and instructor information. While not strictly necessary on the upload page, the target of the upload page and any further pages will require the existence of that cookie. Therefore, the upload page will be responsible for correctly setting the cookie.
The format of the required cookie is as follows:
CM_CURRENTCOURSE: 200605-53443-613536 (TERM_CODE-CRN-INSTRUCTOR_PIDM)
In order to set up the cookie correctly, Sakai will need to forward some information along the url passed to the final grading tool. Specifically, Sakai will need to indicate the course that will be used. The page itself should be able to resolve the correct instructor information from the content of the auth_user cookie.
Therefore, the required url parameter is:
course: 20060553443 (TERM_CODECRN)
Interface Mockups
There are two ways we can approach the Final Grading interface for SmartSite Course Grading sheet uploads. We can either integrate the interface with the existing interface for download and upload of excel files, or we can build a separate interface. Providing one interface, while perhaps allowing some confusion, should present the most powerful set of features.
...
- fgs_gradsheet_parse.cfm : Implement detection of Sakai format file and invocation of appropriate tag.
- tag_fgs_gradesheet_parse_sakai.cfm : New implementation of csv parsing for Sakai file format.
The following pages will be created:
- fgs_direct_upload.cfm : Page to allow direct upload of a SmartSite format file to a course.