Excel Query & Playing TTS Through Pc Speaker

08/10/2004 09:49 PM

I have a Excel spreadsheet with a list of jobsites and start times.

And I am trying to create a script that will query the spreadsheet and read the work schedule to the employees when they call in and enter the last 4 digits of their social security number.

I have created a sample script to see how well it would work. As soon as I enter some numbers the script hangs up. I have included the event trace log from when I tried it.

Also, when I originally installed voiceguide the tts worked fine, but now when I type in the tts box in the play module the voice plays through my computer speaker and over the phone I get the message that there is a problem with the format, and when I load a text file in the play file box I get the same message but nothing plays through my computer speaker.

Wave files still play fine.

Thanks in advance

Ed

08/11/2004 09:27 AM

As soon as I enter some numbers the script hangs up. I have included the event trace log from when I tried it.

No trace was attached - please post/attach it again.

voice plays through my computer speaker

Sounds like the cards Wave drivers were not correctly installed - can you

try removing all the wave drives on your system (including any sound card drivers) and then re-installing the wave drivers for your telephony device first, and then installing the TTS.

To remove other wave drivers got to Control Panel, double clock on System, select the Device Manager tab and go to Sound/Video/Game Controllers entry - then delete all other wave drivers.

You may have to disable the sound card altogether as well to stop Windows from automatically loading it's drivers - to do this just select "Disable" and then select "Uninstall" from the Device Manager.

08/11/2004 05:17 PM

172518.38 0 callstate OFFERING 66306 0 4
172518.39 0 Answer the call at 8/10/2004 5:25:18 PM

172518.41 0 lineAnswer(66306) => 66289

172518.47 0 ring 1

172518.50 0 callstate ACCEPTED 66306 0 0

172519.95 0 Lev_CallerID [p,TR TRUCKING]

172520.08 0 Lev_CallerID [p,TR TRUCKING]

172521.41 0 tapi Reply (LineEvReply) ok 66289 0

172521.55 0 callstate CONNECTED 66306,0,0

172521.56 0 WorkingModeTAPI@Connected=

172521.58 0 WorkingModeScript@Connected=

172521.61 0 Inband detection not enabled

172521.64 0 StartLoadedVgs at 8/10/2004 5:25:21 PM

172521.66 0 AddRVns [scriptsPath]{C:\Documents and Settings\All Users\Documents\VoiceGuide\Scripts\}

172521.67 0 rv add [$RV_STARTTIME]{8/10/2004 5:25:21 PM}

172521.69 0 rv add [$RV_DEVICEID]{0}

172521.72 0 rv add [$RV_CIDNAME]{TR TRUCKING}

172521.73 0 AddRVns [PathApp]{C:\Documents and Settings\All Users\Documents\VoiceGuide\}

172521.75 0 rv add [$RV_CIDNUMBER]{7247224434}

172521.78 0 TimeoutClear

172521.80 0 [Get PIN] Number Input

172521.83 0 [Get PIN] Playing (Enter PIN.wav)

172522.27 0 PlaySoundStart ok [Enter PIN.wav]

172522.30 0 TimeoutClear

172522.34 0 wa(2996,27054600)

172524.67 0 dtmf 1 (66306,49,2)

172524.69 0 ScriptEventCode 49 iLineState=1300

172524.72 0 LsGetNbrsPlayWelcMsg 1

172525.22 0 PlaySoundStop err=0

172525.23 0 [Get PIN] Number Input 1

172525.27 0 path {1} not found

172525.28 0 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

172525.48 0 dtmf 3 (66306,51,2)

172525.52 0 ScriptEventCode 51 iLineState=1301

172525.53 0 LsGetNbrsRxDigits 3

172525.55 0 [Get PIN] Number Input 13

172525.58 0 path {13} not found

172525.59 0 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

172525.70 0 dtmf 8 (66306,56,2)

172525.72 0 ScriptEventCode 56 iLineState=1301

172525.73 0 LsGetNbrsRxDigits 8

172525.77 0 [Get PIN] Number Input 138

172525.78 0 path {138} not found

172525.81 0 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

172525.83 0 TimeoutClear

172525.84 0 rv add [Get PIN]{138}

172525.88 0 path {138} not found

172525.89 0 AddRVns [Get PIN_PathTaken]{success}

172525.91 0 TimeoutClear

172525.94 0 [Database Query] DB Query

172525.95 0 db Jet mode used (To use ODBC mode specify ODBC Connect string)

