[#LDEV-1069] MCQ to have a way to export raw data (from monitor) into a .xls file

LAMS Development

MCQ to have a way to export raw data (from monitor) into a .xls file

Created: 01/Dec/06 09:11 AM Updated: 04/Jun/08 02:50 PM

Component/s:

Tool Multiple Choice

Affects Version/s:

2.1

Fix Version/s:

2.2

File Attachments:

None

Image Attachments:

1. snapshot1.jpg
(61 kb)

2. snapshot2.png
(92 kb)

Resolution Date:	04/Jun/08 01:30 PM
Date of First Response:	17/Oct/07 10:36 AM

Description

« Hide

Need to figure out the format of the xls first

(see ~~LDEV-1068~~ for reference)

All

Comments

Change History

FishEye

Sort Order:

Change by Ernie Ghiglione - 27/Apr/07 10:20 AM
Field	Original Value	New Value
Affects Version/s		2.2 [ 10070 ]
Affects Version/s	2.0 [ 10011 ]

Change by Ernie Ghiglione - 27/Apr/07 10:23 AM
Fix Version/s		2.2 [ 10070 ]
Affects Version/s		2.1 [ 10013 ]
Affects Version/s	2.2 [ 10070 ]

[ Permlink | « Hide ]

Fiona Malikoff - 17/Oct/07 10:36 AM

Include the xls file in the class portfolio (not the learner portfolio).

[ Permlink | « Hide ]

Ernie Ghiglione - 30/Apr/08 05:30 PM

Mitch, have a go at exporting the table that is marked in snap1.jpg into a .xls file.

Make sure you include group information if available too.

Change by Ernie Ghiglione - 30/Apr/08 05:30 PM
Assignee	Ernie Ghiglione [ ernieg ]	Mitchell Seaton [ mseaton ]

Change by Ernie Ghiglione - 30/Apr/08 05:30 PM
Attachment		snapshot1.jpg [ 11320 ]

Change by Mitchell Seaton - 01/May/08 12:38 PM
Status	Open [ 1 ]	In Progress [ 3 ]

Change by Mitchell Seaton - 06/May/08 03:06 PM
Status	In Progress [ 3 ]	Open [ 1 ]

Change by Mitchell Seaton - 12/May/08 03:36 PM
Status	Open [ 1 ]	In Progress [ 3 ]

MAIN:mseaton:20080515034857 by Mitchell Seaton (2 files)

14/May/08 10:48 PM

~~LDEV-1069~~ Added downloadMarks to monitoring action to export marks data spreadsheet.

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/McMonitoringAction.java 1.38

(+188 -2) diffs

lams_tool_lamc/web/monitoring/SummaryContent.jsp 1.25

(+5 -1) diffs

MAIN:mseaton:20080515054013 by Mitchell Seaton (4 files)

15/May/08 12:40 AM

~~LDEV-1069~~ Add custom Message Service for use in MCQ tool. Updated download marks spreadsheet to use dictionary I18N values.

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml 1.18

(+11 -3) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java 1.102

(+18 -2) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServiceProxy.java 1.5

(+12 -1) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/McMonitoringAction.java 1.39

(+20 -7) diffs

MAIN:mseaton:20080516015944 by Mitchell Seaton (6 files)

15/May/08 08:59 PM

~~LDEV-1069~~ Added user name to spreadsheet and modified user mark dto to include full name/user name.

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/McUserMarkDTO.java 1.5

(+21 -3) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/McMonitoringAction.java 1.40

(+17 -5) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/MonitoringUtil.java 1.33

(+3 -2) diffs

lams_tool_lamc/web/export/class.jsp 1.4

(+1 -1) diffs

lams_tool_lamc/web/monitoring/AllSessionsSummary.jsp 1.4

(+2 -2) diffs

lams_tool_lamc/web/monitoring/IndividualSessionSummary.jsp 1.4

(+2 -2) diffs

MAIN:mseaton:20080516040829 by Mitchell Seaton (4 files)

15/May/08 11:08 PM

~~LDEV-1069~~ Added spreadsheet to class portfolio.

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/McAppConstants.java 1.102

(+2 -2) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/ExportServlet.java 1.17

(+48 -1) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/McMonitoringAction.java 1.41

(+135 -133) diffs

lams_tool_lamc/web/export/class.jsp 1.5

(+4 -2) diffs

[ Permlink | « Hide ]

Mitchell Seaton - 20/May/08 10:49 AM

can we confirm this is suitable for 2.1 or is any more work required?

Change by Mitchell Seaton - 20/May/08 10:49 AM
Status	In Progress [ 3 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

[ Permlink | « Hide ]

Ernie Ghiglione - 03/Jun/08 01:08 PM

When using firefox to download the excel file, I'm getting snap2

Change by Ernie Ghiglione - 03/Jun/08 01:08 PM
Resolution	Fixed [ 1 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]
Assignee	Mitchell Seaton [ mseaton ]	Jun-Dir Liew [ jundirl ]

Change by Ernie Ghiglione - 03/Jun/08 01:08 PM
Attachment		snapshot2.png [ 11406 ]

MAIN:jliew:20080604032956 by jliew (4 files)

03/Jun/08 10:29 PM

~~LDEV-1069~~ fix error handling during spreadsheet preparation, and filled in missing label for the error message; fixed SummaryContent.jsp not filling in variable for 'download marks' link when not grouped

lams_tool_lamc/conf/language/lams/ApplicationResources.properties 1.22

(+2 -1) diffs

lams_tool_lamc/conf/language/lams/ApplicationResources_en_AU.properties 1.21

(+2 -1) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/McMonitoringAction.java 1.42

(+6 -15) diffs

lams_tool_lamc/web/monitoring/SummaryContent.jsp 1.27

(+7 -2) diffs

MAIN:jliew:20080604041709 by jliew (3 files)

03/Jun/08 11:17 PM

~~LDEV-1069~~ display error label in html page rather than in the spreadsheet by splitting preparation of spreadsheet from outputting of response

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/ExportServlet.java 1.18

(+15 -17) diffs

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/McMonitoringAction.java 1.43

(+29 -24) diffs

lams_tool_lamc/web/WEB-INF/struts-config.xml 1.59

(+2 -1) diffs

MAIN:jliew:20080604041929 by jliew (1 file)

03/Jun/08 11:19 PM

~~LDEV-1069~~ forgot to remove some old code

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/web/McMonitoringAction.java 1.44

(+1 -7) diffs

Change by Jun-Dir Liew - 04/Jun/08 01:30 PM
Status	Reopened [ 4 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

[ Permlink | « Hide ]

Ernie Ghiglione - 04/Jun/08 02:50 PM

Thanks Jun-Dir.

All tested and closed

Change by Ernie Ghiglione - 04/Jun/08 02:50 PM
Status	Resolved [ 5 ]	Closed [ 6 ]