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

CSV Import for Gradebook: Various Problems

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.9
    • 1.9, 2.0
    • Gradebook
    • None
    • 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
    • MySQL
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE, MOODLE_20_STABLE
    • On Request

    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

            poltawski Dan Poltawski
            orhssoccerguy Rowan Chakoumakos
            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:
              3/Mar/08