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

Copy and paste import from excel into the gradebook.

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Fixed
    • Icon: Minor Minor
    • 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

      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.

            abgreeve Adrian Greeve
            abgreeve Adrian Greeve
            Damyon Wiese Damyon Wiese
            Dan Poltawski Dan Poltawski
            Jetha Chan Jetha Chan
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.