rleflore Report post Posted 07/16/2003 06:17 PM What is needed in my script once the caller enters the phone number? I would like to retreived the phone number and then write it out to an Excel spreadsheet or Access database. Presently I'm trying it with Excel. Can someone instruct me on the syntax necessary to accomplish this? I've tried some of the examples but I've been unsucessful. Will I need to use a third party package to accomplish this? or can this all be done with VG? What is the syntax to execute a read or a write to and from a file? Should I use CT Media instead? Any suggestions would be helpful. This is the output from the event trace log. 54687 5 tapie linedevstate 2048 0 0 54687 5 tapie callstate OFFERING 66169 0 4 54703 5 tapie callinfo CALLEDID 54703 5 tapie callinfo ORIGIN 54703 5 tapie ring 0 54703 5 Answer the call 54703 5 lineAnswer(66169) => 66118 55250 5 tapie callstate CONNECTED 66169,1,0 55250 5 WorkingModeTAPI= 55250 5 WorkingModeScript= 55281 5 Inband detection not enabled 55281 5 tapi Reply 66118 0 55281 5 [begin] Playing 55281 5 [begin] Playing (C:\Program Files\VoiceGuide\Scripts\newbeginintro.wav) 55296 5 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\newbeginintro.wav] 55296 5 RunModule PLAY end 76234 5 tapie monitordigits 49 2 76234 5 LsPlayMsg [1] 76281 5 PlaySoundStop ok 76281 5 [MBcompinfo] Playing 76281 5 [MBcompinfo] Playing (C:\Program Files\VoiceGuide\Scripts\newbizintro.wav) 76312 5 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\newbizintro.wav] 76312 5 RunModule PLAY end 91281 5 tapie monitordigits 49 2 91281 5 LsPlayMsg [1] 91328 5 PlaySoundStop ok 91328 5 [MBcallerentry] Number Input 91343 5 [MBcallerentry] Playing (C:\Program Files\VoiceGuide\Scripts\placenumber.wav) 91359 5 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\placenumber.wav] 06671 5 wb(69134300) 06718 5 Play End line[5] (id=691343) 06734 5 LsGetNbrsPlayWelcMsg EV_PLAY_FINISHED 07734 5 tapie monitordigits 54 2 07734 5 LsGetNbrsRxDigits [6] 07734 5 [MBcallerentry] Number Input 6 08125 5 tapie monitordigits 51 2 08125 5 LsGetNbrsRxDigits [3] 08125 5 [MBcallerentry] Number Input 63 10968 5 tapie monitordigits 48 2 10968 5 LsGetNbrsRxDigits [0] 10968 5 [MBcallerentry] Number Input 630 12937 5 tapie monitordigits 57 2 12937 5 LsGetNbrsRxDigits [9] 12937 5 [MBcallerentry] Number Input 6309 13343 5 tapie monitordigits 53 2 13343 5 LsGetNbrsRxDigits [5] 13343 5 [MBcallerentry] Number Input 63095 13781 5 tapie monitordigits 53 2 13781 5 LsGetNbrsRxDigits [5] 13796 5 [MBcallerentry] Number Input 630955 14359 5 tapie monitordigits 56 2 14359 5 LsGetNbrsRxDigits [8] 14359 5 [MBcallerentry] Number Input 6309558 14609 5 tapie monitordigits 55 2 14609 5 LsGetNbrsRxDigits [7] 14609 5 [MBcallerentry] Number Input 63095587 15078 5 tapie monitordigits 54 2 15078 5 LsGetNbrsRxDigits [6] 15078 5 [MBcallerentry] Number Input 630955876 15609 5 tapie monitordigits 57 2 15609 5 LsGetNbrsRxDigits [9] 15609 5 [MBcallerentry] Number Input 6309558769 15609 5 fn PlaySoundStartNumbers C:\Program Files\VoiceGuide\system\voicedlgc\GetNbrsConfirmIntro.wav, C:\Program Files\VoiceGuide\system\voicedlgc\GetNbrsConfirmMenu.wav, 6309558769, Digits 15625 5 twcal PlaySayNumber C:\Program Files\VoiceGuide\system\voicedlgc\GetNbrsConfirmIntro.wav, C:\Program Files\VoiceGuide\system\voicedlgc\GetNbrsConfirmMenu.wav, 6309558769, , 1 15656 5 PlaySoundStartNumbers ok 32015 5 Play End line[5] (id=715625) 32015 5 LsGetNbrsPlayConfirm EV_PLAY_FINISHED 44406 5 tapie monitordigits 51 2 44406 5 LsGetNbrsPlayConfirm [3] 44421 5 PlaySoundStop ok 44421 5 [MBcallerentry] Number Input 44421 5 [MBcallerentry] Playing (C:\Program Files\VoiceGuide\Scripts\placenumber.wav) 44421 5 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\placenumber.wav] 55000 5 tapie monitordigits 55 2 55000 5 LsGetNbrsPlayWelcMsg [7] 55046 5 PlaySoundStop ok 55046 5 [MBcallerentry] Number Input 7 55453 5 tapie monitordigits 55 2 55453 5 LsGetNbrsRxDigits [7] 55453 5 [MBcallerentry] Number Input 77 56468 5 tapie monitordigits 51 2 56468 5 LsGetNbrsRxDigits [3] 56468 5 [MBcallerentry] Number Input 773 57937 5 tapie monitordigits 50 2 57937 5 LsGetNbrsRxDigits [2] 57937 5 [MBcallerentry] Number Input 7732 58343 5 tapie monitordigits 56 2 58343 5 LsGetNbrsRxDigits [8] 58343 5 [MBcallerentry] Number Input 77328 58578 5 tapie monitordigits 55 2 58578 5 LsGetNbrsRxDigits [7] 58578 5 [MBcallerentry] Number Input 773287 58921 5 tapie monitordigits 51 2 58921 5 LsGetNbrsRxDigits [3] 58921 5 [MBcallerentry] Number Input 7732873 59640 5 tapie monitordigits 55 2 59640 5 LsGetNbrsRxDigits [7] 59640 5 [MBcallerentry] Number Input 77328737 59968 5 tapie monitordigits 54 2 59968 5 LsGetNbrsRxDigits [6] 59968 5 [MBcallerentry] Number Input 773287376 60203 5 tapie monitordigits 53 2 60203 5 LsGetNbrsRxDigits [5] 60203 5 [MBcallerentry] Number Input 7732873765 60203 5 fn PlaySoundStartNumbers C:\Program Files\VoiceGuide\system\voicedlgc\GetNbrsConfirmIntro.wav, C:\Program Files\VoiceGuide\system\voicedlgc\GetNbrsConfirmMenu.wav, 7732873765, Digits 60218 5 twcal PlaySayNumber C:\Program Files\VoiceGuide\system\voicedlgc\GetNbrsConfirmIntro.wav, C:\Program Files\VoiceGuide\system\voicedlgc\GetNbrsConfirmMenu.wav, 7732873765, , 1 60250 5 PlaySoundStartNumbers ok 76093 5 wb(76021811) 76140 5 Play End line[5] (id=760218) 76140 5 LsGetNbrsPlayConfirm EV_PLAY_FINISHED 85031 5 tapie monitordigits 49 2 85031 5 LsGetNbrsPlayConfirm [1] 85031 5 PlaySoundStop ok 85031 5 [Exit-Goodbye] Playing 85031 5 [Exit-Goodbye] Playing (C:\Program Files\VoiceGuide\Scripts\newgoodbye.wav) 85062 5 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\newgoodbye.wav] 85062 5 RunModule PLAY end 88140 5 Play End line[5] (id=785046) 88140 5 LsPlayMsg EV_PLAY_FINISHED 88140 5 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE 88140 5 [Run Program 7] Run Program 88140 5 Run Program Failed, err[5:Invalid procedure call or argument] running[C:\Program Files\VoiceGuide\data\VGRUNRESULT_1.TXT] 88156 5 HangupCall called from [Run module 2369] 88156 5 Hanging up call... 88156 5 PlaySoundStop ok 88156 5 fnHangupCall end 88203 5 tapie linedevstate 2048 0 0 88203 5 tapie callstate IDLE 66169 0 0 88203 5 WorkingMode@Idle= 88203 5 set EV_TIMEOUT_TIMETOREINITLINE 2 88203 5 tapi Reply 66219 0 89265 5 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE 89265 5 ReinitTelephony due to IDLE start 89265 5 tapic lineDeallocateCall(MainCall:66169) 0 89406 5 lineOpen(5) => 0 89406 5 Waiting for a call... 89406 5 lineOpen(5)LineHandle=66236 Thanks! Share this post Link to post
SupportTeam Report post Posted 07/17/2003 01:45 AM Retrieving and setting data from/to Excel spreadsheets can be done quite easily using the Run VB Script module. The following examples show how to work with Access. You will need to look at other samples to see how to use Result Variables and how to return data to VoiceGuide from VB Script. From VoiceGuide Help file ("Modules -> Run VB Script" section) Example 6: The VB Script below retrieves information from an Excel spreadsheet. Dim xlApp 'Excel.Application Dim xlBook 'Excel.Workbook dim xlSht Dim filename, value1, value2, value3, value4 filename = "c:\Warehouse.xls" Set xlApp = CreateObject("Excel.Application") set xlBook = xlApp.WorkBooks.Open(filename) set xlSht = xlApp.activesheet value1 = xlSht.Cells(2, 1) value2 = xlSht.Cells(2, 2) msgbox "Values are: " & value1 & ", " & value2 xlBook.Close False xlApp.Quit Set xlBook = Nothing Set xlApp = Nothing Example 7: The VB Script below saves information to an Excel spreadsheet. Dim xlApp 'Excel.Application Dim xlBook 'Excel.Workbook dim xlSht Dim filename, value1, value2, value3, value4 on error resume next filename = "c:\warehouse.xls" Set xlApp = CreateObject("Excel.Application") set xlBook = xlApp.WorkBooks.Open(filename) set xlSht = xlApp.activesheet xlApp.DisplayAlerts = False 'write data into the spreadsheet xlSht.Cells(2, 2) = "New Data" xlBook.Save xlBook.Close SaveChanges=True xlApp.Close xlApp.Quit set xlSht = Nothing Set xlBook = Nothing Set xlApp = Nothing Share this post Link to post
