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

Copy and paste import from excel into the gradebook.

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.8
    • Fix Version/s: 2.8
    • Component/s: Gradebook
    • Labels:
    • Testing Instructions:
      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.
    • Affected Branches:
      MOODLE_28_STABLE
    • Fixed Branches:
      MOODLE_28_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      wip-MDL-46547-master
    • Story Points:
      100
    • Sprint:
      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

              Assignee:
              abgreeve Adrian Greeve
              Reporter:
              abgreeve Adrian Greeve
              Peer reviewer:
              Damyon Wiese
              Integrator:
              Dan Poltawski
              Tester:
              Jetha Chan
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Nov/14