Messages

676

Running QueueMetrics / Re: how to set the query permission

« on: August 19, 2011, 10:45:42 »

No at the moment this is not possible.

677

QueueMetrics installation / Re: Unanswered yet calls in unanswered detail

« on: August 19, 2011, 10:35:41 »

Lorenzo tells me he has answered you on Tuesday; if you did not receive it there must be some antispam or anything.

678

General Asterisk configuration / Re: Asterisk 1.8 does not write queue_log to file

« on: August 17, 2011, 12:36:36 »

QM at the moment does not support Asterisk realtime logging on Asterisk 1.8, as they changed the file format since 1.6.

We have a workaround anyway:

1. let's say your Asterisk writes to table queue_logs in database asterisk.

2. give your queuemetrics MySQL user the grants to read the database asterisk. Make sure you can run a:

Code: [Select]

SELECT * FROM asterisk.queue_logs LIMIT 0,1 without errors when using the queuemetrics database.

3. Create a view in the QM database, as follows:

CREATE VIEW ql_live AS SELECT unix_timestamp(time) as time_id, callid
as call_id, queuename as queue, agent as agent, event as verb, data1,
data2, data3, data4, data5, id as unique_row_count, 'LIVE' as
partition, '' as serverid FROM asterisk.queue_logs

4. Edit the configurations.properties file of QM as follows:

Code: [Select]

default.queue_log_file=sql:LIVE
And

Code: [Select]

sqlPreset.1.table=ql_live
It will be a bit less efficient, but works.

679

Running QueueMetrics / Re: Logrotate & Queuemetrics Issue

« on: August 17, 2011, 12:29:18 »

But by using a sliding window that is longer than a single shift, you should be sure you always have data....

680

QueueMetrics installation / Re: Unanswered yet calls in unanswered detail

« on: August 17, 2011, 12:27:56 »

Are you sure the request was replied? sometimes we don't get email at all.

681

Running QueueMetrics / Re: Discrepancies in Queuemetrics reports vs. payroll vs. database

« on: August 11, 2011, 10:48:12 »

It one of the Preferences, as described here: http://queuemetrics.com/manuals/QM_UserManual-chunked/apd.html

682

Running QueueMetrics / Re: Agent Listing

« on: August 11, 2011, 10:47:10 »

If you need this in a short timeframe, you can contact Loway for a custom implementation.

683

Running QueueMetrics / Re: Rotated Logs Per SIGXFSZ (exceeded files limit)

« on: August 11, 2011, 10:46:04 »

Yes: try if one works, and if it does, create a batch script based on the output of the ls command :-)

684

QueueMetrics installation / Re: Queuemetrics doesn't restart using the RESTART service - help please

« on: August 11, 2011, 10:45:11 »

One question: are you running this in a VM or on bare metal?

685

Outbound and QueueMetrics / Re: Outbound calling - Show agents as IN USE for a queue?

« on: August 10, 2011, 11:22:09 »

But you would see the agent as paused in the reports, so this would not really do.

686

Running QueueMetrics / Re: Discrepancies in Queuemetrics reports vs. payroll vs. database

« on: August 10, 2011, 11:21:30 »

Anyway, the option is there to be used :-)

687

Running QueueMetrics / Re: Error formating time when export to excel

« on: August 10, 2011, 11:20:49 »

 

688

Running QueueMetrics / Re: Change time format to only seconds

« on: August 10, 2011, 11:20:33 »

I think this is not possible to do at the moment.

689

Running QueueMetrics / Re: Rotated Logs Per SIGXFSZ (exceeded files limit)

« on: August 10, 2011, 11:20:08 »

run the updater multiple times on each file, maybe the files were not merged in order.

690

QueueMetrics installation / Re: Queuemetrics doesn't restart using the RESTART service - help please

« on: August 10, 2011, 11:19:19 »

For the moment you can do something like:

Code: [Select]

kill -9 `ps fax | grep /usr/local/queuemetrics | grep bin/java | cut -d ' ' -f 1`; /etc/init.d/queuemetrics start
This will stop and restart QM (do a copy-and-paste of the line above)