Mazévo can import Events and Bookings 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 Event/Booking Import Utility.
Import File Specifications
The file for importing events and bookings into Mazévo is a simple tab-delimited text file. The column order, data type, and maximum length are listed below:
Order | Description | Max width | Field Type | Format | Example |
1 | Event ID | 8 | Alphanumeric | Left Justified | 1 |
2 | Organization Name | 100 | Alphanumeric |
Left Justified |
Basket Weavers |
3 | Primary Contact Email Address | 100 | Alphanumeric | Left Justified | bob@abc.com |
4 | Booking Date | 10 | Alphanumeric | MM/DD/YYYY | 02/01/2024 |
5 | Start Time | 4 | Numeric | hhmm, zero filled | 0800 |
6 | End Time | 4 | Numeric | hhmm, zero filled | 0900 |
7 | Building | 50 | Alphanumeric | Left Justified | Student Center |
8 | Room | 50 | Alphanumeric | Left Justified | Room 100 |
9 | Event Name | 200 | Alphanumeric | Left Justified | Weekly Meeting |
10 | Setup Style | 50 | Alphanumeric | Left Justified, Optional | Hollow Square |
11 | Setup Count | 5 | Numeric | Left Justified |
10 |
12 | Setup Minutes | 4 | Numeric | 0 to 720 | 0 |
13 | Teardown Minutes | 4 | Numeric | 0 to 720 | 15 |
14 | Event Type | 50 | Alphanumeric | Left Justified, Optional | Performance |
15 | Private | 5 | Alphanumeric | TRUE, FALSE | TRUE |
The Event ID column groups one or more date/time/room records (Bookings) into a single event. Rows with the same event ID will be grouped into a single event.
The following columns will be matched to existing records in Mazevo. If a matching record is not found, the import process will not continue.
- Organization Name
- Primary Contact Email Address
- Building
- Room
- Setup Style. (Optional, may be blank)
- Event Type (Optional, may be blank)