Import calendar items from Excel

Here's how to do it

1. Go to Settings and select Calendar Settings.

2. Click Import to open the import dialog.

3. Click Download Template.

4. Open the template in Excel.

5. Fill in the calendar entries in the “Calendarprocesses” sheet.

6. Select the updated template in the import dialog.

7. Check the “Update existing” box if you want to update calendar events that already exist. The events are matched by name. If this box is unchecked, they will be skipped.

8. Click Import. Rows that were skipped are displayed in the dialog along with the reason.

Common fields

Name

The name of the calendar object.

Type

Select the calendar object type: Room, Generic, BacnetScheduler (BACnet schedule), or BacnetCalendar (BACnet calendar).

Mode

The name of the data point used to change the mode of the object.

Write last

Enter “Yes” if the Evolo Gateway is to write the last value after a restart. If the field is left blank, the last value will not be written.

Fields for generic calendar objects

Cyclic

Yes if Evolo should write the active mode cyclically to the data points.

Cyclic interval

Select the interval for cyclic writing. Valid values are 5, 15, 30, 45, 60, 120, 240, and 360 minutes.

Mode options

Here you define which mode options the calendar object should have. This field is required for Generic, Room, and BacnetScheduler. It is filled out as a JSON list where each option has value (a number) and display_name. Generic objects require at least one option; room objects require at least two.

Example:

[{"value": 0, "display_name": "Av"}, {"value": 1, "display_name": "På"}]

Fields for room calendar objects

Room temperature

The name of the data point that reads the room temperature.

Room setpoint

The name of the data point that reads the room setpoint.

Outside temperature

The name of the data point that reads the outside temperature of the building.

Fields for BACnet calendar objects

The template includes examples of both a BACnet schedule and a BACnet calendar.

Weekly schedule, Exception schedule, and Effective period

Used by the “BacnetScheduler.” The names of the data points for the weekly schedule, exceptions, and validity period, respectively. Only “Weekly schedule” is required.

Data type

Required for “BacnetScheduler.” Valid values are “BOOLEAN,” “REAL,” “ENUMERATED,” “UNSIGNED_INTEGER,” and “SIGNED_INTEGER.”

DateList

Required for BacnetCalendar. The name of the data point for the date list.