Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-46547

Copy and paste import from excel into the gradebook.

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.8
    • 2.8
    • Gradebook
    • MOODLE_28_STABLE
    • MOODLE_28_STABLE
    • wip-MDL-46547-master
    • Hide
      1. Go to or create a course with a few assessments in it.
      2. Download the gradebook as a text file [Administration ► Grade administration ► Export ► Plain text file].
      3. Open the csv file in excel (or libre office), make some alterations.
      4. Go to the direct import from copy and paste [Administration ► Grade administration ► Import ► Copy and paste from spreadsheet].
      5. Copy and paste the data from excel into the data section of the form. Make sure to copy the column headings as well.
      6. Click upload grades, map the columns and assessment columns and import.
      7. Check that the import is successful.

      Unit tests

      1. Please run grade/import/csv/tests/load_data_test.php and check that there are no errors.
      Show
      Go to or create a course with a few assessments in it. Download the gradebook as a text file [Administration ► Grade administration ► Export ► Plain text file] . Open the csv file in excel (or libre office), make some alterations. Go to the direct import from copy and paste [Administration ► Grade administration ► Import ► Copy and paste from spreadsheet] . Copy and paste the data from excel into the data section of the form. Make sure to copy the column headings as well. Click upload grades, map the columns and assessment columns and import. Check that the import is successful. Unit tests Please run grade/import/csv/tests/load_data_test.php and check that there are no errors.
    • 100
    • BACKEND Sprint 17

    Description

      It would be convenient to just copy and paste rows from excel straight into the gradebook. This could be added to the csv import form.

      Attachments

        Issue Links

          Activity

            People

              abgreeve Adrian Greeve
              abgreeve Adrian Greeve
              Damyon Wiese Damyon Wiese
              Dan Poltawski Dan Poltawski
              Jetha Chan Jetha Chan
              Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10/Nov/14