Re: [asterisk-users] balance anouncement
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 <[EMAIL PROTECTED]> 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:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
] On Behalf Of ramSent: Friday, September 01, 2006 11:06 AMTo:
[EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial DiscussionSubject: 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 formatSep 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/8-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 <
[EMAIL PROTECTED]> 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 <
[EMAIL PROTECTED] > 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 9, 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 forAsterisk 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, Javaor start here:
http://home.cogeco.ca/~camstuff/agi.htmlhttp://asterisk.drunkcoder.com/agi.cgi John M
___--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing listTo UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
___--Bandwidth and Colocation provided by Easynews.com
--asterisk-users mailing listTo UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
--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
RE: [asterisk-users] balance anouncement
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:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of ram
Sent: Friday, September 01, 2006
11:06 AM
To:
[EMAIL PROTECTED]; 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/8-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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]
> 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 9, 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
___
--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
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 formatSep 1 21:31:42 WARNING[28610] file.c: Unable to open Goodbye (format ulaw): No such file or directorySep 1 21:31:42 WARNING[28610] app_playback.c: ast_streamfile failed on SIP/8-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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]
> 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 9, 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 forAsterisk 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, Javaor start here:http://home.cogeco.ca/~camstuff/agi.htmlhttp://asterisk.drunkcoder.com/agi.cgi
John M___--Bandwidth and Colocation provided by Easynews.com --asterisk-users mailing listTo UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
--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
Re: [asterisk-users] balance anouncement
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 <[EMAIL PROTECTED]> 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 9, 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
Re: [asterisk-users] balance anouncement
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 <[EMAIL PROTECTED]> 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 9, 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 theresult back to Cepstral or Festival or your favorite text to speech software.John M___ --Bandwidth and Colocation provided by Easynews.com --asterisk-users mailing listTo UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --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
Re: [asterisk-users] balance anouncement
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 9, 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
