SQL Query regular refresh

Is there a way to pull in SQL data from an outside source and have it refresh regularly? I see the ‘DataSet’ module, but that is manual entry.

Thanks,
Tim

I guess you could use the API (that is still in beta). You could make a python script to pull the necessary data using a query and put this data into the datasets using the API.

We pull in SQL data (Microsoft & Mysql) using php, generate a html page and display the info in Xibo using the webpage media type. Works great, been able to get some good visuals using HTML5 and Css3

When you poll the data, how do you filter?
Can you post any screen shots of that display solution?

Hey Rob,

Is your question for me?

See attached in pdf of the php code i am using, i grab the entire record set from SQL then use a each row as a page number, then display 1 row at a time, in my case random rows as i found i always got the same records all the time

Sorry code is a bit messy, knocked this together late one night and as it works have not touched it again.

Example.pdf (35.2 KB)

Let me know if you have any questions
Thanks
Ben

That looks like it will work. I’ll give it a try using my data sets.