Report And Sql Queries For Callque

[Guest sanjayetsi]

Hello,

Is there any ready made sql queries for retrieving certain column values and also update columns.

 

I also want to know if there is a way to find out what are the file names (which has the list of numbers loaded). I understand that we can find the phone numbers from the CallQue database but what about the file names? Sometimes we do not know if we have already pressed start calling button or not when loading and dialing multiple files one after the other!

[SupportTeam]

Outbound calls loaded into the outdial que are made as soon as the 'Activation Time' is reached. If activation time is not specified then the call is made immediately.

 

What 'File Names' are you referring to?

 

What are you trying to achieve/retrieve?

[Guest sanjayetsi]

Outbound calls loaded into the outdial que are made as soon as the 'Activation Time' is reached. If activation time is not specified then the call is made immediately.

 

What 'File Names' are you referring to?

 

What are you trying to achieve/retrieve?

 

1) I am referring to 'File containg phone numbers to be called:' in the Telephone Number loader.

 

2) Suppose I have loaded 10 files daily with specific times for each file and specific scripts for each file. So now all the numbers are in the OutDialQue.mdb which has the table CallQue which has all the info in the 17 columns like ID, PhoneNumber, ActivateTime, DayTimeStart and so on. Now do you have some kind of ready made query to actually find out a) information on how many PhoneNumbers loaded with certain scripts

how many PhoneNumbers start at a certain time

c) how many PhoneNumbers have priority 1

d) To may be update Priority with 1 where Script value is say for example 'evening.vgs'

and so on with the other columns of CallQue table...

 

So do you happen to have some ready made queries at all. Ofcourse I can do this but do you have any resources for these types of queries?

 

Tnx

[SupportTeam]

The actual filename from where the sound files are loaded is not stored in the OutDialQue database. However you could specify the filename or other identifiers as part of the RVs or 'Options' fields which are saved along with the loaded entries.

 

2) Suppose I have loaded 10 files daily with specific times for each file and specific scripts for each file. So now all the numbers are in the OutDialQue.mdb which has the table CallQue which has all the info in the 17 columns like ID, PhoneNumber, ActivateTime, DayTimeStart and so on. Now do you have some kind of ready made query to actually find out a) information on how many PhoneNumbers loaded with certain scripts

The SQL query would be fairy simple for this. Something like this:

 

SELECT Count(*) FROM CallQue where Script='C:\My Path\My Script.vgs'

 

how many PhoneNumbers start at a certain time

SELECT Count(*) FROM CallQue where ActivateTime=704050648

 

notice how 704050648 is derived from date/time as would be written starting with the year, then month etc: 2007-04-05 06:48, ie: 5th April 2007 at 6:48AM

 

d) To may be update Priority with 1 where Script value is say for example 'evening.vgs'

UPDATE CallQue SET Priority=1 WHERE Script='C:\My Path\'evening.vgs'

 

As you can see having all data in one simple table allows all queries to be very straightforward. If you have problems with writing basic SQL queries such as the ones above then you should probably get an introductory book on SQL, or see websites like these:

 

http://www.w3schools.com/web/web_sql.asp

http://www.1keydata.com/sql/sql.html

 

A pretty good book on SQL is:

"SQL Queries for Mere Mortals" by Michael J. Hernandez, John Viescas

ISBN 0201433362