Line Selection Problem

[Guest hogi]

I'm using an external MSSQL 2k Database where I add my outgoing calls.

I need to make sure that I dial out on the right line but VG will only dial out when the db field "LineSelection" = "NULL".

When I try to specify the line id (dxxxB1C2 or 2) the call just sits in the que and nothing happens (as soon as I update the field to "NULL" the call starts.

 

Pointers?

[Guest hogi]

I have a 4 line version 6.0.3243 Enterprise with dialer for Dialogic.

Here is my MSSQL 2k db schema:

CREATE TABLE [dbo].[CallQue] (

[iD] [int] IDENTITY (1, 1) NOT NULL ,

[PhoneNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ActivateTime] [int] NULL ,

[DayTimeStart] [int] NULL ,

[DayTimeStop] [int] NULL ,

[DaysCallAllowed] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[LineSelection] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Priority] [int] NULL ,

[AnnounceMessage] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[script] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[OnAnswerMachine] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[RV] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[AnswerTimeout] [int] NULL ,

[CallRetriesLeft] [int] NULL ,

[DelayBetweenRetries] [int] NULL ,

[OnNotConnected] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Options] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[EscalationCalls] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

[SupportTeam]

Try:

 

,dxxxB1C2,

 

or

 

,2,

 

(Have a look at how the Telephone Number Loader saves similar information in the defalt MSAccess database.)