Voice mail server and Presence Server information for Cius

Version 1
    This document was generated from CDN thread

    Created by: Azhagappan Sivaraman on 16-03-2012 06:55:23 AM
    Hello,
     
    Can you please tell me how which axl api should I use to provide Voice mail Server address, Presence Server address and Chat Server type for Cius.
     
    To provision Cius for voice mail and presence, I have to provide these unlike other hard phones. These parameters are under product specific Configuration Layout.
     
    I am using AXL 8.5.
    Please check the screen shot. 
     
     
    Thanks,
    Azhagappan Sivaraman

    Subject: RE: Voice mail server and Presence Server information for Cius
    Replied by: David Staudt on 16-03-2012 05:52:56 PM
    The 'Product Specific Configuration' area is unique to each device type, and the contents are stored as a more or less free-form XML field in the UCM database.  The data is sometimes referred to as the 'vendor config' data, as it can be customized by 3rd party device vendors.
     
    Access to this data is available from AXL by accessing two stored procedure dbreaddevicexml/dbwritedevicexml.  Details here:
     
    http://developer.cisco.com/web/axl/wikidocs?p_p_id=1_WAR_wikinavigationportlet_INSTANCE_i9JW&p_p_lifecycle=0&p_p_state=normal&p_p_mode=view&p_p_col_id=column-1&p_p_col_count=1&p_r_p_185834411_nodeId=803208&p_r_p_185834411_title=Frequently+Asked+Questions#section-Frequently+Asked+Questions-TheSQLDeviceTableInUCM8.0NoLongerContainsAnXMLFieldForStoringVendorConfigCustomXMLConfigurations.HowCanIReadWriteThisData
     
    The are a couple of considerations:
     
    - There are no published schemas or other meta data for the different vendor configs for different models.  If you need to manage these in detail for multiple models, you will need to reverse engineer
    - The data is also available via direct executeSQLQuery, however the data may be in either devicexml4k or devicexml8k tables.  The stored procedure is provided to avoid having to look into both tables.
    - The XML is provided or consumed in an XML CDATA[] wrapper
    - The dbreaddevicexml procedure requires the phone pkid (uuid), and note that it has to be in the correct case.  When I did an initial getPhone for my Cius, the uuid for the phone returned was in uppercase, however dbreaddevicexml had to have it in lowercase in order to find the device
     
    Example from my 8.5(1)
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.5">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:executeSQLQuery sequence="1">
             <sql>execute procedure dbreaddevicexml('313c7fc2-68cd-bf25-e847-47fde452d2b5')</sql>
          </ns:executeSQLQuery>
       </soapenv:Body>
    </soapenv:Envelope>
    -------------------------
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
       <soapenv:Body>
          <ns:executeSQLQueryResponse xmlns:ns="http://www.cisco.com/AXL/API/8.5">
             <return>
                <row>
                   <expression><![CDATA[<spanToPCPort>0</spanToPCPort><garp>1</garp><lockDevice>0</lockDevice><wipeDevice>0</wipeDevice><webAccess>0</webAccess><androidDebugBridge>1</androidDebugBridge><appInstallFromUnknownSrc>1</appInstallFromUnknownSrc><appInstallFromAndroidMarket>true</appInstallFromAndroidMarket><enableCiscoUcmAppClient>true</enableCiscoUcmAppClient><companyPhotoDir>http://testurl/photo</companyPhotoDir><voicemailServerPri>http://testurl/vm</voicemailServerPri><voicemailServerBkup>http://testurl/vm2</voicemailServerBkup><presenceServerPri>http://testurl/im</presenceServerPri>]]></expression>
                </row>
             </return>
          </ns:executeSQLQueryResponse>
       </soapenv:Body>
    </soapenv:Envelope>
     
     

    Subject: RE: Voice mail server and Presence Server information for Cius
    Replied by: Azhagappan Sivaraman on 22-03-2012 01:46:16 AM
    Hello David,

    Thanks.. Will try to configure my cius with the above information.

    Regards,
    Gappan