[asterisk-users] balance anouncement

[ram]

Hi

the intention of writing that line in to extension.conf to read my balance
when iam dialing 888, read caller id get balance from the table

how can i achive this

is this not possible calling from extension directly than writing some small
agi code, as people recomended before

Ram


On 9/1/06, Kevin Savoy <ksavoy at novo1.com> wrote:
>
>   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.
>
>
>  ------------------------------
>
> *From:* asterisk-users-bounces at lists.digium.com [mailto:
> asterisk-users-bounces at lists.digium.com] *On Behalf Of *ram
> *Sent:* Friday, September 01, 2006 11:06 AM
> *To:* jmillican at sentinelcommunications.com; Asterisk Users Mailing List -
> Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] balance anouncement
>
>
>
> 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 at 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 at 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 <http://easynews.com/>--
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com <http://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/30320322/attachment.htm