Mailing List Archive

On Tue, Jan 08, 2002 at 03:55:32AM +0530, Guru Prasan Sahu wrote:
|+ Hi all,
|+
|+ can I get the data of old RT1 and put the data on another box where I installed RT2.
|+ please guide me for this.

There is a script I beleive in the contrib directory that allows you to
import data from rt1 to rt2. I believe that is what you're looking
for. Read the docs for it, as I believe it doesn't get a few things.

-darrin

First; this should go to rt-users, not rt-devel.

|+ I recently had some clown send over 2000 tracker messages to the server we used for our RT tracker.
|+ This of course clogged the system up, and I needed to know how to remove just these tracker issues
|+ from the system without having to dump the database files as a friend recommended.

Why not go to the search menu, search for the tickets in question (I am
assuming they have a common element, like subject, or email address, or
something), select 'Update all these tickets at once', if there are some
tickets you don't want to update, unselect the 'Update' box, then change
the status to 'Dead'.

|+ I am really new to the system and need if possible the SQL command to get rid of
|+ this access tracker issues. I also would like to know how to backup and remove
|+ older years of tracker issues.

Its not really adviced to delete older tickets. Thats one of the
features of a database, store all your information, have it available to
you at anytime via a search. Would suck if you needed a ticket from 3
years ago, and you had deleted it from teh system. You'd have to then
put the old information up somewhere where its accessable.

-darrin (cc'ing rt-users. questions asking for help should go there)

>>>>> "TJG" == Ted J Green <bishop@totalaccess.net> writes:

TJG> I recently had some clown send over 2000 tracker messages to the
TJG> server we used for our RT tracker. This of course clogged the
TJG> system up, and I needed to know how to remove just these tracker
TJG> issues from the system without having to dump the database files
TJG> as a friend recommended.

We had a mailer loop caused by a misconfiguration that once created
500 or so tickets. What I did was do a search on the some matching
criteria, clicked on "update all these tickets at once" and marked
them dead. Repeat until all are done.

If RT's database had referential integrity with cascade on delete, one
could probably issue a single delete query to the database to clear
out those tickets and all associated records. Alas, it does not have
the references (since MySQL doesn't support them).

Can Anyone Help?

From: Nagraj Arya
Sent: Thursday, June 30, 2016 8:02 AM
To: 'rt-devel@lists.bestpractical.com'; 'rt-users@lists.bestpractical.com'
Subject: help

Hi,
I am new to RT so your help is really appreciated.
We are trying to see if we can create a dashboard and add a field which shows all the attachments for that ticket in the dashboard itself
[cid:image001.png@01D1D6B2.AA266220]
Instead of going to the ticket details and seeing the attachments.

[cid:image002.png@01D1D6B2.AA266220]


Is it possible, can you please guide me to achieve it..

//BR
Nagraj Arya