CCE 5.0 keyword Routing

[sfitzg]

CCE 4.1 was upgraded to 5.0 then 5.0.1 as one upgrade.
In CCE 5.0.1 Email keyword routing rules can be created but they cannot be assigned to a Queue. The Drop down list in CCE Control Panel for a queue is not populated so the rule cannot be completed.

Is keyword routing to another email queue supported in 5.0.1?

[droart]

Hey Simon -

We noticed the same thing in that it won't allow you to point it to a queue. However I did find an ugly way to go about this though. After about 20 mins or so I was able to make it work by playing with the two tables that control this feature. Let me know if you want more details.

-Dan

[sfitzg]

Thanks Dan,

I never got around to testing hacks to the database. I tried to change the database in the hope the changes would show up in control panel, but they don't. Did you use '1' as the queue type and the program ID as the destination and it worked?

Simon

PS The shoe is on the other foot now ;-)

[droart]

Simon –
Here is how I got it working.. The one thing that is a bit tricky is that the GUID is not automatically created for the QueueRuleId in the KBRQueueRules table. So you can manually create a GUID and drop it in that field. You can create the rules from the control panel and then reference the GUIDs for the RuleID in the KBRQueueRules Table. Here is a run down of the fileds and how I entered them to make it work..

QueueRuleId – manually generated GUID.
QueueId – Email Program ID on inbound emails.
RuleId – Rule ID generated from control panel that can be found in the KBRKeywords table.
QueueRuleIdOrder – I am not sure if this is a priority value but ‘1’ seems to work as an entry here.
RouteType – ‘1’ seems to work.
RouteToId – Program ID of the program that you want to send it to.
StrictRouting – True
Description - Null

-Dan