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