Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - chesstrian

Pages: [1]
1
Improving QueueMetrics / Get many call records.
« on: May 22, 2013, 17:48:57 »
It would be great if it's possible to get all call records from an agent or selected agents in a date range. Others filters would be great :)

2
MySQL storage and Qloaderd/Uniloader / Asterisk queue_log file into DB with Node JS.
« on: May 14, 2013, 22:33:08 »
I have programed a little script in Node JS which gather every line from queue_log file and put it into MongoDB; it haven't been tested with log rotation and needs support for MySQL and others DBs, if you have any comment or improvement, it will be appreciated.

It would be great if this is useful for someone.

You can check for sources here: https://github.com/chesstrian/qlog2db

3
MySQL storage and Qloaderd/Uniloader / Qloaderd add every line twice into MySQL
« on: June 11, 2010, 06:00:09 »
Well, i think that subject is clear. Here there are some views:

qloaderd.log
 |Thu Jun 10 20:29:52 2010|Loaded 41000 lines so far...
 |Thu Jun 10 21:34:43 2010|Loaded 100 lines so far...
 |Thu Jun 10 21:43:16 2010|Loaded 41100 lines so far...
 |Thu Jun 10 22:11:16 2010|Heart is still beating... Imported: 41115 lines.
 |Thu Jun 10 22:11:17 2010|Heart is still beating... Imported: 130 lines.


# grep 1276088424.31309 /var/log/asterisk/queue_log
1276088450|1276088424.31309|500|NONE|ENTERQUEUE||45481262
1276088451|1276088424.31309|500|Local/3644@from-dinamicqueues/n|CONNECT|1|1276088450.31323|1
1276088722|1276088424.31309|500|Local/3644@from-dinamicqueues/n|COMPLETECALLER|1|271|1
1276088731|1276088424.31309|NONE|Agent/3644|CALLSTATUS|PA121

Here we can see that logs in queue_log file is good

mysql> SELECT * FROM queue_log WHERE call_id='1276088424.31309';
+-----------+------------+------------------+-------+------------+----------------+-------+------------------+-------+-------+----------+------------------+
| partition | time_id    | call_id          | queue | agent      | verb           | data1 | data2            | data3 | data4 | serverid | unique_row_count |
+-----------+------------+------------------+-------+------------+----------------+-------+------------------+-------+-------+----------+------------------+
| P001      | 1276088450 | 1276088424.31309 | 500   | NONE       | ENTERQUEUE     |       | 45481262         |       |       |          |                1 |
| P001      | 1276088450 | 1276088424.31309 | 500   | NONE       | ENTERQUEUE     |       | 45481262         |       |       |          |                2 |
| P001      | 1276088451 | 1276088424.31309 | 500   | Agent/3644 | CONNECT        | 1     | 1276088450.31323 | 1     |       |          |                1 |
| P001      | 1276088451 | 1276088424.31309 | 500   | Agent/3644 | CONNECT        | 1     | 1276088450.31323 | 1     |       |          |                2 |
| P001      | 1276088722 | 1276088424.31309 | 500   | Agent/3644 | COMPLETECALLER | 1     | 271              | 1     |       |          |                1 |
| P001      | 1276088722 | 1276088424.31309 | 500   | Agent/3644 | COMPLETECALLER | 1     | 271              | 1     |       |          |                2 |
| P001      | 1276088731 | 1276088424.31309 | NONE  | Agent/3644 | CALLSTATUS     | PA121 |                  |       |       |          |                1 |
| P001      | 1276088731 | 1276088424.31309 | NONE  | Agent/3644 | CALLSTATUS     | PA121 |                  |       |       |          |                2 |
+-----------+------------+------------------+-------+------------+----------------+-------+------------------+-------+-------+----------+------------------+
8 rows in set (6.92 sec)

If delete duplicate rows whit a sentence like "DELETE FROM queue_log WHERE unique_row_count=2;", the problems about stints and reports desappears from QueueMetrics, but Reports is saw in any moment, so, change database manually is not a posible solution, any sugestion will be apreciated.

PD: Problems after logs rotation.

4
Running QueueMetrics / Call Outcomes and Stins
« on: June 08, 2010, 19:39:58 »
Hi every body, i activated some call outcomes for every inbound calls, and i have joinMultiStintCalls in true, in reports i can't see the outcome's codes and every qualified call has 2 or 3 stints, so every time attribute is duplicated, for example, a call with 2 minutes of duration, has 4 minutes.

Now if i set stints to false, every call appears 2 or 3 times, so the total number of calls processed is more higher. What can i do about this?

5
Realtime Live / Calls in Realtime Live
« on: April 29, 2010, 19:38:46 »
On realtime live page, i can see incoming calls that are waiting, when the call is answered, it desappears.

6
Lost licences / Licence for a Cluster
« on: April 29, 2010, 19:08:27 »
Hi, I would like to test a licence for a cluster. How can i get a trial?

7
QueueMetrics installation / Agent's Reports
« on: April 07, 2010, 17:48:03 »
Hi everybody, i have a problem with the agent's reports: in the CC, there are agents that not receive calls, but they connect to a queue and stay in pause, when i'm going to see pauses reports, these agents not appear in the report. When an agent receives a call, all the information about these agent is shown, but can't be guaranteed that an agent answer a call because he/she can be in another process.

8
Running QueueMetrics / Re: Problems with Asterisk 1.6 in the Realtime Call Center monitoring
« on: March 27, 2010, 03:48:41 »
Hi everybody, i have the same problem, i can't see the "Calls being processed:" in the Realtime page; but in the Live page, i can see the calls, but when it is answered, i can't see the calls anymore and agents never appear busy.

I have Asterisk 1.6.2.5 on Debian 64 bits and QueueMetrics 1.6.0.1. Agents are Fully Dinamic.

Any sugestion will be appreciated

Pages: [1]