What does importing a CSV file with grades into D2L look like?

Jeff.Y.418
Jeff.Y.418 Posts: 7 🌱
edited June 2023 in K-12

We are moving to D2L from Moodle midway through our school year (we are a 12 month program). I am playing with importing a CSV of grades from the course in Moodle into the same course in D2L. I continually get the error below. I have NO idea what that error might even be. Haha. Has this type of import been done successfully? If so, is there a sample available? The sample CSV provided is for all intents and purposes useless. Thanks for considering my request for support.

Answers

  • Paul.P.783
    Paul.P.783 Posts: 13

    Hello @Jeff.Y.418,

    A good resource for setting up your grade book can be found here

    Without specific details on the content of the CSV file you are trying to import it's difficult to suggest the next steps.

    Some suggestions:

    Use the Grades sample file link, download it, add some basic data, and import it into a test course.
    Did it work as expected?
    What are the differences between your CSV and the sample CSV file?
    What fields are missing/absent?

    If comparisons don't offer some solutions, feel free to open a Support Case with the attached file, and the team can take a look.

    I hope this helps!

  • Steve.B.446
    Steve.B.446 Posts: 74

    The likelihood is that your column headers are in the wrong format or you are missing the # characters that are required in certain places.

    I would recommend exporting the Brightspace gradebook to CSV, add a new worksheet and paste in the Moodle export. Then using Excel's Vlookup function to merge the correct score for each student onto that file from your Moodle sheet, save the first sheet to CSV and and try uploading again.

  • Jeff.Y.418
    Jeff.Y.418 Posts: 7 🌱

    Ah, Brilliant! Thanks, Steve! I will give this a go. Cheers!