rework export process to suit server-side control

Description

This work was started by Duffy Gillman (rsmart) who adapted the code @ the 1.2.0 tag to server-side batch export of gradebooks

Environment

None

Test Plan

None

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

Fixed

Details

Assignee

Reporter

QA Status

PASS

Components

Fix versions

Affects versions

Priority

Created July 15, 2010 at 6:37 PM
Updated August 10, 2010 at 9:30 AM
Resolved July 15, 2010 at 6:51 PM