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

Import succeeds unintentionally if csv file contains id which has number and string mixed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.5.13, 3.7.7, 3.8.4, 3.9.1
    • Fix Version/s: None
    • Component/s: Gradebook
    • Labels:

      Description

      Hi,
      In MariaDB and latest 3.9.1 code I found a problem.

      When I import grade from /grade/import/csv/index.php, and select not 'ID number' but 'User ID', if csv file has id like '1A100' or '4B200', program unintentionally passes with no error and outputs message 'Grade import success'.

      Behind the scene, for the above example, user id 1 and 4 is selected and set studentid the value.

      I can write a patch to fix this in Moodle fashion.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            intrajp Shintaro Fujiwara
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: