SQL for creating calling list in 6.5

[Ritchie]

Hi guys, below is the FAQ with SQL for creating a calling list in 5.1. What is the new SQL for doing this in 6.5?

Anyone any ideas?
Cheers


Campaign Manager FAQ #322: SQL to create a Calling List

Product: Campaign Manager 5.1 & 5.1.5

Question/Problem:
The following SQL will create a Campaign Manager 5.1 calling list.
The call list format should be created via CCE as the format creation
also creates a database table that is used for outbound logging.

Answer/Resolution:
Calling List SQL:

CREATE TABLE listname (record_id INT NULL ,phone VARCHAR( 64)
NOT NULL ,phone_type INT NOT NULL ,record_type INT NULL ,
record_status INT NULL ,call_result INT NOT NULL ,max_attempts INT
NULL ,attempt INT NULL ,call_time INT NULL ,dial_sched_time INT NULL ,
daily_from INT NULL ,daily_till INT NULL ,tz_offset INT NULL ,origination
VARCHAR( 220) NULL ,agent_id VARCHAR( 32) NULL )

INSERT INTO gsw_call_lists
(gsw_list_name, gsw_list_type, gsw_cl_fmt_name, gsw_records, gsw_list_
daily_from)
VALUES ('listname', 0, 'formatname', 0, 0)

CREATE INDEX listnamei0 ON listname (record_id)

CREATE UNIQUE INDEX listnamei1 ON listname (phone ,phone_type )

[gauthier]

In version 6.5 you need to create a New Calling list (see OCS deployment guide for how to do this) in the Configuration Manager at the table will be created automatically next time you start OCM.

[Ritchie]

Hi, I've no problem creating it through CME and OCM, but the developer wants to do it automatically when we get data, so I think I'll just steal the code from DBServer!