rework export process to suit server-side control
Description
Environment
Test Plan
is depended on by
Activity
Michael Wenk August 6, 2010 at 5:51 PM
close per joyce

Vernon O'Connor August 6, 2010 at 1:54 PM
VERIFIED QA PASS

Vernon O'Connor August 6, 2010 at 1:54 PM
QA VERIFICATION ON smartsite-dev.rsmart.com TEST SERVER
Using PC Windows Vista Enterprise SP2 &
using MAC OS X 10.5.8 Leopard on:
smartsite-dev.rsmart.com TEST SERVER
SmartSite@UCDavis - 2.6.4.0 - Sakai 2.6.2 - Server "ucddev1"
GB2 version 1.3.0-b10
QA TASK:
Export a series of gradebooks using all supported browsers in turn and make sure Export generates valid csv and xls files as appropriate by opening & examining the downloaded files.
QA TEST PLAN:
GB2 Export:
A) Grades only via csv file.
B) Grades only via xls file.
C) Grades & structure via csv file.
D) Grades & structure via xls file.
QA SUMMARY:
Sites used:
RST 010A 001-003 / RST 010 001 FQ 2010
RST 010A 001-003 / RST 099 002 / RST 010 001 FQ 2010
1) PC Vista Enterprise SP2
IE 8 (Version 8.0.6001.18928IC)
GB2 Export:
A) Grades only via csv file, QA Pass.
B) Grades only via xls file, QA Pass.
C) Grades & structure via csv file, QA Pass.
D) Grades & structure via xls file, QA Pass.
Export succeeds in all cases, overall QA Pass.
Downloaded files opened & examined, overall QA Pass.
2) PC Vista Enterprise SP2
Firefox 3.6.8 (Version 3.6.8)
GB2 Export:
A) Grades only via csv file, QA Pass.
B) Grades only via xls file, QA Pass.
C) Grades & structure via csv file, QA Pass.
D) Grades & structure via xls file, QA Pass.
Export succeeds in all cases, overall QA Pass.
Downloaded files opened & examined, overall QA Pass.
3) PC Vista Enterprise SP2
Google Chrome 5 (Version 5.0.375.125)
GB2 Export:
A) Grades only via csv file, QA Pass.
B) Grades only via xls file, QA Pass.
C) Grades & structure via csv file, QA Pass.
D) Grades & structure via xls file, QA Pass.
Export succeeds in all cases, overall QA Pass.
Downloaded files opened & examined, overall QA Pass.
4) PC Vista Enterprise SP2
Safari 5.0.1 for PC (Version 7533.17.8)
GB2 Export:
A) Grades only via csv file, QA Pass.
B) Grades only via xls file, QA Pass.
C) Grades & structure via csv file, QA Pass.
D) Grades & structure via xls file, QA Pass.
Export succeeds in all cases, overall QA Pass.
Downloaded files opened & examined, overall QA Pass.
5) MAC OS X 10.5.8 Leopard
Safari 5.0.1 (Version 5533.17.8)
GB2 Export:
A) Grades only via csv file, QA Pass.
B) Grades only via xls file, QA Pass.
C) Grades & structure via csv file, QA Pass.
D) Grades & structure via xls file, QA Pass.
Export succeeds in all cases, overall QA Pass.
Downloaded files opened & examined, overall QA Pass.
6) MAC OS X 10.5.8 Leopard
Firefox 3.6.8 (Version 3.6.8)
GB2 Export:
A) Grades only via csv file, QA Pass.
B) Grades only via xls file, QA Pass.
C) Grades & structure via csv file, QA Pass.
D) Grades & structure via xls file, QA Pass.
Export succeeds in all cases, overall QA Pass.
Downloaded files opened & examined, overall QA Pass.
Task was to Export a series of gradebooks using all supported browsers in turn and make sure Export generates valid csv and xls files as appropriate by opening & examining the downloaded files.
For browsers IE 8 for PC, Safari 5 for PC, Chrome 5 for PC, Firefox 3.6 for PC, Firefox 3.6 for MAC, & Safari 5 for MAC, Export succeeds in all cases, overall QA Pass.
For browsers IE 8 for PC, Safari 5 for PC, Chrome 5 for PC, Firefox 3.6 for PC, Firefox 3.6 for MAC, & Safari 5 for MAC, downloaded files opened & examined, overall QA Pass.
Overall, QA Pass.
QA RESULTS:
Task was to Export a series of gradebooks using all supported browsers in turn and make sure Export generates valid csv and xls files as appropriate by opening & examining the downloaded files.
For browsers IE 8 for PC, Safari 5 for PC, Chrome 5 for PC, Firefox 3.6 for PC, Firefox 3.6 for MAC, & Safari 5 for MAC, Export succeeds in all cases, overall QA PASS.
For browsers IE 8 for PC, Safari 5 for PC, Chrome 5 for PC, Firefox 3.6 for PC, Firefox 3.6 for MAC, & Safari 5 for MAC, downloaded files opened & examined, overall QA PASS.
Overall, QA PASS.
QA VERIFICATION ON smartsite-dev.rsmart.com TEST SERVER
Thomas Amsler August 6, 2010 at 10:14 AM
We need to do some more testing with respect to export:
QA Test Plan:
Export a gradebook using all supported browsers and make sure export generated a valid csv and xsl document.

Jon Gorrono July 15, 2010 at 6:51 PM
I reworked the patch for 1.3.0 era code and changed the entry (into ImportExportUtility) to be filetype-agnostic
This work was started by Duffy Gillman (rsmart) who adapted the code @ the 1.2.0 tag to server-side batch export of gradebooks