Bulk Enroll Extension Students using Flat File (CSV)

The Extension Course Management site uses a flat file enrollment plugin to allow Extension Course instructors to 1) create a GauchoSpace course page and 2) bulk enroll or unenroll course participants with valid UCSBNetIds simultaneously using just a CSV file.

Jump to...

Creating your flat file (file specifications)

It is very important that the file data and file name meet the criteria below:

Enroll (Adds)

• Files must be comma-delimited .csv files and must be named by the quarter.
  • E.g. Winter 2019 is: 20191.csv, Spring 2019 is 20192.csv
• Files must have a header row with the following column headings:
  CourseShort, CourseTitle, UCSBNetID, Role, Operation
  • CourseShort must be a unique  It may contain spaces and you can use the same for the CourseTitle if you like.
  • CourseTitle may be the same as CourseShort
  • UCSBNetId must be the students' valid ID or the user will not be added.
  • Role may be one of instructor, student, editingta, noneditingta. Some roles may be renamed by the system, which you should not worry about.
  • Operation is optional, but should be either add or del. If you leave it blank, the assumption is to add.
  • 

Unenroll (Delete)

• Format the file exactly the same as above, except the operation column:
  • For the students you would like to delete, input del in the operation column next to the student. If you leave it blank, the assumption is to add.
  • 
  Back to the top

Other things to note:

• If you do not include all the students currently in the course they will NOT be dropped.
  • The only means to drop students from a course is to manage enrollments inside the course or to put del in the operation column for the student.
• All rows must include all column data.
• If you upload a file of the same name, the script will process the most-recent file.
• The script will not enroll anyone twice.
• The deletion of the CSV file from the Extension Course Management site doesn't cause the deletion of the courses or the participants.
• The shortname indicates that the participant should be enrolled in that course, and if that course does not exist, the course should be created.
  • This means a typo in the shortname will create a new course. This also means that duplicate shortnames do not create duplicate courses.
• There is a block provided to you to kick off the process so that you can see the results, including errors. The process will happen automatically every few hours if you don't do it yourself.
• When the automated process runs, the script will look for the most recent CSV file for the current quarter, check for a change in the file. If no change is found, the file will not be processed. If changes in the file are found, the file will be processed.
• If you delete the most recent file, the next-most recent file may be processed by the automated script. It may be wise to periodically delete all of the CSV files.