Learn@Illinois Moodle - Using UI Smart Import

The UI Smart Import is a tool that helps catch errors in files that will be uploaded to Moodle. The following is a basic guide for using this feature.

For a permanent link to this information, please use: http://go.illinois.edu/MoodleUISmartImport

  1. In your upload file, name the NetID column "NetID". This tells the Smart Import what field it is and lets it check to verify all of the students are enrolled and have correct NetIDs.
    NetID Column pic
  2. Save the file as a CSV.
    Save As CVS picture
  3. In the Administration block, click on Gradebook setup.
    Gradebook setup link picture
  4. Click Import to expand options. Then, select UI Smart Import.
    UI Smart Import link picture
  5. Click on Choose a Plain-Text Grade File (tab/csv)... and upload your grade file.
    Choose a plain text button picture
  6. Moodle will spend some time processing the file. When it is finished, a box will pop up below those buttons that will report whether the file is okay ("Precheck passed") or list any "Bad Rows". 
  7. Precheck Passed picture
    Bad Rows picture

  8. The bad rows are automatically removed from the grade file up above. If you need to edit a NetID and put it back in, you can edit it, then, copy/paste it into the box above. This will initiate a new Precheck to make sure the data file is now okay.
  9. When you're ready, click Upload grades. This will process the file.
    Upload grades picture
  10. On the next page, use the following settings:
    • In the "Identify user by" section:
      • Under "Map from", select NetID
      • Under "Map to", select Username
    • In the "Grade item mappings" section:
      • Under "NetID", select Ignore
      • Under the name of your assignment (the name of the Excel column in your file), select the name of the grade item in Moodle that you want to import to.
  11. Map from, Map to, NetID, assignment name
  12. Click the Upload grades button. It may take a bit of time and the page will continue to look like it's loading.
  13. Upload grade picture

Related Topics

Keywords:upload, grades, csv file, file error   Doc ID:78177
Owner:ATLAS-TLT .Group:University of Illinois Liberal Arts and Sciences
Created:2017-11-09 15:32 CDTUpdated:2019-04-10 10:03 CDT
Sites:University of Illinois Liberal Arts and Sciences
Feedback:  0   0