<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2900.3354" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>The biggest problem, however, with updating via SQL
is the fact that the RIS subsystem or whatever will not know you have made a
change. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've done this before where I have used SQL to
update a field and the change did not take place. So basically, the database had
a DN forwarded but when you called the DN it rang.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Lelio<BR>--------------------------------------------------------------------------------<BR>Lelio
Fulgenzi, B.A.<BR>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario
N1G 2W1<BR>(519) 824-4120 x56354 (519) 767-1060 FAX
(JNHN)<BR>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<BR>...seen on a Geek Squad patch cord: "While it is the same length, this 7'
crossover cable<BR>is not regulation issue for most competitive Manhattan double
dutch leagues.</DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=egoppel@gmail.com href="mailto:egoppel@gmail.com">Erik Goppel</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=lelio@uoguelph.ca
href="mailto:lelio@uoguelph.ca">Lelio Fulgenzi</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, July 15, 2008 5:44
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [cisco-voip] Help wanted on
Callmanager 3.3.5 SQL query (URGENT!!!)</DIV>
<DIV><BR></DIV>
<DIV dir=ltr>
<DIV>AXL is one of things i`m focusing on myself for 4.x and higher, however
ccm 3.3.5 does not provide an axl interface, since that was introduced since
4.x</DIV>
<DIV>Our company has built quite some progs based on AXL to CCM, so not a
problem there. However since AXL cannot be used, and BAT is not sufficient
now, we need to use SQL.</DIV>
<DIV>As i am not a SQL guru, but do know some stuff, i am asking for help in
ways to manipulate the SQL database for the CFWNA item.</DIV>
<DIV>I know people have faced this before, so i am counting on some experience
facts to be shared here.</DIV>
<DIV>Yes i am fully aware, this is not officially supported by Cisco, however
this is a very short term solution (about a week), that the ccm 3.x cluster
needs to stay alive.</DIV>
<DIV>It is is just that during the transition to the new cluster (which
unfortunately cannot be a big bang), we need to be able to dynamically migrate
phones, as people use extension mobility, we do not know when certain dn`s
will be logging in to the new system, so routing between both should be
seamless.</DIV>
<DIV>We have achieved that, however the prereq is to set the cfwna on the old
cluster.</DIV>
<DIV> </DIV>
<DIV>So if anyone can help me out with an sql query that will update about
8000 dn`s, that would be excellent.</DIV>
<DIV>Also some advise regarding the update in the sql query, regarding
the need of restarting the ccm service, or creating the necesarry
dbnotify`s to the subs, would be welcome as well.</DIV>
<DIV> </DIV>
<DIV>Many thanks,</DIV>
<DIV> </DIV>
<DIV>Erik<BR><BR></DIV>
<DIV class=gmail_quote>On Tue, Jul 15, 2008 at 10:47 PM, Lelio Fulgenzi <<A
href="mailto:lelio@uoguelph.ca">lelio@uoguelph.ca</A>> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV bgcolor="#ffffff">
<DIV><FONT face=Arial size=2>Two options I can think of....1) learn AXL.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The other option, which could probably be done
with some thought is to hack the ccmuser pages. When you press the submit
button on forward page it will check which items are checked and submit the
value to the publisher for update. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm sure you could get a half decent web
programmer to come up with a system that could mimic this. By doing an SQL
query and outputing the pkid for each extension you want to forward and
building a whole bunch of posts, I'll bet it could be done.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV>Lelio<BR>--------------------------------------------------------------------------------<BR>Lelio
Fulgenzi, B.A.<BR>Senior Analyst (CCS) * University of Guelph * Guelph,
Ontario N1G 2W1<BR>(519) 824-4120 x56354 (519) 767-1060 FAX
(JNHN)<BR>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<BR>...seen on a Geek Squad patch cord: "While it is the same length, this
7' crossover cable<BR>is not regulation issue for most competitive Manhattan
double dutch leagues.</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>
<DIV></DIV>
<DIV class=Wj3C7c>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><B>From:</B> <A
title=egoppel@gmail.com href="mailto:egoppel@gmail.com" target=_blank>Erik
Goppel</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=cisco-voip@puck.nether.net href="mailto:cisco-voip@puck.nether.net"
target=_blank>cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, July 15, 2008 9:31
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [cisco-voip] Help wanted on
Callmanager 3.3.5 SQL query (URGENT!!!)</DIV>
<DIV><BR></DIV>
<DIV dir=ltr><SPAN><FONT color=#008000>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi,</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Currently we are facing a
customer migration scenario, where we need to set the Call Forward No
Answer of the lines in their old cluster to a specific
value.</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">BAT does not cover this
functionality in this version, so we need to do some SQL stuff
here.</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">What we need is to set the
CFWNA for the line, for example:</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1000 needs to have the
CFWNA set to 1#1000</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1001 needs to have the
CFWNA set to 1#1001</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1002 needs to have the
CFWNA set to 1#1002</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">,etc………</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can ayone provide my with some
SQL help here to accomplish this?</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We need to do this for around
8000 DN`s, and our migration starts this weekend.</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Many thanks in
advance,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Erik</SPAN></FONT></DIV></FONT></SPAN></DIV></DIV></DIV>
<P>
<HR>
<DIV class=Ih2E3d>
<P></P>_______________________________________________<BR>cisco-voip
mailing list<BR><A href="mailto:cisco-voip@puck.nether.net"
target=_blank>cisco-voip@puck.nether.net</A><BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
target=_blank>https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR></DIV>
<P></P>
<P></P></BLOCKQUOTE></DIV></BLOCKQUOTE></DIV><BR></DIV></BLOCKQUOTE></BODY></HTML>