thr3ads.net - asterisk users - [asterisk-users] IVR not able to Play the Balance.. need some help here [Sep 2006]

If this information is useful, please help other people find it:
Share via:

ram

2006-Sep-13 03:53 UTC

[asterisk-users] IVR not able to Play the Balance.. need some help here

Hi

as i have posted before iam trying to integrate IVR with Balance

exten => 888,1,Read(${CALLERIDNUM})
exten => 888,2,MYSQL(Connect connid 127.0.0.1 root password database)
exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\ from\ balance\
where\ username=${CALLERIDNUM})
exten => 888,4,Wait(1)
exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
exten => 888,6,Playback(card-balance-is ${AMOUNT-DUE})
exten => 888,7,MYSQL(Clear ${resultid})
exten => 888,8,MYSQL(Disconnect ${connid})


I have added in the extension.conf above config

when i dial from X-lite ( my users ID 88888) to  888, its going to Asterisk

after some time it hangs up automatically

when i see the log, its getting the balance "17" in my case
but its not able to play that value

so i have added the GSM file before the Amount Value.

Sep 13 16:18:50 WARNING[3647]: file.c:512 ast_openstream_full: File
card-balance-is 17 does not exist in any format
Sep 13 16:18:50 WARNING[3647]: file.c:824 ast_streamfile: Unable to open
card-balance-is 17 (format gsm): No such file or directory
Sep 13 16:18:50 WARNING[3647]: app_playback.c:132 playback_exec:
ast_streamfile failed on SIP/88888-b7a4 for card-balance-is 17


can some one help me to resolve this problem
i feel some where iam doing mistake.

Ram
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060913/aae6e173/attachment.htm

Steve Totaro

2006-Sep-13 04:08 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

ram wrote:> Hi
>  
> as i have posted before iam trying to integrate IVR with Balance
>  
> exten => 888,1,Read(${CALLERIDNUM})
> exten => 888,2,MYSQL(Connect connid 127.0.0.1 <http://127.0.0.1> 
> root password database)
> exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\ from\ 
> balance\ where\ username=${CALLERIDNUM})
> exten => 888,4,Wait(1)
> exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
> exten => 888,6,Playback(card-balance-is ${AMOUNT-DUE})
> exten => 888,7,MYSQL(Clear ${resultid})
> exten => 888,8,MYSQL(Disconnect ${connid})
>  
>  
> I have added in the extension.conf above config
>  
> when i dial from X-lite ( my users ID 88888) to  888, its going to 
> Asterisk
>  
> after some time it hangs up automatically
>  
> when i see the log, its getting the balance "17" in my case
> but its not able to play that value
>  
> so i have added the GSM file before the Amount Value.
>  
> Sep 13 16:18:50 WARNING[3647]: file.c:512 ast_openstream_full: File 
> card-balance-is 17 does not exist in any format
> Sep 13 16:18:50 WARNING[3647]: file.c:824 ast_streamfile: Unable to 
> open card-balance-is 17 (format gsm): No such file or directory
> Sep 13 16:18:50 WARNING[3647]: app_playback.c:132 playback_exec: 
> ast_streamfile failed on SIP/88888-b7a4 for card-balance-is 17
>  
>  
> can some one help me to resolve this problem
> i feel some where iam doing mistake.
>  
> Ram
It looks like asterisk is looking for a filename "card-balance-is 17" 
I
trust you want it to play two files one called "card-balance is" and 
then the number "17".

maybe:
exten => 888,6,Playback(card-balance-is)
exten => 888,7,Playback(${AMOUNT-DUE})

So that asterisk plays two different files.  You may have to put a 
slight wait between six and seven so it sounds good.

Thanks,
Steve

ram

2006-Sep-13 06:17 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

Hi

thanks for the quick reply

yes as suggested i did the Following modification

exten => 888,1,Read(${CALLERIDNUM})
exten => 888,2,MYSQL(Connect connid 127.0.0.1 root password database)
exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\ from\ balance\
where\ username=${CALLERIDNUM})
exten => 888,4,Wait(1)
exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
exten => 888,6,Playback(card-balance-is)
exten => 888,7,Wait(2)
exten => 888,8,Playback(${AMOUNT-DUE})
exten => 888,9,MYSQL(Clear ${resultid})
exten => 888,10,MYSQL(Disconnect ${connid})

when i dial 888, i get sound card balance is,then after few seconds hangup.

and i see in debug the following error

Sep 13 18:46:59 WARNING[3907]: file.c:512 ast_openstream_full: File 17 does
not exist in any format
Sep 13 18:46:59 WARNING[3907]: file.c:824 ast_streamfile: Unable to open 17
(format gsm): No such file or directory


how to play the results

can some one help me in this regard

Ram
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060913/e98b9a21/attachment.htm

Doug Lytle

