...
- Provide a method for faculty to download multiple media files associated with a quiz, question pool or collection.
- Provide identification information specifying which media file(s) are associated with each question that is being exported.
- Include question title, media file name and question text in the identification information.
- Rename image files from their AFS storage name to their original file name as recorded in the myucdavis database, if possible.
- If image files are renamed, deal with name collisions in an intuitive, documented manner.
GUI Review
Media export is tied into the Quiz Builder export of quiz, collection or question pool, so the information and download are located on the export screen. The text associated with the export function is shown below.
If the user is exporting media as part of a quiz, the information lists the section and question number with which it is related. If the question exists in a pool or collection, there is no associated question number (or there will not be after import into Samigo) so the files are simply listed in the order that they are pulled from the database.
For graphic files, such as .gif, .jpg, or .bmp, the user can click to view and/or save the graphic individually. The user is provided with a download button which displays the filename as "media_quiz#.zip" where # is the id of the quiz or "media_for_kname.zip" where kname is the user's Kerberos name for collection or question pool media.
A ReadMe.txt file is included in each media download indicating the filename, question name, original (user's) filename, and question text. Because the media file is renamed for storage on upload to Quiz Builder, the information is here to assist the user in identifying their content and/or to allow them to rename their files back to the original, descriptive name. The question name will not be imported into Samigo.
Code Functionality
Currently, the MyUCDavis cms runs on ColdFusion MX 6 with an Oracle database. New code for exporting question media in a zip file will use the existing environment and will include ColdFusion code, CF components, and JavaScript. The export file generated via download will be Samigo-compliant XML.
Code modifications to 1 2 existing file files and 1 new file in the directory 'login/CourseManagement/quiz/' are required.
The addition of the component zip.cfc in the root directory level 'login' is also required.
File Name | Proposed Addition/Modification |
|---|---|
qz_quiz_exportfiles.cfm | Calls function to pull information associated with the media files for a quiz, aan entire question pool, or a collection. Calls function to generate a ReadMe.txt message. Calls zip function to generate a zip folder and populates it with the media and ReadMe files. Generates a downloadable zip file screen. |
login/zip.cfc | This imported component is setup in the main cms directory so that it can be access globally. It's Java-based and contains the functions which generate the zip folder and copied files into it. |
qz_quiz_exportxml.cfm | Includes the download link for the user to generate their media files into a zip file. |
qz_quiz_exportxml.cfc | Includes query calls which pull the requested media files and provide user information about those files. |
Code Review
Brian Donnelly, or another qualified member of the MyUCDavis team, will perform code review on these files.
QA Testing
Quis Builder Media Export Test Plan Overview
This three-part test plan covers the ability of users to successfully complete the following actions:
Part 1: Export Media with their Quiz:
- Locate the Export Quiz link in Quiz Builder
- Successfully download any media associated with their quiz
- Verify that a ReadMe.txt contains accurate information about their media
- Verify that the exported media can be imported into SmartSite Resources
Part 1: Export Media with their Question Pool:
- Locate the Export Question Pool link in Quiz Builder
- Successfully download any media associated with their question pool
- Verify that a ReadMe.txt contains accurate information about their media
- Verify that the exported media can be imported into SmartSite Resources
Part 1: Export Media with their Collection:
- Locate the Export Collection link in Quiz Builder
- Successfully download any media associated with their collection
- Verify that a ReadMe.txt contains accurate information about their media
- Verify that the exported media can be imported into SmartSite Resources
JIRA Ticket(s) relating to this story: SAK-270.
TEST ENVIRONMENT
QA TESTING | SETUP |
Server Type | Location |
|---|---|
web server | url, https://bumbus.ucdavis.edu/main_frame.cfm |
web server | url, https://sakai-test.ucdavis.edu:8443/portalOR https://smartsite.ucdavis.edu:8443/portal |
- Website Setup
Tester logs into MyUCDavis dev/test environment and using Secure Login. Tester will need course management (cms) permission to access Quiz Builder. Tester may request access via CM Guest under My Options on the main menu.- Testers must have or create questions in Quiz Builder with one of each of the following media types attached: .jpg, .gif, .pdf, .mp3, .doc, .bmp
- Testers must have or create at least one quiz containg questions with media in Quiz Builder.
- Testers must have or create at least one Collection containg questions with media in Quiz Builder.
Testers unfamiliar with MyUCDavis may contact Lisa at 754-4983 to schedule training.
- Additional Setup for Advanced QA
Advanced QA will be limited to those testers with SuperUser access to MyUCDavis dev/test systems.
**SU access to list of user accounts provided by Lisa
TEST DOCUMENT
Release
Release of the export question pool, collection and media will be concurrent and are expected to go to production late November/early December. Code releases include r71 - r76 from mware.ucdavis.edu/svn/coursemanagement/trunk/login
Jira Story Card Description
...