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.


Messages - gopal2k

Pages: 1 2 [3] 4 5
31
MySQL storage and Qloaderd/Uniloader / Re: Changing email of all agents
« on: March 03, 2014, 09:38:56 »
Sorry for my delayed reply. Yes the Agent description... while creating agents.

Actually I have so many agents, so will the replace command in mysql is sufficient to change bunch of email address?

Thanks.

32
MySQL storage and Qloaderd/Uniloader / Changing email of all agents
« on: December 03, 2013, 09:49:31 »
I would like to change the email column for all my agents configured in queuemetrics. The agents might be around 1000 numbers, I see in MySQL this table named "agenti_noti" all the agents information.

By using replace function in MySQL, if I change the value of email "descr_agente" will that be sufficient?

Please advise.

Thanks.

33
Outbound and QueueMetrics / Re: Transferred call via Outbound Dialplan
« on: November 21, 2013, 12:40:43 »
Yes button on the hardphone.

34
Running QueueMetrics / Re: Call Status
« on: November 21, 2013, 12:39:57 »
Yes, its an Inbound call. And following is the simple example which am using for my inbound calls,

exten => _X.,1,Answer()
exten => _X.,n,Set(QUEUE_NAME=TESTQUEUE)
exten => _X.,n,Set(START_TIME=${STRFTIME(${EPOCH},,%Y-%m-%d_%H-%M-%S)})
exten => _X.,n,Set(MONITOR_FILENAME=TESTQUEUE/IN/${STRFTIME(${EPOCH},,%Y-%m)}/${STRFTIME(${EPOCH},,%d)}/${CALLERID(number)}-${START_TIME}-${EXTEN}-IN)
exten => _X.,n,Queue(TESTQUEUE,t,,,30000,queue_log.agi,macro(beep))
exten => _X.,n,NoOp(${QUEUESTATUS})
exten => _X.,n,GotoIf($["${QUEUESTATUS}" = "TIMEOUT"]?lbl_project_0:)
exten => _X.,n,GotoIf($["${QUEUESTATUS}" = "FULL"]?lbl_project_0:)
exten => _X.,n,GotoIf($["${QUEUESTATUS}" = "JOINEMPTY"]?lbl_project_0:)
exten => _X.,n,GotoIf($["${QUEUESTATUS}" = "LEAVEEMPTY"]?lbl_project_0:)
exten => _X.,n,GotoIf($["${QUEUESTATUS}" = "JOINUNAVAIL"]?lbl_project_0:)
exten => _X.,n,GotoIf($["${QUEUESTATUS}" = "LEAVEUNAVAIL"]?lbl_project_0:)
exten => _X.,n(lbl_project_0),Hangup()


Thanks.


35
Outbound and QueueMetrics / Transferred call via Outbound Dialplan
« on: November 19, 2013, 13:43:17 »
Am using Queuemetrics mainly for Inbound and @some times there might be a situation where Inbound calls will get transferred to Internal TL's and to external Toll Free numbers, the external Toll free number am handling as like below,

exten => _1.,1,Set(MONITOR_FILENAME=${CDR(accountcode)}-${STRFTIME(${EPOCH},,%Y-%m-%d_%H-%M-%S)}-${EXTEN}-OUT)
exten => _1.,n,MixMonitor(OUT/${STRFTIME(${EPOCH},,%Y-%m)}/${STRFTIME(${EPOCH},,%d)}/${MONITOR_FILENAME}.wav,b)
exten => _1.,n,Set(QDIALER_QUEUE=q-Outbound)
exten => _1.,n,Set(QDIALER_NUMBER=${EXTEN})
exten => _1.,n,Set(QDIALER_AGENT=SIP/${CDR(accountcode)})
exten => _1.,n,Set(QDIALER_CHANNEL=${USIAX}/9999${QDIALER_NUMBER})
exten => _1.,n,Set(QueueName=${QDIALER_QUEUE})
exten => _1.,n,Set(CALLERID(number)=5107711717)
exten => _1.,n,Goto(qm-queuedial,${EXTEN},1)
exten => _1.,n,Hangup()

Am facing a issue like, after external call transfer for some calls the disconnection is not happening immediately till the call completes, according to agent point of view he transferred and started to take other inbound calls, but in QM Agent screen we see the transferred call is still going on in the background.