2006-Sep-13 06:39 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some

ram wrote:>
> exten => 888,8,Playback(${AMOUNT-DUE})
Change this from Playback to SayNumber

http://www.voip-info.org/wiki/index.php?page=Asterisk+cmd+SayNumber

Doug


-- 
 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."

bails

2006-Sep-13 06:41 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

> exten => 888,8,SayDigits(${AMOUNT-DUE})
B

ram wrote:> Hi
>  
> thanks for the quick reply
>  
> yes as suggested i did the Following modification
>  
> exten => 888,1,Read(${CALLERIDNUM})
> exten => 888,2,MYSQL(Connect connid 127.0.0.1 <http://127.0.0.1>
root
> password database)
> exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\ from\ 
> balance\ where\ username=${CALLERIDNUM})
> exten => 888,4,Wait(1)
> exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
> exten => 888,6,Playback(card-balance-is)
> exten => 888,7,Wait(2)
> exten => 888,8,Playback(${AMOUNT-DUE})
> exten => 888,9,MYSQL(Clear ${resultid})
> exten => 888,10,MYSQL(Disconnect ${connid})
>  
> when i dial 888, i get sound card balance is,then after few seconds hangup.
>  
> and i see in debug the following error
>  
> Sep 13 18:46:59 WARNING[3907]: file.c:512 ast_openstream_full: File 17 
> does not exist in any format
> Sep 13 18:46:59 WARNING[3907]: file.c:824 ast_streamfile: Unable to open 
> 17 (format gsm): No such file or directory
> 
>  
> how to play the results
>  
> can some one help me in this regard
>  
> Ram
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> --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

ram

2006-Sep-13 06:52 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

Hi bails

thanks for the reply

just now i have changed to the same and replying to list
your mail came with the same answer
thanks for the help

after anouncing mysql connection will be closed right ?

Ram
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060913/c2b4414d/attachment.htm

ram

2006-Sep-13 06:53 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some

Hi

thanks i have rectified the problem

ram


On 9/13/06, Doug Lytle <support@drdos.info> wrote:>
> ram wrote:
> >
> > exten => 888,8,Playback(${AMOUNT-DUE})
>
> Change this from Playback to SayNumber
>
> http://www.voip-info.org/wiki/index.php?page=Asterisk+cmd+SayNumber
>
> Doug
>
>
> --
>
> Ben Franklin quote:
>
> "Those who would give up Essential Liberty to purchase a little
Temporary
> Safety, deserve neither Liberty nor Safety."
>
>
> _______________________________________________
> --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/20060913/f6186752/attachment.htm

Steve Totaro

2006-Sep-13 06:56 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

ram wrote:> Hi
>  
> thanks for the quick reply
>  
> yes as suggested i did the Following modification
>  
> exten => 888,1,Read(${CALLERIDNUM})
> exten => 888,2,MYSQL(Connect connid 127.0.0.1 <http://127.0.0.1>
root
> password database)
> exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\ from\ 
> balance\ where\ username=${CALLERIDNUM})
> exten => 888,4,Wait(1)
> exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
> exten => 888,6,Playback(card-balance-is)
> exten => 888,7,Wait(2)
> exten => 888,8,Playback(${AMOUNT-DUE})
> exten => 888,9,MYSQL(Clear ${resultid})
> exten => 888,10,MYSQL(Disconnect ${connid})
>  
> when i dial 888, i get sound card balance is,then after few seconds 
> hangup.
>  
> and i see in debug the following error
>  
> Sep 13 18:46:59 WARNING[3907]: file.c:512 ast_openstream_full: File 17 
> does not exist in any format
> Sep 13 18:46:59 WARNING[3907]: file.c:824 ast_streamfile: Unable to 
> open 17 (format gsm): No such file or directory
>
>  
> how to play the results
>  
> can some one help me in this regard
>  
> RamMaybe if you copy 17.gsm from /sounds/digits to /sounds it might work or 
put the path in the playback priority 8.

Thanks,
Steve Totaro

ram

2006-Sep-13 07:09 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

Hi all

Same like reading  Numbers
how can read words

since i dont see India Currency anouncing ( i see Dollars)
i want to anounce after 17 then Rupees

how can i achive this

Ram