172525.98 0 ERROR 5.2.2000 OpenDatabase [3170:Could not find installable ISAM.]

172526.00 0 rv add [Hangup Time]{8/10/2004 5:25:26 PM}

172526.02 0 Hanging up call... [srlib 282]

172526.09 0 RecSoundStop ok

172526.17 0 PlaySoundStop err=0

172526.19 0 TimeoutSet 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

172526.27 0 fnHangupCall end

172526.58 0 callstate DISCONNECTED 66306,1,0

172526.59 0 ScriptEventCode 9250 iLineState=900

172526.61 0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT

172526.64 0 rv add [Hangup Time]{8/10/2004 5:25:26 PM}

172526.66 0 Hanging up call...

172526.73 0 RecSoundStop ok

172526.80 0 PlaySoundStop err=0

172526.81 0 TimeoutSet 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

172526.89 0 fnHangupCall end

172526.92 0 callstate IDLE 66306 0 0

172526.94 0 WorkingMode@Idle=

172526.97 0 TimeoutClear

172527.00 0 TimeoutSet 1 EV_TIMEOUT_TIMETOREINITLINE

172527.05 0 tapi Reply (LineEvReply) ok 66254 0

172527.08 0 tapi Reply (LineEvReply) ok 66271 0

172528.08 0 Timer fired EV_TIMEOUT_TIMETOREINITLINE

172528.09 0 ScriptEventCode 9008 iLineState=900

172528.11 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

172528.14 0 ReinitTelephony due to IDLE

172528.16 0 tapic lineDeallocateCall(MainCall:66306) 0

172529.03 0 lineOpen(0)=>

172529.05 0 Waiting for a call...

172529.06 0 LineHandle=66323

172529.11 0 TimeoutSet 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT

172532.50 0 Timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT

172532.52 0 ScriptEventCode 9013 iLineState=900

172532.83 0 sys cleanup Start

172532.84 0 sys cleanup End

here is the trace log.

I will try re-installing the drivers.

I did re-install the drivers before, but then I had to format my pc.

I thought it might be something different this time, since it only does it with TTS.

Before it also played the wave files through the pc speaker.

Thanks

Ed

08/12/2004 09:01 PM

172525.98 0 ERROR 5.2.2000 OpenDatabase [3170:Could not find installable ISAM.]

It looks like the Microsoft's Data Access Drivers are not installed on this system.

Please see "MDAC Downloads" on this page: http://msdn.microsoft.com/data/default.aspx

08/17/2004 08:00 PM

I tried that and still no luck.

I will try uninstalling microsoft office and reinstalling everything.

Ed

08/17/2004 10:01 PM

Please post the script that you are using (or a script snippet that demonstrates the problem)

08/21/2004 10:04 PM

Here is my sample script.

Ed

Excel_Schedule.vgs

08/21/2004 11:31 PM

I see that in the module you have specified the 'Connect String' to be:

Excel 97-2000

Why are you using this as a Connect String ?

Please try using either;

Excel 5.0;

or

Excel 8.0;

as per examples provided in the Help file: http://www.voiceguide.com/vghelp/html/modDbQuery.htm

08/23/2004 05:05 PM

Thanks no wonder it wasn't working,

I keep getting:

125620.94 0 dial start any summary:|0:dok=0|

125621.94 0 dial start any summary:|0:dok=0|

125622.94 0 dial start any summary:|0:dok=0|

125623.94 0 dial start any summary:|0:dok=0|

125624.94 0 dial start any summary:|0:dok=0|

125625.94 0 dial start any summary:|0:dok=0|

on the trace log no matter which script I use.

Ed

08/23/2004 05:47 PM

134106.59 0 dial start any summary:|0:dok=0|
134107.59 0 dial start any summary:|0:dok=0|

134108.59 0 dial start any summary:|0:dok=0|

134108.84 0 callstate OFFERING 66441 0 4

134108.84 0 Answer the call at 8/23/2004 1:41:08 PM

134108.84 0 lineAnswer(66441) => 66458

134108.91 0 ring 1

134108.92 0 callstate ACCEPTED 66441 0 0

134110.59 0 Lev_CallerID [7247224434,TR TRUCKING,]

134110.70 0 Lev_CallerID [7247224434,TR TRUCKING,]

134111.89 0 tapi Reply (LineEvReply) ok 66458 0

134112.02 0 callstate CONNECTED 66441 0 0

