UCCX 9.0 Outbound IVR Campaign

Version 1
    This document was generated from CDN thread

    Created by: Rajasekar Padmanaban on 19-04-2013 05:33:18 AM
    Hi All, In UCCX IVR campaign i am trying to retrieve BAAccount number field in the script editor but no success. i tried the below options in the UCCX script editor but didn't work. Once contact is uploaded, dialer fields are sent to IVR application by default or is there any settings we need to do in UCCX admin? Thanks in advance for your help!
    1) Tried through ECC variables in Get Enterprise Call Info element
    2) Getting as session data through Get session element
    Thanks
    Rajasekar

    Subject: RE: UCCX 9.0 Outbound IVR Campaign
    Replied by: Steven Pawlak on 19-04-2013 08:38:18 AM
    This is a serious flaw in the OUtbound IVR setup. NONE of the data that you uploaded to the dialer is accessible in the resulting IVR script that you send the caller too. Like Inbound, the only thing you will know is the ANI of the caller, that is correctly handled. 
     
    All of the BA... values are for the Outbound Preview and can be pushed to the the desktop as Fields in a Layout. 
     
    Hope this helps. 

    Subject: RE: UCCX 9.0 Outbound IVR Campaign
    Replied by: Rajasekar Padmanaban on 19-04-2013 09:08:30 AM
    Hi Steven,
    Thanks for your response.
    Is there any way i can access the Database(Informix) to get the data i uploaded to the dialer?
     
    Thanks
    Rajasekar

    Subject: RE: UCCX 9.0 Outbound IVR Campaign
    Replied by: Steven Pawlak on 19-04-2013 09:20:07 AM
    Rajasekar,
    There is no way to get at the DB directly from inside the CCX script. 
    BUT, you could write a web service offboard that does remote back into the DB, get the data you want and then send back to the script as XML.
     
    Long Explain
    So the CCX script would call a web service on an external server (that someone needs to provide), the service then does an ODBC to the CCX database, queries the table, sends back the data. Then the CCX script can do things with this data. 
    Not pretty but the best we can do until they give us a way to get the data that was uploaded. 

    Subject: RE: UCCX 9.0 Outbound IVR Campaign
    Replied by: Rajasekar Padmanaban on 10-07-2013 04:09:25 AM
    Hi Steven,

    Thanks for your information.
    From CCX script we can not do ODBC to CCX database. How does a web service on an external server do that? Is there any published API available to do this? Please clarify.

    Thanks in advance.

    Subject: RE: UCCX 9.0 Outbound IVR Campaign
    Replied by: Steven Pawlak on 10-07-2013 08:11:12 AM
    You would set up an ODBC/JDBC connection to the database, on the 3rd party web server. This is described in the Historical Reporting Admin and Developer guide. This gives you read access to the tables. You also have the ability to execute current stored procedures and create new ones too. 

    From there you would write a web service to do what ever you want. I would suggest that you do a simple HTTP POST version so that you can use the Create URL Document step, and have the web service pass back simple XML. 

    Subject: RE: UCCX 9.0 Outbound IVR Campaign
    Replied by: Rajasekar Padmanaban on 11-07-2013 12:24:39 AM
    Hi Steven,

    I referred the document. We can access only reporting tables, I don't think we have access to other tables. my requirement is to get the details from campaign tables. Is it possible?

    Thanks
    Rajasekar

    Subject: RE: UCCX 9.0 Outbound IVR Campaign
    Replied by: Steven Pawlak on 11-07-2013 08:57:30 AM
    Rajasekar, 

    I just tried this on a 9.02 system and I was able to SELECT from the 3 campagin tables and the DialingList table too. 

    Have not tested all, but I believe that the uccxhruser account has SELECT rights on all tables in db_cra. 

    Hope this helps

    Steve

    Subject: RE: UCCX 9.0 Outbound IVR Campaign
    Replied by: Quan Shi on 08-08-2013 01:18:09 PM
    Hi, I am trying to achieve the same thing. So the ony info the IVR can have is the ANI. Is the ANI the customer number or the CTI port? Many Thanks.