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
[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. > > RamIt 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
[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
[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
[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
[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
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
[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
[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
[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
[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
[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 >