Hi how can i do balance anouncement by using asterisk take example, i have table balance , user name 99999, balance 200$ user dial *98 or what ever, then i need anouce his balance is 200$, by reading from that row any clues how can i achive this or is this possible ? Ram -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060901/76043892/attachment.htm
On Friday September 01 2006 9:27 am, ram wrote:> Hi > > how can i do balance anouncement by using asterisk > > take example, i have table balance , user name 99999, balance 200$ > > user dial *98 or what ever, then i need anouce his balance is 200$, by > reading from that row > > any clues how can i achive this or is this possible ? > > RamCreate an AGI script that does a db look up for the ballance and then pass the result back to Cepstral or Festival or your favorite text to speech software. John M
Hi thanks for the quick reply any documents to read to achive this or any examples would be great to read Ram On 9/1/06, John Millican <jmillican@sentinelcommunications.com> wrote:> > On Friday September 01 2006 9:27 am, ram wrote: > > Hi > > > > how can i do balance anouncement by using asterisk > > > > take example, i have table balance , user name 99999, balance 200$ > > > > user dial *98 or what ever, then i need anouce his balance is 200$, by > > reading from that row > > > > any clues how can i achive this or is this possible ? > > > > Ram > Create an AGI script that does a db look up for the ballance and then pass > the > result back to Cepstral or Festival or your favorite text to speech > software. > John M > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060901/fff1785c/attachment.htm
On Friday September 01 2006 10:19 am, ram wrote:> Hi > > thanks for the quick reply > > any documents to read to achive this > or any examples would be great to read > > Ram > > On 9/1/06, John Millican <jmillican@sentinelcommunications.com> wrote: > > On Friday September 01 2006 9:27 am, ram wrote: > > > Hi > > > > > > how can i do balance anouncement by using asterisk > > > > > > take example, i have table balance , user name 99999, balance 200$ > > > > > > user dial *98 or what ever, then i need anouce his balance is 200$, by > > > reading from that row > > > > > > any clues how can i achive this or is this possible ? > > > > > > Ram > > > > Create an AGI script that does a db look up for the ballance and then > > pass the > > result back to Cepstral or Festival or your favorite text to speech > > software. > > John M > >Try google or voip-info.org and search for Asterisk AGI should yeid some good results. AGI can be called from the dial plan and written in your favorite language i.e. PHP, C++, Perl, C, Java or start here: http://home.cogeco.ca/~camstuff/agi.html http://asterisk.drunkcoder.com/agi.cgi John M
Hi iam trying like this in my extension.conf some one refered in the news group past error in messages Sep 1 21:31:42 WARNING[28610] file.c: File Goodbye does not exist in any format Sep 1 21:31:42 WARNING[28610] file.c: Unable to open Goodbye (format ulaw): No such file or directory Sep 1 21:31:42 WARNING[28610] app_playback.c: ast_streamfile failed on SIP/88888-3ca6 for Goodbye exten => 888,1,Read(${CALLERIDNUM}) exten => 888,2,MYSQL(Connect connid 127.0.0.1 root password mydatabase) exten => 888,3,MYSQL(Query resultid ${connid} select total from balance where username=${CALLERIDNUM}) exten => 888,4,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE) exten => 888,5,MYSQL(Clear ${resultid}) exten => 888,6,Playback(Goodbye) exten => 888,7,Hangup iam calling from my extension to 888 Ram On 9/1/06, John Millican <jmillican@sentinelcommunications.com> wrote:> > On Friday September 01 2006 10:19 am, ram wrote: > > Hi > > > > thanks for the quick reply > > > > any documents to read to achive this > > or any examples would be great to read > > > > Ram > > > > On 9/1/06, John Millican <jmillican@sentinelcommunications.com> wrote: > > > On Friday September 01 2006 9:27 am, ram wrote: > > > > Hi > > > > > > > > how can i do balance anouncement by using asterisk > > > > > > > > take example, i have table balance , user name 99999, balance 200$ > > > > > > > > user dial *98 or what ever, then i need anouce his balance is 200$, > by > > > > reading from that row > > > > > > > > any clues how can i achive this or is this possible ? > > > > > > > > Ram > > > > > > Create an AGI script that does a db look up for the ballance and then > > > pass the > > > result back to Cepstral or Festival or your favorite text to speech > > > software. > > > John M > > > > Try google or voip-info.org and search for > Asterisk AGI should yeid some good results. > AGI can be called from the dial plan and written in your favorite language > i.e. PHP, C++, Perl, C, Java > or start here: > http://home.cogeco.ca/~camstuff/agi.html > http://asterisk.drunkcoder.com/agi.cgi > > John M > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060901/d1368d4d/attachment.htm