[asterisk-users] Asterisk as an IVR

[research at businesstz.com]

Thanks Anselm

Its true that is a lot of calls but i have a separate mysql database on
different server (HP DL580G5 with 16cores). what am currently doing is
capturing the information right after selection and insert that record
into mySql.

****
[macro-capture-input]
;
;
; Macro that feeds data into mysql through perl script:
; ${ARG1} - MSISDN
; ${ARG2} - src
; ${ARG3} - MainMenu Application
; ${ARG4} - Channel
; ${ARG5} - calldatetime
; ${ARG6} - Sub Menu Application
;
;
exten => s,1,System(/var/lib/asterisk/agi-bin/capture.pl ${ARG1} ${ARG2}
${ARG3} ${ARG4} ${ARG5} ${ARG6})

[Data-Services-Options]
;       This menu is aimed to provide user with info about data services
offered by Vodacom, including
;       1 - SUBMenu 1
;       2 - SUBMenu 2
;       3 - SUBMenu 3
;       4 - SUBMenu 4
;
;
;SUBMENU 1
;
exten =>
1,1,Macro(capture-input,"${MSISDN}","${OPT}","APPLICATION1","${CHANNEL}","now()","SUBMENU1")
exten => 1,n,Background(IVR/(1110) MENU 1)

;SUBMENU 2
exten => 2,1,Macro(sendsms,${MSISDN},1,${LANGUAGE})
exten =>
2,n,Macro(ivrcdr,"${MSISDN}","${OPT}","APPLICATION2","${CHANNEL}","now()","SUBMENU2")
exten => 2,n,Background(IVR/(1120) MENU 2)
.
.
.
****

what i will also want to capture is how long a caller took to listen to
say SUBMENU1

It should be noted that CDR doesnot capture such detailed info (Tzafrir)

Regards
Kili
>
> On Sat, Jun 28, 2008 at 03:37:56PM +0200, Anselm Martin Hoffmeister wrote:
>> Am Samstag, den 28.06.2008, 08:15 -0500 schrieb research at businesstz.com:
>> > Hi List
>> >
>> > I have build an IVR on Asterisk from 1.2 to now 1.4.18 and has already
>> > processed more than 10million calls!
>> >
>> > I have one big challenge which is reporting... it is the requirement
>> to
>> > have a web reporting module which should the following info based on
>> > selected time frame
>> > - Number of calls on specific branch- Done
>> > - Number of calls to branch 1 that came from  branch 2 (this should be
>> > flexible)
>> > - talktime on specified branch (say how long caller listened to option
>> 1
>> > before choosing option 2 or hangup)
>> >
>> > On IVR, it is so important to understand how many callers select a
>> > specific branch and how long they spent on that branch. CDR stats can
>> not
>> > provide these type of information and on trying freepbx, still can not
>> go
>> > so detailed
>>
>> Dear Kili,
>>
>> in my opinion this is a good application for Database backends. You
>> could, for example, write entries to a DB whenever someone presses a key
>> (or is re-routed in the dialplan, which comes to a similar scheme). In
>> data mining time some SQL logic can produce nearly any data you want,
>> provided the input data is there.
>>
>> Millions of calls sounds a lot though, so be sure to have a reasonable
>> database backend: The asterisk included one might be a bit on the small
>> side here.
>>
>> This is just an idea, I did not implement anything the like (yet).
>
> Asterisk already has this separate database backend: CDR.
>
> --
>                Tzafrir Cohen
> icq#16849755              jabber:tzafrir.cohen at xorcom.com
> +972-50-7952406           mailto:tzafrir.cohen at xorcom.com
> http://www.xorcom.com  iax:guest at local.xorcom.com/tzafrir
>