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 |
7 | 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 | 4 | 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 |
2 | Monday |
3 | Tuesday |
4 | Wednesday |
5 | 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.