Split Table/Calling list

[fred.s]

Hi,

This may be a quick one for you to answer..... we have Genesys Outbound Contact Manager 7.6

Is there a way that I can split a table into 5 equal portions (filters), in order to create 5 Callings list?

Background;
we are looking to set up individual Agent/Place specific campaigns for each of our agents to work from their own lists/campaigns.

I guess I would then need to set up 5 of each -  Filters, calling lists, campaigns and agent/place groups?

Is there an alternative solution that your are aware of?

Any advice/tips would be much apprecieated.

[Vikram_Joshi]

Hi fred,

I have just posted a very similar query before reading your post.... 

http://www.sggu.com/smf/index.php/topic,7422.0.html


Regards,
Vikram

[fred.s]

I forgot to include that these Campaigns will be dialled in PREVIEW Mode.

Thanks

[bublepaw]

Hi,

As far as I remember it is possible to attach multiple calling list to same campaign and define ratio which tells OCS how many records from each list should be taken (parameter is called List weight). One comment there is no tool to split exisiting one table into multiple tables. Still having one table You can create multiple Calling list from same table by applying different filter for each calling list.

Pawel

[fred.s]

thanks bubelpaw.

Anyone aware of a query that I can use for each filter?? In order to split the records equally?

[bublepaw]

Hi,

something like this should help (it is for MS SQL):

- first cl - xxx%4 = 0
- second cl - xxx%4 = 1
- third cl - xxx%4 = 2
- fourth cl - xxx%4 = 3

4 = number of calling lists
xxx - any autoincremental field in table

This trick works only if field xxx contains consequtives values

[fred.s]

superb thanks.