Topics

1

MySQL storage and Qloaderd/Uniloader / queue_log table fields

« on: March 21, 2007, 21:29:48 »

I'm using qloaderd script to copy queue_log records to MySQL. I followed the instructions and everything works fine. One of our customer requested a specific format of the queue stats in order to import this data into another statistic software.

1. I need to re-elaborate the basic log information but could not find enough about the standard fields of the queue_log table in queuemetrics MySQL db. Any suggestions about the field meaning (especially data1..data4 and verb), so I can build my own queries? 

2. Secondly, is there any way to extract the Answered Calls (and Unanswered Calls) detail page in a CSV/XML format automatically or from a script/software? I was able to write a program which takes CSV exported data form QM and builds up data into a specific custom format, so I wonder if I can import data automatically instead of manually feed my script.

Thank you for your support.

David

2

Running QueueMetrics / changing stats information

« on: March 12, 2007, 18:00:16 »

Hi there and congratulations for this great piece of software!

I've been using QM for about a week and I am very satisfied of its features.
In order to use it in a production environment I need the following changes to the statistics showed by the application:

- in Answered/unanswered Calls the first step to the Service Level Agreement should be 12 seconds instead of 10. That is a precise request coming from one of our customers. I wonder if there is a configuration file where one could change the default time intervals. I also thought about importing the queue_log file to MySQL and then execute my own queries, but I would like to use QM's nice web stats pages.

- in Distrib. / Answered call distribution per hour page, I would like to see the stats "per half an hour" instead of "per hour". For example, the rows should contain 8:00 then 8:30, 9:00, 9:30 and so on. Same idea for the stats contained in the same page.

Thank you very much for your time and attention.

David La Monaca
Press4Web
Roma - Lugano (CH)