meta data for this page
  •  

Class Schedule Import

Class Schedule Headers
Field Field Type Import? Notes
Code text (length: 30) Required Primary Key
Name text (length: 255) Required  
Department text (length: 255) Optional  
Semester text (length: 255) Required  
Schedule text (length: unlimited) Optional  

Explanation:

The class code has to be unique for each semester. If there are 2 (or more) classes with the same code, in the same semester, they will be merged.

The Name is just a friendly name that will help you visually identify the class, it's usually displayed along with the Code.

The Department is optional.

The Semester is mandatory and it must exist before you import the class file. The semesters are not automatically created to reduce to possibility of errors.

The Schedule field needs to have the following format: <days> <start>-<end> <classroom> Where:

  1. <days> is the list of days of the week when the class is given, without spaces.
    For example: MoWeFr means that the class is given every Monday, Wednesday, and Friday. The days can be specified using the first 2 or 3 letters of the day: (Mo)nday, (Tu)esday, (We)dnesday, and so on.
  1. <start> is the start time of the class, in military time. For example 900 or 0900 refers to 9:00am, 1730 refers to 5:30pm.
  2. <end> is the end time of the class, in military time. Please note that it has to be separated from the start time using a hyphen.
  3. <classroom> is the name of the classroom where it's given.

Regular schedule (Recurring sessions) example:

If class is Mondays and Thursdays, from 9am to 10:30am in the classroom A-101.

MoTh 900-1030 A-101

You can specify multiple recurring day/times and different classrooms separating them by a slash (/), for example:
MoWeFr 900-1030 A-101 / TuTh 1400-1530 A-101

Irregular Schedule (One-time meetings) example:

To specify the class meets July 29th, 2013 from 3pm to 5:45pm in the classroom A-101.

20130729 1500-1745 A-101

You can specify multiple one-time meeting times for different times and classrooms by separating them by a slash (/), for example:
20180813 900-1030 A-101 / 20180814 1400-1530 A-201 / 20180815 1100-1230 A-203
To avoid frustration name the Classrooms without any spaces as this typically indicates to the AccuClass import job that you are starting on the next field. As an example change “Room 101” to “Room-101” or even “RM101”. This will save you a lot of time troubleshooting the issues with the CSV import file.

Example:

Download the example file (.csv)

Back to Advanced Options | Back to Imports