On 9/13/06, bails <bails@westcomuk.com> wrote:>
> > exten => 888,8,SayDigits(${AMOUNT-DUE})
>
> B
>
> ram wrote:
> > Hi
> >
> > thanks for the quick reply
> >
> > yes as suggested i did the Following modification
> >
> > exten => 888,1,Read(${CALLERIDNUM})
> > exten => 888,2,MYSQL(Connect connid 127.0.0.1
<http://127.0.0.1> root
> > password database)
> > exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\ from\
> > balance\ where\ username=${CALLERIDNUM})
> > exten => 888,4,Wait(1)
> > exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
> > exten => 888,6,Playback(card-balance-is)
> > exten => 888,7,Wait(2)
> > exten => 888,8,Playback(${AMOUNT-DUE})
> > exten => 888,9,MYSQL(Clear ${resultid})
> > exten => 888,10,MYSQL(Disconnect ${connid})
> >
> > when i dial 888, i get sound card balance is,then after few seconds
> hangup.
> >
> > and i see in debug the following error
> >
> > Sep 13 18:46:59 WARNING[3907]: file.c:512 ast_openstream_full: File 17
> > does not exist in any format
> > Sep 13 18:46:59 WARNING[3907]: file.c:824 ast_streamfile: Unable to
open
> > 17 (format gsm): No such file or directory
> >
> >
> > how to play the results
> >
> > can some one help me in this regard
> >
> > Ram
> >
> >
> >
------------------------------------------------------------------------
> >
> > _______________________________________________
> > --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
>-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060913/4c4d8da9/attachment.htm

Héctor Maldonado

2006-Sep-13 10:13 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

uh.. maybe recording a gsm file with "rupees" and playing it just
after
SayDigits.. ?



2006/9/13, ram <talk2ram@gmail.com>:>
>  Hi all
>
> Same like reading  Numbers
> how can read words
>
> since i dont see India Currency anouncing ( i see Dollars)
> i want to anounce after 17 then Rupees
>
> how can i achive this
>
> Ram
>
>
>  On 9/13/06, bails <bails@westcomuk.com> wrote:
> >
> > > exten => 888,8,SayDigits(${AMOUNT-DUE})
> >
> > B
> >
> > ram wrote:
> > > Hi
> > >
> > > thanks for the quick reply
> > >
> > > yes as suggested i did the Following modification
> > >
> > > exten => 888,1,Read(${CALLERIDNUM})
> > > exten => 888,2,MYSQL(Connect connid 127.0.0.1 <
http://127.0.0.1> root
> > > password database)
> > > exten => 888,3,MYSQL(Query resultid ${connid} select\ saldo\
from\
> > > balance\ where\ username=${CALLERIDNUM})
> > > exten => 888,4,Wait(1)
> > > exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
> > > exten => 888,6,Playback(card-balance-is)
> > > exten => 888,7,Wait(2)
> > > exten => 888,8,Playback(${AMOUNT-DUE})
> > > exten => 888,9,MYSQL(Clear ${resultid})
> > > exten => 888,10,MYSQL(Disconnect ${connid})
> > >
> > > when i dial 888, i get sound card balance is,then after few
seconds
> > hangup.
> > >
> > > and i see in debug the following error
> > >
> > > Sep 13 18:46:59 WARNING[3907]: file.c:512 ast_openstream_full:
File 17
> > > does not exist in any format
> > > Sep 13 18:46:59 WARNING[3907]: file.c:824 ast_streamfile: Unable
to
> > open
> > > 17 (format gsm): No such file or directory
> > >
> > >
> > > how to play the results
> > >
> > > can some one help me in this regard
> > >
> > > Ram
> > >
> > >
> > >
> >
------------------------------------------------------------------------
> > >
> > > _______________________________________________
> > > --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
> >
>
>
> _______________________________________________
> --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/20060913/96a627a7/attachment.htm

ram

2006-Sep-13 10:21 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

Hi

is this possible to read words like digits  in asterisk

Ram


On 9/13/06, H?ctor Maldonado <hamaldonado@gmail.com>
wrote:>
> uh.. maybe recording a gsm file with "rupees" and playing it just
after
> SayDigits.. ?
>
>
>
> 2006/9/13, ram <talk2ram@gmail.com>:
> >
> >  Hi all
> >
> > Same like reading  Numbers
> > how can read words
> >
> > since i dont see India Currency anouncing ( i see Dollars)
> > i want to anounce after 17 then Rupees
> >
> > how can i achive this
> >
> > Ram
> >
> >
> >  On 9/13/06, bails <bails@westcomuk.com> wrote:
> > >
> > > > exten => 888,8,SayDigits(${AMOUNT-DUE})
> > >
> > > B
> > >
> > > ram wrote:
> > > > Hi
> > > >
> > > > thanks for the quick reply
> > > >
> > > > yes as suggested i did the Following modification
> > > >
> > > > exten => 888,1,Read(${CALLERIDNUM})
> > > > exten => 888,2,MYSQL(Connect connid 127.0.0.1 <
http://127.0.0.1>
> > > root
> > > > password database)
> > > > exten => 888,3,MYSQL(Query resultid ${connid} select\
saldo\ from\
> > > > balance\ where\ username=${CALLERIDNUM})
> > > > exten => 888,4,Wait(1)
> > > > exten => 888,5,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
> > > > exten => 888,6,Playback(card-balance-is)
> > > > exten => 888,7,Wait(2)
> > > > exten => 888,8,Playback(${AMOUNT-DUE})
> > > > exten => 888,9,MYSQL(Clear ${resultid})
> > > > exten => 888,10,MYSQL(Disconnect ${connid})
> > > >
> > > > when i dial 888, i get sound card balance is,then after few
seconds
> > > hangup.
> > > >
> > > > and i see in debug the following error
> > > >
> > > > Sep 13 18:46:59 WARNING[3907]: file.c:512
ast_openstream_full: File
> > > 17
> > > > does not exist in any format
> > > > Sep 13 18:46:59 WARNING[3907]: file.c :824 ast_streamfile:
Unable to
> > > open
> > > > 17 (format gsm): No such file or directory
> > > >
> > > >
> > > > how to play the results
> > > >
> > > > can some one help me in this regard
> > > >
> > > > Ram
> > > >
> > > >
> > > >
> > >
------------------------------------------------------------------------
> > > >
> > > > _______________________________________________
> > > > --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
> > >
> >
> >
> > _______________________________________________
> > --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/20060913/91c27fb7/attachment.htm

