Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Imported grades to GradebookNG could fail if the excel file is not saved determining column types

Description

Imported grades to GradebookNG could fail if the excel file is not saved determining column types.

This could happen when using grades using decimals. An imported grade as “2.3” will be imported as “2.29999999999999” and the import will fail. This is happening because the cell is being interpreted as a string cell.

Attachments

2
  • 15 Jun 2023, 12:51 PM
  • 15 Jun 2023, 12:49 PM

Activity

Show:

Andrea Schmidt August 30, 2023 at 11:18 PM

Verified on 22x: https://qa22-mysql.nightly.sakaiproject.org/, build: b61f62a4

Andrea Schmidt June 17, 2023 at 1:45 PM

Verified on 24x: https://trunk-maria.nightly.sakaiproject.org/, build: 1dabdc85
23x: https://qa23-maria.nightly.sakaiproject.org/, build: 5bbf0ab6

following the test plan

Miguel Pellicer June 15, 2023 at 1:35 PM

The issue you’re mentioning is not related to this issue

Ramana Reddy Battula June 15, 2023 at 12:49 PM
Edited

Tested on Sakai 23: https://qa23-mysql8.nightly.sakaiproject.org/portal/site/ , build info: c5e26f4a

Note: After exporting a csv file, I changed the grade to a decimal number and saved the file with .xlsx extension. (Excel version: 2304) I received an error(Exception).

Miguel Pellicer May 5, 2023 at 10:37 AM

Verified at UPV in 20.x and 22.x.

Fixed

Details

Priority

Affects versions

Fix versions

23 Status

QA Verification Pass

22 Status

Verified

Components

Assignee

Reporter

Labels

Created December 7, 2022 at 9:04 AM
Updated August 30, 2023 at 11:18 PM
Resolved December 7, 2022 at 10:06 AM
Configure

Flag notifications