Database

[Guest Dave]

How do I cycle through a list in a database to call. it seems that the getquery is made for one call or the script for that matter...I want to cycle through a list and the list is in a database. I don't want to use that dialer thing that loads phone numbers.

[SupportTeam]

Can you please explain in more detail what you want to achieve - perhaps giving a specific example as well.

[Guest Dave]

I have a list of numbers in a database. I want to cycle through the numbers. It will dial number ask user code code and then put the code back into the database.

[SupportTeam]

If you do not want to use the "VoiceGuide Telephone Number Loader" GUI application then you can add the numbers to be dialed into VGDialer using either:

 

1. OutDial_New.xml file,

see: http://www.voiceguide.com/vghelp/html/DialListInto.htm

 

or

 

2. Dialer_OutDialQueAdd COM function,

see: http://www.voiceguide.com/vghelp/html/com_...tDialQueAdd.htm

 

From inside the VoiceGuide script you can access your own database to update any values etc.

[Guest Guest]

But how do I cycle and repeat the script for each record. Where would I put the code that says..

 

 

While

 

Read Rec

Play script

Next Rec

 

End While

[SupportTeam]

Inside your application/script which would be responsible for generating the OutDial_New.xml file or calling the Dialer_OutDialQueAdd COM function.

(suggest you use the Dialer_OutDialQueAdd COM function)

[Guest Dave]

When you say inside my application. Do you mean inside of the script editor. How? Can you show a small example?

[SupportTeam]

What event would start off the process of going through your database and selecting the outbound calls to be made?

 

Is this something you want to do in response to the callers' selection (in which case you can do it using a loop of DB Query modules and Send Phone Message modules).

 

If you want to load the number of calls to be made from some external program/script then you have to write all that yourself in the programming language of your choice.

 

Either way the approach is to load all the numbers at once - not load one, then call, then load another. You load them all in and then you let VG make the calls and handle redials on no-answer etc etc.

 

If the purpose of the while loop is to keep control of escalations then there is another way of doing this in VG - please read the section on escalations in the VG Help file: http://www.voiceguide.com/vghelp/html/DialListInto.htm