My First Script - Please Bear With Me ;-)

[Guest Geoff R]

This is my first script, and I am using the module pane. I feel a little in the dark, so if you don't mind, I'll share what I hope to achieve, in case you can guide me a little.

 

The script starts with a welcome message, and asks for a customer number.

 

Then asks for customer to enter a specific service number...

 

The customer then records their message.

 

They can then replay it, confirm it.

 

I then need to name the .wav file depending on the service selected, and upload the wav file via ftp to server details from their customer account.

 

I think I would like to validate the user as I go, from a DB, so that I can confirm he/she is a real customer. I'm not sure how to do this ... do I do this with a script in the RUN module after each input?

 

I looked at some sample scripts but couldn't find quite what I wanted.

 

Thanks, this is the first time I have used anything like this before. Any help, sample scripts that come close to this, etc., would be really appreciated.

 

Geoff

[Guest Guest_zackrspv]

Hello.

 

We validate users using different information based on where they are in the menu; all of this, of course, is in a database; for example:

 

Section Registration:

 

System records CID Name and CID Number (if availalbe)

If not available it prompts the user to enter their phone number and (first 4) of their name.

 

System then asks them to create a PIN number and records that

 

System then repeates the information back to the user, the CID Name, Number, Pin Number and then gives them an AIN (which is an authentication number (a random 4-8 digit number).

 

Every time they call in, the system validates them with the CID Name and CID numbers, and then will (if a match occurs) ask them for either their AIN or PIN. If all of that information is correct, they then are processed through the rest of the menu.

 

If some of the information is incorrect, they are given 3 chances to enter the correct information (or missing information) and are required to enter their AIN; upon failure the system will REFUSE to allow access via that PIN number unless a system operator resets the field in the database (which is simply a '1' in a 'Lock' field.)

 

All of this is done by using the Evaulate Expression Module and the Database Lookup Module.

 

We use Microsoft Access; it is pretty simple; just goto the help file and look under ODBC or Database and you'll see step by step instructions on how to do all of this.

 

Also, search the forum here, many users, myself included, have asked and posted alot about DATABASE queries and such.

 

Your situation is quite simple enough; a simple 4 field database with the information that you have, and a database query module is all you need.

 

Thanks!

[SupportTeam]

I think I would like to validate the user as I go, from a DB, so that I can confirm he/she is a real customer. I'm not sure how to do this ... do I do this with a script in the RUN module after each input?

To see if the customer number exists you should have a database of all customers and then use a "DB Query" module to see if the customer number exists in your database...

Recommend you read through the VG Help files's section on "DB Query" module...