Purchase - Help

[npeiman]

I have made the recommendation to my company to purchase Voiceguide. However I am not a programmer although I did play with QB4.5 some years ago. However I have been given one week to deploy the first Voiceguide installation in Panama.

 

We have purchased a Dialogic D41/h but I am not a VB programmer by any means and we need some help to deploy this. We are using two Excel excel workbooks and need some assistance in writing the scripts. We are ready to purchase the first 4 port enterprise license. The second system is due to be deployed in Costa Rica by February 5.

 

See the atached word file for specs. 12 seperate systems will be deployed througout central and south america over the next 3 months. A 16 port system is slated for both Costa Rica and Panama once the prototype is working.

 

Thanks for your help and consideration

[SupportTeam]

No file was attached to the previous post, could you please try posting it again? (or email it to support@katalinatech.com and we can post it here for you...)

 

Most of the VB Scripts for retrieving & setting data in Excel spreadsheets are pretty short and straightforward, and we can of course assist you in writing these scripts. ( I assume that what you need to do in your script is similar to the question posted in: http://voiceguide.com/forums/index.php?showtopic=986 )

 

Once you have your first draft of the VG script and Excel files set up please post them here and we can then add to the script the appropriate VB Script Excel access routines.

[npeiman]

Just following up to be sure you received my email and the attachements.

 

Thanks, Neil Peiman

[SupportTeam]

The attached script should get you pretty close to the mark.

 

Please have a read through all of the VB Script modules (and descriptions of all other modules) you may need to change the location of the filenames etc. used in them to suit your system.

 

Also - instead of saving the resulting two numbers to be used by a callback system to a text file you could probably pass them to the callback server as part of the HTTP query or via a socket - the callback server should be able to provide a more convienient interface then a text file...

 

The 'Table2' Excel spreadsheet can be just changed when needed - uploading of new versions of this file can be done independently of VoiceGuide operation.

 

 

Here are the specs for the system you have provided as a reference:

Agent Call Back System

 

Computer will be connected to the public telephone network that will be called by the representatives. Dialogic or other high density telephony product. The System will also be connected to a full-time Internet connection. This will interface to the Long Distance carriers web sites or servers.

 

A call will be received by the system from a representative. If the rep is valid and authorized their phone number will be in the first table.

 

Table 1 - Representatives

 

Rep No.  Telephone  DID No.

1          819-8734    3078975465

2          846-5643    3078754332

 

If the rep is in Table 1 then the DID will be used to call him back. The DID number will be passed to the LD carrier as the call back number for the rep. If the rep is not in table 1 then goodbye.

 

Table 2 - Leads 

 

Control No.    Telephone

23456           8056745673

35621           9094536342

 

1. System captures caller's telephone number from caller ID 

 

2. If caller's telephone number does not match a telephone number in Table 1, caller hears a rapid busy tone or voice response and is disconnected.

 

3. If caller's telephone number matches number in Table 1, caller is prompted to "Enter number".

    NOTE: This could be just a tone or a verbal prompt.

 

4. Caller enters a five digit or 10 digit number followed by #.

   A. Five digit number requires a look-up on Table 2.

   B. Ten digit number indicates a special call not in Table 2.

 

5. System disconnects

 

The DID number from table 1 and the destination number from table two, (or entered by the caller if there is not 5 digit lead number, is written to a text file. Then we pass the DID and destination number to the long distance carrier web site or server.

 

NOTE: The information in Table 2 will be changed completely each day.  Currently this information is maintained in Excel format.  Ideal would be the ability to delete all information in Table 2 and import the new information from the Excel worksheet.

Panama_CB_system.vgs

[npeiman]

First, thanks for your help with the scripts. I think I'm getting the jist of things. I've put off implementation testing till Wednesday.

 

First, I've noticed in the trace logs that it appears that each time a module is called or started the trace log shows the [module name] in square brackets, is that correct.

 

If so I noticed that when the script begins the first [evaluate expression] module in this case does not seem to appear in the trace log. But the subsequent module [Write Call Data] is shown first. Also I was wondering what the "161255.71 5 Could not obtain handle to kill process. (new call) 312, 0" is all about?

 

 

Enter 5 or 10 digit - When I enter the 5 digits "12345", (exists in sheet called LEADS in Excel workbook called Panama.xls) I get the response that the number was not found in the table.

 

In the excel workbook there are two sheets. The first is called AGENTS and the other is called LEADS.

 

I am not clear on this but I know that "12345" is in collum 1 in the sheet caled LEADS yet it appears that I don't know how to handle the sytax properly so that the scipt knows what the correct sheet to search for is.

 

Entering a 5 digit number that exists in collum 1, sheet called LEADS means that we have to get the destination number in collum 2. If the caller enters a 5 digit number not in the collum 1, then a result of false should prompt to re-enter the 5 digit number, (in the event of error) till he/she gets it right. If after a specified number of attempts the system should disconnect.

 

If a 10 digit number is entered, that "is" the destination number. So we need to grab the resulting DID variable and Destination and pass it to the web sites, (socket connection, etc).

 

Also in the VB Script module called [Write CB Data 1] there is the following:

 

if xlSht.Cells(i, iColumn) = "" then

'5 digit number was not found in Excel spreadsheet

vg.Script_Goto $RV_LINEID, "", "Not In List", ""

 

Shouldn't $RV_LINEID be $RV CIDNUMBER?

 

I've attached the script with the modifications I've made since you made it available. Hope you can look at it and see where I'm off the mark! Thanks for your assistance

 

Neil Peiman

 

 

161158.14 5 fnHangupCall end

161158.20 5 linedevstate 2048 0 0

161158.20 5 callstate IDLE 65723 0 0

161158.23 5 WorkingMode@Idle=

161158.23 5 tapi Reply (LineEvReply) ok 65689 0

161159.17 5 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

161159.18 5 ReinitTelephony due to IDLE start

161159.20 5 tapic lineDeallocateCall(MainCall:65723) 0

161159.38 5 lineOpen(5) => 0

161159.40 5 Waiting for a call...

161159.41 5 lineOpen(5)LineHandle=65672

161249.66 5 linedevstate 2048 0 0

161249.69 5 callstate OFFERING 65621 0 4

161249.73 5 Lev_CallerID [3087794,]

161249.74 5 callinfo CALLEDID

161249.76 5 callinfo ORIGIN

161249.77 5 ring 0

161255.70 5 ring 2

161255.71 5 Could not obtain handle to kill process. (new call) 312, 0

161255.73 5 Answer the call at 1/12/2004 4:12:55 PM

161255.73 5 lineAnswer(65621) => 65604

161256.27 5 callstate CONNECTED 65621,1,0

161256.29 5 WorkingModeTAPI@Connected=

161256.30 5 WorkingModeScript@Connected=

161256.34 5 Inband detection not enabled

161256.36 5 StartLoadedVgs at 1/12/2004 4:12:56 PM

161256.37 5 tapi Reply (LineEvReply) ok 65604 0

161256.39 5 [Write Call Data] Running VB Script...

161256.40 5 RVreplace start (strlen>100)

161256.44 5 VBScript Run continuing...

161256.48 5 [Play One Moment] Playing

161256.49 5 [Play One Moment] Playing (C:\Call Center\Sound Files\One Moment Please We Are Checking.wav)

161256.52 5 PlaySoundStart ok [C:\Call Center\Sound Files\One Moment Please We Are Checking.wav]

161256.53 5 RunModule PLAY end

161308.32 5 Play End line[5] (id=67466)

161308.32 5 LsPlayMsg EV_PLAY_FINISHED

161308.35 5 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

161308.36 5 [Check Caller] Running VB Script...

161308.37 5 RVreplace start (strlen>100)

161308.41 5 VBScript Run continuing...

161308.46 5 [Enter 5 or 10 Digit] Number Input

161308.46 5 [Enter 5 or 10 Digit] Playing (C:\Call Center\Sound Files\Enter 5 or 10.wav)

161308.48 5 PlaySoundStart ok [C:\Call Center\Sound Files\Enter 5 or 10.wav]

161309.39 5 cl Script_Goto 5, , Enter 5 or 10 Digit, [DidNumber]{9259900022}

161309.40 2 tr NewVgsVgm_Goto ,Enter 5 or 10 Digit,[DidNumber]{9259900022},,,0

161309.42 2 tr NewVgsVgm_Goto 1

161309.43 2 tr NewVgsVgm_Goto 2

161309.45 5 [Enter 5 or 10 Digit] Number Input

161309.46 5 [Enter 5 or 10 Digit] Playing (C:\Call Center\Sound Files\Enter 5 or 10.wav)

161309.54 5 PlaySoundStart ok [C:\Call Center\Sound Files\Enter 5 or 10.wav]

161309.56 2 tr NewVgsVgm_Goto end

161322.59 5 dtmf 1 (65621,49,2)

161322.60 5 LsGetNbrsPlayWelcMsg 1

161322.67 5 PlaySoundStop ok

161322.68 5 [Enter 5 or 10 Digit] Number Input 1

161322.69 5 path {1} not found

161322.71 5 wb(8044500)

161323.12 5 dtmf 2 (65621,50,2)

161323.14 5 LsGetNbrsRxDigits 2

161323.15 5 [Enter 5 or 10 Digit] Number Input 12

161323.16 5 path {12} not found

161323.80 5 dtmf 3 (65621,51,2)

161323.81 5 LsGetNbrsRxDigits 3

161323.82 5 [Enter 5 or 10 Digit] Number Input 123

161323.84 5 path {123} not found

161324.47 5 dtmf 4 (65621,52,2)

161324.48 5 LsGetNbrsRxDigits 4

161324.50 5 [Enter 5 or 10 Digit] Number Input 1234

161324.51 5 path {1234} not found

161325.03 5 dtmf 5 (65621,53,2)

161325.05 5 LsGetNbrsRxDigits 5

161325.06 5 [Enter 5 or 10 Digit] Number Input 12345

161325.07 5 path {12345} not found

161331.25 5 LsGetNbrsRxDigits EV_TIMEOUT_ENTERDATA

161331.26 5 fn PlaySoundStartNumbers C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmIntro.wav, C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmMenu.wav, 12345, Digits

161331.28 5 sVbsFunctionToUse=Digits

161331.32 5 Started SayNumber VBScript OK. (C:\Program Files\VoiceGuide\data\vbs_5_SayNumber.vbs)

161331.37 5 cl Play_Start C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmIntro.wav,1.wav,2.wav,3.wav,4.wav,5.wav,C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmMenu.wav

161331.42 5 PlaySoundStart ok [C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmIntro.wav,C:\Program Files\VoiceGuide\system\voice\1.wav,C:\Program Files\VoiceGuide\system\voice\2.wav,C:\Program Files\VoiceGuide\system\voice\3.wav,C:\Program Files\VoiceGuide\system\voice\4.wav,C:\Program Files\VoiceGuide\system\voice\5.wav,C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmMenu.wav]

161343.24 5 Play End line[5] (id=102356)

161343.25 5 LsGetNbrsPlayConfirm EV_PLAY_FINISHED

161344.63 5 dtmf 1 (65621,49,2)

161344.64 5 LsGetNbrsPlayConfirm 1

161344.66 5 PlaySoundStop ok

161344.67 5 path {12345} not found

161344.70 5 [is number 5 digit] Evaluate [len("$RV[Enter 5 or 10 Digit]") = 5]

161344.71 5 RVreplace start: [len("$RV[Enter 5 or 10 Digit]") = 5]

161344.73 5 RVreplace end: [len("12345") = 5]

161344.74 5 .Eval(len("12345") = 5)

161344.76 5 Eval Expr result:[True]

161344.77 5 path {True} not found

161344.79 5 [Write CB Data 1] Running VB Script...

161344.80 5 RVreplace start (strlen>100)

161344.84 5 Run Script waiting... (shellid=312, process=24)

161344.86 5 [Write CB Data 1] Playing (C:\Call Center\Sound Files\You entered 5 digits.wav)

161344.90 5 PlaySoundStart err=[0 play PlaySoundStart ResetWavOutAndContinuePlay=>32] file[C:\Call Center\Sound Files\You entered 5 digits.wav]

161344.95 5 tapie PlayEnd old line=5 0 115835

161345.86 5 cl Script_Goto 5, , Thank You Bye,

161345.88 2 tr NewVgsVgm_Goto ,Thank You Bye,,,,0

161345.89 2 tr NewVgsVgm_Goto 1

161345.89 2 tr NewVgsVgm_Goto 2

161345.91 5 [Thank You Bye] Playing

161345.93 5 [Thank You Bye] Playing ()

161345.95 5 LsPlayMsg EV_PLAY_FINISHED

161345.95 5 RunModule PLAY end

161345.98 2 tr NewVgsVgm_Goto end

161349.46 5 Play End line[5] (id=115835)

161349.47 5 LsPlayMsgFinished EV_PLAY_FINISHED

161350.92 5 LsPlayMsgFinished EV_TIMEOUT_REPLAYMSG

161350.94 5 [Thank You Bye] Playing ()

161350.95 5 LsPlayMsg EV_PLAY_FINISHED

161355.98 5 LsPlayMsgFinished EV_TIMEOUT_REPLAYMSG

161356.00 5 [Thank You Bye] Playing ()

161356.01 5 LsPlayMsg EV_PLAY_FINISHED

161356.02 5 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

161356.04 5 Hanging up call... [Hangup Module]

161356.05 5 RecSoundStop ok

161356.06 5 PlaySoundStop ok

161356.08 5 fnHangupCall end

161356.12 5 linedevstate 2048 0 0

161356.13 5 callstate IDLE 65621 0 0

161356.14 5 WorkingMode@Idle=

161356.16 5 tapi Reply (LineEvReply) ok 65587 0

161357.09 5 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

161357.10 5 ReinitTelephony due to IDLE start

161357.12 5 tapic lineDeallocateCall(MainCall:65621) 0

161357.29 5 lineOpen(5) => 0

161357.31 5 Waiting for a call...

161357.32 5 lineOpen(5)LineHandle=65570

Panama_CB_system.vgs