Blogs

CELCAT Timetabler offers tools and features that allow users to manage most aspects of an institution’s timetable. Nevertheless, we occasionally receive requests for very specific features that are only of interest to one or two institutions at the most.

The good news is that there are a number of CELCAT tools that can give users the ability to customise their system to meet their specific needs. For example, CELCAT Web API allows users to view and manage timetable data from third party applications developed in-house and CELCAT SIM allows you to export data or synchronise CELCAT data with data from other sources.

Even more useful is having your CELCAT timetables stored on a Microsoft SQL Server, which gives you greater control over your data. With the right knowledge and resources, you can make use of the SQL Server features to create bespoke reports, through views or stored procedures, using tools such as Power BI or SQL Server Reporting Services.

One (albeit little known) feature included in CELCAT Live, called Live Links, is a powerful tool.

Live Links allow users to open links from within CELCAT Live. These links could be a simple shortcut or include contextual information originating from the Live interface. For example, if you select a room in CELCAT Live, a Live Link can use the room ID to open a Power BI report specifically for that room. The sky’s the limit! The screenshot below shows what can be achieved with a mini PHP site integrated within CELCAT Live.

This example was created in a collaboration with a French university. It generates customised statistics which can be both viewed on the screen and downloaded as an Excel spreadsheet. So, imagine what you could do for your institution!

Would you like to export a resource’s timetable over a specific time period into Excel? That too is possible when coupled with another CELCAT tool, Datastore (which has been open source since early 2020).

SQL commands can also be launched from the interface. In the example below, you can delete a register that has been created by mistake:

To find out more, please feel free to contact us. We are happy to provide information on Live Links and can assist you with their implementation.