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

CSV Import for Gradebook: Various Problems

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9, 2.0
    • Component/s: Gradebook
    • Labels:
      None
    • Environment:
      Just in case:
          Linux infong 2.4
          PHP Version 5.2.4
          MySQL 5.0.45
          Window Vista Home Basic
          Firefox 2.0.0.11
    • Database:
      MySQL
    • URL:
      On Request
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      When trying to import CSVstored in Gradebook:

      To reproduce
      ===========

      1. Turn on Debugging in Moodle.
      2. Go to www.yoursite.com/grade/import/csv/index.php?id=

      {course id number}

      3. Attempt to import an CSV file.

      First Case
      ====================================
      Everything Correct:
      id,grade1,grade2,etc
      3,100,90,etc

      Map id to userid

      Expected result
      ============

      Successfully import of CSV.

      Actual result
      ==========

      user mapping error, could not find user with id ""

      First Case
      ====================================
      Everything Correct:
      id,grade1,grade2,etc
      3,100,90,etc

      Map id to useridnumber

      Expected result
      ============

      Successfully import of CSV.

      Actual result
      ==========

      user mapping error, could not find user with id "3"

      Second Case
      ====================================
      Everything Correct:
      email,grade1,grade2,etc
      johnsmith@smith.com,100,90,etc

      Map email to email address.

      Expected result
      ============

      Successfully import of CSV.

      Actual result
      ==========

      user mapping error, could not find user with email address ""

      Third Case
      ====================================
      Everything Correct:
      extra,email,grade1,grade2,etc
      extra,johnsmith@smith.com,100,90,etc

      Map email to email address.

      Expected result
      ============

      Successfully import of CSV.

      Actual result
      ==========

      Successfully import of CSV.

      Note
      ====
      It appears that there must be a place holder in the first column.
      However, I have yet to get the userid or useridnumber to work.
      Another person is also having an issue: http://moodle.org/mod/forum/discuss.php?d=87159

        Attachments

          Activity

            People

            Assignee:
            poltawski Dan Poltawski
            Reporter:
            orhssoccerguy Rowan Chakoumakos
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              3/Mar/08