Voice Guide Developer $$

[Guest Juga Guru]

We would like to develop a store value card upload program for internal use. Interested Party pls leave email/Phone for contact.

 

Harware: Celeron 1.2G, 40G Harddisk, 256MB Memory, Robotics Sportster Voice Modem

Software: Windows XP/2000, Traditional Chinese version

 

Deliverable includes source code.

 

Pls suggest which version of Voice Guide to buy, delivery schedule and budget!! Urgent.

 

 

Specification are as following:

 

1. read all parameters input from the cfg.ini ( see below cfg.ini ) from the default directory

2. process all *.xls from the Data_dir,

3. For each .xls file, use worksheet Sheet_name

4. start from Start_Row

5. if cell(Column A, Start_Row) not null

6. Get dial tone from Voice Modem

7. if not Skip_DTMF_1 then

Send DTMF_1 in band followed by Pause_Time_1

endif

8. Send DTMF_2 in band in band followed by Pause_Time_2

9. Send DTMF_3 in band followed by Pause_Time_3

10. Send DTMF_4 in band followed by Pause_Time_4

11. Send DTMF_5 in band followed by Pause_Time_5

12. Send Column A + "#" in band followed by Pause_Time_6

13. Send Column A + "#" in band followed by Pause_Time_7

14. Send DTMF_8 in band followed by Pause_Time_8

15. Send Column B + "#" in band followed by Pause_Time_9

16. update Column C with "Done", Column D with current date time(format=text, mask=yyyy-mm-dd-hh-mm-ss), save work sheet

17. go to next row in Excel file

18. if not cell(Column b, next Row) null

19. if cell(Column A, next Row) is null

Send DTMF_10 in band followed by Pause_Time_10

goto 15

else

Hang up line

go to 6.

endif

else

Hang up line

endif

20. Hang up line

21. endif

 

 

 

cfg.ini

 

Data_dir

 

Sheet_Name

 

Start_Row

 

Skip_DTMF_1

 

DTMF_1 ;1st stage dial #

Pause_Time_1

DTMF_2 ;2nd stage dial #

Pause_Time_2

DTMF_3 ;Card service selection

Pause_Time_3

DTMF_4 ;Card Language Selection

Pause_Time_4

DTMF_5 ;Card Function

Pause_Time_5

Pause_Time_6 ;Telephone #

Pause_Time_7 ;Telephone # confirm

DTMF_8 ;Store Value Selection

Pause_Time_8

Pause_Time_9 ;Card Pin

DTMF_10 ;Continue Store Value

Pause_Time_10

 

 

Excel File Format

Column A: Telephone Number (TEXT)

Column B: Card Pin (TEXT)

Column C: Status (TEXT)

Column D: Update Date Time (TEXT)

 

 

 

Must work with Voice Card also.

[SupportTeam]

You will require VoiceGuide Pro + Dialer.

 

From what I can see here one of the approaches could be to just create a dial string up to about 'DTMF_5' using DTMF tones and comma characters for pauses.

 

Then use that dial string as the telephone number to be called when adding an entry to the DialListNew.txt file (see the 'Auto Dialing' chapter in the VoiceGuide Help file), with 'strAnnouce' set to "none", and the script points to a VGS script which reads data from Excel and plays out the digits...

 

You may prefer to use a Dialogic card, as for these cards you can set the length of the pause (",") character - and then when creating the dial string you can easily calculate how many pause characters would be needed between each successive sequence of DTMF tones.

 

An example of a VB Script which reads Excel files is also included in VG Help file (Run VB Script module 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