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