vicidial.org

by **ZeeTech** » Wed Jun 13, 2018 7:41 am

Call menu defined with following options.

Tracking Group = Call Menue
Log Key Press = 1 - DTMF Logging Enabled
Log field = comments

Call Menu Options:
All options are routing call to different ingroups with Handle Method "CIDLOOKUP" & Search Method "LB"

Everything is working fine please advise how to determine the Report on the call menu like who press options like 1,2,3 etc
I tried "Export Calls Report" & "Export Leads Report" but the is no value captured under comments field. Please advise.

Thanks.

Environment Information:
ViciBOX 8 | VERSION: 2.14-673a BUILD: 180512-2217 | Asterisk 11.25.1-vici | Dell R730 | No additional HW

by **mflorell** » Wed Jun 13, 2018 8:17 am

If the call goes to a Call Menu with no lead_id attached, then it will not log the key presses to any lead.

How are the calls getting to the Call Menu?

by **ZeeTech** » Wed Jun 13, 2018 8:24 am

Calls are coming through a DID number.
DID Route: is set to required Call Menu, how we can enable lead_id ?

by **mflorell** » Wed Jun 13, 2018 9:22 am

You have to send the call through a closed In-Group and then to the Call Menu if you want a lead_id to be tied to the call when it's in the call menu.

We usually create a "always_closed" Call Time and use that for the initial in-group, then set the after-hours action to the call menu.

If you do this, be sure to use the CLOSER option when sending calls from the call menu into the different destination in-groups, because the call will already be tagged with a lead_id.

by **ZeeTech** » Wed Jun 13, 2018 4:25 pm

I made the changes but still not able to capture required data, please also advise either this data will be available in Export Calls Report or Export Leads Report

This is new call flow.
1. SIP Carrier -> Call Routing to DID,
2. DID is forwarding call to IN_GROUP001, Ingroup handle method=CID, Ingroup search method=LB, List 999
3. INGROUP001 - Call time= Always close(Set 2400 to 2400), After Hours Action =CALL MENU, After Hours Call Menu = IVR001)
4. IVR001
Tracking Group = Call Menu
Log Key Press = 1 - DTMF Logging Enabled
Log field = comments (i tried different fields)
Options - Route=INGROUP, In-Group=Q_General, Handle Method=Closer, Search Method=LB List ID 998

Call is landing to IVR but still data is missing, please advise.

Thanks.

Environment Information:
ViciBOX 8 | VERSION: 2.14-673a BUILD: 180512-2217 | Asterisk 11.25.1-vici | Dell R730 | No additional HW

by **mflorell** » Wed Jun 13, 2018 10:59 pm

That looks like it should work, I'd have to see the Asterisk CLI output (from screenlog.0 preferably) with the Server AGI output set to BOTH, before I could comment as to why it's not working for you.

by **ZeeTech** » Thu Jun 14, 2018 6:04 am

Please review output from screenlog.0

