Re: CSQ Stats on idle 7960 screen

g.kwait · ‎10-21-2004

Does anyone know of or have a application that would display stats about a particular CSQ as the idle screen on 7960's? I am looking to replace our company logo as the idle screen for the phones in our IT dept. I would like to display Calls in Queue, Agents logged in, Agents talking, and just some other basic CSQ overview stats. Does anyone know where to start?

Thank you.

g.kwait · ‎10-25-2004

Nevermind, I figured it out shortly after I posted. The trick is to you an HTTP trigger with a script on the back end that gathers a bunch of reporting stats and then uses a JSP send to send the data to a JSP page. If you are interested let me know, and I can send you the JSP and the AEF script.

jfrelin · ‎10-25-2004

Can I get a copy of this jsp and aef? What kind of stats are getting reported back to the phone? # in Queue, average wait, etc?

Thanks!

-jjf-

g.kwait · ‎10-25-2004

Here you go.

Keep in mind you will need to configure a couple of things. The script will display: Agents logged in, Agents Ready, Agents Talking, Calls in Queue, Oldest call in queue (sec), and total calls handled.

1st. You need to create an HTTP trigger (mine is /stats). To configure the application you need to specify the CSQ parameter, this is the CSQ you wants stats of.

Next place the stats.jsp page in your /wfavvid/tomcat/webapps/root/ folder. I created a sub folder called CSQ.

The last thing you need to do is modify the JSP page so that the refresh page points to the location where you have the JSP located. Oh, you also need to modify your users phone to either add as a service, or I changed their idle url to that of the http trigger. That way it is like having a scrolling LED board, except at each users phone.

I am sure I left out some steps, so if you get stuck/lost, let me know.

acowne · ‎05-04-2005

Hi,

I'm trying something similar to what you are doing.

I want to create an application that will call a jsp and that jsp page will then call another jsp.

I have added the http trigger and put the jsp file under c:/program files/wfavvid\tomcat\webapps\ROOT

but this is not triggering the application. could you point me to the right direction and let me know what i'm missing?

Thank you,

Adriana

g.kwait · ‎06-28-2005

I have the script pointing to a sub-directory of c:/program files/wfavvid\tomcat\webapps\ROOT called c:/program files/wfavvid\tomcat\webapps\ROOT \CSQ.

Put the stats.jsp in that folder (or you can modify the AEF to point to wherever your script is).

Hope this helps

jfrelin · ‎06-13-2005

I've done the above, but I can't seem to get it to trigger. It gives me an error 500 (with this being the most specific: javax.servlet.ServletException: bean parameters not found within scope). Ideas?

g.kwait · ‎06-28-2005

I had an error in my original post. Put the JSP in the folder c:/program files/wfavvid\tomcat\webapps\ROOT\CSQ. Hope this helps.

jfrelin · ‎08-01-2005

Still having the same problem and it is setup as you mentioned...

2005-08-01 02:37:09 - Ctx( ): Exception in: R( + /CSQ/stats.jsp + null) - javax.servlet.ServletException: bean parameters not found within scope

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459)

at CSQ._0002fCSQ_0002fstats_0002ejspstats_jsp_0._jspService(_0002fCSQ_0002fstats_0002ejspstats_jsp_0.java:128)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)

at org.apache.tomcat.core.Handler.service(Handler.java:286)

at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)

at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)

at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)

at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)

at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)

at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)

at java.lang.Thread.run(Unknown Source)

Root cause:

java.lang.InstantiationException: bean parameters not found within scope

at CSQ._0002fCSQ_0002fstats_0002ejspstats_jsp_0._jspService(_0002fCSQ_0002fstats_0002ejspstats_jsp_0.java:78)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)

at org.apache.tomcat.core.Handler.service(Handler.java:286)

at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)

at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)

at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)

at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)

at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)

at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)

at java.lang.Thread.run(Unknown Source)

t.kartsonakis · ‎08-08-2005

Hi Jfrelin and everyone !

I am trying to use this scrip and I get exactly the same error as above...Did you manage to make this work ???

jfrelin · ‎08-08-2005

Yes. I was able to get it to work and can get information if I browse via a IE window to the link, but I can not make it work on the phone.

Thoughts?

jefflock1 · ‎08-11-2005

You all got farther than I did. I don't even have the option to make an HTTP Trigger. I only have JTAPI. Do I have to install something extra? Do I have to configure anything in Microsoft's IIS to make the webpage work?

andri · ‎08-11-2005

You need the IPCC premium edition to configure HTTP triggers.

Regards

Andri

roberts · ‎09-29-2005

What was the fix to get rid of java error:500?

I've placed the stats.jsp in K:\Program Files\wfavvid\tomcat\webapps\ROOT\CSQ

My http trigger points to http://172.17.1.1:8080/CSQ/stats.jsp and is associated to an application.

I've supplied my CSQ name in the script and uploaded the script.

I've modified the "refresh" in the jsp to point to http://172.17.1.1:8080/CSQ/stats.jsp"

I've placed the Idle URL info on my phone.

I've tested using IE.

Am receiveing the ERROR: 500

javax.servlet.ServletException: bean parameters not found within scope.....etc

Any help would be appreciated.

darryl.wilson · ‎11-17-2005

Did you ever get this figured out? I am having the similiar error and must be doing something silly because logically, it all makes sense... Any help would be appreciated.

Thanks...D