Course Import File Specifications

This article details the format of the data file necessary for the Mazévo Course Import Utility.

Import File Specifications

The file that is used for importing courses into Mazévo is a simple comma-delimited text file.  The column order, data type, and maximum length of each columns listed below:

 

Sequence Description Max width Field Type Format Example
1 Department 10 Alphanumeric Left Justified ACCT
2 Course 10 Alphanumeric

Left Justified

101
3 Section 10 Alphanumeric Left Justified 1
4 Course Title 50 Alphanumeric Left Justified Intro to Accounting
5 Instructor 50 Alphanumeric Left Justified Dean Evans
6 Days 7 Alpha Positional  M W F
Building 10 Alphanumeric Left Justified BUS
8 Room 20 Alphanumeric Left Justified 215A
9 Start Time 4 Numeric Right Justified, Zero Filled, Numbers only 0900
10 End Time Numeric Right Justified, Zero Filled, Numbers only 1030
11 Start Date 10 Date, Optional mm/dd/yyyy 09/01/2020
12 End Date 10 Date, Optional mm/dd/yyyy 12/15/2020
13 Attendance 5 Numeric, Optional Right Justified, Zero Filled, Numbers only 00010

 

The Days column is exactly 7 characters long.  Any nonblank character in the 1st position will schedule the course on a Sunday. Any nonblank character in the 2nd position will schedule the course on Monday.

Character Position Day of Week
1 Sunday
Monday
3 Tuesday
Wednesday
Thursday
6 Friday
7 Saturday

 

The Start Date, End Date, and Attendance columns are optional.  If you are not using them, leave the column blank, but include a 'separator' character.