Anyone know how to assign an IPCC extension to a user using AXL?

Version 1
    This document was generated from CDN thread

    Created by: Jeffrey Sailers on 24-07-2009 09:58:55 PM
    The updateUser AXL Call allows you to set the Primary Extension, but I don't see an option for setting the IPCC extension.  I can't even find any reference to it in the Data Dictionary.  Using CUCM 6.1.3.
     
    Thanks in advance.

    Subject: RE: Anyone know how to assign an IPCC extension to a user using AXL?
    Replied by: Sascha Monteiro on 05-08-2009 06:43:00 PM
    Hi,
     
    We ran into the same issue (inlcuding more settings like Subscribe CSS etc), and you can set it via AXL do SQLUpdate,
    it does set it in hte DB, but still need to test if IPCC really sees it..
     
    <sql>insert into endusernumplanmap (fkenduser,fknumplan,tkdnusage) values((select pkid from enduser where userid='john.doe'),(select numplan.pkid from numplan join routepartition on(routepartition.pkid = numplan.fkroutepartition) where numplan.dnorpattern = '12345' and routepartition.name = 'P_Internal'),'2')</sql>
     
    as you see, you need an entry where tkdnusage=2 for IPCC extn

    Subject: RE: Anyone know how to assign an IPCC extension to a user using AXL?
    Replied by: Jason Rohm on 13-09-2011 01:05:55 AM
    Note to future people who stumble upon this very useful message...

    The above query works very well except the SQL query is case senstive by default, so if you aren't consistent with the case of the UID, it is going to cause problems.

    I worked around the issue by always querying in uppercase since, even though the UID is case senstive, you should never have multiples with different case.

    Modified query:

    <sql>insert into endusernumplanmap (fkenduser,fknumplan,tkdnusage) values((select pkid from enduser where upper(userid)='john.doe'),(select numplan.pkid from numplan join routepartition on(routepartition.pkid = numplan.fkroutepartition) where numplan.dnorpattern = '12345' and routepartition.name = 'P_Internal'),'2')</sql>

    Subject: RE: Anyone know how to assign an IPCC extension to a user using AXL?
    Replied by: Sascha Monteiro on 19-09-2011 07:29:42 PM
    Hi,
    My query assumes you retrieved the correct userid from the cucm, which will have correct casing..
     
    Your query will not work as you should upper the userid string as well;
    upper(userid)=upper('john.doe')

    Subject: RE: Anyone know how to assign an IPCC extension to a user using AXL?
    Replied by: Jason Rohm on 04-10-2011 10:27:35 PM
    Hi,
    My query assumes you retrieved the correct userid from the cucm, which will have correct casing..
     
    Your query will not work as you should upper the userid string as well;
    upper(userid)=upper('john.doe')

     
    You are correct. A 'safe' implementation would upper both items. I got away with it because I was passing previously 'upper'-d UIDs always.