<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Subbaraman,<br>
<br>
<br>
You said you "added the CF to the Queue". If this CF will be used
for ALL queues, then you should make it a "Global" CF. If you try to
copy CF data from Queue 1, where it IS applied, to Queue 2, where it is
NOT applied, you won't get the results you want. The CF has to be
applied to ALL queues where it will be used. just a thought.<br>
<br>
<br>
Kenn<br>
LBNL<br>
<br>
On 3/26/2009 11:01 AM, Venkateswaran, Subbaraman wrote:
<blockquote
cite="mid:D025D0AB92335E4B90B7ADA30FA3D59504570CC7@PCCPMEXV02.na.blkint.com"
type="cite">
<title>Transferring CustomField Values from old to new on all tickets
in a queue</title>
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2900.3492" name="GENERATOR">
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">Ken Thanks for your
suggestions. Just thought of sharing the path we took to fix this
issue...</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"></span> </div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">1. Basically we
identified that one unique CF that we want across all queues</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">2. Added it to the Queue</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">3. Ran a script to copy
data from the old CF to the new CF on all tickets in this queue. This
we did it using a template that we found in RT wiki</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2"><a moz-do-not-send="true"
href="http://wiki.bestpractical.com/view/ImportCustomFieldValues">http://wiki.bestpractical.com/view/ImportCustomFieldValues</a></font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">and basically used the
HasEntry, AddCustomFieldValue methods from objectcustomfieldvalues to
accomplish this.</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">4. Detached the old CF
from the Queue.</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"></span> </div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">What we are planning is
to do the same for all dup'ed CFs on all the queue. Many one time
effort but could pay us in long run on ease of maintenance.</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"></span> </div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">Thanks</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"><font
color="#0000ff" face="Trebuchet MS" size="2">Subba</font></span></div>
<div dir="ltr" align="left"><span class="530124017-26032009"></span> </div>
<br>
<div class="OutlookMessageHeader" dir="ltr" align="left" lang="en-us">
<hr tabindex="-1"><font face="Tahoma" size="2"><b>From:</b> Ken
Crocker [<a class="moz-txt-link-freetext" href="mailto:kfcrocker@lbl.gov">mailto:kfcrocker@lbl.gov</a>] <br>
<b>Sent:</b> Friday, March 20, 2009 2:21 PM<br>
<b>To:</b> Venkateswaran, Subbaraman<br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
<b>Subject:</b> Re: [rt-users] Transferring CustomField Values from
old to new on all tickets in a queue<br>
</font><br>
</div>
Subbaraman,<br>
<br>
<br>
Yes. I've been thru this several times. Each time I found a better
way to do it. First off, you have to decide what the CF name will be
for ALL the queues that will be using it. Secondly, you have to have a
consensus on the values you will allow. Third, you create the NEW CF
and it's values. Now, if you have a CF that already exists and you want
to use it, then you still need to set up all the values. The last step
is to APPLY this particular CF to all the queues that will be using it.
Once that is done, set up some scripts (NOT scrips) that detail which
OLD CF"s should be WHAT VALUE for the NEW CF. Once that is done, you
execute each of those scripts for EACH queue by running a query to pull
ALL tickets of each queue (1 queue at a time) and use the "bulk update"
feature to set the new value for the new CF based on the
script/selection criteria for the OLD CF.<br>
For example. Let's say I have 3 CF's that are similar. I take CF1
and set up all the values I want it to have. If there are any values I
want to get rid of, I add the news ones first, then run a Search/Bulk
Update to change the values I want to get rid of to the new values.
Select all tickets where CF1 value = "X". Bulk Update the results to be
CF1 value = "Y". This would be the basic routine you walk thru for EACH
and EVERY value of CF2 and CF3 for Each Queue that uses CF2 and CF3, 1
Queue at a time.<br>
That should do it. There are no real shortcuts that I know of for
this kind of thing. You COULD use SQL and do this DIRECTLY to the
DataBase, but that get REAL messy and I do NOT recommend it.<br>
Hope this helps.<br>
<br>
<br>
Kenn<br>
LBNL<br>
<br>
On 3/20/2009 7:42 AM, Venkateswaran, Subbaraman wrote:
<blockquote
cite="mid:D025D0AB92335E4B90B7ADA30FA3D59504570C62@PCCPMEXV02.na.blkint.com"
type="cite">
<meta content="MS Exchange Server version 6.5.7654.12"
name="Generator">
<!-- Converted from text/rtf format -->
<p><font color="#0000ff" face="Trebuchet MS" size="2">We are using
RT 3.6.4 and what we are trying to do is to synchronize custom field
across all queues and basically have one unique custom field and type.
Currently we have some CFs with the same name and different types
dupe'ed across all the queues. Is there a way we can script around to
move all the values from oldCF to new CF on all tickets in a Queue ?</font></p>
<p><font color="#0000ff" face="Trebuchet MS" size="2">For e.g.: </font><br>
<font color="#0000ff" face="Trebuchet MS" size="2">CF Name XYZ,
Type: Enter multiple values</font> <br>
<font color="#0000ff" face="Trebuchet MS" size="2">CF Name XYZ,
Type: Text</font> <br>
<font color="#0000ff" face="Trebuchet MS" size="2">Move all the
values on XYZ(enter multiple values) to the CF XYZ(Text) on all tickets
in a Queue.</font> </p>
<p><font color="#0000ff" face="Trebuchet MS" size="2">Once this is
done we will disconnect the old CF XYZ(Enter multiple values) from the
Queue.</font> </p>
<p><font face="Trebuchet MS" size="2">Thanks for your help</font> </p>
<br>
THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE
PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM
DISCLOSURE. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, copying or use of this message and any attachment is
strictly prohibited. If you have received this message in error, please
notify us immediately by replying to the message and permanently delete
it from your computer and destroy any printout thereof.<br>
<pre wrap=""><hr size="4" width="90%">
_______________________________________________
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a moz-do-not-send="true"
class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a></pre>
</blockquote>
<br>
THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE
PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM
DISCLOSURE. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, copying or use of this message and any attachment is
strictly prohibited. If you have received this message in error, please
notify us immediately by replying to the message and permanently delete
it from your computer and destroy any printout thereof.<br>
</blockquote>
</body>
</html>