Xibo Clock and House Points

[lmrogers]

Good Afternoon,

 

I have taken over a school which has a custom written signage solution. It is essentially a webpage with javascript and php to display images and a few other bits. This includes a clock which also shows which period of the school day it is, as well as a graph of house points which are extracted from SIMS.

 

I want to make this easier to manage for my team and for anyone new who starts. I have installed and set up Xibo but would like to keep the clock and house points display.

 

The question is how would I be able to do this as I can't seem to embed the php in the Xibo layout?

 

Thanks

[robyholmes]

I used the 'Datasets' area to input my periods of the day. Then using some SQL filters you can show one at a time using the dataset ticker widget. I can post more information tomorrow for you.

 

As for house points, can't help you with that I'm afraid.

[3s-gtech]

You can get Xibo to show a web page as part of the layout, of that helps. We used to have an overlaid clock on every slide - how on Earth we did it I can’t summon at the moment but I think it was a chunk of PHP in a region.

[DrBeaker]

Funny reading this post, a bit like going back in time for me.

 

Got tasked with investigating this at one place. Got as far as spreadsheets that IMHO the Heads of House would have updated and then from there it would have updated on the TV.

 

After numerous attempts, no-one was bothered to do it, update it etc so we had no choice to drop the idea. Pity but if the stakeholders weren't interested, what could we do?

[lmrogers]

I used the 'Datasets' area to input my periods of the day. Then using some SQL filters you can show one at a time using the dataset ticker widget. I can post more information tomorrow for you.

 

As for house points, can't help you with that I'm afraid.

 

Morning,

 

If you could post more information that would be great!

[robyholmes]

So we have a DataSet with lessons (Or Periods whatever you want to show) which has the end time in a column, like so:

 

As we run a two week timetable, we also have a Dataset for school weeks with a 'End Date' column rather than Time.

 

Then you add a 'DataSet Ticker' widget to your layout (Or sub playlist in our case as we display lesson and weeks in the same place, one after the other)

Configure it as follows:

The above filter is for the lessons/periods Dataset shown above. Its as follows: DATE_FORMAT(NOW(), '%T') < Time

 

If you want to show weeks, the filter is as follows: Now() <= WeekEnd

 

Hopefully that's all you need. From there you just format it how you want. The same system can be used for anything time or date based from a DataSet. We have another one for Assemblies as well.

[lmrogers]

Thanks for that, I'll give it a try and see if I can get it working.

[LukeAdl]

Hello have you got any more info on this? for the life of me can not figure it out.

 

Thanks,

[LukeAdl]

So we have a DataSet with lessons (Or Periods whatever you want to show) which has the end time in a column, like so:

[ATTACH=CONFIG]55345[/ATTACH]

 

As we run a two week timetable, we also have a Dataset for school weeks with a 'End Date' column rather than Time.

 

Then you add a 'DataSet Ticker' widget to your layout (Or sub playlist in our case as we display lesson and weeks in the same place, one after the other)

Configure it as follows:

[ATTACH=CONFIG]55346[/ATTACH]

[ATTACH=CONFIG]55347[/ATTACH]

[ATTACH=CONFIG]55348[/ATTACH]

The above filter is for the lessons/periods Dataset shown above. Its as follows: DATE_FORMAT(NOW(), '%T') < Time

 

If you want to show weeks, the filter is as follows: Now() <= WeekEnd

 

Hopefully that's all you need. From there you just format it how you want. The same system can be used for anything time or date based from a DataSet. We have another one for Assemblies as well.

 

Hi Can you show a screenshot of the edit column section for the dataset for the times?

 

Thanks