vicidial + queuemetrice Reporting.

[faqeerali]

[img]We have configured vicidial for out bound call centre application.
We are trying to use queuemetrice as a reporting tool for it, and we have configured vicidial for queuemetrice reporting through vicidial's web interface system setting.

queue metrice is showing the data through the queuemetrice storage info page.
Vicidial is also populating the queue_log lable of queue metrice.

The problem is that queuemetrice fails to generate any vicidial's reports,
please advice on vicidial + queuemetrice integration.

We are using queuemetrics-1.4.4 and vicidial 2.0.4[/img]

Best Regards
FQ

[mflorell]

What vicidial reports did you want QM to generate?

[faqeerali]

We want to generate the available reports which queuemetrics can generate for vicidial. We know that queuemetrics can only support the outbound reports for vicidial, but it is not supporting that at the moment .

[mflorell]

if you login to the queuemetrics mysql database, do you see the queue_log table being populated with records from VICIDIAL? (they should all have VIC as an identifier by default)

[faqeerali]

Yes queue_log table is being populated, and the VIC identifier is also there in the records.

Code: Select all

partition   
   
time_id   
   
call_id   
   
queue   
   
agent   
   
verb   
   
data1   
   
data2   
   
data3   
   
data4   
   
serverid   
   
unique_row_count   
P01    1215085744    NONE    NONE    NONE    QUEUESTART    
   
   
   
   VIC    1
P01    1215086592    NONE    TEST_IN    Agent/002    AGENTLOGOFF    002@agents    1    
   
   VIC    1
P01    1215090786    NONE    NONE    NONE    QUEUESTART    
   
   
   
   VIC    1
P01    1215101102    NONE    NONE    NONE    QUEUESTART    
   
   
   
   VIC    1

[mflorell]

In the 2.0.4 versions of VICIDIAL QM integration only works fully with RATIO and ADAPT dialing, not with MANUAL dialing in campaigns. The SVN trunk codebase does fully work with these however.

Did you create queues in QM to match campaigns in VICIDIAL?

[faqeerali]

We are using ADAPT dialing, and also we have created the queues in QM which match the campaign in vicidial, still the reports are not being created.

Any suggestions please?

-FQ

[mflorell]

Did you edit the configuration.properties in QM to use database queue_log instead of a flat file?

[faqeerali]

I have not edited queue_log_file in configurations.properties as below.

default.queue_log_file=jdbc:mysql://localhost/queuemetrics/queue_log

But when generating a report, it shows an error. "the file * doesnot exists".

Thanks for your prompt replies.

--FQ

[mflorell]

That should be set to this:
default.queue_log_file=sql:P01

Which will link to sqlPreset.1 parther down on the file.

[faqeerali]

I have setted that as below:
default.queue_log_file=sql:P01

And this is linking to sqlPreset.1 parther down on the file as below
"sqlPreset.1.table=queue_log".

But still I can't see any reports within queuemetrics.

Thanks a lot for yr prompt replies.

--FQ

[faqeerali]

Thanks a lot it is working now. When you select all queues and generate a report with QM it wont show any results,
But when you select a queue and generate a report it is showing the calls results.


Thanks
--FQ

[mflorell]

For some reason you need to setup all individual queues separately in QM and then set up an alias queue entry in QM that includes all of the queues to get total results.