Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: fred.s on September 11, 2012, 03:43:50 PM
-
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.
-
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
-
I forgot to include that these Campaigns will be dialled in PREVIEW Mode.
Thanks
-
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
-
thanks bubelpaw.
Anyone aware of a query that I can use for each filter?? In order to split the records equally?
-
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
-
superb thanks.