Course Evaluations

Here is a list of the common import errors that we typically see:

1. Overarching Items

• Files needs to be saved as .CSV file format
  Solution: Make sure that the import files are saved as .csv, not .xlsx or .xls
• Leading Zero's may have been dropped from the file
  Solution: follow this article to re-add leading zeros

2. Faculty Import and Student Import

• Errors can occur when information is missing such as a password, email address, or if the import is trying to update non-updateable fields (such as the username or password)
  Solution: Be sure to carefully proof the .csv files before import to ensure accuracy of information

3. Course Import

• Errors include no matches for an Instructor
  Solution: Check to make sure the correct instructor data (username, ID, or email) is identified when matching the instructor identifier header to its data column or that the faculty was in fact brought in with the faculty import
  • Remember, only one faculty member can be attached to a course using the Course Import
    • To attach additional faculty for team-taught courses, you will need to do an additional enrollment import, "Enrollment Import-Responsible Faculty"

      
      

• There may be an issue if the system doesn't recognize department names brought in with the courses
  Solution: To avoid this error, make sure the departments brought in with the Faculty Import are consistent with the ones brought in with the Course Import

4. Enrollment Import

• Errors include the following:
  • The assessment period does not match the assessment period brought in with the Course Import
    Solution: Make sure period/term used in the Course Import matches the period/term used in the enrollment import
  • The Course number does not match the number in the Course Import
    Solution: Make Course Number used in the Course Import matches the Course Number used in the enrollment import
    • Leading Zero's may have been dropped from the file
  • The Section number does not match the number in the Course Import or is missing
    Solution: Make sure Section Number used in the Course Import matches the Section Number used in the enrollment import
    • Leading Zero's may have been dropped from the file
  • The incorrect role is chosen (Students, Responsible Faculty, Participating Faculty, Course Director)
    Solution: Make sure the correct role is chosen when doing the Enrollment Import
    • The Student option needs to be selected in the role drop-down when doing the student enrollment import
    • The Responsible Faculty option needs to be selected in the role drop-down when doing a team-taught faculty enrollment import
    • The Participating Faculty option needs to be selected in the role drop-down when doing an import with faculty in a lesser role than the Responsible Faculty. 
      Example: Lab instructor, quest lecturer
    • The Teaching Assistant option needs to be selected in the role drop-down when doing the TA enrollment import
    • The Course Administrator option needs to be selected in the role drop-down when doing the Course Administrator import
  • The incorrect data in the file for the person identifier
    Solution: If the system cannot find a person, check the original Faculty and Student Imports to make sure they are on that list and that their data is correct
    
    

Related Articles:

Imports  - An Overview

Import Settings - In Depth

Saving As A CSV File