Guest mtplz Report post Posted 12/19/2006 02:53 PM How can i get $RV_CIDNUMBER and $RV_ENTEREDNUMBER' number when caller is calling . set vg = CreateObject("VoiceGuide.CommandLink") set cn = CreateObject("ADODB.Connection") set rs = CreateObject("ADODB.Recordset") cn.Open "Provider=SQLOLEDB;Server=;UID=;PWD=;Database=" if cn.State <> 1 then vg.Run_ResultReturn iLineId, "fail" WScript.Quit end if set rs.ActiveConnection = cn sSQL = "select Transactionid from TransactionMaster where Phone='"$RV_CIDNUMBER"' and Transcode='$RV_ENTEREDNUMBER'" rs.Open sSQL, cn, 3 if not rs.eof then set vg = CreateObject("VoiceGuide.CommandLink") sResult = "success" vg.Run_ResultReturn $RV_LINEID, sResult set vg = Nothing else vg.Run_ResultReturn iLineId, "fail" end if rs.close cn.Close Set rs = Nothing Set cn = Nothing Set vg = Nothing if cn.State <> 1 then vg.Run_ResultReturn iLineId, "fail" WScript.Quit end if Please help me Share this post Link to post
SupportTeam Report post Posted 12/19/2006 06:26 PM Please post the entire script (as attachment) and a trace capturing the call (.ZIPed). $RV_ENTEREDNUMBER will only work when used in the Get Number module's verification script. Share this post Link to post
Guest mtplz Report post Posted 12/20/2006 05:11 AM Hi Supposrt Team Let me explain my problems: When i am dialing the number the 1.1 Welcome to xyz.com. Please enter your verification number and press the pound key. 1’2. If telephone is not registered at xyz.com: Hello, this telephone number you are calling to is used to make escrow transaction at xyz.com. Your telephone number is not registered at xyz.com or blocked. Please, call from telephone number which you provided on the moment of a bid acceptance or unblock the number. 2’1. If verification number provided is correct: Please enter your partner’s acceptance number and press the pound key. 2’2. If verification number is wrong: The verification number you entered is not correct. Please, enter your verification number and press the pound key. (When the user gets correct number next step will be 2’1; a user can try to enter correct numbers 4 times; after 4 times unsuccessful attempt the phone will hang up and 4’1 will be played) 3’1 if acceptance number is correct: Transaction is successfully completed for offer ID 1111. Thank you for using xyz.com. If you would like to check transaction status again press the star key, or you can call from same phone number during two days entering acceptance number (If the user clicks the star key 3’1 will be played again) 3’2. If acceptance number is not correct: The acceptance number you entered is not correct. Please, enter your partner’s acceptance number and press the pound key. (When the user gets correct number next step will be 3’1; A user can try to enter correct numbers 4 times; after 4 times unsuccessful attempt the phone will hang up and 4’1 will be played) 4’1 The number you entered is not correct. Good bye. Can u explain how can i write the script on above description. I have problems to get telehone number and Verification number which is dial by Caller user. So please help me as soon as possible Share this post Link to post
SupportTeam Report post Posted 12/20/2006 05:54 AM Sounds like you will be using Get Number modules to ask caller to enter verification and transaction numbers etc. The VBScript you posted would be appropriate for usage from within a Get Number module. If you are still having problems please post the entire script (as attachment) and a trace capturing the call (.ZIPed). To get a trace: Enable logging by setting the log levels to 10 in VG.INI as per below: [Log] VoiceGuide=10 Then restart VG and make a test call which demonstrates the problem. Trace files will be created in VG's \log\ subdirectory. Please post the traces and the VoiceGuide script used. When posting traces/scripts please .ZIP them up and post them as attachments. Share this post Link to post
Guest mtplz Report post Posted 12/20/2006 07:48 AM Hi Support Team As per your advice i have to made.I am sending traces/scripts please .ZIP.please advise me or help me how to run this script. Please help me ............ newfile.zip Share this post Link to post
SupportTeam Report post Posted 12/20/2006 10:15 PM Looks like you're on the right track with the script. The traces supplied do not include a capture of an incoming call... Looking at first module we see that in it's VBScript you have this line: sSQL = "select Transactionid from TransactionMaster where Phone='"$RV_CIDNUMBER"' and Transcode='"$RV_ENTEREDNUMBER"'" That line should probably be changed to something like this: sSQL = "select Transactionid from TransactionMaster where Phone='$RV_CIDNUMBER' and Transcode='$RV_ENTEREDNUMBER'" Double quotes should only be at beginning and end of string. Share this post Link to post