Messages

1

MySQL storage and Qloaderd/Uniloader / Re: Upload old stats from queueloq

« on: June 19, 2007, 00:55:12 »

OK, I think I have this figured out. IF you are not using the MySQL storage, QM can only report on the data it sees in queue_log. If you are rolling your queue_log, you'll truncate the data available to QM. It may make sense to point this out in the docs (for morons like me ;-))

As I understand the docs, I do not think my call center is high volume enough to warrant using MySQL storage. However, does that mean I can never roll queue_log? Is it possible to have QM read the current and the last queue_log? Here is what my /var/log/asterisk looks like:

/var/log/asterisk$ ls -ltrh | grep queue
-rw-r--r--  1 root root 330K Jun 15 18:02 queue_log.0
-rw-r--r--  1 root root  45K Jun 19 09:07 queue_log
chaag@asterisk4:/var/log/asterisk$

thanks,

Chris

2

MySQL storage and Qloaderd/Uniloader / Re: Upload old stats from queueloq

« on: June 18, 2007, 21:06:35 »

OK,

One sanity check... table queue_log is already empty. However, I do have data in the actual (web) reports. (weird no?)

Something odd may be going on here, This a one week old QM installation ( we had a server hardware problem and moved asterisk and QM to a new server last week).

When I went home Friday night I had a weeks worth of data in the QM reports. This morning, I only have data since Saturday (~2.5 days worth). To my knowledge, nothing was done on the server except an automated Asterisk restart (/etc/init.d/asterisk restart) early Saturday morning. I have restarted Asterisk in the past w/o losing data, so by my own experience I know they are decoupled. Now, I am at a loss as to what happened to the previous weeks data.

$ last shows no activity on the server, so I don't think we have a saboteur, (unless he had a root kit ;-))

Any suggestions?

thanks!

3

MySQL storage and Qloaderd/Uniloader / Re: Upload old stats from queueloq

« on: June 18, 2007, 18:43:19 »

When you say "delete all data" which tables are you referring too? (running 1.3.5). Just want to confirm before I delete.

Also, should restarting asterisk cause data loss in QM?

thanks,

Chris

4

Improving QueueMetrics / Option to "show" days with 0 calls

« on: April 03, 2007, 19:42:32 »

Currently, in the "Answered call distribution per day" report, days where no calls are received are skipped (not shown).

When pulling data for different queues into excel, it is painful to go line up all the missing dates and add in a "0".

To make pulling QM reports into excel easier, I'd love a config option to "show 0 call days in per day report"

thanks

5

Improving QueueMetrics / Re: Report based on call duration

« on: April 02, 2007, 19:36:18 »

To see this info now:
open a report > Answered Tab > Report details answered calls (at bottom) and then sort on duration.

Not exactly the report you wanted, but it would be easy to open this report in excel and get exactly what you want.

Just a thought

6

Improving QueueMetrics / Re: Report based on call duration

« on: April 02, 2007, 18:03:12 »

That would be very useful.

7

Improving QueueMetrics / Bookmark custom reports

« on: April 02, 2007, 18:02:42 »

Ability to generate a custom report and then send a special URL. Users receiving the URL, perhaps in an email, after authenticating, would see the same report as the report creator. Similar to sending a Google search URL.

To do this, QM would have to add the report criteria as parameters to the URL, for ex:
http://asterisk.example.com:8080/queuemetrics/qm/results_p_answered.jsp?start=2007030100:00:00&end=2007040100:00:00&queue=all&agent=all&location=all

8

Running QueueMetrics / Re: Does anyone have the XML RPC API working with 1.3.3?

« on: March 14, 2007, 17:07:20 »

Success! (and embarrassment)

In my lame understanding of Tomcat, I had somehow assumed /qm130/ was actually meaningful, rather than simply how the example instance had been set up. Works great when I use a valid URL.

Apologies for such a silly question.

Thanks for the help

9

Running QueueMetrics / Re: Does anyone have the XML RPC API working with 1.3.3?

« on: March 14, 2007, 16:29:51 »

(doh!)
same error with .do, thanks for taking a look, I have an exec dashboard on another system that shows calls per day (and other stats), it would be nice if I could just pull each days data over via this interface.

thanks!

>>> server = xmlrpclib.Server("http://127.0.0.1:8080/qm130/xmlrpc.do")
>>> server.system.listMethods
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.3/xmlrpclib.py", line 1029, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.3/xmlrpclib.py", line 1316, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.3/xmlrpclib.py", line 1070, in request
    headers
xmlrpclib.ProtocolError: <ProtocolError for 127.0.0.1:8080/qm130/xmlrpc.do: 404 /qm130/xmlrpc.do>

10

Running QueueMetrics / Re: Does anyone have the XML RPC API working with 1.3.3?

« on: March 14, 2007, 16:03:12 »

I tried connecting directly from the server that hosts queuemetrics
Python 2.3.4 (#1, Sep 26 2006, 17:23:01)
[GCC 3.4.6 20060404 (Red Hat 3.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sys
>>> import xmlrpclib
>>> server = xmlrpclib.Server("http://127.0.0.1:8080/qm130/xmlrpc.dp")
>>> server.system.listMethods
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.3/xmlrpclib.py", line 1029, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.3/xmlrpclib.py", line 1316, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.3/xmlrpclib.py", line 1070, in request
    headers
xmlrpclib.ProtocolError: <ProtocolError for 127.0.0.1:8080/qm130/xmlrpc.dp: 404 /qm130/xmlrpc.dp>


Tailing the logs shows nothing, I'd guess I am simply not connecting, is there a way to force a connection using telnet or something?

11

Running QueueMetrics / Does anyone have the XML RPC API working with 1.3.3?

« on: March 13, 2007, 01:12:14 »

Is the XML RPC still included in the latest builds? I can't seem to get this working, and it appears the file itself is simply missing:
chaag@phoneserver:/usr/local/queuemetrics/tomcat/webapps$ find . -name xmlrpc.do
chaag@phoneserver:/usr/local/queuemetrics/tomcat/webapps$

When I try to connect I get a 404 HTTP response
server_url = 'http://asterisk.ironport.com:8080/qm130/xmlrpc.do'

thanks

chris