Mazévo can import course data from a text file or an Excel file. However, you must format the data in a specific way to import it correctly. This article details the data file format necessary for the Mazévo Course Import Utility.
Import File Specifications
The file used for importing courses into Mazévo can be a comma-delimited text, 'tab-delimited' text, or an Excel file. Using the 'tab-delimited' or Excel format will be necessary if your data contains commas. The column order, data type, and maximum length are listed below. The column names need to match exactly and are case-sensitive.
Sequence | Description | Max width | Field Type | Format | Example |
1 | Department | 10 | Alphanumeric | Left Justified | ACCT |
2 | CourseNumber | 10 | Alphanumeric |
Left Justified |
101 |
3 | Section | 10 | Alphanumeric | Left Justified | 1 |
4 | 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 | BuildingCode | 10 | Alphanumeric | Left Justified | BUS |
8 | RoomCode | 10 | Alphanumeric | Left Justified | 215A |
9 | StartTime | 4 | Numeric | Right Justified, Zero Filled, Numbers only | 0900 |
10 | EndTime | 4 | Numeric | Right Justified, Zero Filled, Numbers only | 1030 |
11 | StartDate | 10 | Date, Optional | mm/dd/yyyy | 09/01/2020 |
12 | EndDate | 10 | Date, Optional | mm/dd/yyyy | 12/15/2020 |
13 | Enrollment | 5 | Numeric | Right Justified, Zero Filled, Numbers only | 00010 |
The Days column must be seven characters long, exactly. You must include any trailing spaces in the data.
The Days column is exactly seven 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, and End Date, columns are optional. If you are not using them, leave the column blank.