<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>That’s not a bad idea, and I ended up importing my ~17000 tickets and imported the resolved date into the starts date, and then in phpmyadmin I did <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>update `Tickets` set `Resolved` = `Starts` where `Queue` = '4'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Now my question is can I now move all the tickets with? <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>update `Tickets` set `Queue` = '3' where `Queue` = '4'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Kenneth Crocker<br><b>Sent:</b> Friday, July 15, 2011 12:23 PM<br><b>To:</b> rt-users@lists.bestpractical.com<br><b>Subject:</b> Re: [rt-users] Import from Old System and Set Resolved Date<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>Jason,<br><br>If you're using the API and you are setting the status to resolved, then RT is going to set that date to now. What I recommend is creating a Custom Date Field and putting your original resolved date into that and then after conversion, run some SQL that will change the resolved date (don't forget to include the "To" date in the TRANSACTION Record) to the value in that Custom Field.<br><br>That's the best idea I have. Hope it helps.<br><br>Kenn<br>LBNL<o:p></o:p></p><div><p class=MsoNormal>On Fri, Jul 15, 2011 at 3:40 AM, Jason Ledford <<a href="mailto:jledford@biltmore.com">jledford@biltmore.com</a>> wrote:<o:p></o:p></p><p class=MsoNormal>Let me rephrase the question and change the subject. How can I migrate my old work orders from an old system and set the resolved date? When I do this with the offline tool, even though it has the resolved field for me to fill out, it ignores that and sets the date to now(). Is there any other way to import from another system where I can accuratly set that date?<br>________________________________________<br>From: Jason Ledford<br>Sent: Wednesday, July 13, 2011 7:12 AM<br>To: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>Subject: Re: imports with the offline tool not taking resolved date<br><br>Sorry, I know this is an older email <a href="http://www.gossamer-threads.com/lists/rt/users/73345?search_string=offline%20resolved%20date;#73345" target="_blank">http://www.gossamer-threads.com/lists/rt/users/73345?search_string=offline%20resolved%20date;#73345</a><br>but I am trying to do this and have a question about what the last person suggests. I can't find that code in the CreateTicket code like suggested, I am sure I just don't know what I am looking at. Using RT 3.8.9.<br><br>Thanks for any help.<br><br>--------<br>2011 Training: <a href="http://bestpractical.com/services/training.html" target="_blank">http://bestpractical.com/services/training.html</a><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></body></html>