For some transferred call its fine, I can see the calls are terminated after transfer.

Any comments would be much appreciated.

Thanks.

36
Running QueueMetrics / Re: Call Status
« on: November 18, 2013, 17:54:03 »
So do we need to do anything in the dialplan?

Regards

37
Running QueueMetrics / Re: Call Status
« on: November 15, 2013, 16:12:33 »
One more example I have,

Following is the Queuelog file,
Caller Disconnected
1384520637|1384520630.119824|TEST|NONE|ENTERQUEUE||1008|1
1384520637|1384520630.119824|TEST|SIP/1007|CONNECT|0|1384520637.119825|0
1384520660|1384520630.119824|TEST|SIP/1007|COMPLETECALLER|0|23|1

Agent Disconnected
1384520675|1384520669.119826|TEST|NONE|ENTERQUEUE||1008|1
1384520676|1384520669.119826|TEST|SIP/1007|CONNECT|1|1384520675.119827|0
1384520682|1384520669.119826|TEST|SIP/1007|COMPLETECALLER|1|6|1

And below is the queue_log table,
mysql> select * from queue_log where call_id = '1384520669.119826';
+-----------+------------+-------------------+-------+----------+----------------+-------+-------------------+-------+-------+-------+----------+------------------+
| partition | time_id    | call_id           | queue | agent    | verb           | data1 | data2             | data3 | data4 | data5 | serverid | unique_row_count |
+-----------+------------+-------------------+-------+----------+----------------+-------+-------------------+-------+-------+-------+----------+------------------+
| P001      | 1384520675 | 1384520669.119826 | TEST  | NONE     | ENTERQUEUE     |       | 1008              | 1     |       |       |          |                1 |
| P001      | 1384520676 | 1384520669.119826 | TEST  | SIP/1007 | CONNECT        | 1     | 1384520675.119827 | 0     |       |       |          |                1 |
| P001      | 1384520682 | 1384520669.119826 | TEST  | SIP/1007 | COMPLETECALLER | 1     | 6                 | 1     |       |       |          |                1 |
+-----------+------------+-------------------+-------+----------+----------------+-------+-------------------+-------+-------+-------+----------+------------------+
3 rows in set (2.90 sec)

mysql> select * from queue_log where call_id = '1384520630.119824';
+-----------+------------+-------------------+-------+----------+----------------+-------+-------------------+-------+-------+-------+----------+------------------+
| partition | time_id    | call_id           | queue | agent    | verb           | data1 | data2             | data3 | data4 | data5 | serverid | unique_row_count |
+-----------+------------+-------------------+-------+----------+----------------+-------+-------------------+-------+-------+-------+----------+------------------+
| P001      | 1384520637 | 1384520630.119824 | TEST  | NONE     | ENTERQUEUE     |       | 1008              | 1     |       |       |          |                1 |
| P001      | 1384520637 | 1384520630.119824 | TEST  | SIP/1007 | CONNECT        | 0     | 1384520637.119825 | 0     |       |       |          |                2 |
| P001      | 1384520660 | 1384520630.119824 | TEST  | SIP/1007 | COMPLETECALLER | 0     | 23                | 1     |       |       |          |                1 |
+-----------+------------+-------------------+-------+----------+----------------+-------+-------------------+-------+-------+-------+----------+------------------+
3 rows in set (1.28 sec)

And FYI: the calls are inbound calls... while checking in extensions_queuemetrics.conf file I see the COMPLETESTATUS is mentioned only for outbound call context. Will this be applicable for Inbound call as well?

Thanks.

38
Running QueueMetrics / Re: Call Status
« on: October 11, 2013, 20:53:36 »
Hi,

We explored little bit and found Asterisk is populating data correctly. For example, a particular record is updated in CEL table, where CEL table has detailed information about a call.

