OTRS status on external display

[montoxic]

Hi

I am thinking of doing some sort of external display, where i display open, new, escaleted tickets and so on external monitor that are in the support room.

Is there anyone that has done something similar, any tips or tricks?

I have 2 current ideas.

1. Create a webpage and retrieve the data from the DB after som detective work to discover the best way to retrive the data

2. Export the wanted data from DB to an excelfile with data and then have powerpointfile that retrives the data from the file and then show in it in a form slideshow and also and som other slides and more "easier" way to some graphics.

Regards Montoxic

[jojo]

At the moment there is no generic way to do so.

I suggest to use SQL based, API based or webservice based data retrival.

There are some nice dashboard tools, like http://shopify.github.io/dashing/ which you might use as a base for your project.

[jojo]

https://github.com/obazoud/statusdashboard would be also a nice approach

[montoxic]

Hi

Thanks for the tip, i am evaulating this 2 tips. I will post my result when im done.

[goteamtim]

I was hoping to do the exact same thing, did you ever get this dashboard up and running? I was thinking of digging through the titles of the queues and stripping out the numbers to get current ticket counts. My post is linked below but any information would be helpful. Thank you!

viewtopic.php?f=61&t=22255

[montoxic]

I am currently working on it right now. will post after i success or fails.

[goteamtim]

Great thank you!

I am not sure if you decided on how to display your information but another option would be to go with a raspberry pi and screenly. This is what we are currently using http://www.screenlyapp.com/ose.html and so far its working great. We built a simple webpage that is "hosted" on a dropbox account and it pulls data from a google spreadsheet to update various statistics. Right now the ticket count is manually entered in but eventually we would like to generate this automatically. Good luck, look forward to hearing what you end up going with and if you are able to pull the ticket count automatically.