Steve Totaro

2006-Sep-13 10:44 UTC

head link

[asterisk-users] IVR not able to Play the Balance.. need some helphere

I think what matters is what directory the file resides in.  They are 
all wav or gsm.

ram wrote:> Hi
>  
> is this possible to read words like digits  in asterisk
>  
> Ram
>
>  
> On 9/13/06, *H?ctor Maldonado* <hamaldonado@gmail.com 
> <mailto:hamaldonado@gmail.com>> wrote:
>
>     uh.. maybe recording a gsm file with "rupees" and playing it
just
>     after SayDigits.. ?
>      
>
>      
>     2006/9/13, ram <talk2ram@gmail.com
<mailto:talk2ram@gmail.com>>:
>
>         Hi all
>          
>         Same like reading  Numbers
>         how can read words
>          
>         since i dont see India Currency anouncing ( i see Dollars)
>         i want to anounce after 17 then Rupees
>          
>         how can i achive this
>          
>         Ram
>
>          
>         On 9/13/06, *bails* <bails@westcomuk.com
>         <mailto:bails@westcomuk.com>> wrote:
>
>             > exten => 888,8,SayDigits(${AMOUNT-DUE})
>
>             B
>
>             ram wrote:
>             > Hi
>             >
>             > thanks for the quick reply
>             >
>             > yes as suggested i did the Following modification
>             >
>             > exten => 888,1,Read(${CALLERIDNUM})
>             > exten => 888,2,MYSQL(Connect connid 127.0.0.1
>             <http://127.0.0.1/> < http://127.0.0.1
>             <http://127.0.0.1/>> root
>             > password database)
>             > exten => 888,3,MYSQL(Query resultid ${connid} select\
>             saldo\ from\
>             > balance\ where\ username=${CALLERIDNUM})
>             > exten => 888,4,Wait(1)
>             > exten => 888,5,MYSQL(Fetch fetch ${resultid}
AMOUNT-DUE)
>             > exten => 888,6,Playback(card-balance-is)
>             > exten => 888,7,Wait(2)
>             > exten => 888,8,Playback(${AMOUNT-DUE})
>             > exten => 888,9,MYSQL(Clear ${resultid})
>             > exten => 888,10,MYSQL(Disconnect ${connid})
>             >
>             > when i dial 888, i get sound card balance is,then after
>             few seconds hangup.
>             >
>             > and i see in debug the following error
>             >
>             > Sep 13 18:46:59 WARNING[3907]: file.c:512
>             ast_openstream_full: File 17
>             > does not exist in any format
>             > Sep 13 18:46:59 WARNING[3907]: file.c :824
>             ast_streamfile: Unable to open
>             > 17 (format gsm): No such file or directory
>             >
>             >
>             > how to play the results
>             >
>             > can some one help me in this regard
>             >
>             > Ram
>             >
>
> s
>

asterisk users - Sep 2006 - IVR not able to Play the Balance.. need some help here

[asterisk-users] IVR not able to Play the Balance.. need some help here

[asterisk-users] IVR not able to Play the Balance.. need some helphere

[asterisk-users] IVR not able to Play the Balance.. need some helphere

[asterisk-users] IVR not able to Play the Balance.. need some

[asterisk-users] IVR not able to Play the Balance.. need some helphere

[asterisk-users] IVR not able to Play the Balance.. need some helphere

[asterisk-users] IVR not able to Play the Balance.. need some

[asterisk-users] IVR not able to Play the Balance.. need some helphere

[asterisk-users] IVR not able to Play the Balance.. need some helphere

[asterisk-users] IVR not able to Play the Balance.. need some helphere

[asterisk-users] IVR not able to Play the Balance.. need some helphere

[asterisk-users] IVR not able to Play the Balance.. need some helphere