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
DaysOfWeek text (length: unlimited) Optional
StartTime Time (13:00 or 1:00 PM) Optional
EndTime Time (13:00 or 1:00 PM) Optional
Classroom text (length: 255) 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 DaysOfWeek field needs to have the following format:

  1. This is the list of days of the week when the class is given, with slashes separating each day.
    For example: Mon/Wed/Fri means that the class is given every Monday, Wednesday, and Friday. The days can be specified using the first 3 letters of the day: (Mon)day, (Tue)sday, (Wed)nesday, and so on.

The StartTime field needs to have the following format:

  1. This is the start time of the class, in military time or standard time format. For example, 9:00 or 09:00 refers to 9:00 AM and 17:30 refers to 5:30 PM.

The EndTime field needs to have the following format:

  1. This is the end time of the class, in military time or standard time format. For example, 9:00 or 09:00 refers to 9:00 AM and 17:30 refers to 5:30 PM.

The Classroom is the name of the classroom where the class will take place and the instruction is given.

TIP: This classroom is one of the options that can be set when creating a Kiosk. The Kiosk is used to collect the swipes of the students signing in and it will follow the schedule for this classroom when set to a classroom.
NOTE: If you will be having different recurring sessions at different times in different classrooms then you will need to have a new line for each of these recurring sessions in the file.
Multiple Recurring Schedules Example: If a class is “Monday” and “Wednesday” from “9:00 AM” to “10:30 AM” in the classroom “101A” and “Thursdays” from “1:00 PM” to “2:00 PM” in the classroom “101B” then the one class will have 2 lines in the file like this:
Code Name Department Semester DaysOfWeek StartTime EndTime Classroom
MATH-101-01 College Algebra I Mathematics Spring 2025 Mon/Wed 09:00 AM 10:30 AM 101A
MATH-101-01 College Algebra I Mathematics Spring 2025 Thu 01:00 PM 02:00 PM 101B
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:

Back to Advanced Options | Back to Imports