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 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
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 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
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.