D2L - Problems Importing the Gradebook (UW-Madison)


UW-Madison is adopting Canvas as the single, centrally supported learning management system, and discontinuing support for Desire2Learn (D2L) and Moodle. Access to D2L and Moodle will permanently end June 1, 2018. For information about retaining materials from D2L or Moodle, please refer to this document.

To ensure that a gradebook import works properly, please check the following:

  1. Check to ensure that the file you are importing is a "Windows .csv" file type. 
    (For older versions of Excel that don't have the "Windows .csv" file type, try ".csv comma delimited" as the file type.)
  2. Check to ensure the following were not included in the original export:
    • A 'Weighted' Grade
    • Grade Scheme
    • Subtotal for Category
    • Calculated Final Grade
    • Type Calculated Grade Item
    • Type Formula Grade Item
  3. Check the import file to verify that no text (or letter grades) have been added to any grade items that are not of type Text.
  4. Make sure the actual names, not the "Short Names," for the grade items are in the .csv file.
  5. Check your platform and browser.
  6. Check that the Grade Items do not have the same name as a Category.

Keywords:learnuw learn@uw desire2learn d2l limitation grades gradebook grades problems importing exporting   Doc ID:3231
Owner:Learn@UW Madison .Group:Learn@UW Madison
Created:2004-09-22 19:00 CDTUpdated:2017-12-01 12:20 CDT
Sites:DoIT Help Desk, DoIT Tech Store, Learn@UW Madison
Feedback:  2   19