<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Agreed! I like the magic of channel
variables showing up in the XML. It has made my life worth living compared to
the hellishness of CDRs in Asterisk.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>-MC<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
freeswitch-dev-bounces@lists.freeswitch.org
[mailto:freeswitch-dev-bounces@lists.freeswitch.org] <b><span style='font-weight:
bold'>On Behalf Of </span></b>Anthony Minessale<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, June 30, 2008 6:44
AM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">freeswitch-dev@lists.freeswitch.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Freeswitch-dev] FW:
[asterisk-users] Asterisk as an IVR</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>That would be possible.<br>
<br>
The best bet is to first exhaust anything you can't do reasonable with what we
currently have and then see what we have left to add. The time stamp on
the app log is probably pretty trivial so we can look at adding that.<br>
<br>
For other stuff, remember that anything you set as a channel variable will
magically end up in the CDR so keep that in mind when figuring it out.<br>
<br>
<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Sat, Jun 28, 2008 at 2:44 PM, <st1:PersonName w:st="on">Michael
Collins</st1:PersonName> <<a href="mailto:mcollins@fcnetwork.com">mcollins@fcnetwork.com</a>>
wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Question...<br>
<br>
Is this something that FreeSWITCH can do with the XML CDRs? Just<br>
curious. If it's possible to store the time of key DTMF received in the<br>
XML CDR then that would be awesome. The other thing I was thinking<br>
about was the list of apps that get stored in the XML. Is it<br>
possible/realistic to have not only the list of applications but also a<br>
timestamp for each one? That would allow one to calculate the amount of<br>
time spent in things like IVR menus, listening to message playbacks,<br>
etc.<br>
<br>
This kind of feature would allow us to snag all sorts of IVR-builders.<br>
Asterisk's handling of this kind of information is pathetic. FS is<br>
*way* better for gathering this kind of info.<br>
<br>
Thanks,<br>
MC<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a><br>
[mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a>]
On Behalf Of<br>
<a href="mailto:research@businesstz.com">research@businesstz.com</a><br>
Sent: Saturday, June 28, 2008 11:09 AM<br>
To: <a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a><br>
Subject: Re: [asterisk-users] Asterisk as an IVR<br>
<br>
Thanks Anselm<br>
<br>
Its true that is a lot of calls but i have a separate mysql database on<br>
different server (HP DL580G5 with 16cores). what am currently doing is<br>
capturing the information right after selection and insert that record<br>
into mySql.<br>
<br>
****<br>
[macro-capture-input]<br>
;<br>
;<br>
; Macro that feeds data into mysql through perl script:<br>
; ${ARG1} - MSISDN<br>
; ${ARG2} - src<br>
; ${ARG3} - MainMenu Application<br>
; ${ARG4} - Channel<br>
; ${ARG5} - calldatetime<br>
; ${ARG6} - Sub Menu Application<br>
;<br>
;<br>
exten => s,1,System(/var/lib/asterisk/agi-bin/capture.pl ${ARG1} ${ARG2}<br>
${ARG3} ${ARG4} ${ARG5} ${ARG6})<br>
<br>
[Data-Services-Options]<br>
; This menu is aimed to provide user with info about data
services<br>
offered by Vodacom, including<br>
; 1 - SUBMenu 1<br>
; 2 - SUBMenu 2<br>
; 3 - SUBMenu 3<br>
; 4 - SUBMenu 4<br>
;<br>
;<br>
;SUBMENU 1<br>
;<br>
exten =><br>
1,1,Macro(capture-input,"${MSISDN}","${OPT}","APPLICATION1","${CHANNEL}"<br>
,"now()","SUBMENU1")<br>
exten => 1,n,Background(IVR/(1110) MENU 1)<br>
<br>
;SUBMENU 2<br>
exten => 2,1,Macro(sendsms,${MSISDN},1,${LANGUAGE})<br>
exten =><br>
2,n,Macro(ivrcdr,"${MSISDN}","${OPT}","APPLICATION2","${CHANNEL}","now()<br>
","SUBMENU2")<br>
exten => 2,n,Background(IVR/(1120) MENU 2)<br>
.<br>
.<br>
.<br>
****<br>
<br>
what i will also want to capture is how long a caller took to listen to<br>
say SUBMENU1<br>
<br>
It should be noted that CDR doesnot capture such detailed info (Tzafrir)<br>
<br>
Regards<br>
Kili<br>
><br>
> On Sat, Jun 28, 2008 at 03:37:56PM +0200, Anselm Martin Hoffmeister<br>
wrote:<br>
>> Am Samstag, den 28.06.2008, 08:15 -0500 schrieb<br>
<a href="mailto:research@businesstz.com">research@businesstz.com</a>:<br>
>> > Hi List<br>
>> ><br>
>> > I have build an IVR on Asterisk from 1.2 to now 1.4.18 and has<br>
already<br>
>> > processed more than 10million calls!<br>
>> ><br>
>> > I have one big challenge which is reporting... it is the<br>
requirement<br>
>> to<br>
>> > have a web reporting module which should the following info based<br>
on<br>
>> > selected time frame<br>
>> > - Number of calls on specific branch- Done<br>
>> > - Number of calls to branch 1 that came from branch 2 (this
should<br>
be<br>
>> > flexible)<br>
>> > - talktime on specified branch (say how long caller listened to<br>
option<br>
>> 1<br>
>> > before choosing option 2 or hangup)<br>
>> ><br>
>> > On IVR, it is so important to understand how many callers select
a<br>
>> > specific branch and how long they spent on that branch. CDR stats<br>
can<br>
>> not<br>
>> > provide these type of information and on trying freepbx, still
can<br>
not<br>
>> go<br>
>> > so detailed<br>
>><br>
>> Dear Kili,<br>
>><br>
>> in my opinion this is a good application for Database backends. You<br>
>> could, for example, write entries to a DB whenever someone presses a<br>
key<br>
>> (or is re-routed in the dialplan, which comes to a similar scheme).<br>
In<br>
>> data mining time some SQL logic can produce nearly any data you want,<br>
>> provided the input data is there.<br>
>><br>
>> Millions of calls sounds a lot though, so be sure to have a<br>
reasonable<br>
>> database backend: The asterisk included one might be a bit on the<br>
small<br>
>> side here.<br>
>><br>
>> This is just an idea, I did not implement anything the like (yet).<br>
><br>
> Asterisk already has this separate database backend: CDR.<br>
><br>
> --<br>
> Tzafrir Cohen<br>
> icq#16849755 <a
href="mailto:jabber%3Atzafrir.cohen@xorcom.com">jabber:tzafrir.cohen@xorcom.com</a><br>
> +972-50-7952406 mailto:<a
href="mailto:tzafrir.cohen@xorcom.com">tzafrir.cohen@xorcom.com</a><br>
> <a href="http://www.xorcom.com" target="_blank">http://www.xorcom.com</a>
<a href="http://iax:guest@local.xorcom.com/tzafrir" target="_blank">iax:guest@local.xorcom.com/tzafrir</a><br>
><br>
<br>
<br>
<br>
_______________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com"
target="_blank">http://www.api-digital.com</a> --<br>
<br>
AstriCon 2008 - September 22 - 25 <st1:place w:st="on"><st1:City w:st="on">Phoenix</st1:City>,
<st1:State w:st="on">Arizona</st1:State></st1:place><br>
Register Now: <a href="http://www.astricon.net" target="_blank">http://www.astricon.net</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users"
target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
<br>
_______________________________________________<br>
Freeswitch-dev mailing list<br>
<a href="mailto:Freeswitch-dev@lists.freeswitch.org">Freeswitch-dev@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-dev"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-dev</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
-- <br>
Anthony Minessale II<br>
<br>
FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
<br>
AIM: anthm<br>
<a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br>
<br>
FreeSWITCH Developer Conference<br>
<a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br>
<a href="http://iax:guest@conference.freeswitch.org/888">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:213-799-1400 <o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>