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

Copy and paste import from excel into the gradebook.

    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 (Obsolete):
      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

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