[cisco-voip] Implement UCCX Geographic Inbound Call Routing using callers area code

Mon Sep 30 21:59:39 EDT 2013

Chase,

That XPATH can be condense like so:

"//[@number='" + ani + "']/csq"

You could also condense the XML to:

<?xml version="1.0" encoding="utf-8"?>
<triggers>
<trigger number="17631112222">CSQ</trigger>
</triggers>

And then your XPATH is simply:

"//[@number='" + ani + "']"

However, Grace is looking for a solution based on caller's area code, which
would involve at least one more step: pulling the area code out of the
calling number.  So Grace, this is how you pull an area code from the
calling number.

ani = Get Call Contact Info (Calling Number)
Set area_code = ani.substring(0, 3)

And now at this point, one could use the XML file approach as Chase has
pointed out.

<?xml version="1.0" encoding="utf-8"?>
<areas>
<area code="612">Midwest_CSQ</area>
<area code="305">East_CSQ</area>
</areas>

Of course that can be a large file considering there are almost 300 area
codes in use today, and that number is growing towards its current maximum
potential of 800 numbers.  In an effort to shrink that document, you could
compress the data yourself like this:

<?xml version="1.0" encoding="utf-8"?>
<a><b c="612">0</b><b c="305">1</b></a>

We're just using single characters to represent the tag names, and numeric
values for the CSQ names.  You will need a String Array to convert the
digit value of the CSQ into the actual CSQ like this:

Variable

String[] csq_map = new String[] {"Midwest_CSQ", "East_CSQ"}

Script

result = Get XML Document Data(xml_doc, "//[@c='" + ani + "']")
Set csq = csq_map[Integer.parseInt(result)]

If you haven't worked with String Arrays yet, just know that each element
in the array has an associated value, or index, and it starts with 0 on the
left, and goes up incrementally from there to the right.  So in the above
example, Midwest_CSQ is 0 and East_CSQ is 1.

At this point, your csq variable holds the name of the CSQ, and you saved
yourself some amount of JVM heap usage.  The reason this saves space is
because if you have 150 area codes for which CSQ NorthCentralSupport_CSQ (a
23 character name) serves, then without the trick you need at least 150 *
length of CSQ Name, which is 3.4KB.  With the trick I used, you get the
text alone down to 150Bytes (the character "0" used 150 times).  That's a
96% decrease.  Now, the String Array doesn't come for free, and there is a
formula to figure it out, but I'd wager you're fine doing without the
compression at all, therefore compression is just icing on the cake.  Just
use RTMT perfmon counters to watch your JVM heap usage.

You could alternatively use a java switch block and keep all dependencies
right inside the script, but I don't know if the XML functionality is a
requirement for you or not.

Example:

Do {

switch (area_code) {

case "612": case "763": case "651":

csq = "Midwest_CSQ";

break;

case "305": case "786":

csq = "East_CSQ";

break;

default:

csq = "Default_CSQ";

}

}

This has the advantage of not having to assign the csq variable for each
area code in the US, rather you do it for blocks of csq's rather easily, as
I have demonstrated.  If you needed this to be available to a few other
scripts, consider making it a sub flow which takes 1 input mapping of the
ani, and provides 1 output mapping of the mapped csq name like so:

area_code_lookup.aef
Variables

String csq = ""
String ani = ""

Script

Start
On Exception (WFExecutionException) Goto End of Script
Do {

switch (ani.substring(0, 3)) {

case "612": case "763": case "651":

csq = "Midwest_CSQ":

break;

case "305": case "786":

csq = "East_CSQ";

break;

}

}
End of Script:
End

main_aa.aef
Variables

String csq = ""
String ani = ""

Script

Start
Accept(--Triggering Contact--)
ani = Get Call Contact Info (Calling Number)
csq = Call Subflow (SCRIPT[area_code_lookup.aef], Input: ani, Output: csq)
Set csq (csq == null || csq.trim() == "") ? "Default_CSQ" : csq
Select Resource (--Triggering Contact-- from csq)

Connected

End

Queued

...queue logic...

End

There's many different ways to solve for this requirement.  Which one you
pick should meet the objective first, and then be easy to troubleshoot and
administer second.  The rest is subjective.  In my opinion...of course!
 Haha.

Good luck.

On Mon, Sep 30, 2013 at 3:29 PM, Chase Mergenthal <
cmergenthal at digitalriver.com> wrote:

>  Conceptually this is how you could do it:****
>
> ** **
>
> ****
>
> ** **
>
> Xml doc:****
>
> ** **
>
> <triggers>****
>
> ** **
>
> <trigger number="17631112222”>****
>
> <csq>CSQ</csq>****
>
> </trigger>****
>
> ** **
>
> </triggers>****
>
> ** **
>
> ** **
>
> Chase Mergenthal *|* Digital River****
>
> p: +1 952 225 3202 *|* cmergenthal at digitalriver.com *|* digitalriver.com<http://www.digitalriver.com/>
> ****
>
> 10380 Bren Road West, Minnetonka, MN 55343, United States****
>
> ** **
>
> *From:* cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] *On Behalf
> Of *Grace Maximuangu
> *Sent:* Monday, September 30, 2013 3:14 PM
> *To:* Anthony Holloway; Ryan LaFountain (rlafount);
> cisco-voip at puck.nether.net
> *Subject:* [cisco-voip] Implement UCCX Geographic Inbound Call Routing
> using callers area code****
>
> ** **
>
> Hi all,****
>
> I have a customer requirement, when a call is placed into the call center,
> the script needs to query an xml file using Xpath (they do not want to do a
> database lookup at this time)  to determine what CSQ to place the call in.
> ****
>
> Has anyone done this before?****
>
> Or does anyone have a sample code that can be modified to satisfy this
> requirement?****
>
> ** **
>
> :-:gm****
>
> ** **
>
> Grace Maximuangu****
>
> Voice Solutions Engineer****
>
> *Black Box Network Services*
>
> Cell: 213.268.6342****
>
> grace.maximuangu at blackbox.com****
>
> www.blackbox.com ****
>
> ** **
>
> [image: bbox logo.JPG]****
>
> ** **
>
> ** **
>  ------------------------------
>
> This email and any files transmitted with it are confidential and are
> intended for the sole use of the individual to whom they are addressed.
> Black Box Corporation reserves the right to scan all e-mail traffic for
> restricted content and to monitor all e-mail in general. If you are not the
> intended recipient or you have received this email in error, any use,
> dissemination or forwarding of this email is strictly prohibited. If you
> have received this email in error, please notify the sender by replying to
> this email.****
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130930/18e99506/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 7182 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130930/18e99506/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4336 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130930/18e99506/attachment.jpg>