Topics

1

QueueMetrics installation / Upgrade from 1.6.1.2 to 1.7.1.13

« on: November 23, 2011, 05:16:31 »

We finally got around to upgrading our install, and after adjusting the database issues by adding the necessary fields, etc. we're getting the following error when attempting to run any report:


Database access error.  -  <p> - Exception: it.loway.tpf.common.exceptions.TechException - Errore file/DB: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'data5' in 'field list' - at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLogMysql.createTemporaryFile(AnalizzaLogMysql.java:500) - at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLogMysql.loadLogInfo_classic(AnalizzaLogMysql.java:250) - at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLogMysql.loadLogInfo(AnalizzaLogMysql.java:200) - at it.loway.app.queuemetrics.caricamento.caricaCoda.runDataAnalysis(caricaCoda.java:281) -

TIA,

Carlos.

2

Improving QueueMetrics / Selection of Time for Last x days

« on: May 20, 2010, 16:16:42 »

I think that the reports for Last day, 7 days, etc. should automatically select 00:00 to 23:59 for the time start/end as well as selecting the previous day for hte period end date and going back from there. 

If I select Last 30, I expect to see from Yesterday back 30 days, not 30 24 hour periods from now

Thanks.

Carlos.

3

Running QueueMetrics / Wildcards - driving me crazy

« on: May 19, 2010, 21:23:10 »

I'm having some really strange things happening with the reports.  I previously had statically assigned queues in each of the groups, but as we started to add queues, i thought I would attempt to clean up the long list of queues.  However, it seems that I'm having some problems with the wildcards, and the subqueues.  These reports just don't seem to make sense, we're seeing calls disappear, etc.

What I've noticed is that I can't have a wildcard value after the "." when defining the queues.  It works correctly when using the 9001*|9101*, but when it's used after the "." for the subqueues, is where we seem to have a problem.

I have the following queues:
Alias = Direction = Queue(s)

These Alias definition work, and all the values are properly displayed as expected:
 - 00 - All = Undefined = 9001*, 9101*, 9201*, 9601*, 9800*, q-*
 - 01 - All Inbound = In = 9001*, 9101*, 9201*, 9601*
 - 01 - All Outbound = Out = 9800*, q-*

These do not work as expected, since the * is after the ".":
 - Inbound -AAA = In = 9001.AAA*, 9101.AAA*, 9201.AAA*, 9601.AAA*
 - Inbound - BBB = In = 9001.BBB*, 9101.BBB*, 9201.BBB*, 9601.BBB*
 - Inbound - CCC = In = 9001.CCC*, 9101.CCC*, 9201.CCC*, 9601.CCC*
 - Outbound - 111 = Out = q-1110000, q-111*
 - Outbound - 222 = Out = q-1110000, q-222*
 - Outbound - 333 = Out = q-3330000, q-333*

These also work in reports, but with the *, won't let the agents log in.
 - Queue - 9001 = In = 9001*
 - Queue - 9101 = In = 9101*
 - Queue - 9201 = In = 9201*
 - Queue - 9601 = In = 9601*
 - Queue - 9800 = Out = 9800*

Thanks in advance.

Carlos

4

Running QueueMetrics / Undefined Call Direction

« on: May 17, 2010, 20:14:11 »

We have several inbound/outbound queues, and are noticing that the answered call direction is always showing undefined.  We have several main queues defined inobund/outbound, and our subqueues are working correctly.  Any ideas on what to look for?

Thanks,

Carlos.

5

Running QueueMetrics / Agent Activities

« on: April 05, 2010, 20:38:18 »

I am starting to look at the Pay reports available, and wondering if we can use pause codes to track when our agents are responding to emails.  I was considering making a pause code for each of our customers, depending on what emails the CSR was responding to.  This would let us keep track of how many pauses for each code, as well as how long each pause was for.  We would be extracting this to Excel, so that we can run minimum/incremental for each pause and then distribute along to each customer.

Thanks in advance,

Carlos.

6

Running QueueMetrics / Pausing Agents

« on: April 05, 2010, 20:34:34 »

We have agents that handle inbound/outbound/email.  I was wondering if we could pause an agent on one queue (inbound) but leave them active on the outbound queue, so they can place outbound calls.  This would make it easier than having to log an agent off the inbound queue(s) and then back on. 

