VoiceGuide IVR Software Main Page
Jump to content

Export Entered Numbers To File

Recommended Posts

Good day all,

 

I have a quastion we use here voiceguide and it all works perfect.

But the thing we want to have is that people can type there number in and that the number is exported to an MS exel file like *.xls or *.csv is this possible? i know that they can type there number and that it is beiing verifyed but i want to export it.

 

Please HELP !!!

 

Thanks,

 

Regards DenD

Share this post


Link to post

Hey,

If you dont want to go to net, you may also find it in your machine if Voiceguide inatalled. Start-->Programms-->VoiceGuide-->User's Guide-->Modules References-->RunVBScript

You may find here so many usefull vb scripts.

rajendrarajsri@yahoo.co.in

Share this post


Link to post

Thanks but when i type this in the vb script:

 

Const ForReading = 1

Const ForWriting = 2

Const ForAppending = 8

set fso = CreateObject("Scripting.FileSystemObject")

set tsFile = fso.OpenTextFile("C:\LogCalls.txt", ForAppending, True)

tsFile.WriteLine "$RV[EnterClientNumber]"

tsFile.Close

set tsFile = Nothing

set fso = Nothing

 

 

Than it still doesnt work the file logcalls.txt stay's empty??

any idea what i do wrong?

 

Regards DenD

Share this post


Link to post

If you are simply writing a number to an Excell spreadsheet (i.e. not reading information from the spreadsheet to be spoken to the caller) then you could use the DDE Send module instead of getting wrapped up in VBS.

 

This module sets up a DDE link to the spreadhseet and can write values to specific cells in the sheet.

 

Its cheap and cheerful but seems to work.

Share this post


Link to post

Hello,

This script will work only when the file exist. If the file does not exost then you have to open the file "for writing" instead of "for appending". I think this will work.

 

rajendrarajsri@yahoo.co.in

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
×