Code: Select all: [Jun 14 20:49:32] == Using SIP RTP CoS mark 5 -- [Jun 14 20:49:32] -- Executing [111007008@default:1] Answer("SIP/6814264-00000007", "") in new stack > [Jun 14 20:49:32] > 0x7ff374006400 -- Probation passed - setting RTP source address to 10.99.93.8:19272 -- [Jun 14 20:49:32] -- Executing [111007008@default:2] AGI("SIP/6814264-00000007", "agi-DID_route.agi") in new stack -- [Jun 14 20:49:32] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-DID_route.agi -- [Jun 14 20:49:32] -- <SIP/6814264-00000006>AGI Script agi-VDAD_ALL_inbound.agi completed, returning 0 -- [Jun 14 20:49:32] -- Executing [s@IVR001:1] Answer("SIP/6814264-00000006", "") in new stack -- [Jun 14 20:49:32] -- Executing [s@IVR001:2] AGI("SIP/6814264-00000006", "agi-VDAD_inbound_calltime_check.agi,CALLMENU-----YES-----IVR001-------------------------NO") in new stack -- [Jun 14 20:49:32] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-VDAD_inbound_calltime_check.agi -- [Jun 14 20:49:33] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:49:33] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:49:33] -- <SIP/6814264-00000006>AGI Script agi-VDAD_inbound_calltime_check.agi completed, returning 0 -- [Jun 14 20:49:33] -- Executing [s@IVR001:3] Set("SIP/6814264-00000006", "INVCOUNT=0") in new stack -- [Jun 14 20:49:33] -- Executing [s@IVR001:4] BackGround("SIP/6814264-00000006", "HB-IVR") in new stack -- [Jun 14 20:49:33] -- <SIP/6814264-00000006> Playing 'HB-IVR.slin' (language 'en') [Jun 14 20:49:57] DTMF[7206][C-00000009]: channel.c:4215 __ast_read: DTMF begin '5' received on SIP/6814264-00000006 [Jun 14 20:49:57] DTMF[7206][C-00000009]: channel.c:4219 __ast_read: DTMF begin ignored '5' on SIP/6814264-00000006 [Jun 14 20:49:57] DTMF[7206][C-00000009]: channel.c:4129 __ast_read: DTMF end '5' received on SIP/6814264-00000006, duration 180 ms [Jun 14 20:49:57] DTMF[7206][C-00000009]: channel.c:4199 __ast_read: DTMF end passthrough '5' on SIP/6814264-00000006 -- [Jun 14 20:49:57] -- Executing [5@IVR001:1] AGI("SIP/6814264-00000006", "cm.agi,CALLMENU-----5-----rank-----0-----0") in new stack -- [Jun 14 20:49:57] -- Launched AGI Script /usr/share/asterisk/agi-bin/cm.agi -- [Jun 14 20:49:57] -- <SIP/6814264-00000006>AGI Script cm.agi completed, returning 0 -- [Jun 14 20:49:57] -- Executing [5@IVR001:2] AGI("SIP/6814264-00000006", "agi-VDAD_ALL_inbound.agi,CLOSER-----LB-----Q_General-----IVR001--------------------998-----1-----C001------------------------------") in new stack -- [Jun 14 20:49:57] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi -- [Jun 14 20:49:58] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:49:58] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') DBD::mysql::db do failed: Duplicate entry '1528991371.15' for key 'PRIMARY' at /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi line 2346, <STDIN> line 27. -- [Jun 14 20:49:59] -- Started music on hold, class 'default', on SIP/6814264-00000006 == [Jun 14 20:50:01] == Manager 'sendcron' logged on from 127.0.0.1 == [Jun 14 20:50:01] == Manager 'sendcron' logged on from 127.0.0.1 == [Jun 14 20:50:01] == Manager 'sendcron' logged off from 127.0.0.1 == [Jun 14 20:50:01] == Manager 'sendcron' logged off from 127.0.0.1 -- [Jun 14 20:50:02] -- Stopped music on hold on SIP/6814264-00000006 -- [Jun 14 20:50:02] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:50:02] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:50:02] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:50:03] -- <SIP/6814264-00000006> Playing 'generic_hold.gsm' (escape_digits=) (sample_offset 0) (language 'en') == [Jun 14 20:50:06] == Manager 'sendcron' logged on from 127.0.0.1 == [Jun 14 20:50:06] == Manager 'sendcron' logged off from 127.0.0.1 -- [Jun 14 20:50:09] -- Started music on hold, class 'default', on SIP/6814264-00000006 == [Jun 14 20:50:15] == Manager 'sendcron' logged on from 127.0.0.1 -- [Jun 14 20:50:15] -- Executing [010*100*100*125*78600051@default:1] Goto("Local/010*100*100*125*78600051@default-00000003;2", "default,78600051,1") in new stack -- [Jun 14 20:50:15] -- Goto (default,78600051,1) -- [Jun 14 20:50:15] -- Executing [78600051@default:1] MeetMe("Local/010*100*100*125*78600051@default-00000003;2", "8600051,Fq") in new stack > [Jun 14 20:50:15] > Channel Local/010*100*100*125*78600051@default-00000003;1 was answered -- [Jun 14 20:50:15] -- Executing [83047777777777@vicidial-auto:1] Answer("Local/010*100*100*125*78600051@default-00000003;1", "") in new stack -- [Jun 14 20:50:15] -- Executing [83047777777777@vicidial-auto:2] Playback("Local/010*100*100*125*78600051@default-00000003;1", "ding") in new stack -- [Jun 14 20:50:15] -- <Local/010*100*100*125*78600051@default-00000003;1> Playing 'ding.gsm' (language 'en') -- [Jun 14 20:50:15] -- Executing [83047777777777@vicidial-auto:3] Hangup("Local/010*100*100*125*78600051@default-00000003;1", "") in new stack == [Jun 14 20:50:15] == Spawn extension (vicidial-auto, 83047777777777, 3) exited non-zero on 'Local/010*100*100*125*78600051@default-00000003;1' -- [Jun 14 20:50:15] -- Executing [h@vicidial-auto:1] AGI("Local/010*100*100*125*78600051@default-00000003;1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16---------------") in new stack -- [Jun 14 20:50:15] -- <Local/010*100*100*125*78600051@default-00000003;1>AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16--------------- completed, returning 0 == [Jun 14 20:50:15] == Spawn extension (default, 78600051, 1) exited non-zero on 'Local/010*100*100*125*78600051@default-00000003;2' -- [Jun 14 20:50:15] -- Executing [h@default:1] AGI("Local/010*100*100*125*78600051@default-00000003;2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack -- [Jun 14 20:50:15] -- <Local/010*100*100*125*78600051@default-00000003;2>AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------- completed, returning 0 -- [Jun 14 20:50:15] -- Stopped music on hold on SIP/6814264-00000006 -- [Jun 14 20:50:15] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:50:15] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') == [Jun 14 20:50:16] == Manager 'sendcron' logged off from 127.0.0.1 -- [Jun 14 20:50:16] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:50:16] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:50:16] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 14 20:50:16] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') DBI::db=HASH(0x220b230)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi line 3905, <STDIN> line 61. -- [Jun 14 20:50:16] -- <SIP/6814264-00000006>AGI Script agi-VDAD_ALL_inbound.agi completed, returning 0 -- [Jun 14 20:50:16] -- Executing [010*100*100*125*8600051@default:1] Goto("SIP/6814264-00000006", "default,8600051,1") in new stack -- [Jun 14 20:50:16] -- Goto (default,8600051,1) -- [Jun 14 20:50:16] -- Executing [8600051@default:1] MeetMe("SIP/6814264-00000006", "8600051,F") in new stack == [Jun 14 20:50:21] == Manager 'sendcron' logged on from 127.0.0.1 -- [Jun 14 20:50:21] -- Manager 'sendcron' from 127.0.0.1, hanging up channel: SIP/6814264-00000006 == [Jun 14 20:50:21] == Spawn extension (default, 8600051, 1) exited non-zero on 'SIP/6814264-00000006' -- [Jun 14 20:50:21] -- Executing [h@default:1] AGI("SIP/6814264-00000006", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack -- [Jun 14 20:50:21] -- <SIP/6814264-00000006>AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------- completed, returning 0 == [Jun 14 20:50:21] == Manager 'sendcron' logged on from 127.0.0.1 [Jun 14 20:50:21] NOTICE[7325]: manager.c:3407 action_hangup: Request to hangup non-existent channel: SIP/6814264-00000006 == [Jun 14 20:50:22] == Manager 'sendcron' logged off from 127.0.0.1 == [Jun 14 20:50:22] == Manager 'sendcron' logged off from 127.0.0.1 ^C vicibox8:/var/log/astguiclient # vim screenlog.0 ^[[1;30m -- ^[[0m[Jun 14 20:50:15] -- <Local/010*100*100*125*78600051@default-00000003;2>AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------- completed, returning 0 ^[[1;30m -- ^[[0m[Jun 14 20:50:15] -- Stopped music on hold on SIP/6814264-00000006 ^[[1;30m -- ^[[0m[Jun 14 20:50:15] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') ^[[1;30m -- ^[[0m[Jun 14 20:50:15] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') ^[[1;30m == ^[[0m[Jun 14 20:50:16] == Manager 'sendcron' logged off from 127.0.0.1 ^[[1;30m -- ^[[0m[Jun 14 20:50:16] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') ^[[1;30m -- ^[[0m[Jun 14 20:50:16] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') ^[[1;30m -- ^[[0m[Jun 14 20:50:16] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') ^[[1;30m -- ^[[0m[Jun 14 20:50:16] -- <SIP/6814264-00000006> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') DBI::db=HASH(0x220b230)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi line 3905, <STDIN> line 61. ^[[1;30m -- ^[[0m[Jun 14 20:50:16] -- <SIP/6814264-00000006>AGI Script agi-VDAD_ALL_inbound.agi completed, returning 0 ^[[1;30m -- ^[[0m[Jun 14 20:50:16] -- Executing [010*100*100*125*8600051@default:1] ^[[1;36mGoto^[[0m("^[[1;35mSIP/6814264-00000006^[[0m", "^[[1;35mdefault,8600051,1^[[0m") in new stack ^[[1;30m -- ^[[0m[Jun 14 20:50:16] -- Goto (default,8600051,1) ^[[1;30m -- ^[[0m[Jun 14 20:50:16] -- Executing [8600051@default:1] ^[[1;36mMeetMe^[[0m("^[[1;35mSIP/6814264-00000006^[[0m", "^[[1;35m8600051,F^[[0m") in new stack ^[[1;30m == ^[[0m[Jun 14 20:50:21] == Manager 'sendcron' logged on from 127.0.0.1 ^[[1;30m -- ^[[0m[Jun 14 20:50:21] -- Manager 'sendcron' from 127.0.0.1, hanging up channel: SIP/6814264-00000006 ^[[1;30m == ^[[0m[Jun 14 20:50:21] == Spawn extension (default, 8600051, 1) exited non-zero on 'SIP/6814264-00000006' ^[[1;30m -- ^[[0m[Jun 14 20:50:21] -- Executing [h@default:1] ^[[1;36mAGI^[[0m("^[[1;35mSIP/6814264-00000006^[[0m", "^[[1;35magi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------^[[0m") in new stack ^[[1;30m -- ^[[0m[Jun 14 20:50:21] -- <SIP/6814264-00000006>AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------- completed, returning 0 ^[[1;30m == ^[[0m[Jun 14 20:50:21] == Manager 'sendcron' logged on from 127.0.0.1 [Jun 14 20:50:21] ^[[1;33mNOTICE^[[0m[7325]: ^[[1;37mmanager.c^[[0m:^[[1;37m3407^[[0m ^[[1;37maction_hangup^[[0m: Request to hangup non-existent channel: SIP/6814264-00000006 ^[[1;30m == ^[[0m[Jun 14 20:50:22] == Manager 'sendcron' logged off from 127.0.0.1 ^[[1;30m == ^[[0m[Jun 14 20:50:22] == Manager 'sendcron' logged off from 127.0.0.1

by **mflorell** » Thu Jun 14, 2018 8:10 am

You don't have the Server AGI output set to BOTH. Please make that change and run again.

by **ZeeTech** » Thu Jun 14, 2018 4:07 pm

Thank you for your response; AGI output set to Both and capture logs again, please review & advise.

I also noticed that there was no calling part CLI appear to agent screen, so i must be missing something.

Code: Select all: == [Jun 15 02:03:27] == Using SIP RTP CoS mark 5 -- [Jun 15 02:03:27] -- Executing [111007008@default:1] Answer("SIP/6814264-0000000d", "") in new stack > [Jun 15 02:03:27] > 0x7ff37400a4d0 -- Probation passed - setting RTP source address to 172.16.222.128:4002 -- [Jun 15 02:03:27] -- Executing [111007008@default:2] AGI("SIP/6814264-0000000d", "agi-DID_route.agi") in new stack -- [Jun 15 02:03:27] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-DID_route.agi 2018-06-15 02:03:27|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1529010207.34',channel='SIP/6814264-0000000d',server_ip='10.100.100.125',caller_id_number='6814264',caller_id_name='6814264',extension='111007008',call_date='2018-06-15 02:03:27',did_id='2',did_route='IN_GROUP';| 2018-06-15 02:03:27|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1529010207.34',channel='SIP/6814264-0000000d',server_ip='10.100.100.125',caller_id_number='6814264',caller_id_name='6814264',extension='111007008',call_date='2018-06-15 02:03:27',did_id='2',did_route='IN_GROUP';| 2018-06-15 02:03:27|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1529010207.34', channel='SIP/6814264-0000000d', channel_group='DID_INBOUND', server_ip='10.100.100.125', type='SIP', extension='111007008', number_dialed='111007008', caller_code='6814264', start_time='2018-06-15 02:03:27', start_epoch='1529010207';| 2018-06-15 02:03:27|agi-DID_route.agi|exiting the DID app, transferring call to 99909*2***DID @ default -- [Jun 15 02:03:27] -- <SIP/6814264-0000000d>AGI Script agi-DID_route.agi completed, returning 0 -- [Jun 15 02:03:27] -- Executing [99909*2***DID@default:1] Answer("SIP/6814264-0000000d", "") in new stack -- [Jun 15 02:03:27] -- Executing [99909*2***DID@default:2] AGI("SIP/6814264-0000000d", "agi-VDAD_ALL_inbound.agi") in new stack -- [Jun 15 02:03:27] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- accountcode = 6814264 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- callerid = 6814264 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- calleridname = 6814264 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- callingpres = 0 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- callingtns = 0 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- callington = 0 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- channel = SIP/6814264-0000000d 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- context = default 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- dnid = 111007008 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- extension = 99909*2***DID 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- language = en 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- priority = 2 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- threadid = 140683246982912 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- type = SIP 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1529010207.34 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi| -- version = 11.25.1-vici 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi|AGI Variables: |1529010207.34|SIP/6814264-0000000d|99909*2***DID|SIP|| 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |IN_GROUP001|-111007008|2018-06-15 02:03:27 -- [Jun 15 02:03:27] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:27] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi|-- AH VDCL vcl insert: |1|16|14|203|2400|2400|0|0 |SELECT LAST_INSERT_ID() LIMIT 1;| 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi|-- AH VLE insert: |1| |INSERT INTO vicidial_log_extended set uniqueid='1529010207.34',server_ip='10.100.100.125',call_date='2018-06-15 02:03:27',lead_id = '16',caller_code='Y6150203270000000016',custom_call_id='';| 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi|-- AH VDCL vl update: |1|16| |UPDATE vicidial_list set status='AFTHRS' where lead_id = '16';| 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi|-- AH VDCL vac record deleted: |0E0| IN_GROUP001| 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi|-- AH action: |CALLMENU|8300|vm-goodbye|| Setting CID ""IN_GROUP001 <6814264>"" 2018-06-15 02:03:27|02:03:27|agi-VDAD_ALL_inbound.agi|callerID changed: "IN_GROUP001 <6814264>" -- [Jun 15 02:03:27] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:27] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:28] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:28] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:28] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:28] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') 2018-06-15 02:03:27|02:03:29|agi-VDAD_ALL_inbound.agi|exiting the VDAD app after hours, transferring call to s -- [Jun 15 02:03:29] -- <SIP/6814264-0000000d>AGI Script agi-VDAD_ALL_inbound.agi completed, returning 0 -- [Jun 15 02:03:29] -- Executing [s@IVR001:1] Answer("SIP/6814264-0000000d", "") in new stack -- [Jun 15 02:03:29] -- Executing [s@IVR001:2] AGI("SIP/6814264-0000000d", "agi-VDAD_inbound_calltime_check.agi,CALLMENU-----NO-----IVR001-------------------------NO") in new stack -- [Jun 15 02:03:29] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-VDAD_inbound_calltime_check.agi 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi|Perl Environment Dump: 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi|0|CALLMENU-----NO-----IVR001-------------------------NO 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- accountcode = 6814264 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- arg_1 = CALLMENU-----NO-----IVR001-------------------------NO 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- callerid = 6814264 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- calleridname = IN_GROUP001 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- callingani2 = 0 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- callingpres = 0 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- callingtns = 0 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- callington = 0 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- channel = SIP/6814264-0000000d 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- context = IVR001 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- dnid = 111007008 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- enhanced = 0.0 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- extension = s 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- language = en 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- priority = 2 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- rdnis = unknown 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- request = agi-VDAD_inbound_calltime_check.agi 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- threadid = 140683246982912 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- type = SIP 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- uniqueid = 1529010207.34 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi| -- version = 11.25.1-vici 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi|AGI Variables: |1529010207.34|SIP/6814264-0000000d|s|SIP|| 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi|+++++ INBOUND CALL VDCL STARTED : |CALLMENU|-|2018-06-15 02:03:29 -- [Jun 15 02:03:29] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:29] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi||INSERT INTO live_inbound_log (uniqueid,channel,server_ip,caller_id,extension,phone_ext,start_time,comment_a,comment_b,comment_d,comment_e) values('1529010207.34','SIP/6814264-0000000d','10.100.100.125','','s','6814264','2018-06-15 02:03:29','CALLMENU','IVR001','IVR001','2')| 2018-06-15 02:03:29|agi-VDAD_inbound_calltime_check.agi|-- LIL insert: |1|1529010207.34||s| -- [Jun 15 02:03:29] -- <SIP/6814264-0000000d>AGI Script agi-VDAD_inbound_calltime_check.agi completed, returning 0 -- [Jun 15 02:03:29] -- Executing [s@IVR001:3] Set("SIP/6814264-0000000d", "INVCOUNT=0") in new stack -- [Jun 15 02:03:29] -- Executing [s@IVR001:4] BackGround("SIP/6814264-0000000d", "HB-IVR") in new stack -- [Jun 15 02:03:29] -- <SIP/6814264-0000000d> Playing 'HB-IVR.slin' (language 'en') [Jun 15 02:03:35] DTMF[14545][C-00000015]: channel.c:4215 __ast_read: DTMF begin '5' received on SIP/6814264-0000000d [Jun 15 02:03:35] DTMF[14545][C-00000015]: channel.c:4219 __ast_read: DTMF begin ignored '5' on SIP/6814264-0000000d [Jun 15 02:03:35] DTMF[14545][C-00000015]: channel.c:4129 __ast_read: DTMF end '5' received on SIP/6814264-0000000d, duration 200 ms [Jun 15 02:03:35] DTMF[14545][C-00000015]: channel.c:4199 __ast_read: DTMF end passthrough '5' on SIP/6814264-0000000d -- [Jun 15 02:03:35] -- Executing [5@IVR001:1] AGI("SIP/6814264-0000000d", "cm.agi,CALLMENU-----5-----rank-----0-----0") in new stack -- [Jun 15 02:03:35] -- Launched AGI Script /usr/share/asterisk/agi-bin/cm.agi 2018-06-15 02:03:35|cm.agi|Perl Environment Dump: 2018-06-15 02:03:35|cm.agi|0|CALLMENU-----5-----rank-----0-----0 2018-06-15 02:03:35|cm.agi| -- accountcode = 6814264 2018-06-15 02:03:35|cm.agi| -- arg_1 = CALLMENU-----5-----rank-----0-----0 2018-06-15 02:03:35|cm.agi| -- callerid = 6814264 2018-06-15 02:03:35|cm.agi| -- calleridname = IN_GROUP001 2018-06-15 02:03:35|cm.agi| -- callingani2 = 0 2018-06-15 02:03:35|cm.agi| -- callingpres = 0 2018-06-15 02:03:35|cm.agi| -- callingtns = 0 2018-06-15 02:03:35|cm.agi| -- callington = 0 2018-06-15 02:03:35|cm.agi| -- channel = SIP/6814264-0000000d 2018-06-15 02:03:35|cm.agi| -- context = IVR001 2018-06-15 02:03:35|cm.agi| -- dnid = 111007008 2018-06-15 02:03:35|cm.agi| -- enhanced = 0.0 2018-06-15 02:03:35|cm.agi| -- extension = 5 2018-06-15 02:03:35|cm.agi| -- language = en 2018-06-15 02:03:35|cm.agi| -- priority = 1 2018-06-15 02:03:35|cm.agi| -- rdnis = unknown 2018-06-15 02:03:35|cm.agi| -- request = cm.agi 2018-06-15 02:03:35|cm.agi| -- threadid = 140683246982912 2018-06-15 02:03:35|cm.agi| -- type = SIP 2018-06-15 02:03:35|cm.agi| -- uniqueid = 1529010207.34 2018-06-15 02:03:35|cm.agi| -- version = 11.25.1-vici 2018-06-15 02:03:35|cm.agi|AGI Variables: |1529010207.34|SIP/6814264-0000000d|5|SIP|| 2018-06-15 02:03:35|cm.agi|+++++ DTMF LOG STARTED : |CALLMENU|-|2018-06-15 02:03:35 2018-06-15 02:03:35|cm.agi||INSERT INTO live_inbound_log (uniqueid,channel,server_ip,caller_id,extension,phone_ext,start_time,comment_a,comment_b,comment_d,comment_e) values('1529010207.34','SIP/6814264-0000000d','10.100.100.125','','5','6814264','2018-06-15 02:03:35','CALLMENU','5','IVR001>5','1');| 2018-06-15 02:03:35|cm.agi|-- LIL insert: |1|1529010207.34||5| -- [Jun 15 02:03:35] -- <SIP/6814264-0000000d>AGI Script cm.agi completed, returning 0 -- [Jun 15 02:03:35] -- Executing [5@IVR001:2] AGI("SIP/6814264-0000000d", "agi-VDAD_ALL_inbound.agi,CLOSER-----LB-----Q_General-----IVR001--------------------998-----1-----C001------------------------------") in new stack -- [Jun 15 02:03:35] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|Perl Environment Dump: 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|0|CLOSER-----LB-----Q_General-----IVR001--------------------998-----1-----C001------------------------------ 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- accountcode = 6814264 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- arg_1 = CLOSER-----LB-----Q_General-----IVR001--------------------998-----1-----C001------------------------------ 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- callerid = 6814264 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- calleridname = IN_GROUP001 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- callingpres = 0 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- callingtns = 0 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- callington = 0 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- channel = SIP/6814264-0000000d 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- context = IVR001 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- dnid = 111007008 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- extension = 5 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- language = en 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- priority = 2 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- threadid = 140683246982912 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- type = SIP 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1529010207.34 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi| -- version = 11.25.1-vici 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|AGI Variables: |1529010207.34|SIP/6814264-0000000d|5|SIP|| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |Q_General|-IVR001|2018-06-15 02:03:35 -- [Jun 15 02:03:35] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:35] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|callerID changed: "Y6150203350000000000 <6814264>" 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_xfer_log (lead_id,campaign_id,call_date,phone_code,phone_number,user,closer,list_id,front_uniqueid,close_uniqueid) values('','Q_General','2018-06-15 02:03:35','1','','IVR001','VDXL','998','','1529010207.34')| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|-- VDXL : ||6|insert to vicidial_xfer_log 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|0|SELECT auto_call_id from vicidial_auto_calls where uniqueid='1529010207.34' and server_ip='10.100.100.125';| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls SET server_ip='10.100.100.125', campaign_id='Q_General', status='LIVE', lead_id='', uniqueid='1529010207.34', callerid='Y6150203350000000000', channel='SIP/6814264-0000000d', phone_code='1', phone_number='', call_time='2018-06-15 02:03:35', call_type='IN', stage='LIVE-0', queue_priority='0' ;| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|1|SELECT count(*) from vicidial_auto_calls where status = 'LIVE' and campaign_id='Q_General';| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|1|UPDATE vicidial_auto_calls SET queue_position='1' WHERE auto_call_id='7';| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log SET lead_id='', campaign_id='Q_General', call_date='2018-06-15 02:03:35', start_epoch='1529010215', status='QUEUE', phone_code='1', phone_number='', user='VDCL', processed='N', xfercallid='6', uniqueid='1529010207.34', queue_position='1',called_count='1',list_id='998' ;| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|-- VDCL : ||6|15|insert to vicidial_closer_log DBD::mysql::db do failed: Duplicate entry '1529010207.34' for key 'PRIMARY' at /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi line 2346, <STDIN> line 27. 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|-- ENTER QUEUE VLE insert: || |INSERT INTO vicidial_log_extended set uniqueid='1529010207.34',server_ip='10.100.100.125',call_date='2018-06-15 02:03:35',lead_id = '',caller_code='Y6150203350000000000',custom_call_id='';| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|DID IVR time logged: 2018-06-15 02:03:35|1529010215|1|UPDATE call_log set end_time='2018-06-15 02:03:35',end_epoch='1529010215',length_in_sec=8,length_in_min=' 0.13',extension='Y6150203350000000000' where uniqueid='1529010207.34'| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'Q_General' and call_time < "2018-06-15 02:03:35" and lead_id != '' and queue_priority >= '0' and agent_only='';| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2018-06-15 02:03:35") );| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|5911|2018-06-15 01:50:58|SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('C001') and closer_campaigns LIKE "% Q_General %" and last_update_time > '20180615020328' and vicidial_live_agents.user NOT IN('','') order by random_id limit 1;| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|50|60|1|1||0|update of vla table: Q_General| |UNLOCK TABLES;| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|-- VDCL XFER REMOTE: |1|update of vac table: Y6150203350000000000 |UPDATE vicidial_auto_calls set status='CLOSER', stage='CLOSER-0' where callerid='Y6150203350000000000';| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|-- VDXL vicidial_xfer_log update: |1||5911 |UPDATE vicidial_xfer_log set closer='5911' where lead_id = '' order by xfercallid desc limit 1;| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|-- closer log : |1|update of vcl table: |UPDATE vicidial_closer_log set user='5911' where lead_id='' order by closecallid desc limit 1;| 2018-06-15 02:03:35|02:03:35|agi-VDAD_ALL_inbound.agi|-- VDCL agent alert: |VH6150203358600051|010*100*100*125*78600051|ding|"ding" <ding>|SIP/6814264-0000000d|insert to vicidial_manager == [Jun 15 02:03:35] == Manager 'sendcron' logged on from 127.0.0.1 -- [Jun 15 02:03:35] -- Executing [010*100*100*125*78600051@default:1] Goto("Local/010*100*100*125*78600051@default-00000008;2", "default,78600051,1") in new stack -- [Jun 15 02:03:35] -- Goto (default,78600051,1) -- [Jun 15 02:03:35] -- Executing [78600051@default:1] MeetMe("Local/010*100*100*125*78600051@default-00000008;2", "8600051,Fq") in new stack > [Jun 15 02:03:35] > Channel Local/010*100*100*125*78600051@default-00000008;1 was answered -- [Jun 15 02:03:35] -- Executing [83047777777777@vicidial-auto:1] Answer("Local/010*100*100*125*78600051@default-00000008;1", "") in new stack -- [Jun 15 02:03:35] -- Executing [83047777777777@vicidial-auto:2] Playback("Local/010*100*100*125*78600051@default-00000008;1", "ding") in new stack -- [Jun 15 02:03:35] -- <Local/010*100*100*125*78600051@default-00000008;1> Playing 'ding.gsm' (language 'en') -- [Jun 15 02:03:36] -- Executing [83047777777777@vicidial-auto:3] Hangup("Local/010*100*100*125*78600051@default-00000008;1", "") in new stack == [Jun 15 02:03:36] == Spawn extension (vicidial-auto, 83047777777777, 3) exited non-zero on 'Local/010*100*100*125*78600051@default-00000008;1' -- [Jun 15 02:03:36] -- Executing [h@vicidial-auto:1] AGI("Local/010*100*100*125*78600051@default-00000008;1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16---------------") in new stack -- [Jun 15 02:03:36] -- <Local/010*100*100*125*78600051@default-00000008;1>AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16--------------- completed, returning 0 == [Jun 15 02:03:36] == Spawn extension (default, 78600051, 1) exited non-zero on 'Local/010*100*100*125*78600051@default-00000008;2' -- [Jun 15 02:03:36] -- Executing [h@default:1] AGI("Local/010*100*100*125*78600051@default-00000008;2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack -- [Jun 15 02:03:36] -- <Local/010*100*100*125*78600051@default-00000008;2>AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------- completed, returning 0 2018-06-15 02:03:35|02:03:36|agi-VDAD_ALL_inbound.agi|exiting VDAD app, transferring call to 010*100*100*125*8600051 -- [Jun 15 02:03:36] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:36] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') 2018-06-15 02:03:35|02:03:36|agi-VDAD_ALL_inbound.agi||SELECT calls_today from vicidial_inbound_group_agents WHERE user='5911' and group_id='Q_General';| 2018-06-15 02:03:35|02:03:36|agi-VDAD_ALL_inbound.agi|-- VDLIA agent calls: |1|5911|Q_General| == [Jun 15 02:03:36] == Manager 'sendcron' logged off from 127.0.0.1 2018-06-15 02:03:35|02:03:37|agi-VDAD_ALL_inbound.agi|-- VDCL vcl update: |1|| |UPDATE vicidial_closer_log set queue_seconds='0' where lead_id = '' and call_date='2018-06-15 02:03:35' order by closecallid desc limit 1;| -- [Jun 15 02:03:37] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:37] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:37] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') -- [Jun 15 02:03:37] -- <SIP/6814264-0000000d> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en') DBI::db=HASH(0x2797320)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi line 3905, <STDIN> line 37. 2018-06-15 02:03:37|02:03:37|agi-VDAD_ALL_inbound.agi|XXXXX VDAD transferred: start|stop 2018-06-15 02:03:35|2018-06-15 02:03:37|010*100*100*125*8600051 -- [Jun 15 02:03:37] -- <SIP/6814264-0000000d>AGI Script agi-VDAD_ALL_inbound.agi completed, returning 0 -- [Jun 15 02:03:37] -- Executing [010*100*100*125*8600051@default:1] Goto("SIP/6814264-0000000d", "default,8600051,1") in new stack -- [Jun 15 02:03:37] -- Goto (default,8600051,1) -- [Jun 15 02:03:37] -- Executing [8600051@default:1] MeetMe("SIP/6814264-0000000d", "8600051,F") in new stack == [Jun 15 02:03:41] == Spawn extension (default, 8600051, 1) exited non-zero on 'SIP/6814264-0000000d' -- [Jun 15 02:03:41] -- Executing [h@default:1] AGI("SIP/6814264-0000000d", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack -- [Jun 15 02:03:41] -- <SIP/6814264-0000000d>AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------- completed, returning 0

by **mflorell** » Fri Jun 15, 2018 12:58 am

For your initial in-group, try setting the "Action Transfer CID" to CLOSERCUSTOMER, then try again.

by **ZeeTech** » Fri Jun 15, 2018 3:25 pm

Working perfectly, thank you so much for your assistance.
One more question, can we monitor live calls that in IVR through realtime_report?
i have enable Track Calls in Real-Time Report but calls in IVR are not showing in realtime_report.php

by **mflorell** » Fri Jun 15, 2018 10:26 pm

You have to set the Tracking Group to an In-Group that is allowed in one of your active campaigns in order for those calls to show up in the Real-Time Report.

by **ZeeTech** » Wed Jun 20, 2018 10:55 am

thank you it is working fine.

by **Mahmoud** » Tue Jul 16, 2019 5:46 am

ZeeTech wrote:I made the changes but still not able to capture required data, please also advise either this data will be available in Export Calls Report or Export Leads Report

This is new call flow.
1. SIP Carrier -> Call Routing to DID,
2. DID is forwarding call to IN_GROUP001, Ingroup handle method=CID, Ingroup search method=LB, List 999
3. INGROUP001 - Call time= Always close(Set 2400 to 2400), After Hours Action =CALL MENU, After Hours Call Menu = IVR001)
4. IVR001
Tracking Group = Call Menu
Log Key Press = 1 - DTMF Logging Enabled
Log field = comments (i tried different fields)
Options - Route=INGROUP, In-Group=Q_General, Handle Method=Closer, Search Method=LB List ID 998

Call is landing to IVR but still data is missing, please advise.

Thanks.

Environment Information:
ViciBOX 8 | VERSION: 2.14-673a BUILD: 180512-2217 | Asterisk 11.25.1-vici | Dell R730 | No additional HW

Hello, i have followed all the steps here yet it doesn't work with me, i have made Action Transfer CID in initial group to CUSTOMER CLOSER too, i didn't install the system so i don't understand this screenlog.0 codes, any help would be appreciated

by **williamconley** » Mon Mar 30, 2020 11:25 pm

It doesn't work is a bit vague. What didn't work?

vicidial.org

Call Menu Repoting & Real Time Tracking

Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Re: Call Menu Repoting & Real Time Tracking

Who is online