Skip to main content

Gradebook Download Feature Produces tab Delimited Files With an Incorrect Extension

The Gradebook/Grade Center Download feature is creating tab delimited files with an invalid extension. A warning message is shown while trying to open the file in Microsoft Excel.

Description

The Gradebook/Grade Center Download feature is creating tab delimited files with an invalid extension. A warning message (FIle invalid or corrupted / File from untrusted source) will be shown while trying to open the file in Microsoft Excel.

Symptoms

Users will see a warning message while trying to open XLS files downloaded from the Gradebook/Gradecenter:
​

Invalid file format.PNG

Steps to Replicate

  1. Log in to Blackboard Learn as an Instructor

  2. Go to Courses (Top Frame tab in Original Experience or Ultra Base Navigation Menu in Ultra experience)

  3. Search for a course (Original View or Ultra View)

  4. In Original view: Go to Course Menu > Control Panel > Grade Center > Full Grade Center

  5. Hover over Work Offline (Top Right corner) and select Download

  6. Make sure not to change the options selected by default (Select Data to Download: Full Grade Center, Delimiter Type: Tab)

    Default Options - Original.PNG
  7. Click on Submit

  8. In Ultra view: Go to Gradebook (Top navigation tabs) and click on the "Down Arrow" (↓) button (Top Right corner)

  9. Make sure not to change the options selected by default (Data: Full Gradebook, File Type: XLS, Save Location: My Device)

    Default Options - Ultra.PNG
  10. Save the file

  11. Open the file in Microsoft Excel

  12. The following message is shown when trying to open the file:

"The format and extension of the file don't match. The file could be corrupted or unsafe. Unless you trust this source, don't open it"
​Observed Behavior:
A warning message is shown while trying to open Gradebook/Grade Center XLS files (Tab Delimited) in Microsoft Excel
​Expected Behavior:
No warning messages should be shown while trying to open Gradebook/Grade Center XLS files (Tab Delimited) in Microsoft Excel

Affected Versions

  • Learn 3900.34.0

  • Learn 3900.37.0

  • Learn 3900.39.0

Target Release

Will Not Fix

Did this answer your question?