Course Import File Specifications
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 comma-delimited text, 'tab-delimited' text, or an Excel file. If your data contains commas, using the 'tab-delimited' or Excel format will be necessary. 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 | See Note Below | |
| 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 |
Format Options for Days column
There are 3 different formats available for this column:
1. Positional (Original Format)
2. Numeric
3. Character
Positional format
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 |
Example: _x_x_x_ would represent a Monday, Wednesday Friday course
Numeric Format
This format uses numbers (1 through 7) to indicate the days of the week. The order of the numbers does not matter. The value 246 indicates a Monday, Wednesday, and Friday date pattern, but you can also specify 642 for the same pattern.
1= Sunday
2= Monday
3= Tuesday
4= Wednesday
5= Thursday
6= Friday
7= Saturday
Character Format
This format uses letters to indicate the days of the week (UMTWRFS). The order of the characters does not matter. The value MWF indicates a Monday, Wednesday, and Friday date pattern, but you can also specify FWM or WMF for the same pattern.
U= Sunday
M= Monday
T= Tuesday
W= Wednesday
R= Thursday
F= Friday
S= Saturday
The Start Date, and End Date, columns are optional. If you are not using them, leave the column blank.