134112.02 0 callstate CONNECTED 66441,0,0

134112.03 0 WorkingModeTAPI@Connected=

134112.03 0 WorkingModeScript@Connected=

134112.06 0 Inband detection not enabled

134112.08 0 StartLoadedVgs at 8/23/2004 1:41:12 PM

134112.08 0 AddRVns [scriptsPath]{C:\Documents and Settings\All Users\Documents\Scripts\}

134112.09 0 AddRVns [scriptPath]{C:\Documents and Settings\All Users\Documents\Scripts}

134112.11 0 rv add [$RV_STARTTIME]{8/23/2004 1:41:12 PM}

134112.11 0 rv add [$RV_DEVICEID]{0}

134112.13 0 rv add [$RV_CIDNAME]{TR TRUCKING}

134112.14 0 AddRVns [PathApp]{C:\Documents and Settings\All Users\Documents\VoiceGuide\}

134112.14 0 rv add [$RV_CIDNUMBER]{7247224434}

134112.16 0 timer clear

134112.17 0 [Get PIN] Number Input

134112.17 0 [Get PIN] Playing (Enter PIN.wav)

134112.19 0 play set playid=506765

134112.63 0 PlaySoundStart ok [Enter PIN.wav]

134112.64 0 timer clear

134112.69 0 wa(2996,50676500)

134114.05 0 dtmf 1 (66441,49,2)

134114.06 0 ScriptEventCode 49 iLineState=1300

134114.06 0 LsGetNbrsPlayWelcMsg 1

134114.64 0 PlaySoundStop err=0

134114.66 0 [Get PIN] Number Input 1

134114.67 0 path {1} not found

134114.67 0 timer set 6 EV_TIMEOUT_ENTERDATA

134114.88 0 dtmf 4 (66441,52,2)

134114.88 0 ScriptEventCode 52 iLineState=1301

134114.89 0 LsGetNbrsRxDigits 4

134114.91 0 [Get PIN] Number Input 14

134114.92 0 path {14} not found

134114.92 0 timer set 6 EV_TIMEOUT_ENTERDATA

134115.59 0 dtmf 5 (66441,53,2)

134115.61 0 ScriptEventCode 53 iLineState=1301

134115.61 0 LsGetNbrsRxDigits 5

134115.63 0 [Get PIN] Number Input 145

134115.64 0 path {145} not found

134115.64 0 timer set 6 EV_TIMEOUT_ENTERDATA

134115.66 0 timer clear

134115.67 0 rv add [Get PIN]{145}

134115.67 0 path {145} not found

134115.69 0 AddRVns [Get PIN_PathTaken]{success}

134115.70 0 timer clear

134115.72 0 [Database Query] DB Query

134115.72 0 db Jet mode used (To use ODBC mode specify ODBC Connect string)

134115.73 0 rv replace start: [sheet1$A$RV[Get PIN]:I$RV[Get PIN]]

