Mazévo can import course data from a text 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 that is used for importing courses into Mazévo is a simple comma-delimited text file. However, in some cases, it may be necessary to use a 'tab-delimited' file if your data contains commas. The column order, data type, and maximum length are 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 Code | 10 | Alphanumeric | Left Justified | BUS |
8 | Room Code | 10 | 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 | 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, and End Date, columns are optional. If you are not using them, leave the column blank.