Does anyone know of a way using JDBC to update the ICM database via CVP?  I wanted to try and disable a campaign using a dial in number and pressing an option, like an emergency shutdown off-site.  I can write the SQL but can't figure out what it would be.  I think when I save it in the Admin tool it does a lot more than I realize....or maybe not...maybe it just calls some function I might be able to call?  There isn't any XML admin tool for ICM so looking for a workaround.   And I tried changing the enabled flag to "N" (on a lab system of course) from "Y" on one of our lab DAW's but nothing, just changed on that DB, somewhere there must be a trigger to update everything, just can't find it.
 
Thanks,
Bill Westby.

Genius!!! Forgot all about the admin script capabilities, DUH! Thank you so much Luis!!
Bill Westby
Office: 1-818.576.3776
www.medtronicdiabetes.com


________________________________
From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
Sent: Tuesday, February 08, 2011 7:45 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Luis Yrigoyen in Customer Voice Portal (CVP) - CVP - All Versions: RE: Updating ICM DB from CVP

Luis Yrigoyen has created a new message in the forum "CVP - All Versions":

--------------------------------------------------------------
When you say a campaign, do you mean a dialer campaign?
How about using an ICM global variable and using CVP to change its value.
I built something like that for one of our customers; they wanted an ON/OFF switch for one of their dialer campaigns.
I created a user varaibale in ICM (which shows up under Global.user_NameOfVariable) I then created the logic on CVP to read the value of the variable, set its value to OFF or ON. In the administration script for that particular campaign I added an IF node to check the value of the variable and if ON then skillgroup.CampaignSkillGroup.outboundcontrol = OUTBOUND and if OFF then skillgroup.CampaignSkillGroup.outboundcontrol = INBOUND.
--
To respond to this post, please click the following link:

<http://developer.cisco.com/web/cvp/forums/-/message_boards/view_message/3028970>

or simply reply to this email.

[CONFIDENTIALITY AND PRIVACY NOTICE]

Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.

To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com