<!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.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I need to cleanup a RT 1.0.7 database before
migrating to RT 3.0.4</FONT></DIV>
<DIV><FONT face=Arial size=2>and need tips to filter out the unwanted queues and
tickets opened</FONT></DIV>
<DIV><FONT face=Arial size=2>by spam.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What would happen if I run the "import-1.0-to-2.0"
script </FONT><FONT face=Arial size=2>after deleting</FONT></DIV>
<DIV><FONT face=Arial size=2>the unwanted "queue_id" records from the "queues"
</FONT><FONT face=Arial size=2>table? It'll ignore </FONT></DIV>
<DIV><FONT face=Arial size=2>the </FONT><FONT face=Arial size=2>tickets (and the
transactions) referring to those deleted queue_ids</FONT></DIV>
<DIV><FONT face=Arial size=2>or break? And what would be the simplest way to
erase the "spam </FONT></DIV>
<DIV><FONT face=Arial size=2>tickets" before running the script?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm asking all this because: </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1) my dept. is about to run it's own RT and
</FONT><FONT face=Arial size=2>don't need data of other depts. </FONT></DIV>
<DIV><FONT face=Arial size=2> queues</FONT></DIV>
<DIV><FONT face=Arial size=2>2) the fist trials of migration took much more than
72h in a Dell 1650</FONT></DIV>
<DIV><FONT face=Arial size=2>(P3 1.4GHz, </FONT><FONT face=Arial size=2>2GB RAM,
100MB SCSI-3 HDDs) and we cancelled the </FONT></DIV>
<DIV><FONT face=Arial size=2>migration before finishing. </FONT></DIV>
<DIV><FONT face=Arial size=2>3) The RT 1.0.7 db has a little bit less than
25.000 </FONT><FONT face=Arial size=2>tickets and we really </FONT></DIV>
<DIV><FONT face=Arial size=2>need a to keep our dept. queues'
tickets.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I appreciate your help,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Alex</FONT></DIV></BODY></HTML>