Telephone Number Loader

[Guest fsoudbakhsh]

Hello,

 

Here is what I am trying to accomplish, I will received emails from my customers which contain their telephone numbers. I will convert these emails from Outlook to MS access table. Then upload the Access Table to Telephone number loader.

 

I am hopping that, as Access table is updated automatically with new phone numbers by outlook, VG dialer would keep dial them.

 

 

If I am not right with this assumption, would you please let me know, how can I make dialer to dial phone number as access table is updated automatically?

[SupportTeam]

You should be updating the OutDialQue database directly from your application. Any entries inserted into the OutDialQue's table will be automatically picked up the be the dialer and the calls will be made.

[Guest fsoudbakhsh]

You should be updating the OutDialQue database directly from your application.

 

Do you mean my VG script by “application”?

I can do that easily, but since VG won’t start running until it received a call, I have to keep one line busy 24 hours, this is because I keep getting email and my script keep scheduling them in dialer.

 

Do you have any suggestion that I don’t keep one line busy at all the time.

[SupportTeam]

By application we mean whatever is checking for new emails on the email server.

[Guest fsoudbakhsh]

I can't see OutDialQue database in C:\Program Files\VoiceGuide\data?!

 

I do have this file in my other computers from earlier download, but now that I installed Voice Guide 5.2.5012 in my new computer I don't see it.

 

After download the Voice Guide 5.2.5012 several times, I even search C:\Program Files\VoiceGuide directory but I couldn't find it ether.

 

Would you please check the download file in your homepage contains OutDialQue database?

 

Thanks

[Harry L. Roberts]

I can't see OutDialQue database in C:\Program Files\VoiceGuide\data?!

 

Start VG Dialer and enter a phone number and select a script to be played when call is answered then select "Load Numbers" and VG Dialer will create the database for you.

 

You don't have to use any particular phone number just something to get VG Dialer to create the database. You can delete the entry after the database is created.

[Guest fsoudbakhsh]

thanks a lot. I see it now.

[Guest fsoudbakhsh]

Do I have to record to callque all the fields, or just Phone Number is enough?

[Guest fsoudbakhsh]

I have inserted the phone number into the CallQue via dialer.

And review every single field in the CallQue table.

 

Unfortunately can not find primary key on CallQue table. I have checked every single field in this table and none of them was primary key.

 

When I insert Phone number manually into the table; It keeps given me a message that the primary key can not contain a Null value.

 

Please let me know what field is a primary key. We are in the process of the developing new program for new market, and cann’t do any thing without your help.

[SupportTeam]

I think it may be easier for you to use the COM function Dialer_OutDialQueAdd

or the OutDial_New.xml file to add new calls into the system.

 

Adding calls directly to OutDialQue database is possible and has been done by others but it requires programming skills and knowing how to work with databases.

 

(You can look at the Database schema to see which entries are primary keys. However I think there should only be one and it's the automatically generated ID number...)

[Guest fsoudbakhsh]

thank for response,

The primary key is “Active time” field. I could successfully input the data in the CallQue and make Voice guide to dial the number for me.

Thanks

[SupportTeam]

"Active time" is not a primary key.

 

It is an indexed field however - maybe that's what you we referring to.

 

Sounds like things are working now, which is good news.