1
Running QueueMetrics / Re: Generate reports and send them by email
« on: January 14, 2009, 20:36:41 »
That's was the problem. I changed and it's working .Thank you.
QueueMetrics professional call center suite for the Asterisk PBX
News:
Welcome to the new forum!
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
2
Running QueueMetrics / Re: Generate reports and send them by email
« on: January 13, 2009, 23:52:54 »
Hello All, I would really appreciate your help, I am trying to dowload using wget a report using robot user, my syntax is the following:
wget -O report.html http://SERVER:8080/queuemetrics/qm_rep.do?user=robot&pass=robot&queues=nopin-queue&t_from=2009-01-07.00:00:00&t_to=2009-01-10.12:00:00
I am getting an error. However if i copy and paste into a browser i get the report correcty. The error I am getting is the following:
"Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazione.preparaParametriReport'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Date error: either date is invalid (from: null to null - format: 'yyyy-MM-dd.HH:mm:ss') - at it.loway.app.queuemetrics.autenticazione.preparaParametriReport.setPeriodoTemporale(Unknown Source) - at it.loway.app.queuemetrics.autenticazione.preparaParametriReport.doRun(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(Unknown Source) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHost
please help!
wget -O report.html http://SERVER:8080/queuemetrics/qm_rep.do?user=robot&pass=robot&queues=nopin-queue&t_from=2009-01-07.00:00:00&t_to=2009-01-10.12:00:00
I am getting an error. However if i copy and paste into a browser i get the report correcty. The error I am getting is the following:
"Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazione.preparaParametriReport'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Date error: either date is invalid (from: null to null - format: 'yyyy-MM-dd.HH:mm:ss') - at it.loway.app.queuemetrics.autenticazione.preparaParametriReport.setPeriodoTemporale(Unknown Source) - at it.loway.app.queuemetrics.autenticazione.preparaParametriReport.doRun(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(Unknown Source) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHost
please help!
3
Running QueueMetrics / Re: Generate reports and send them by email
« on: December 09, 2008, 22:59:07 »
This is the the beginning of the file content saved:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>A problem occurred</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link rel="shortcut icon" href="/queuemetrics/img/favicon.ico">
<link rel="stylesheet" type="text/css" href="/queuemetrics/img/video.css" media="screen,projection" />
<link rel="stylesheet" type="text/css" href="/queuemetrics/img/print.css" media="print" />
</head>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>A problem occurred</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link rel="shortcut icon" href="/queuemetrics/img/favicon.ico">
<link rel="stylesheet" type="text/css" href="/queuemetrics/img/video.css" media="screen,projection" />
<link rel="stylesheet" type="text/css" href="/queuemetrics/img/print.css" media="print" />
</head>
4
Running QueueMetrics / Re: Generate reports and send them by email
« on: December 09, 2008, 22:15:55 »
Normally I think I would have a pop up and download a csv, txt or pdf file but I just get is the report of the day displayed in the browser. when I use wget i just get the html content saved into a file. Is there a way that I can send a CSV file by mail that contents the whole day activity in queuemetrics.
5
Running QueueMetrics / Re: Generate report using ROBOTS does no work
« on: December 09, 2008, 21:58:17 »
Thanks for the reply. According to my understanding, wget will download a CSV or Excel page for me? but When I tried it just saved a file with the content of the xml/html page. Is that the normal behaviour? If yes, is there a way that I can export the to text or CSV and send them to email on a daily basis?
6
Running QueueMetrics / Generate report using ROBOTS does no work
« on: December 09, 2008, 06:34:58 »
I have tried to use download report using the ROBOTS, It just shows me the report in the browser but NOT download it. Is that the normal behavior. Please help, I would like to run a crontab daily to send those reports by email.
Best regards,
James
Best regards,
James
7
Running QueueMetrics / Re: Generate reports and send them by email
« on: December 09, 2008, 06:24:42 »
I have tried to use download report using the ROBOTS, It just shows me the report in the browser but NOT download it. Is that teh normal behavior. Please help!
Best regards,
James
Best regards,
James
8
QueueMetrics installation / Re: Sql exception every time we create a new intem in the DB
« on: November 19, 2008, 03:52:44 »
I solved the problem using a less recent mysql connector. I was using 5.0 and i went back to 3.1 and it is working fine.
9
QueueMetrics installation / Sql exception every time we create a new intem in the DB
« on: November 18, 2008, 22:43:29 »
Every time I try to add a new user, queues, agents ( whatever) i'm getting this error; but it does not happen when I edit something already created like a user. The error is the following:
A problem occurred in QueueMetrics.
The following error occurred in the Transaction handler:
"Errore tecnico nella classe 'it.loway.app.queuemetrics.configurazione.cfg2.ptLocations'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema update DB: java.sql.SQLException: !Statement.GeneratedKeysNotRequested! - at it.loway.tpf.SQL.insertSql(Unknown Source) - at it.loway.tpf.SQL.insertContext(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.performSave(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.processEditor(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.PTProcessVerb(Unknown Source) - at it.loway.app.queuemetrics.configurazione.cfg2.ptLocations.doRun(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(Unknown Source) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) - at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) - at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) - at java.lang.Thread.run(Thread.java:595) - -- End Inner Exception -- - "
A problem occurred in QueueMetrics.
The following error occurred in the Transaction handler:
"Errore tecnico nella classe 'it.loway.app.queuemetrics.configurazione.cfg2.ptLocations'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema update DB: java.sql.SQLException: !Statement.GeneratedKeysNotRequested! - at it.loway.tpf.SQL.insertSql(Unknown Source) - at it.loway.tpf.SQL.insertContext(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.performSave(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.processEditor(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.PTProcessVerb(Unknown Source) - at it.loway.app.queuemetrics.configurazione.cfg2.ptLocations.doRun(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(Unknown Source) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) - at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) - at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) - at java.lang.Thread.run(Thread.java:595) - -- End Inner Exception -- - "
Pages: [1]