Error Reading From Excel Sheet

[Guest Matthew]

I am querying an excel sheet with: sheet1B$RV[add one to number]. I did a screen shot of my module/excel sheet, but couldn't post it here (Doesnt' reside on a website). I get to following error when it comes to checking the sheet for row 5, column B:

 

ERROR 5.1.2058 OpenRecordset: 3011:The Microsoft Jet database engine could not find the object 'Sheet1B5'. Make sure the object exists and that you spell its name and the path name correctly.

 

Do I need to format the query differenty, or is there a connectivity problem? I know I pointed the module to the right excel file!

 

 

Here is the full trace log:

132504.78 0 callstate OFFERING 66201 0 4

132504.80 0 ring 1

132505.84 0 Lev_CallerID [0755030879,]

132507.89 0 ring 2

132510.90 0 ring 3

132510.90 0 Answer the call at 23/09/2003 1:25:10 PM

132510.91 0 lineAnswer(66201) => 66184

132510.92 0 callstate ACCEPTED 66201 0 0

132511.66 0 tapi Reply (LineEvReply) ok 66184 0

132511.67 0 callstate CONNECTED 66201,0,0

132511.68 0 WorkingModeTAPI@Connected=

132511.68 0 WorkingModeScript@Connected=

132511.69 0 Inband detection not enabled

132511.72 0 StartLoadedVgs at 23/09/2003 1:25:11 PM

132511.73 0 [cid] Evaluate [$RV_CIDNUMBER]

132511.74 0 RVreplace start: [$RV_CIDNUMBER]

132511.75 0 RVreplace end: [0755030879]

132511.77 0 .Eval(0755030879)

132511.85 0 Eval Expr result:[755030879]

132511.89 0 [welcome] Playing

132511.90 0 [welcome] Playing (C:\Documents and Settings\Mark41\Desktop\Ivg recordings\Welcome message.wav)

132512.31 0 PlaySoundStart ok [C:\Documents and Settings\Mark41\Desktop\Ivg recordings\Welcome message.wav]

132512.33 0 RunModule PLAY end

132517.85 0 Play End line[0] (id=715652)

132517.87 0 LsPlayMsg EV_PLAY_FINISHED

132519.83 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

132519.84 0 [Get Numbers 3] Number Input

132519.86 0 [Get Numbers 3] Playing (C:\Program Files\VoiceGuide\system\voice\beep1.wav)

132520.27 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\system\voice\beep1.wav]

132520.47 0 Play End line[0] (id=723604)

132520.48 0 LsGetNbrsPlayWelcMsg EV_PLAY_FINISHED

132522.43 0 dtmf 4 (66201,52,2)

132522.45 0 LsGetNbrsRxDigits 4

132522.46 0 [Get Numbers 3] Number Input 4

132522.48 0 path {4} not found

132522.49 0 [add 1 to number] Evaluate [$RV[Get Numbers 3]+1]

132522.51 0 RVreplace start: [$RV[Get Numbers 3]+1]

132522.52 0 RVreplace end: [4+1]

132522.54 0 .Eval(4+1)

132522.55 0 Eval Expr result:[5]

132522.57 0 path {5} not found

132522.59 0 [Check row entered] DB Query

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

132522.87 0 RVreplace start: [sheet1B$RV[add 1 to number]]

132522.88 0 RVreplace end: [sheet1B5]

132522.90 0 About to execute Retrieve Operation [sheet1B5]

132522.94 0 ERROR 5.1.2058 OpenRecordset: 3011:The Microsoft Jet database engine could not find the object 'Sheet1B5'. Make sure the object exists and that you spell its name and the path name correctly.

132522.96 0 [system ssheet error] Playing

132522.97 0 [system ssheet error] Playing (C:\Documents and Settings\Mark41\Desktop\Ivg recordings\system error.wav)

132523.33 0 PlaySoundStart ok [C:\Documents and Settings\Mark41\Desktop\Ivg recordings\system error.wav]

132523.35 0 RunModule PLAY end

