VoiceGuide IVR Software Main Page
Jump to content

Return Var From Excel

Recommended Posts

Just a question about using a variable in excel.

I used the RV$[Module] to look for the numbers in an Excel file.

This all works well, and now I like to use that variable (Pinnumber) in my voiceguide module again.

How to use it in Voiceguide in for example an evualate module, cause It seems not to pass it as a number!

 

I trying to check it with an evualatemodule but it seems it won;t see it as a number at all?

 

Thank U.

Share this post


Link to post

Can you please post your script which shows what you are trying to do - also could you please post a copy of VoiceGuide's Debug Printout which captures the problem, this will allow us to see what is happening on your system.

 

(When running the script click on VoiceGuide's View menu and select 'Event Trace Log' option - any log information will then appear in this window. You must open the trace window before making the call.)

Share this post


Link to post

what I want is to use this variable (Pin5) in an evaluatemodule.

 

It doesn't check really, no matter what the pin5 variable is is always says true.

seems to me that it doesn't tranfer to voiceguide and makes it 0 .

so how to tranfer this variable to Voiceguide?

 

 

here the trace

 

 

55687 6 tapie linedevstate 2048 0 0

55703 6 tapie callstate OFFERING 65964 0 4

55703 6 tapie callinfo CALLEDID

55718 6 tapie callinfo ORIGIN

55718 6 tapie ring 0

55718 6 Start without answering the call

55718 6 CID at StartLoadedVgs []

55718 6 CID at RunModule% []

55718 6 [Welkom] Playing

55718 6 lineAnswer(65964) => 65930

56265 6 tapie callstate CONNECTED 65964,1,0

56265 6 WorkingModeTAPI=

56265 6 WorkingModeScript=BeforeAnswerRun

56312 6 tapi Reply 65930 0

56312 6 CID at RunModule% []

56312 6 [Welkom] Playing

56312 6 [Welkom] Playing (D:\gidstekst\Welkom\4_MAIN.WAV)

56328 6 PlaySoundStart ok [D:\gidstekst\Welkom\4_MAIN.WAV]

56328 6 RunModule PLAY end

58187 6 tapie monitordigits 50 2

58187 6 LsPlayMsg [2]

58234 6 PlaySoundStop ok

58234 6 CID at RunModule% []

58234 6 [Keuze] Evaluate $RV[Welkom] < 4

58234 6 RVreplace start: [$RV[Welkom] < 4]

58234 6 CID at RvProcessAndReplace []

58234 6 RVreplace end: [2 < 4]

58234 6 .Eval(2 < 4)

58250 6 Eval Expr result:[True]

58250 6 CID at RunModule% []

58250 6 [Check_01] Running VB Script...

58250 6 CID at RvProcessAndReplace []

58265 6 VBScript Run continuing...

58281 6 CID at RunModule% []

58281 6 [Check] Evaluate pin5 < 200

58281 6 .Eval(pin5 < 200)

58281 6 Eval Expr result:[True]

58296 6 CID at RunModule% []

58296 6 [Goed] Playing

58296 6 [Goed] Playing (D:\gidstekst\hoofdtekst\3_complex onderbrengen.wav)

58359 6 PlaySoundStart ok [D:\gidstekst\hoofdtekst\3_complex onderbrengen.wav]

58359 6 RunModule PLAY end

64390 6 tapie callstate DISCONNECTED 65964,0,0

64390 6 LsPlayMsg EV_REMOTEPARTY_DISCONNECT

64437 6 PlaySoundStop ok

64437 6 Hanging up call...

64437 6 PlaySoundStop ok

64437 6 fnHangupCall end

64484 6 tapie linedevstate 2048 0 0

64484 6 tapie callstate IDLE 65964 0 0

64484 6 WorkingMode@Idle=

64484 6 tapi Reply 65947 0

65578 6 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

65578 6 Initialise telephony (due to IDLE)

65578 6 tapic lineDeallocateCall(MainCall:65964) 0

65718 6 Waiting for a call...

65718 6 hLine=65896

Share this post


Link to post

I assume that "pin5" was some variable used in the VB Script which was ran in the previous module ("[Check_01]"), correct?

 

If you want to return some Result Variables from a VB Script back to VoiceGuide you need create a "Result File" and save any returned result variables into that file... Please see the VoiceGuide Help file's section of "Run VB Script" module for more information on this...

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×