Mass update of 20k tickets

hello rt-users,
does anybody have any idea of how to update 20 000 tickets in a
reasonable manner. i did not look into RT for some time and want to do
some cleaning…
total number of tickets in this particular installation is probably ~500
000 so any processing through WebUI is not possible. server times-out.

any help appreciated.

best regards,

Alek Cesarz
Operations Director

Crowley Data Poland Sp. z o.o.
tel. +48(22)8606960
fax. +48(22)8606796
ul. Stawki 2, 00-193 Warszawa

With command-line perl script.On 1/17/06, Alek Cesarz acesarz@crowley.pl wrote:

hello rt-users,
does anybody have any idea of how to update 20 000 tickets in a
reasonable manner. i did not look into RT for some time and want to do
some cleaning…
total number of tickets in this particular installation is probably ~500
000 so any processing through WebUI is not possible. server times-out.

any help appreciated.

best regards,


Alek Cesarz
Operations Director

Crowley Data Poland Sp. z o.o.
tel. +48(22)8606960
fax. +48(22)8606796
ul. Stawki 2, 00-193 Warszawa


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at http://bestpractical.com/services/training.html

Best regards, Ruslan.

Ruslan Zakirov wrote:

With command-line perl script.

hello rt-users,
does anybody have any idea of how to update 20 000 tickets
You can use the Perl API (not sure what documentation is available) or
the command-line ‘rt’ utility (which is less flexible but OK for
changing some things). ‘$RTHOME/bin/rt help’ and some experimentation
will get you started with the latter.

I started a wiki page for the ‘rt’ utility:
http://wiki.bestpractical.com/index.cgi?RtCommandLine

Everyone, please let me know if it is accurate (it’s not very lengthy yet).

-Kevin Murphy

I’d love to see an example perl script using the API (not CLI) to do a
simple operation (e.g. resolve all tickets with ticket number bigger
than 1000).

I realize that the CLI could handle a simple query, but the CLI isn’t
flexible enough for some operations (e.g. custom field updates).
I’m currently trying to figure out the best method for mass ticket
custom field updates based on attributes of the requestor.

Thanks in advance.

Mike

Mike Patterson
Systems Manager
UC Berkeley Extension

Kevin Murphy napisał(a), W dniu 2006-01-17 17:04:

You can use the Perl API (not sure what documentation is available) or
the command-line ‘rt’ utility (which is less flexible but OK for
changing some things). ‘$RTHOME/bin/rt help’ and some experimentation
will get you started with the latter.

thank you very much Kevin. some scripting involving rt cli did the job
perfectly.

best regards,

Alek Cesarz
Operations Director

Crowley Data Poland Sp. z o.o.
tel. +48(22)8606960
fax. +48(22)8606796
ul. Stawki 2, 00-193 Warszawa