Let's consider the following example from queue_log table,
mysql> select * from queue_log where call_id ='1375644053.1307271';
+-----------+---------------------+------------+--------------------+-----------+-----------+----------------+-------+--------------------+-------+-------+-------+----------+------------------+
| partition | EntryTime           | time_id    | call_id            | queue     | agent     | verb           | data1 | data2              | data3 | data4 | data5 | serverid | unique_row_count |
+-----------+---------------------+------------+--------------------+-----------+-----------+----------------+-------+--------------------+-------+-------+-------+----------+------------------+
| P001      | 2013-08-04 12:38:06 | 1375645085 | 1375644053.1307271 | NONE      | SIP/10857 | CALLSTATUS     | dc    |                    |       |       |       |          |                2 |
| P001      | 2013-08-04 12:33:41 | 1375644060 | 1375644053.1307271 | XSS_SALES | SIP/10857 | COMPLETEAGENT  | 1     | 5                  |       |       |       |          |                1 |
| P001      | 2013-08-04 12:41:34 | 1375645293 | 1375644053.1307271 | XSS_SALES | SIP/10857 | COMPLETECALLER | 1     | 1238               | 1     |       |       |          |                2 |
| P001      | 2013-08-04 12:20:55 | 1375644055 | 1375644053.1307271 | XSS_SALES | SIP/10857 | CONNECT        | 1     | 1375644054.1307273 | 0     |       |       |          |                1 |
| P001      | 2013-08-04 12:20:55 | 1375644054 | 1375644053.1307271 | XSS_SALES | NONE      | ENTERQUEUE     |       | 7135763000         | 1     |       |       |          |                1 |
+-----------+---------------------+------------+--------------------+-----------+-----------+----------------+-------+--------------------+-------+-------+-------+----------+------------------+
5 rows in set (0.03 sec)

and for the same unique ID, if we see in the CEL table,
mysql> select * from cel where uniqueid like '1375644053.1307271%' or linkedid like '1375644053.1307271%';
+----------+--------------+---------------------+-------------+------------+------------+------------+-----------+------------+------------+---------------+--------------------+----------+----------------------------------------------+----------+-------------+-------------+--------------------+--------------------+-----------+--------------------+
| id       | eventtype    | eventtime           | userdeftype | cid_name   | cid_num    | cid_ani    | cid_rdnis | cid_dnid   | exten      | context       | channame           | appname  | appdata                                      | amaflags | accountcode | peeraccount | uniqueid           | linkedid           | userfield | peer               |
+----------+--------------+---------------------+-------------+------------+------------+------------+-----------+------------+------------+---------------+--------------------+----------+----------------------------------------------+----------+-------------+-------------+--------------------+--------------------+-----------+--------------------+
| 32798068 | CHAN_START   | 2013-08-04 12:20:53 |             | HOUSTON TX | 7135763000 |            |           |            | 5108242149 | trunk-inbound | SIP/US-000b6368    |          |                                              |        3 |             |             | 1375644053.1307271 | 1375644053.1307271 |           |                    |
| 32798069 | ANSWER       | 2013-08-04 12:20:53 |             | HOUSTON TX | 7135763000 | 7135763000 |           | 5108242149 | 5108242149 | project       | SIP/US-000b6368    | Answer   |                                              |        3 |             |             | 1375644053.1307271 | 1375644053.1307271 |           |                    |
| 32798078 | CHAN_START   | 2013-08-04 12:20:54 |             | ComCast    | 5108242149 |            |           |            | s          | xss-call-out  | SIP/10857-000b636a |          |                                              |        3 | 10857       | 10857       | 1375644054.1307273 | 1375644053.1307271 |           |                    |
| 32798079 | ANSWER       | 2013-08-04 12:20:54 |             | ComCast    | 5108242149 | 5108242149 |           |            | 5108242149 | xss-call-out  | SIP/10857-000b636a | AppQueue | (Outgoing Line)                              |        3 | 10857       | 10857       | 1375644054.1307273 | 1375644053.1307271 |           |                    |
| 32798082 | BRIDGE_START | 2013-08-04 12:20:55 |             | HOUSTON TX | 7135763000 | 7135763000 |           | 5108242149 | 5108242149 | project       | SIP/US-000b6368    | Queue    | XSS_SALES,t,,,3600,queue_log.agi,macro(beep) |        3 |             |             | 1375644053.1307271 | 1375644053.1307271 |           | SIP/10857-000b636a |
| 32803212 | BRIDGE_END   | 2013-08-04 12:41:33 |             | HOUSTON TX | 7135763000 | 7135763000 |           | 5108242149 | 5108242149 | project       | SIP/US-000b6368    | Queue    | XSS_SALES,t,,,3600,queue_log.agi,macro(beep) |        3 |             |             | 1375644053.1307271 | 1375644053.1307271 |           | SIP/10857-000b636a |
| 32803213 | HANGUP       | 2013-08-04 12:41:33 |             | ComCast    | 5108242149 | 5108242149 |           |            | 5108242149 | xss-call-out  | SIP/10857-000b636a | AppQueue | (Outgoing Line)                              |        3 |             |             | 1375644054.1307273 | 1375644053.1307271 |           |                    |
| 32803214 | CHAN_END     | 2013-08-04 12:41:33 |             | ComCast    | 5108242149 | 5108242149 |           |            | 5108242149 | xss-call-out  | SIP/10857-000b636a | AppQueue | (Outgoing Line)                              |        3 |             |             | 1375644054.1307273 | 1375644053.1307271 |           |                    |
| 32803215 | HANGUP       | 2013-08-04 12:41:33 |             | HOUSTON TX | 7135763000 | 7135763000 |           | 5108242149 | 5108242149 | project       | SIP/US-000b6368    |          |                                              |        3 |             |             | 1375644053.1307271 | 1375644053.1307271 |           |                    |
| 32803216 | CHAN_END     | 2013-08-04 12:41:33 |             | HOUSTON TX | 7135763000 | 7135763000 |           | 5108242149 | 5108242149 | project       | SIP/US-000b6368    |          |                                              |        3 |             |             | 1375644053.1307271 | 1375644053.1307271 |           |                    |
| 32803217 | LINKEDID_END | 2013-08-04 12:41:33 |             | HOUSTON TX | 7135763000 | 7135763000 |           | 5108242149 | 5108242149 | project       | SIP/US-000b6368    |          |                                              |        3 |             |             | 1375644053.1307271 | 1375644053.1307271 |           |                    |
+----------+--------------+---------------------+-------------+------------+------------+------------+-----------+------------+------------+---------------+--------------------+----------+----------------------------------------------+----------+-------------+-------------+--------------------+--------------------+-----------+--------------------+
11 rows in set (54.81 sec)

