Facilities
      Back to home
      1. Mazevo Knowledge Base
      2. Setting Up The System
      3. Facilities

      How to Import Buildings and Rooms

      Mazévo can import buildings and related rooms from a CSV, TXT, or Excel file. However, importing will only create new buildings and rooms. Updates to existing records are not supported.

      Overview and what gets imported

      Records that are imported:

      • Mazévo will create new buildings if the building name doesn't already exist.
      • Mazévo will create new rooms if the room name doesn't already exist in the room table.

      File Format Requirements

      The file needs to be in one of the following formats:

      • Text file in a CSV (comma-separated values) format
      • Tab-delimited format
      • Excel Spreadsheet

      The first row in the file needs column names (shown in bold below), and the names must match exactly (case-sensitive).  

      The columns need to appear in the following order:

      • Building (Required - text)
      • TimeZone (Optional - text - if blank, you'll be prompted to select a timezone during import processing).  Valid values are:
        • Pacific Standard Time
        • Mountain Standard Time
        • Central Standard Time
        • Eastern Standard Time
      • Room (Required - text)
      • RoomType (Optional—text): You should first define Room Types in Mazévo to match the values in this column.
      • SetupMinutes (Optional - integer - defaults to 0 if not specified)
      • TeardownMinutes (Optional - integer - defaults to 0 if not specified)
      • MinCapacity (Optional - integer - defaults to 0 if not specified)
      • MaxCapacity (Optional - integer - defaults to 0 if not specified)
      • RoomCards (Optional - integer - defaults to 1 if not specified)
      • ExternalNotes (Optional - text)
      • InternalNotes (Optional - text)

       

      Importing data

      1. Navigate to Settings > Rooms.
      2. Press Import. Importing Rooms
      3. Press Upload Room File and select the file from your system, and a list of buildings that Mazévo will import is displayed.  If the data doesn't include the timezone, you must set it before proceeding.
      4. Press Import Buildings to start the building import. This step will be skipped if no new buildings exist in the import file. 
      5. When buildings have been imported, Mazévo will display a list of rooms.  Press Import Rooms to begin the room import.