Messages

1

MySQL storage and Qloaderd/Uniloader / Re: MySQL 5 not working ?

« on: August 28, 2008, 15:27:43 »

It did fix my issue, thanks a lot!

2

MySQL storage and Qloaderd/Uniloader / Re: MySQL 5 not working ?

« on: August 28, 2008, 13:35:12 »

Code: [Select]

"Errore tecnico nella classe 'it.loway.app.queuemetrics.configurazione.inserisciCoda'.
-- Inner Exception --
- Exception: it.loway.tpf.common.exceptions.TechException
- Stack trace:
- Problema update DB: java.sql.SQLException: Incorrect integer value: '' for column 'id_coda' at row 1
- at it.loway.tpf.SQL.insertSql(Unknown Source)
- at it.loway.tpf.SQL.insertContext(Unknown Source)
- at it.loway.app.queuemetrics.configurazione.inserisciCoda.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:710)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
- at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:419)
- at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:394)
- at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
- at java.lang.Thread.run(Unknown Source)
-
-- End Inner Exception -- - "

3

MySQL storage and Qloaderd/Uniloader / MySQL 5 not working ?

« on: August 27, 2008, 15:41:04 »

I have storage setup for MySQL, everything works well, except for any kind of transaction does does a database SQL insert.  (I need MySQL 5 for data replication)

Am I the only one experiencing this?

4

Running QueueMetrics / Re: Stats on concurrent calls

« on: May 09, 2008, 15:01:15 »

Umm this is not what we want to do.  We want to staff based on calls, not hire more staff or less staff and hope we have enough staff.

Any idea what sort of raw SQL query I would have to do to get this query?

5

Running QueueMetrics / Stats on concurrent calls

« on: May 09, 2008, 03:10:10 »

Is there any method to find out how many concurent call wher over a period of time in an inbound queue?  I am trying to find out how many calls we get in peak times to improve staffing

6

QueueMetrics installation / Re: How to install queuemetrics in another server

« on: November 13, 2007, 16:49:29 »

In that instance, how does one have the realtime wallboard work? I cannot seem to get any stats in that instance.

Qloaderd is working fine, the data is on the MYSQL server, the string in configuration.properties points to that mysql server and the proper partition (I can pull reports and they look like they should)


EDIT:
Fixed it myself.

My problem was the fact that I edited the time offset in qloaderd.pl, when I should not as all my servers are in the same time zone

Code: [Select]

my $timezone_offset  = 0 * 3600;  # in seconds


7

Running QueueMetrics / 1.4.2 rendering bug in IE 7

« on: October 09, 2007, 20:45:16 »

If I open the realtime_wallboard in IE7, and a queue has a dash in it name
(for example queuename-test ) it will take two lines on the wall board in IE7 but not in Firefox

8

Running QueueMetrics / Re: CallerID absed Queues / Stats

« on: April 02, 2007, 19:47:05 »

Woudl it be possible to show a quick dial plan example of how to prefix a callerid?

From example: if a call comes in under callerid (num) = 555-555-1212 rewrite it as  91-555-555-1212

Thanks again

9

Running QueueMetrics / CallerID absed Queues / Stats

« on: March 20, 2007, 15:31:08 »

I have one General Queue defined in Asterisk, yet various customers of ours use that number to dial in.

I would like to have queuemetric present stats based on a customer, which in turn would be based a set range of callerids numbers.

For example, one customer of ours, has 8 different numbers their calls can show up on our callerid.  ANother customer has 5.

Thus I would like to see: call info for customer1 or call info for customer2

Regards,