On Sat, Jun 28, 2008 at 03:37:56PM +0200, Anselm Martin Hoffmeister wrote: > Am Samstag, den 28.06.2008, 08:15 -0500 schrieb [EMAIL PROTECTED]: > > 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:[EMAIL PROTECTED] +972-50-7952406 mailto:[EMAIL PROTECTED] http://www.xorcom.com iax:[EMAIL PROTECTED]/tzafrir _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users