132528.37 0 Play End line[0] (id=726718)

132528.39 0 LsPlayMsg EV_PLAY_FINISHED

132530.32 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

132530.33 0 Hanging up call... [Hangup Module]

132530.35 0 RecSoundStop ok

132530.36 0 PlaySoundStop ok

132530.38 0 fnHangupCall end

132531.38 0 callstate DISCONNECTED 66201,1,0

132531.40 0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT

132531.41 0 Hanging up call...

132531.43 0 RecSoundStop ok

132531.45 0 PlaySoundStop ok

132531.46 0 fnHangupCall end

132531.48 0 callstate IDLE 66201 0 0

132531.49 0 WorkingMode@Idle=

132531.54 0 tapi Reply (LineEvReply) ok 66167 0

132531.55 0 tapi Reply (LineEvReply) ok 66150 0

132532.47 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

132532.48 0 ReinitTelephony due to IDLE start

132532.52 0 tapic lineDeallocateCall(MainCall:66201) 0

132532.63 0 lineOpen(0) => 0

132532.64 0 Waiting for a call...

132532.66 0 lineOpen(0)LineHandle=66133

[SupportTeam]

I did a screen shot of my module/excel sheet, but couldn't post it here

You can attach it as a file to the message... (may need to register as a forum member first)

 

I think the problem is that you should use:

 

sheet1$B$RV[add one to number]

 

instead of the current sheet1B$RV[add one to number]

 

The sheet name and cell name should be separated by a "$"

[jims]

I just tried Sheet1$B$RV[add 1 to number], but jet engine error still came up. I am sure it is pointing to the right excel file!

 

I am looking for data in a particular cell, so should I use Sheet1$B$$RV[add 1 to number] ? Or have I capitalised something that I shouldnt' have?

 

I am running VoiceGuide 5.1.2058 on windows2000. Could this version of VG be my problem, should I try the latest trial version?

 

I really like VG and will buy 2 licences if I can get my script up to scratch! Thanks for the good support!

 

Here is the latest trace log:

 

155335.18 0 callstate OFFERING 66201 0 4

155335.24 0 ring 1

155336.24 0 Lev_CallerID [0755030879,]

155338.20 0 ring 2

155341.21 0 ring 3

155341.21 0 Answer the call at 23/09/2003 3:53:41 PM

155341.22 0 lineAnswer(66201) => 66184

155341.23 0 callstate ACCEPTED 66201 0 0

155341.96 0 tapi Reply (LineEvReply) ok 66184 0

155341.97 0 callstate CONNECTED 66201,0,0

155341.98 0 WorkingModeTAPI@Connected=

155341.98 0 WorkingModeScript@Connected=

155341.99 0 Inband detection not enabled

155342.02 0 StartLoadedVgs at 23/09/2003 3:53:42 PM

155342.03 0 [cid] Evaluate [$RV_CIDNUMBER]

155342.04 0 RVreplace start: [$RV_CIDNUMBER]

155342.05 0 RVreplace end: [0755030879]

155342.10 0 .Eval(0755030879)

155342.17 0 Eval Expr result:[755030879]

155342.18 0 [welcome] Playing

155342.20 0 [welcome] Playing (C:\Documents and Settings\Mark41\Desktop\Ivg recordings\Welcome message.wav)

155342.60 0 PlaySoundStart ok [C:\Documents and Settings\Mark41\Desktop\Ivg recordings\Welcome message.wav]

155342.62 0 RunModule PLAY end

155348.13 0 wb(40394000)

155348.15 0 Play End line[0] (id=403940)

155348.17 0 LsPlayMsg EV_PLAY_FINISHED

155350.12 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

155350.13 0 [Get Numbers 3] Number Input

155350.14 0 [Get Numbers 3] Playing (C:\Program Files\VoiceGuide\system\voice\beep1.wav)

155350.54 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\system\voice\beep1.wav]

155350.74 0 Play End line[0] (id=411892)

