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

[Steve Totaro]

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