Each row in the file needs to contain the following fields. It is assumed that each row represents a room booking. An action can be triggered on the main event start/stop times or the booking start/stop times. Only rows that have a particular status and have rooms assigned to equipment will be used for scheduling. This will be a daily import into Events2HVAC.
Each row should be sorted by TimeBookingStart prior to export to a file. The date range should include events for an entire day at least, with some overlap in time with the next planned import of events.
File name should be date coded with the date range of the query so the user importing the file doesn’t import a file with older events by accident.
Events_[YYYYMMDD]_[YYYYMMDD].csv or similar.
E2H Event Field Descriptions
|
Field Name |
Data Type |
Description/Notes |
|
EventID* |
String |
Unique ID (primary key) of the specific event occurrence |
|
ReservationID* |
String |
Unique ID (primary key) of the reservation holding all event occurrences |
|
EventName* |
String |
Name of the event |
|
RoomID* |
String |
Unique ID (primary key) of the room assigned |
|
RoomName* |
String |
Name of the room assigned |
|
BuildingID |
String |
Unique ID (primary key) of the building for the room |
|
BuildingName |
String |
Name of the building |
|
TimeBookingStart |
Date |
Optional - Start of the event reservation (includes setup time) |
|
TimeBookingEnd |
Date |
Optional - End of the event reservation (includes teardown time) |
|
TimeEventStart* |
Date |
Start of the main event |
|
TimeEventEnd* |
Date |
End of the main event |
|
StatusID |
String |
Unique ID of the status for the event (See event status information below) |
|
StatusDesc |
String |
Description of the status (confirmed, tentative, etc.) - event (See event status information below) |
|
FunctionID |
String |
Optional - Unique ID for the event function. |
|
EventType |
String |
Optional – Event Type |
|
ExpectedCount |
Integer |
Optional – Expected Attendees |
|
PercentCapacity |
Single |
Optional - % People Capacity of Event for the Room |
|
LastModified |
DateTime |
Optional – Last Modified Date/Time of the event record |
* = required fields