155350.76 0 LsGetNbrsPlayWelcMsg EV_PLAY_FINISHED

155352.61 0 dtmf 6 (66201,54,2)

155352.63 0 LsGetNbrsRxDigits 6

155352.64 0 [Get Numbers 3] Number Input 6

155352.64 0 path {6} not found

155352.66 0 [add 1 to number] Evaluate [$RV[Get Numbers 3]+1]

155352.68 0 RVreplace start: [$RV[Get Numbers 3]+1]

155352.70 0 RVreplace end: [6+1]

155352.70 0 .Eval(6+1)

155352.73 0 Eval Expr result:[7]

155352.73 0 path {7} not found

155352.75 0 [Check row entered] DB Query

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

155353.07 0 RVreplace start: [sheet1$B$RV[add 1 to number]]

155353.09 0 RVreplace end: [sheet1$B7]

155353.10 0 About to execute Retrieve Operation [sheet1$B7]

155353.16 0 ERROR 5.1.2058 OpenRecordset: 3011:The Microsoft Jet database engine could not find the object 'Sheet1$B7'. Make sure the object exists and that you spell its name and the path name correctly.

155353.16 0 [system ssheet error] Playing

155353.19 0 [system ssheet error] Playing (C:\Documents and Settings\Mark41\Desktop\Ivg recordings\system error.wav)

155353.57 0 PlaySoundStart ok [C:\Documents and Settings\Mark41\Desktop\Ivg recordings\system error.wav]

155353.59 0 RunModule PLAY end

155358.61 0 Play End line[0] (id=414926)

155358.61 0 LsPlayMsg EV_PLAY_FINISHED

155400.54 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

155400.55 0 Hanging up call... [Hangup Module]

155400.57 0 RecSoundStop ok

155400.57 0 PlaySoundStop ok

155400.60 0 fnHangupCall end

155401.60 0 callstate DISCONNECTED 66201,1,0

155401.62 0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT

155401.63 0 Hanging up call...

155401.65 0 RecSoundStop ok

155401.66 0 PlaySoundStop ok

155401.68 0 fnHangupCall end

155401.69 0 callstate IDLE 66201 0 0

155401.71 0 WorkingMode@Idle=

155401.75 0 tapi Reply (LineEvReply) ok 66167 0

155401.76 0 tapi Reply (LineEvReply) ok 66150 0

155402.68 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

155402.69 0 ReinitTelephony due to IDLE start

155402.73 0 tapic lineDeallocateCall(MainCall:66201) 0

155402.78 0 lineOpen(0) => 0

155402.79 0 Waiting for a call...

155402.81 0 lineOpen(0)LineHandle=66133

[SupportTeam]

Looks like the trick is that you always need to specify a range of cells to be retrieved, even if you need to retrieve just one cell.

 

So for example if you needed to retrieve Sheet2$B5 you should specify Sheet2$B5:B5.

 

We have got the same error when using Sheet2$B5 but everything worked OK when using Sheet2$B5:B5.

Examples below were made using the modified and then the original "Customer Enquiry" demo script which comes with VoiceGuide.

 

Using Sheet2$B5

210021.17  9 RVreplace start: [sheet$RV[Get Day]$B$RV[Get Roster Number]]

210021.17  9 RVreplace end: [sheet2$B5]

210021.17  9 About to execute Retrieve Operation [sheet2$B5]

210021.19  9 ERROR 5.1.2068 OpenRecordset: 3011:The Microsoft Jet database engine could not find the object 'Sheet2$B5'.  Make sure the object exists and that you spell its name and the path name correctly.

 

Using Sheet2$B5:B5

210113.56  9 RVreplace start: [sheet$RV[Get Day]$B$RV[Get Roster Number]:B$RV[Get Roster Number]]

210113.56  9 RVreplace end: [sheet2$B5:B5]

210113.56  9 About to execute Retrieve Operation [sheet2$B5:B5]

210113.56  9 [Excel Query] row count=1

[Guest Matthew]

Thanks for great help. It is working fine now!