Guest researcher Report post Posted 06/03/2009 05:40 PM Hello everybody Can somebody help me understand why the Say Number Module can not say the digits after the Dbquerry gets a unique record? Here is my script and log. I am on WinXP. Any help will be greatly appreciated. 0603vgm.txt d2p1.vgs Share this post Link to post
SupportTeam Report post Posted 06/03/2009 09:23 PM Trace shows that Database Query module [buyersearch] does retrieve a value from a database, and trace shows the the data retrieved has been stored in $RV[buyersearch_1_1] So in the Say Number module you should be this $RV: $RV[buyersearch_1_1] You are using v5 of VoiceGuide and we would recommend ultimately using v7 and a Dialogic card. 225756.25 0 state [buyersearch] DB Query 225756.25 0 db Jet mode used (To use ODBC mode specify ODBC Connect string) 225756.27 0 rv replace start: [sELECT Mobile FROM d2pcommondata WHERE Fcost=$Rv[bUDGET]] 225756.27 0 rv ns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{F:\VOICE-GUIDE\}[scriptPath]{F:\VOICE-GUIDE}[$RV_STARTTIME]{6/3/2009 10:56:51 PM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[$RV_DNIS]{}[DNIS]{}[Welcome 3 options]{2}[Welcome 3 options_PathTaken]{2}[AREA sq.ft.]{4560}[AREA sq.ft._PathTaken]{*}[bUDGET]{15000000}[bUDGET_PathTaken]{*}[City STD]{020}[City STD_PathTaken]{*}[Mobile]{9420520030}[Mobile_PathTaken]{*} 225756.28 0 rv replace end: [sELECT Mobile FROM d2pcommondata WHERE Fcost=15000000] 225756.28 0 db About to execute a Retrieve type operation [sELECT Mobile FROM d2pcommondata WHERE Fcost=15000000] 225756.30 0 db [buyersearch] row count=1 225756.30 0 rv lg add [buyersearch_RowCount]{1} 225756.31 0 db get RecordsetGetRowsMax 225756.31 0 db get 999 records. (row count=1) 225756.33 0 db update RVs start 225756.33 0 db update RVs cols=1 rows=1 225756.33 0 db test vRetData(0, 0)=9881129783 225756.34 0 db test CStr(vRetData(0, 0))=9881129783 225756.34 0 db about to close dbDbqDatabase 225756.36 0 db going down path [True] 225756.36 0 timer clear 225756.38 0 rv replace start: [$Rv[buyersearch]] 225756.38 0 rv ns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{F:\VOICE-GUIDE\}[scriptPath]{F:\VOICE-GUIDE}[$RV_STARTTIME]{6/3/2009 10:56:51 PM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[$RV_DNIS]{}[DNIS]{}[Welcome 3 options]{2}[Welcome 3 options_PathTaken]{2}[AREA sq.ft.]{4560}[AREA sq.ft._PathTaken]{*}[bUDGET]{15000000}[bUDGET_PathTaken]{*}[City STD]{020}[City STD_PathTaken]{*}[Mobile]{9420520030}[Mobile_PathTaken]{*}[buyersearch_RowCount] {1}[buyersearch_1_1]{9881129783} 225756.39 0 rv replace end: [] 225756.39 0 state [Good bye] Say numbers: [] as Digits Share this post Link to post
SupportTeam Report post Posted 06/03/2009 09:24 PM Trace shows that Database Query module [buyersearch] does retrieve a value from a database, and trace shows the the data retrieved has been stored in $RV[buyersearch_1_1] So in the Say Number module you should be this $RV: $RV[buyersearch_1_1] NB. You are using v5 of VoiceGuide and we would recommend ultimately using v7 and a Dialogic card. 225756.25 0 state [buyersearch] DB Query 225756.25 0 db Jet mode used (To use ODBC mode specify ODBC Connect string) 225756.27 0 rv replace start: [sELECT Mobile FROM d2pcommondata WHERE Fcost=$Rv[bUDGET]] 225756.27 0 rv ns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{F:\VOICE-GUIDE\}[scriptPath]{F:\VOICE-GUIDE}[$RV_STARTTIME]{6/3/2009 10:56:51 PM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[$RV_DNIS]{}[DNIS]{}[Welcome 3 options]{2}[Welcome 3 options_PathTaken]{2}[AREA sq.ft.]{4560}[AREA sq.ft._PathTaken]{*}[bUDGET]{15000000}[bUDGET_PathTaken]{*}[City STD]{020}[City STD_PathTaken]{*}[Mobile]{9420520030}[Mobile_PathTaken]{*} 225756.28 0 rv replace end: [sELECT Mobile FROM d2pcommondata WHERE Fcost=15000000] 225756.28 0 db About to execute a Retrieve type operation [sELECT Mobile FROM d2pcommondata WHERE Fcost=15000000] 225756.30 0 db [buyersearch] row count=1 225756.30 0 rv lg add [buyersearch_RowCount]{1} 225756.31 0 db get RecordsetGetRowsMax 225756.31 0 db get 999 records. (row count=1) 225756.33 0 db update RVs start 225756.33 0 db update RVs cols=1 rows=1 225756.33 0 db test vRetData(0, 0)=9881129783 225756.34 0 db test CStr(vRetData(0, 0))=9881129783 225756.34 0 db about to close dbDbqDatabase 225756.36 0 db going down path [True] 225756.36 0 timer clear 225756.38 0 rv replace start: [$Rv[buyersearch]] 225756.38 0 rv ns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{F:\VOICE-GUIDE\}[scriptPath]{F:\VOICE-GUIDE}[$RV_STARTTIME]{6/3/2009 10:56:51 PM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[$RV_DNIS]{}[DNIS]{}[Welcome 3 options]{2}[Welcome 3 options_PathTaken]{2}[AREA sq.ft.]{4560}[AREA sq.ft._PathTaken]{*}[bUDGET]{15000000}[bUDGET_PathTaken]{*}[City STD]{020}[City STD_PathTaken]{*}[Mobile]{9420520030}[Mobile_PathTaken]{*}[buyersearch_RowCount] {1}[buyersearch_1_1]{9881129783} 225756.39 0 rv replace end: [] 225756.39 0 state [Good bye] Say numbers: [] as Digits Share this post Link to post
Guest researcher Report post Posted 06/04/2009 01:06 AM It still did not read out the number. Here is that part of log Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{F:\VOICE-GUIDE\}[scriptPath]{F:\VOICE-GUIDE}[$RV_STARTTIME]{6/4/2009 6:31:41 AM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[$RV_DNIS]{}[DNIS]{}[Welcome 3 options]{2}[Welcome 3 options_PathTaken]{2}[AREA sq.ft.]{4500}[AREA sq.ft._PathTaken]{*}[bUDGET]{15000000}[bUDGET_PathTaken]{*}[City STD]{020}[City STD_PathTaken]{*}[Mobile]{9420074455}[Mobile_PathTaken]{*}[buyersearch_RowCount] {1}[buyersearch_1_1]{9881129783} 063252.95 0 rv replace end: [] 063252.95 0 state [Good bye] Say numbers: [] as Digits Share this post Link to post
Guest researcher Report post Posted 06/04/2009 01:18 AM Now it can perform the replace end properly but says Error playing file 0604vgm.txt Share this post Link to post
Guest researcher Report post Posted 06/04/2009 01:40 AM Surprisingly it works without me changing anything at all . Thanks Share this post Link to post
SupportTeam Report post Posted 06/04/2009 01:41 AM One of the sound files is in the incorrect format and the modem's Wave drivers cannot play it. Have a look at your sound file: G:\Buddhist Chants\gelug_chant.wav and make sure it is in right format. See: http://www.voiceguide.com/vghelp/source/html/soundfiles.htm 064347.44 0 state [Good bye] Say numbers: [9881129783] as Digits 064347.44 0 fn PlaySoundStartNumbers [G:\Buddhist Chants\gelug_chant.wav],[C:\Program Files\VoiceGuide\system\voice\VmSendSuccess.wav],[9881129783],Digits 064347.44 0 sVbsFunctionToUse=Digits 064347.53 0 Started SayNumber VBScript OK. (C:\Program Files\VoiceGuide\temp\vbs_0_SayNumber.vbs) 064347.59 0 cl Play_Start G:\Buddhist Chants\gelug_chant.wav,9.wav,8.wav,8.wav,1.wav,1.wav,2.wav,9.wav,7.wav,8.wav,3.wav ,C:\Program Files\VoiceGuide\system\voice\VmSendSuccess.wav 064347.61 0 play set playid=407187 064347.63 0 PlaySoundStart err=[0 play PlaySoundStart ResetWavOutAndContinuePlay=>32,play pss EnsureWaveOutIsOpenAndReady=>play waveOutOpen mapped failed WAVERR_BADFORMAT] [G:\Buddhist Chants\gelug_chant.wav,C:\Program Files\VoiceGuide\system\voice\9.wav,C:\Program Files\VoiceGuide\system\voice\8.wav,C:\Program Files\VoiceGuide\system\voice\8.wav,C:\Program Files\VoiceGuide\system\voice\1.wav,C:\Program Files\VoiceGuide\system\voice\1.wav,C:\Program Files\VoiceGuide\system\voice\2.wav,C:\Program Files\VoiceGuide\system\voice\9.wav,C:\Program Files\VoiceGuide\system\voice\7.wav,C:\Program Files\VoiceGuide\system\voice\8.wav,C:\Program Files\VoiceGuide\system\voice\3.wav,C:\Program Files\VoiceGuide\system\voice\VmSendSuccess.wav] 064347.63 0 path {WAVERR_BADFORMAT} not found Share this post Link to post