How To Fetch Scripts From Mysql

[jeh]

Hi all,

 

We are using 'VoiceGuide for TAPI v5.2.5049' for outbound calling purpose. We installed it comfortably. But we need to fetch scripts from db, because of, to meet our requiements.

 

Is it possible to get scripts from db?

 

Anyone knows, please help me.

[SupportTeam]

What do you mean by "fetch scripts from DB" ?

 

Retrieve the entire .vgs file from DB and then goto/gosub to it?

 

If that's what you want to do then you could just use a 'DB Query' module to retrieve the .vgs file text from DB and save the retrieved data in a file (ending in .vgs). Then you can goto/gosub to that retrieved script by just specifying the filename (and optionally the starting module).

 

BTW. for outbound calls you should be using a VoiceGuide v7 based system with a Dialogic card.

 

Please let us know if you have any questions.

[jeh]

First of all thanks for your swift reply.

 

Yes, We need to retrieve the entire .vgs files from DB. We are using MYSQL + PHP.

 

It is helpful to me, if u post any sample scripts or examples about 'DB query' to understand better.

[SupportTeam]

We are using MYSQL + PHP.

How are you using PHP?

 

It is helpful to me, if u post any sample scripts or examples about 'DB query' to understand better.

Please see attached script. It shows the approach.

 

What type of system are you deploying?

Are you using VoiceGuide to host an IVR service and allowing various customers to upload their own scripts through a WWW portal?

jeh.zip

[jeh]

Hi,

 

We are the one who host and manage the IVR system and the Customers are not involved in this system. Customers receive the call (script/questions) from our IVR system and reply back to us by simple answering option "yes" or "no" by press key 1 or 2 respectively. These replies are saved in a database for report generation. One important element in this system is to alert us when the reply is "yes", if reply is "no" system not alert us and just save the reply in the database.

 

Hope I've clarified you.

 

 

How are you using PHP?

 

 

Please see attached script. It shows the approach.

 

What type of system are you deploying?

Are you using VoiceGuide to host an IVR service and allowing various customers to upload their own scripts through a WWW portal?

[SupportTeam]

Customers receive the call (script/questions) from our IVR system and reply back to us by simple answering option "yes" or "no" by press key 1 or 2 respectively. These replies are saved in a database

So all you want to just save responses in the database, and alert, correct?

 

This is very different then "fetch scripts from db" and "We need to retrieve the entire .vgs files from DB" that you specified in your previous posts.

 

To save data to database just use an INSERT or UPDATE SQL statement in a Database Query type module. If you have problems doing that then .ZIP up and post your script and we'll have a look at it and advise how to get it working.

[jeh]

Yes, we need to save responses in the databases. As well as, outbound call goes to multiple users simultaneously or on regular basis.

 

For example, see the attached file. It had a list of customers we need to call. We need to fetch those customers phone number or mobile number using queries and show in 'Que telephone numbers to call'. After all, the outbound call goes to those customers and saving responses in table.

customers.sql.zip

[jeh]

Hi,

 

In one of your reply you have stated that for outbound calls we should be using a VoiceGuide v7 based system with a Dialogic card. Shall we use any other card like GSM rather than dialogic card? If you know any substitute for Daialogic card kindly do let us know.

[SupportTeam]

This section of the Help file covers how calls can be loaded to be made with VoiceGuide Dialer:

 

http://www.voiceguide.com/vghelp/source/html/diallistinto.htm

 

http://www.voiceguide.com/vghelp/source/html/dial_vgdb_external_config.htm

 

Dialogic card is pretty much the only choice if you want to have a working outbound dialing system.

 

Please start a new thread if you have a question on a new topic in future.

[jeh]

Ok i go through these and comeback to u if i have any questions.