<div>Hi</div>
<div> </div>
<div>the intention of writing that line in to extension.conf to read my balance</div>
<div>when iam dialing 888, read caller id get balance from the table</div>
<div> </div>
<div>how can i achive this </div>
<div> </div>
<div>is this not possible calling from extension directly than writing some small</div>
<div>agi code, as people recomended before</div>
<div> </div>
<div>Ram<br><br> </div>
<div><span class="gmail_quote">On 9/1/06, <b class="gmail_sendername">Kevin Savoy</b> <<a href="mailto:ksavoy@novo1.com">ksavoy@novo1.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div lang="EN-US" vlink="blue" link="blue">
<div>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="2">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font face="Tahoma" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">
asterisk-users-bounces@lists.digium.com</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a>
] <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> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:jmillican@sentinelcommunications.com" target="_blank">
jmillican@sentinelcommunications.com</a>; 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></div>
<div><span class="e" id="q_10d6a5aebaa4ddcc_1">
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Hi</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">iam trying like this in my extension.conf</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">some one refered in the news group past</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">error in messages</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">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 onclick="return top.js.OpenExtLink(window,event,this)" href="http://127.0.0.1/" target="_blank">
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><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">iam calling from my extension to 888</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Ram</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"><br> </span></font></p></div>
<div>
<p><span><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">On 9/1/06, <b><span style="FONT-WEIGHT: bold">John Millican</span></b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:jmillican@sentinelcommunications.com" target="_blank">
jmillican@sentinelcommunications.com</a>> wrote:</span></font></span> </p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">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 onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:jmillican@sentinelcommunications.com" target="_blank">
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 onclick="return top.js.OpenExtLink(window,event,this)" href="http://voip-info.org/" target="_blank">
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 onclick="return top.js.OpenExtLink(window,event,this)" href="http://home.cogeco.ca/~camstuff/agi.html" target="_blank">
http://home.cogeco.ca/~camstuff/agi.html</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://asterisk.drunkcoder.com/agi.cgi" target="_blank">http://asterisk.drunkcoder.com/agi.cgi </a><br><br>John M
<br><br>_______________________________________________<br>--Bandwidth and Colocation provided by <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://easynews.com/" target="_blank">Easynews.com</a> --<br>
<br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit: <br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users
</a></span></font></p></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></span></div>
<div></div></div></div><br>_______________________________________________<br>--Bandwidth and Colocation provided by <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://easynews.com/" target="_blank">Easynews.com
</a> --<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">
http://lists.digium.com/mailman/listinfo/asterisk-users</a><br><br><br></blockquote></div><br>