In the above said example, 'COMPLETECALLER ' date is properly updated in CEL table as "BRIDGE_END", so this states that Asterisk is pushing data fine.

Any other way that we can find out, whether qloaderd is getting any input and that is getting pushed to database? because queue_log file is also fine there is no COMPLETEAGENT, whereas in DB both resides.

Thanks in advance.

Regards

39
Running QueueMetrics / Re: Agent List mapped to Queue
« on: September 24, 2013, 12:47:30 »
I configured and able to see some stats report, I tried to use Method: QM.findaudio, but in the Audiofiles tab I get
Response block: AudioFiles
--Block not found--

I tried specifying Asterisk IP address in server field, proivided Unique ID, Queue and date & time.

Regards

40
Running QueueMetrics / Re: Agent List mapped to Queue
« on: September 23, 2013, 09:49:20 »
Sorry for my delayed reply... basically I think I can start up with PHP, also where to enable XML-RPC?

Thanks

41
Running QueueMetrics / Re: Agent List mapped to Queue
« on: September 19, 2013, 07:37:49 »
Any examples are there? Just as a startup..!

42
Running QueueMetrics / Re: Agent List mapped to Queue
« on: September 12, 2013, 16:10:06 »
So I have write some XML script?

Regards,
Gopal

43
Running QueueMetrics / Re: ChanSpy SIP/Exten instead of Agentcode
« on: September 10, 2013, 13:31:07 »
Hi,

Actually its working as expected with the existing setup itself, if i leave the barging channel as it is, its going for next call for the same agent.

Now only thing i have to check is the whispering mode while in the barging.

Regards,
Gopal.

44
Running QueueMetrics / Re: Agent List mapped to Queue
« on: September 10, 2013, 13:29:19 »
I would like to get a list of queue mappings for some agent as they are now created in the QM.

Regards,
Gopal

45
Running QueueMetrics / Re: Call Status
« on: September 10, 2013, 13:28:28 »
If it is bug in the Asterisk, then queue_log file also need to have both COMPLETEAGENT and COMPLETECALLER if am not wrong.

This is happening only in database, and database is populated via qloaderd application.

Please correct me if am wrong.

Regards,
gopal.

Pages: 1 2 [3] 4 5