All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by muyousif » Fri Dec 14, 2018 11:40 am
Hi,
Is it possible to extract inbound callers data who hangup during ivr/call menus before reaching to inbound group?
Thanks.
ViciBox v.6.0.3 | VERSION: 2.14-685a BUILD: 180825-2100| Asterisk 1.8.29 | Cluster: 1 DB: 16Core@2.67GHz 16RAM | 1 WEB: 8Core@2.50GHz 16RAM | 8 Tel: QuadCore@2.93GHz 8RAM
-
muyousif
-
- Posts: 119
- Joined: Wed May 14, 2014 5:29 am
by ambiorixg12 » Sat Dec 15, 2018 4:43 pm
What data exactly would you like to extract ?
-
ambiorixg12
-
- Posts: 453
- Joined: Tue Sep 17, 2013 10:35 pm
by muyousif » Sun Dec 16, 2018 1:58 pm
Callers info who disconnected during ivr before reaching to agents, who just listened to ivr options but didn't press 0 to reach agent and disconnected call.
ViciBox v.6.0.3 | VERSION: 2.14-685a BUILD: 180825-2100| Asterisk 1.8.29 | Cluster: 1 DB: 16Core@2.67GHz 16RAM | 1 WEB: 8Core@2.50GHz 16RAM | 8 Tel: QuadCore@2.93GHz 8RAM
-
muyousif
-
- Posts: 119
- Joined: Wed May 14, 2014 5:29 am
by ambiorixg12 » Sun Dec 16, 2018 4:12 pm
All calls inbound and outbound are stored on table call_log, but using this table I dont see a way for you to indentify if caller listen to the IVR and then hangup. I would suggest make little script in a custom context and catch ${CALLERID(num)} variable and time before send the call to the call menu. In this way you will have a least a list of caller who dial in to the IVR. Dont know if is there is an easy method using vicidial GUI, as I used to custom code most of the things I need, dont blame me, I'm a frustrated developer lol
-
ambiorixg12
-
- Posts: 453
- Joined: Tue Sep 17, 2013 10:35 pm
by muyousif » Mon Dec 17, 2018 3:14 am
Thanks for your help, following query helped me to catch required data.
select distinct(phone_ext) from live_inbound_log where uniqueid NOT IN (select distinct(uniqueid) from vicidial_closer_log);
ViciBox v.6.0.3 | VERSION: 2.14-685a BUILD: 180825-2100| Asterisk 1.8.29 | Cluster: 1 DB: 16Core@2.67GHz 16RAM | 1 WEB: 8Core@2.50GHz 16RAM | 8 Tel: QuadCore@2.93GHz 8RAM
-
muyousif
-
- Posts: 119
- Joined: Wed May 14, 2014 5:29 am
Return to Support
Who is online
Users browsing this forum: No registered users and 74 guests