Course Import File Specifications

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
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 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 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
Monday
3 Tuesday
Wednesday
Thursday
6 Friday
7 Saturday

 

The Start Date, and End Date,  columns are optional.  If you are not using them, leave the column blank.