<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<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.EmailStyle18
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in .5in 1.0in 1.0in;}
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'>It’s telling you the sound file “Goodbye”
does not exist in the directory it looks for sounds. If you indeed have a sound
file called Goodbye then you need to either move it to the default sounds
directory or add the path line to the command. If you don’t have the
sound file you’ll need to either create one or use one you do have.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<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'>
asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] <b><span style='font-weight:
bold'>On Behalf Of </span></b>ram<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, September 01, 2006
11:06 AM<br>
<b><span style='font-weight:bold'>To:</span></b>
jmillican@sentinelcommunications.com; Asterisk Users Mailing List -
Non-Commercial Discussion<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [asterisk-users]
balance anouncement</span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>iam trying like this in my extension.conf</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>some one refered in the news group past</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>error in messages</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Sep 1 21:31:42 WARNING[28610] file.c: File Goodbye does not exist
in any format<br>
Sep 1 21:31:42 WARNING[28610] file.c: Unable to open Goodbye (format
ulaw): No such file or directory<br>
Sep 1 21:31:42 WARNING[28610] app_playback.c: ast_streamfile failed on
SIP/88888-3ca6 for Goodbye <br>
<br>
<br>
exten => 888,1,Read(${CALLERIDNUM})<br>
exten => 888,2,MYSQL(Connect connid <a href="http://127.0.0.1">127.0.0.1</a>
root password mydatabase)<br>
exten => 888,3,MYSQL(Query resultid ${connid} select total from balance
where username=${CALLERIDNUM}) <br>
exten => 888,4,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)<br>
exten => 888,5,MYSQL(Clear ${resultid})<br>
exten => 888,6,Playback(Goodbye)<br>
exten => 888,7,Hangup</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>iam calling from my extension to 888</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Ram</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
</span></font></p>
</div>
<div>
<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>On 9/1/06, <b><span style='font-weight:bold'>John
Millican</span></b> <<a href="mailto:jmillican@sentinelcommunications.com">jmillican@sentinelcommunications.com</a>>
wrote:</span></font></span> </p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Friday September 01 2006 10:19 am, ram wrote:<br>
> Hi<br>
><br>
> thanks for the quick reply<br>
><br>
> any documents to read to achive this<br>
> or any examples would be great to read<br>
><br>
> Ram<br>
><br>
> On 9/1/06, John Millican <<a
href="mailto:jmillican@sentinelcommunications.com">jmillican@sentinelcommunications.com
</a>> wrote:<br>
> > On Friday September 01 2006 9:27 am, ram wrote:<br>
> > > Hi<br>
> > ><br>
> > > how can i do balance anouncement by using asterisk<br>
> > ><br>
> > > take example, i have table balance , user name 99999, balance
200$ <br>
> > ><br>
> > > user dial *98 or what ever, then i need anouce his balance is
200$, by<br>
> > > reading from that row<br>
> > ><br>
> > > any clues how can i achive this or is this possible ? <br>
> > ><br>
> > > Ram<br>
> ><br>
> > Create an AGI script that does a db look up for the ballance and then<br>
> > pass the<br>
> > result back to Cepstral or Festival or your favorite text to speech <br>
> > software.<br>
> > John M<br>
> ><br>
Try google or <a href="http://voip-info.org">voip-info.org</a> and search for<br>
Asterisk AGI should yeid some good results.<br>
AGI can be called from the dial plan and written in your favorite language <br>
i.e. PHP, C++, Perl, C, Java<br>
or start here:<br>
<a href="http://home.cogeco.ca/~camstuff/agi.html">http://home.cogeco.ca/~camstuff/agi.html</a><br>
<a href="http://asterisk.drunkcoder.com/agi.cgi">http://asterisk.drunkcoder.com/agi.cgi
</a><br>
<br>
John M<br>
<br>
_______________________________________________<br>
--Bandwidth and Colocation provided by <a href="http://Easynews.com">Easynews.com</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">http://lists.digium.com/mailman/listinfo/asterisk-users</a></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</body>
</html>