<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff size=2>Use a
perl script or even php</FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff size=2>The
table for ticket headers and details is "Tickets"</FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff size=2>And
for the content(message body and attachments) is
"Attachments".</FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2>Actually for me i play with that database alot....I have a system where
tickets are resolved automatically and sends a confirmation mail but the logic
is just</FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2>mysql> update Tickets set Status='Resolved' where
Id=$TicketId;</FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2>assinging Tickets owners and owners sent mail,</FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2>mysql> update Tickets set Owner=$UserId where
id=$Tickeid;</FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff size=2>And so
on...just get fluent with your scripting languages but don't delete some initial
database info like the system group, the system users, etc. If you do, then go
to /path/to/rt/etc/initialdata and do the necessary.</FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff size=2>Guys
at work also refused to always login to Our RT so they just send mail (and
tickets are created), then resolve by also sendiing mail. </FONT></SPAN></DIV>
<DIV><SPAN class=596474608-29062004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=596474608-29062004> </SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]<B>On Behalf Of </B>Jonas
Lindvall (AllTele)<BR><B>Sent:</B> Tuesday, June 29, 2004 11:45
AM<BR><B>To:</B> rt-users@lists.bestpractical.com<BR><B>Subject:</B>
[rt-users] Inserting tickets directly to database<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Is there any good way to do this. I have a set of
</FONT></DIV>
<DIV><FONT face=Arial size=2>about 4000 tickets from our old text based simple
system.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>And importing thoose to RT is probably pretty
</FONT></DIV>
<DIV><FONT face=Arial size=2>simple if i just could figure out how to add a
</FONT></DIV>
<DIV><FONT face=Arial size=2>ticket manually, anyone can help??</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>./Jonas
Lindvall</FONT></DIV></BLOCKQUOTE></BODY></HTML>