Meeting and Event Schedules through Xibo

1

Hi all,

We went live with Xibo at our conference / event center earlier this year. We switched from an ancient Janus system.

At this point, I am using a dataset containing a CSV of our daily bookings to appear on our main reader board. Here is what that looks like…

Pasted image559×932 54.9 KB

I’ve seen many examples of hospitality reader boards, but I wanted to see if there were any Xibo-specific examples.

Also, with Janus we were able to get the events to automatically leave the readerboard after their “End Times” passed. Is there a way to achieve this in Xibo without using the Ticker?

2

Below are some filter examples, where Col_TimeStamp is a dataset column in which I’ve placed dates in the format Y-m-d H:i:s (e.g. 2016-12-31 23:59:59)
Y = 4-digit year; e.g. 2016
m = month with leading zero; 01 ~ 12
d = day of the month, with leading zero; 01 ~ 31
H = hour with leading zero; 24-hour format; 00 ~ 23
i = minutes with leading zero; 00 ~ 59
s = seconds with leading zero; 00 ~ 59

to show only events that haven’t yet started
Col_TimeStamp > NOW()

to show only today’s events that haven’t yet started
Col_TimeStamp > NOW() AND DATE(Col_TimeStamp) = CURDATE()

to show only today’s events that will start at least two hours from now
Col_TimeStamp > DATE_ADD(NOW(),INTERVAL 2 HOUR) AND DATE(Col_TimeStamp) = CURDATE()

to show only today’s events that started less than 45 minutes ago or haven’t yet started
Col_TimeStamp > DATE_SUB(NOW(),INTERVAL 45 MINUTE) AND DATE(Col_TimeStamp) = CURDATE()

1 Like