134115.75 0 rv ns [PathSysVoice]{C:\Documents and Settings\All Users\Documents\VoiceGuide\system\voice\}[PathApp]{C:\Documents and Settings\All Users\Documents\VoiceGuide\}[PathDataVm]{C:\Documents and Settings\All Users\Documents\VoiceGuide\data\}[PathVgSys]{C:\Documents and Settings\All Users\Documents\VoiceGuide\system\}[scriptsPath]{C:\Documents and Settings\All Users\Documents\Scripts\}[scriptPath]{C:\Documents and Settings\All Users\Documents\Scripts}[$RV_STARTTIME]{8/23/2004 1:41:12 PM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{TR TRUCKING}[PathApp]{C:\Documents and Settings\All Users\Documents\VoiceGuide\}[$RV_CIDNUMBER]{7247224434}[Get PIN]{145}[Get PIN_PathTaken]{success}

134115.77 0 rv replace end: [sheet1$A145:I145]

134115.78 0 db About to execute a Retrieve type operation [sheet1$A145:I145]

134115.78 0 db [Database Query] no records found.

134115.81 0 rv add [Hangup Time]{8/23/2004 1:41:15 PM}

134115.81 0 Hanging up call... [srlib 282]

134115.88 0 RecSoundStop ok

134115.95 0 PlaySoundStop err=0

134115.95 0 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

134116.03 0 fnHangupCall end

134116.34 0 callstate DISCONNECTED 66441 1 0

134116.36 0 ScriptEventCode 9250 iLineState=900

134116.36 0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT

134116.38 0 rv add [Hangup Time]{8/23/2004 1:41:16 PM}

134116.39 0 Hanging up call...

134116.45 0 RecSoundStop ok

134116.50 0 PlaySoundStop err=0

134116.52 0 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

134116.58 0 fnHangupCall end

134116.61 0 callstate IDLE 66441 0 0

134116.63 0 WorkingMode@Idle=

134116.63 0 timer clear

134116.67 0 timer set 1 EV_TIMEOUT_TIMETOREINITLINE

134116.70 0 tapi Reply (LineEvReply) ok 66083 0

134116.72 0 tapi Reply (LineEvReply) ok 66100 0

134117.72 0 timer fired EV_TIMEOUT_TIMETOREINITLINE

134117.72 0 ScriptEventCode 9008 iLineState=900

134117.73 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

134117.75 0 ReinitTelephony due to IDLE

134117.77 0 tapic lineDeallocateCall(MainCall:66441) 0

134118.64 0 lineOpen(0)=>

134118.66 0 Waiting for a call...

134118.66 0 LineHandle=66475

134118.69 0 timer set 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT

134118.70 0 dial start any summary:|0:rdy=0|

134119.72 0 dial start any summary:|0:rdy=0|

134120.72 0 dial start any summary:|0:rdy=0|

134121.72 0 dial start any summary:|0:rdy=0|

134121.98 0 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT

134121.98 0 ScriptEventCode 9013 iLineState=900

134122.72 0 dial start any summary:|0:dok=0|

134123.72 0 dial start any summary:|0:dok=0|

134124.73 0 dial start any summary:|0:dok=0|

134125.73 0 dial start any summary:|0:dok=0|

134126.75 0 dial start any summary:|0:dok=0|

Thanks now it looks like it is working,

but I get no records found and the cells are not blank.

Ed

08/23/2004 09:38 PM

Please post the Excel spreadsheet along with the script which demonstrates the problem and we'll run it on our test system here to try to reproduce the problem you are having.

08/23/2004 10:04 PM

Here is the script

Excel_Schedule.vgs

08/23/2004 10:07 PM

And the spreadsheet

Copy_of_8_6_04sched.zip

08/24/2004 01:04 AM

The Excel spreadsheet that you are using has some unusual settings in it (eg: why can’t we scroll up above row 120?). Maybe this is related to why Excel is refusing to return the data from the spreadsheet back to the calling program.

The sample supplied with VoiceGuide that shows how to retrieve roster data from Excel works - I'd recommend you have a look at it - it's in VoiceGuide's \Scripts\Customer Enquiry\ subdirectory.

I'd recommend you just place the data in a standard Excel spreadsheet - like in the provided VG sample.

08/24/2004 04:53 PM

I set all the rows from 1-120 to be hidden, because I wanted to have it so that anyone who calls in has to enter a 3 digit number 120-? etc...

I will try modifying the sample script.

Thats what I originally tried to do but it didn't work out, but now I know what I was doing wrong before. So it should work now.

Thanks

Ed

08/24/2004 08:30 PM

Even with the customer Enquiry script all I get is

"134115.78 0 db [Database Query] no records found." then it hangs up.

unless I put 0 in for roster number, then it goes through the say numbers modules but doesn't speak anything.

Ed

08/28/2004 10:35 PM

I think that there may have been so confusion here as the Customer Enquiry demo script only works if specific keys are pressed by caller (see the script and what is in Excels sheet to determine what caller should be pressing to get it to work..)

Here is a 'hard wired' demo that does not need you to input anything.

Please run this demo script and you will see it query the Excel sheet and then speak data from within it.

Excel_Test.zip

09/01/2004 11:46 PM

I tried the excel demo script, and it works fine,

but if I change the speak numbers module to play sound and set it up to speak the cells and I put text in the cells it will not speak anything. If there are numbers in the cells it will still speak with my seech settings.

Ed

09/02/2004 07:41 AM

Please post the VG script and Excel file you are using and the trace from VG when you attempt to do what you describe.

09/03/2004 07:37 PM

If I change cell B3 to text it will not read it. It just skips it.

Ed

Excel_Test1.zip

09/06/2004 10:16 PM

Please try using this in the 'Connect String' text field of the Excel Query module:

Excel 8.0; HDR=NO; IMEX=1;

This should then allow you to retrieve the text info from the Excel spreadsheet as well.

09/08/2004 11:03 PM

That worked great.

My tts is still not working right though, it plays right sometimes but most of the time it plays through the pc speaker.

I uninstalled and reinstalled all the wave drivers.

I am looking into getting a D/4PCI anyway.

So I'll have to see how that works out. Should solve my problems, unless it's the computers sound card and not the modem.

Ed

09/10/2004 10:06 PM

I tried reinstalling the wave files one last time.

It started out fine. I thought it was working until it got to "174432.06" in the trace log, thats when it started playing through the pc speaker again.

Ed

Trace_Log.txt

09/11/2004 12:36 AM

Could you please post the MMDDtw.txt and MMDDsw.txt trace files - we can then see what is happening in more detail.

09/11/2004 01:37 PM

Sure, here they are.

Ed

log.zip

09/12/2004 07:53 AM

Looks like the errors start to occur as the TTS system reports that it is unable to write to a file, so it just starts playing though the speakers instead of it's own accord.

We've done some changes to the vgmulti.exe program that may

Please update your v5.2.3 installation with the attached .exe and try running the scripts again. If the TTS play error occurs again please post the three traces as before.

VgMulti_5.2.3034.zip

09/13/2004 04:41 PM

It is still doing the same thing.

I have included the logs.

Ed

log.zip

09/13/2004 08:49 PM

Which TTS engine is used on this system?

09/13/2004 10:47 PM

That time I used AT&T Natural Voices, but before I was using Microsoft SAPI 5.1 and it did the same thing.

Ed

09/14/2004 07:21 PM

I just tried it again with both voice engines, and the first few calls worked good, but after a while it would play every other cell in excel through the pc speaker then it go back to working good again.

Ed

09/14/2004 07:53 PM

Can you post a copy of your VG script and Excel file which can be used to reproduce the problem - we'll try running it on your test system here and see what happens.

09/14/2004 08:00 PM

Sure here it is.

Ed

Excel_Schedule.zip

09/15/2004 08:00 PM

Now I just noticed that when I use the updated version of VG that you posted, that when it reads each tts it saves them as a .wav file in the data folder, then when it hangs up it does not delete all of them. After awhile it mixes up the files and plays the old ones instead of creating new .wav files.

Once I deleted them all and used switched back to VG v5.2.3 it would work right, except for playing some through the pc speaker.

Ed

09/15/2004 08:08 PM

Here are the logs.

The last call I tried was with the older version of VG.

Ed

log.zip

09/20/2004 04:06 PM

I ordered a D/4PCI from True Data Technology last week.

It should be here soon.

Ed

09/21/2004 05:35 AM

The problem is with the TTS system, as said before: - the TTS system reports that it is unable to write to a file, so it just starts playing though the speakers instead...

Not too sure why it would do this all of a sudden...

Once you get the Dialogic card I'd recommend doing a clean install of WinXP, then just installing the Dialogic drivers and VG and AT&T - and running the system without installing anything else to see if the problem still occurs.

09/22/2004 07:04 PM

Ok, Dialogic card installed, and clean install completed, I did not install the sound card drivers.

But, the tts worked for about 20 seconds and now I get there has been an error playing this file message.

I suppose if the sound card was installed the tts would play through the pc.

Trace log included from the last try when it didn't work at all.

Ed

Trace_log.txt

09/23/2004 04:54 PM

If i put tts in my old script it works good. but the new excel query script is the one that is having problems.

Once I close VG and reopen it then it will work until it gets to the last cell in excel.

I switched to VG v5.2.3034 and I don't need to restart VG each time I call, but it still plays the last cell through the pc. and if there is a blank cell I always get the sound file not found.

with v5.2.3034 it saves the tts as tts_6_1.wav etc.. for each cell, but it never deletes them when it is done.

Ed

124520.09 6 play set playid=414796
124520.09 6 PlaySoundStart ok [C:\Documents and Settings\All Users\Documents\VoiceGuide\data\tts_6_6.wav]

124520.09 6 timer clear

124520.11 6 wa(1256,41479600)

124520.11 6 callinfo MONITORMODES

124521.39 6 wb(41479600)

124521.44 6 play end current play (playid=414796)

124521.44 6 ScriptEventCode 8001 iLineState=1100

124521.44 6 LsPlayMsg EV_PLAY_FINISHED

124521.44 6 timer set 10 EV_TIMEOUT_HANGUP

124521.45 6 timer set 1 EV_TIMEOUT_GOTOMODULE

124522.47 6 timer fired EV_TIMEOUT_GOTOMODULE

124522.47 6 ScriptEventCode 9002 iLineState=1101

124522.47 6 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

124522.47 6 timer clear

124522.47 6 [shop Time] Playing

124522.47 6 rv replace start: [$RV[Database Query_6_1]]

124522.47 6 rv ns [PathSysVoice]{C:\Documents and Settings\All Users\Documents\VoiceGuide\system\voice\}[PathApp]{C:\Documents and Settings\All Users\Documents\VoiceGuide\}[PathDataVm]{C:\Documents and Settings\All Users\Documents\VoiceGuide\data\}[PathVgSys]{C:\Documents and Settings\All Users\Documents\VoiceGuide\system\}[DNIS]{0000}[scriptsPath]{C:\Documents and Settings\All Users\Documents\Excel Schedule\}[scriptPath]{C:\Documents and Settings\All Users\Documents\Excel Schedule}[$RV_STARTTIME]{9/23/2004 12:45:07 PM}[$RV_DEVICEID]{6}[$RV_CIDNAME]{TR TRUCKING}[PathApp]{C:\Documents and Settings\All Users\Documents\VoiceGuide\}[$RV_CIDNUMBER]{7247224445}[Get PIN]{8434}[Get PIN_PathTaken]{success}[Database Query_RowCount]{1}[Database Query_1_1]{8}[Database Query_2_1]{Bob Nichols}[Database Query_3_1]{3 Rivers}[Database Query_4_1]{Coal}[Database Query_5_1]{7:00:00 AM}[Database Query_6_1]{}

124522.48 6 rv replace end: []

124522.48 6 tts generate start[]

124522.50 6 tts generate wait

124522.50 6 RunModule PLAY end

124522.53 6 tts generate finish. lineCallState=CONNECTED

124522.55 6 [shop Time] Playing (C:\Documents and Settings\All Users\Documents\VoiceGuide\data\tts_6_7.wav)

124522.55 6 play set playid=417250

124522.55 6 PlaySoundStart err=[0 play PlaySoundStart ResetWavOutAndContinuePlay=>7,play pss EnsureWaveOutIsOpenAndReady=>play FileMmioOpenAndAscend failed in Play_EnsureWaveOutIsOpenAndReady] [C:\Documents and Settings\All Users\Documents\VoiceGuide\data\tts_6_7.wav]

124522.55 6 err wav file not ready to play. Header incomplete. Lets wait a little while and try again.

124522.55 6 timer set 0.2 EV_TIMEOUT_REPLAYMSG

124522.55 6 play end current play (playid=0)

124522.56 6 ScriptEventCode 8001 iLineState=1100

124522.56 6 LsPlayMsg EV_PLAY_FINISHED

124522.56 6 ignoring EV_PLAY_FINISHED as EV_TIMEOUT_REPLAYMSG set in timers - looks like we are replaying TTS sound file

124522.72 6 timer fired EV_TIMEOUT_REPLAYMSG

124522.72 6 ScriptEventCode 9005 iLineState=1100

124522.72 6 LsPlayMsg EV_TIMEOUT_REPLAYMSG

124522.72 6 tts generate reuse

124522.72 6 [shop Time] Playing (C:\Documents and Settings\All Users\Documents\VoiceGuide\data\tts_6_8.wav)

124522.72 6 File not found [C:\Documents and Settings\All Users\Documents\VoiceGuide\data\tts_6_8.wav]

124522.72 6 play set playid=417421

124522.73 6 PlaySoundStart ok [C:\Documents and Settings\All Users\Documents\VoiceGuide\system\voice\SoundFileNotFound.wav]

124522.73 6 timer clear

124522.73 6 wa(3112,41742100)

124522.73 6 callinfo MONITORMODES

124525.91 6 play end current play (playid=417421)

124525.92 6 ScriptEventCode 8001 iLineState=1100

124525.92 6 LsPlayMsg EV_PLAY_FINISHED

124525.92 6 timer set 10 EV_TIMEOUT_HANGUP

124525.92 6 timer set 2 EV_TIMEOUT_GOTOMODULE

124528.09 6 timer fired EV_TIMEOUT_GOTOMODULE

124528.09 6 ScriptEventCode 9002 iLineState=1101

124528.09 6 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

124528.09 6 timer clear

124528.09 6 rv add [Hangup Time]{9/23/2004 12:45:28 PM}

124528.09 6 Hanging up call... [Hangup Module]

124528.09 6 RecSoundStop ok

124528.11 6 PlaySoundStop err=0

124528.11 6 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

124528.11 6 fnHangupCall end

124528.16 6 linedevstate 2048 0 0

124528.16 6 callstate IDLE 66407 0 0

124528.16 6 WorkingMode@Idle=

124528.16 6 timer clear

124528.17 6 timer set 1 EV_TIMEOUT_TIMETOREINITLINE

124528.17 6 tapi Reply (LineEvReply) ok 66543 0

124529.20 6 timer fired EV_TIMEOUT_TIMETOREINITLINE

124529.20 6 ScriptEventCode 9008 iLineState=900

124529.20 6 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

124529.20 6 ReinitTelephony due to IDLE

124529.20 6 tapic lineDeallocateCall(MainCall:66407) 0

124529.38 6 lineOpen(6)=>

124529.38 6 Waiting for a call...

124529.38 6 LineHandle=66544

124529.38 6 timer set 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT

124529.81 0 dial start any summary:|6:rdy=0|

124530.81 0 dial start any summary:|6:rdy=0|

124531.81 0 dial start any summary:|6:rdy=0|

124532.66 6 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT

09/23/2004 06:00 PM

I also have a script question.

The way I have my script setup now is when the caller enters a four digit numder (the last four digits of social security #) the script searches excel and finds that row and reads it.

I think it would probably be easier for me if I could have it search for their four digit number in say column A in excel and then just read that row.

That way I wouldn't need to hide all the rows that are empty and sort everyone by social security number.

Is there a easier way to do this?

Ed

09/23/2004 07:44 PM

If you think that the TTS problem is somehow related to Excel can you just start using a database instead? the type of task that you are performing (looking up a value and getting a related value) is better suited to a database application.

Moving to a database (MS Access would be fine) would test whether the problems are related to MS Access or not.

09/24/2004 10:00 PM

I will try Access or Filemaker Pro maybe.

But I have no experience with either.

I will try to set something up this weekend.

Ed

09/27/2004 06:27 PM

When I set up Access I keep getting the error: 140728.81 6 OpenRecordset: 3075:Syntax error in date in query expression 'Truck #'.

I don't have anything set to date format in access at all.

Ed

Access_Schedule.zip

09/27/2004 06:40 PM

As for my excel query I think the problem may be because I used the play sound module to speak the start time. I changed it to the speak numbers module and it doesnt play anything through the computer speakers. But, I can't get it to read the time right it speaks 58 PM no matter what time I put in excel.

Ed

09/27/2004 08:39 PM

Ok in Access I took out the # in my tables and script, that fixed the error in date.

But now I get missing operator.

Ed

09/27/2004 09:12 PM

Nevermind the access problems, after a complete overhaul I got it working.

09/28/2004 05:26 PM

Ok, I think I found the reason VG plays fine for me and all of a sudden it plays my tts through the pc speaker.

In Excel and even in Access when VG comes to a cell or record that it is supposed to read and it is left blank on purpose then anything after it is played through the pc speaker. and all calls after that with tts are also played through the pc.

Unless VG is shutdown and restarted.

Is there any way to have it skip the cells if they are blank?

Also I wanted to thank you for all the help setting up my system. And for recommending that I use a database instead of Excel. It works so much better and once we all learn to use it we should save so much time.

Ed

09/29/2004 07:53 AM

The attached version no longer tries to play TTS when the resulting TTS to play id a blank. Please update your v5.2.3 installation with this attached .exe and see if this resolves the TTS problem for you.

VgMulti_5.2.3036.zip

09/29/2004 06:18 PM

Thanks, it seems that it is working good now.

Ed

10/05/2004 03:07 PM

Now when some callers call in they enter their pin number and confirm it then VG reads the day of the week for their next scheduled work day, and then VG just pauses for a while then hangs up.

in the trace log I think it stops at: 191028.80 6 ignoring EV_PLAY_FINISHED as EV_TIMEOUT_REPLAYMSG set in timers - looks like we are replaying TTS sound file

any idea what could be causing this.

Thanks for the help

Ed

10_04_04_trace_log.txt

Excel Query & Playing TTS Through Pc Speaker

Recommended Posts

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post

eal6877

Share this post

Link to post

SupportTeam

Share this post

Link to post