Thanks in advance,

Carlos.

7

Running QueueMetrics / Queues and SubQueues in Reports

« on: April 05, 2010, 20:31:47 »

I was wondering if there's something I'm doing wrong.  I've got asterisk setting up subqueues based on the DNIS, done on the inbound side through a custom context, and using that info to populate the DNIS information, as well as the subqueue.  These queues are setup as 9901.ABC11, 9901.XYZ12, etc.  For the queues, I've got queues setup as CustABC, with 9901.ABC11, CustXYZ with queue 9901.XYZ12|9901.XYZ65, etc.  If I add all these queues to our All queues view, the reports are fine.  However, when I try to pull a report on CustomerABC, it shows up as blank, even though the Atomic queues referenced seem to be correctly populating.

Thanks in advance,

Carlos.

8

Running QueueMetrics / Split Audio Files

« on: April 02, 2010, 21:13:54 »

I was wondering if it would be possible to modify the storage of the monitoring files to add additional variables.  For example, we'd like to have a directory structure as follows:

Queue-CustID\YYYY\MM\DD

This way, we can separate our audio recordings, and make the archiving of them per customer much simpler.  The only issue I foresee is that the configuration.properties may not accept a variable for the Queue-CustID, or at least not an asterisk based variable.

Before I spend too much time on this, is this feasible/possible?

I've seen the documentation to change the FilesByDay, etc. but because I'm using FreePBX it makes it a bit more difficult to split up.  I'm sure I can get FreePBX to cooperate, by moving the queue out into extensions_custom, to set the recording path, the thing is how do I get QM to pickup the variable path...

Thanks,

Carlos.

9

QueueMetrics installation / Re: Admin Logon

« on: April 02, 2010, 04:28:06 »

Hi,

We are starting to look at our queues, and would like to let some of our customers look at the stats.  however, we run one queue for all clients, so we don't have to maintain dozens of queues, and then have agents need to login to multiple queues.  Would it be possible to limit the queues on a DID basis?

Thanks,

Carlos.

10

Lost licences / Need license

« on: April 02, 2010, 03:26:27 »

Hi - I submitted two emails for license requests and haven't received them yet.  Trying a test run for a small 10 seat center for one of our clients.  Also interested in teh reseller program.  Thanks.

Carlos.

11

General Asterisk configuration / Dynamic Agents, Hotdesking

« on: April 01, 2010, 19:46:54 »

I've seen various posts on dynamic agents and hotdesking.  We currently use FreePBX, since it makes admin of almost everything easier.  We've implemented our config to be in device and user mode, which allows to keep the devices (phones) separate from the agents (users).  We've also been using Aastra phones with their XML scripts, which allow the agents to login to any phone, and then has them at the proper extension at the proper device.  Would this cause any issues with Queuemetrics?  We're currently testing, and it all seems ok, but after seeing many complications with dynamic agents, different extensions for the agents, I want to make sure we're not going to see any issues with this in the long run.

Thanks in advance,

Carlos.

12

Outbound and QueueMetrics / Using Outbound Routes

« on: April 01, 2010, 19:22:43 »

I saw an older post titled LCR, and the response was to setup custom extensions to handle this.  However, would it not be possible to redirect the call back into the Outbound routes to accomplish this?  I was wondering if there was anything stopping from sending the calls to outbound-allroutes and let the system determine based on the rules we may already have.  This would accomplish everything needed.  By having the call originate in the queuedial or queuedial-loggedin contexts, the call would simply be sent right back out, just on the proper trunk(s).  This also allows for redundancy for failover, etc. using the builtin mechanisms asterisk already has.

If we are adding an 8 to the outbound to get out, in the queuedial and queuedial-loggedin contexts I was going to change the line that sets the QDialer channel to:

exten => _XXXXX.,n,Set(QDIALER_CHANNEL=9${QDIALER_NUMBER})

This would set the dial string to 9+ the actual dial string.  At this point all the QDIALER parameters have been set correctly?  If so, then in the qm-queuedial context, I was wondering how to change the dial command to a GoTo(outbound-allroutes), passing the same parameters.

I'm currently using asterisk 1.4.25.1, freePBX 2.7 QueueMetrics 1.6.0.1

Thanks in advance.

Carlos.