Call Menu Repoting & Real Time Tracking

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Call Menu Repoting & Real Time Tracking

Postby 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
ZeeTech
 
Posts: 72
Joined: Sun Apr 04, 2010 5:45 am

Re: Call Menu Repoting & Real Time Tracking

Postby 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?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call Menu Repoting & Real Time Tracking

Postby 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 ?
ZeeTech
 
Posts: 72
Joined: Sun Apr 04, 2010 5:45 am

Re: Call Menu Repoting & Real Time Tracking

Postby 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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call Menu Repoting & Real Time Tracking

Postby 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
ZeeTech
 
Posts: 72
Joined: Sun Apr 04, 2010 5:45 am

Re: Call Menu Repoting & Real Time Tracking

Postby 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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call Menu Repoting & Real Time Tracking

Postby 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
ZeeTech
 
Posts: 72
Joined: Sun Apr 04, 2010 5:45 am

Re: Call Menu Repoting & Real Time Tracking

Postby 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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call Menu Repoting & Real Time Tracking

Postby 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
ZeeTech
 
Posts: 72
Joined: Sun Apr 04, 2010 5:45 am

Re: Call Menu Repoting & Real Time Tracking

Postby mflorell » Fri Jun 15, 2018 12:58 am

For your initial in-group, try setting the "Action Transfer CID" to CLOSERCUSTOMER, then try again.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call Menu Repoting & Real Time Tracking

Postby 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
ZeeTech
 
Posts: 72
Joined: Sun Apr 04, 2010 5:45 am

Re: Call Menu Repoting & Real Time Tracking

Postby 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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call Menu Repoting & Real Time Tracking

Postby ZeeTech » Wed Jun 20, 2018 10:55 am

thank you it is working fine.
ZeeTech
 
Posts: 72
Joined: Sun Apr 04, 2010 5:45 am

Re: Call Menu Repoting & Real Time Tracking

Postby 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
Mahmoud
 
Posts: 3
Joined: Tue Jul 02, 2019 8:34 am

Re: Call Menu Repoting & Real Time Tracking

Postby williamconley » Mon Mar 30, 2020 11:25 pm

It doesn't work is a bit vague. What didn't work?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 81 guests