Difference between revisions of "Contributions"

From Request Tracker Wiki
Jump to navigation Jump to search
(41 intermediate revisions by 15 users not shown)
Line 17: Line 17:
Custom [[Condition]]s. Doesn't matter if it's module or text to fill into "user defined condition" block in the WebUI, all live here.
Custom [[Condition]]s. Doesn't matter if it's module or text to fill into "user defined condition" block in the WebUI, all live here.


Many conditions are very simple and you can find a big list in [[CustomConditionSnippets]].
'''<nowiki>*Please</nowiki>'''*, start wiki page names with "On" prefix if you don't want to add condition into [[CustomConditionSnippets]].


'''<nowiki>*Please</nowiki>'''*, start wiki page names with "On" prefix if you don't want to add condition into [[CustomConditionSnippets]].
* [[CustomConditionSnippets]] - '''very big''' and organized list of simple conditions


* [[AnyTransactionSource]];
* [[AnyTransactionSource]];
* [[AnyReminderTransaction]] - a scrip condition which triggers on all reminder transactions;
* [[AnyReminderTransaction]] - a scrip condition which triggers on all reminder transactions;
* [[ExampleOfCustomFieldInCondition]] - a condition that check [[CustomField]] value;
* [[MuteResolve]] - let resolver choose not to send email on resolve;
* [[MuteResolve]] - let resolver choose not to send email on resolve;
* [[MuteResolve Redux]] - alternate version of MuteResolve that uses a status code and custom field to avoid some problems;
* [[MuteResolve Redux]] - alternate version of MuteResolve that uses a status code and custom field to avoid some problems;
* [[NotResolved]] - a scrip condition to detect all ticket that aren't marked resolved;
* [[NotResolved]] - a scrip condition to detect all ticket that aren't marked resolved;
* [[On Correspond Notify AdminCcs if Not Owned|OnCorrespondNotifyAdminCcsNotOwned]] - Notifies AdminCc only if ticket is unowned
* [[OnCreateAutoReplyException]] - a scrip condition that will send [[AutoReply]] emails to users except for those in the execption list;
* [[OnCreateAutoReplyException]] - a scrip condition that will send [[AutoReply]] emails to users except for those in the execption list;
* [[OnCreateCheckCF]] - check presence of a mandatory cf on ticket creation;
* [[OnCreateCheckCF]] - check presence of a mandatory cf on ticket creation;
Line 45: Line 45:
* [[ReplyBasedUponContent]] - a scrip to reply to an email based upon its content
* [[ReplyBasedUponContent]] - a scrip to reply to an email based upon its content
* [[ReplyToResolved]] - a scrip condition to detect all ticket that are marked resolved;
* [[ReplyToResolved]] - a scrip condition to detect all ticket that are marked resolved;
* [[ShowDashboardTabs]] - add dashboards to the personal quickbar
* [[TicketIDMatches]].pm - a condition which triggers only one ticket by id;
* [[TicketIDMatches]].pm - a condition which triggers only one ticket by id;
* [[UntouchedInHours]] - scrip condition that checks if a ticket's LastUpdate is more than the specified number of hours;
* [[UntouchedInHours]] - scrip condition that checks if a ticket's LastUpdate is more than the specified number of hours;
* [[OnCorrespondOpenUnlessResolved]] - condition to stop RT re-opening resolved tickets when the user replies to them by email;
* [[OnCorrespondOpenUnlessResolved]] - condition to stop RT re-opening resolved tickets when the user replies to them by email;
* [[NoReplyAddress]] - Use a "no reply" RT email address that posts comments as a Reply/Correspondence (so they can see it in web UI), but does not send email to Requestors


== ScripActions ==
== ScripActions ==
Line 60: Line 62:
* [[AddWatcherPerTicket]] - Add a watcher to a specific ticket (e.g. when certain conditions are met, such as high urgency)
* [[AddWatcherPerTicket]] - Add a watcher to a specific ticket (e.g. when certain conditions are met, such as high urgency)
* [[AddWatchersOnCorrespond]] - Add Actor &amp; other Cc'd people to ticket on any Correspondence (complement to using [[ParseNewMessageForTicketCcs]] to add people on ticket creation).
* [[AddWatchersOnCorrespond]] - Add Actor &amp; other Cc'd people to ticket on any Correspondence (complement to using [[ParseNewMessageForTicketCcs]] to add people on ticket creation).
* [[LoopIn]] - Similar to [[AddWatchersOnCorrespond]], but with some additional security and rules to prevent random people from getting added to existing tickets.
* [[AutomaticCustomFieldValue]] - set CF value by requestor's email address.
* [[AutomaticCustomFieldValue]] - set CF value by requestor's email address.
* [[AutoCcOwner]] - Add the owner as an [[AdminCc]]
* [[AutoCcOwner]] - Add the owner as an [[AdminCc]]
Line 69: Line 72:
* [[AutoSetOwnerFromCC]] - how to automatically set owner from Cc
* [[AutoSetOwnerFromCC]] - how to automatically set owner from Cc
* [[BounceMerge]] - Merge a Mail Bounce into the original Ticket
* [[BounceMerge]] - Merge a Mail Bounce into the original Ticket
* [[CcManagers]] - Add the manager subgroup of the ticket creator as Cc, useful when managing departments as groups (as [[Rights|rights]] suggests).
* [[CopyContentToCF]] - When called 'On Create' will copy <tt>$Transaction->Content</tt> to the custom field <tt>Problem</tt>.
* [[CreatePriorityBasedOnCustomFieldValues]] - Automatically set the Priority based on Ticket Urgency and Impact.
* [[CreatePriorityBasedOnCustomFieldValues]] - Automatically set the Priority based on Ticket Urgency and Impact.
* [[DefaultCustomFieldValue]] - set default CF value.
* [[DefaultCustomFieldValue]] - set default CF value.
Line 80: Line 85:
* [[OnCreateSetDeptHeadCc]] - On create in the case that [[CustomField]].Department = 'Foo' then add group 'Head Foo' as a Cc
* [[OnCreateSetDeptHeadCc]] - On create in the case that [[CustomField]].Department = 'Foo' then add group 'Head Foo' as a Cc
* [[OnCreateAddGroupCc]] - On create from Requestor email that matches a regex, add members of arbitrary group to CC list while making sure not to add anyone already associated with the ticket
* [[OnCreateAddGroupCc]] - On create from Requestor email that matches a regex, add members of arbitrary group to CC list while making sure not to add anyone already associated with the ticket
* [[OnOwnershipSquelchMailtoQueueWatchers]] - When a ticket's owner changes from "Nobody" to a regular user, stop sending mail to people who are just Queue Watchers.
* [[OnQueueChangeFixReminders]] - Tickets lose reminders when they are moved between queues. This scrip fixes that
* [[OnQueueChangeFixReminders]] - Tickets lose reminders when they are moved between queues. This scrip fixes that
* [[OnQueueChangeResetPriorityAndDueDate ]] - Reset priorities and due date when moving a ticket to another queue.
* [[OpenTicketOnAllMemberResolve]]
* [[OpenTicketOnAllMemberResolve]]
* [[OpenDependantsOnResolve]]
* [[OpenDependantsOnResolve]]
* [[RemoteControlLimeSurvey]] - Scrip action to trigger [[LimeSurvey]] to add a token to a given survey.
* [[RemoteControlLimeSurvey2]] - new Version of the old [[RemoteControlLimeSurvey]] - Scrip action to trigger [[LimeSurvey]] to add a token to a given survey.
* [[ResolveTicket]]
* [[ResolveTicket]]
* [[SendEmailAction]] - sends an alert to someone not specified in the ticket
* [[SendEmailAction]] - sends an alert to someone not specified in the ticket
Line 89: Line 96:
* [[SendNagiosAlert]] - Send an alert to Nagios if a new or open ticket exists in any defined queues.
* [[SendNagiosAlert]] - Send an alert to Nagios if a new or open ticket exists in any defined queues.
* [[SendAlarmPointEvent]] - Send an event to alarm point to invoke SMS/Voice/E-mail alerts
* [[SendAlarmPointEvent]] - Send an event to alarm point to invoke SMS/Voice/E-mail alerts
* [[SetActiveOnCustomerReply]] - detects if a ticket is set to a certain status and changes that status if someone other than the ticket owner replies.
* [[SetCorresponderAsCC]] - Add anyone who correspondes on a ticket to CC - for the lazy users.
* [[SetCorresponderAsCC]] - Add anyone who correspondes on a ticket to CC - for the lazy users.
* [[SetOwnerAndQueueBySubject]] - Set queue and owner when the subject matches a regex
* [[SetOwnerAndQueueBySubject]] - Set queue and owner when the subject matches a regex
Line 105: Line 113:
* [[AddQueueNameToMailHeaders]] - add the relevent queue name to mail sent
* [[AddQueueNameToMailHeaders]] - add the relevent queue name to mail sent
* [[AddLastCommentToMail]]
* [[AddLastCommentToMail]]
* [[AddRichTextEditorToCustomField]] - add CKEditor to a [[CustomField]]s textarea values
* [[AutoreplyOrCorrespondence]] - if creator is not requestor use Corresondence instead of Autoreply
* [[EmailGroup]] - email an RT [[Group]]
* [[EmailGroup]] - email an RT [[Group]]
* [[ForkTemplate]] - send a range of customized responses without hard-coding variants.
* [[ForkTemplate]] - send a range of customized responses without hard-coding variants.
* [[ForwardFirstMessage]] - re-send the first message (i.e. ticket creation message)
* [[MailingListIntegration]] - Scrip + Template to optionally subscribe requestors to a listserv.
* [[MailingListIntegration]] - Scrip + Template to optionally subscribe requestors to a listserv.
* [[MultipleOutgoingEmailAddresses]]
* [[MultipleOutgoingEmailAddresses]]
Line 122: Line 133:
* [[MakeClicky:Fedex]] - Make a link to Fedex tracking website whenever phrase looks like a tracking number
* [[MakeClicky:Fedex]] - Make a link to Fedex tracking website whenever phrase looks like a tracking number
* [[QuickResolveandQuickReject]] - Create two actions in Display page which allow you to reject or resolve the ticket without no comments.
* [[QuickResolveandQuickReject]] - Create two actions in Display page which allow you to reject or resolve the ticket without no comments.
* [[MailtoLinksFromTransactions]] - Create mailto-inks at the top of transactions
* [[TwoColumnTicketLayout]] - Display a ticket's history and metadata side by side
* [[AutoRequestorTicketSearch]] - Automatically search for requestor's last updated tickets on creation page
* [[NewTicketsAlert]] - Display a messagebox on My RT listing new tickets and add new ticket count to page title


== Extensions ==
== Extensions ==
Line 129: Line 144:
Packages that have their own installer have been moved to [[Extensions]] - Below are code bits too small/experimental/etc. to warrant a standalone package:
Packages that have their own installer have been moved to [[Extensions]] - Below are code bits too small/experimental/etc. to warrant a standalone package:


* [[ActiveDirectory]] - Several authentication techniques.
* [[AutomaticImageResize]] -- automatically scale images that are displayed inline in your ticket history
* [[AutomaticImageResize]] -- automatically scale images that are displayed inline in your ticket history
* [[AutoRedirectToSelfService]] - automatically redirect your users to Self Service if they don't have "own ticket" permissions;
* [[AutoRedirectToSelfService]] - automatically redirect your users to Self Service if they don't have "own ticket" permissions;
* [[BasicVsAdvancedInterface]] - allow privileged users to choose between the [[SelfService]] and RT at a Glance interfaces
* [[BasicVsAdvancedInterface]] - allow privileged users to choose between the [[SelfService]] and RT at a Glance interfaces
* [[BetterPerformanceWithFullText]] - tweak to improve full text search in Postgres (and a note about Oracle).
* [[CalendarWidget]] - add a the dynarch.com jscalendar widget to pick dates
* [[CalendarWidget]] - add a the dynarch.com jscalendar widget to pick dates
* [[CannedReplies]] - provides drop-down list of templates that can be included in a ticket reply
* [[CannedReplies]] - provides drop-down list of templates that can be included in a ticket reply
Line 143: Line 158:
* [[DisplayCustomFieldsOnTicketUpdatePage]] - Make a ticket's custom fields visible when updating or resolving a ticket.
* [[DisplayCustomFieldsOnTicketUpdatePage]] - Make a ticket's custom fields visible when updating or resolving a ticket.
* [[EditCustomFieldsOnUpdate]] - edit custom fields on update, reply, comment...;
* [[EditCustomFieldsOnUpdate]] - edit custom fields on update, reply, comment...;
* [[ForwardWithMessage]] - forward a transaction or ticket WITH a message for the recipient
* [[GroupMembershipCheck]] - snippet that can be included in a custom form if you want to limit the display of some things to a specific group;
* [[GroupMembershipCheck]] - snippet that can be included in a custom form if you want to limit the display of some things to a specific group;
* [[HideTransactions]] - hide messages from a history view
* [[HideTransactions]] - hide messages from a history view
* [[HomePageSavedSearches]] - display lists of saved searches on the RT home page;
* [[HomePageSavedSearches]] - display lists of saved searches on the RT home page;
* [[HTML5Charts]] - eye candy with jqplot;
* [[ImportCustomFieldValues]] - Fills custom field data from external source;
* [[ImportCustomFieldValues]] - Fills custom field data from external source;
* [[LdapSummary]] - Several authentication and user creation techniques
* [[LdapSummary]] - Several authentication and user creation techniques
Line 156: Line 173:
* [[PersistentSessions]] - Making users' sessions persistent
* [[PersistentSessions]] - Making users' sessions persistent
* [[PopUpAlert]] - Send Reply instead of Comment
* [[PopUpAlert]] - Send Reply instead of Comment
* [[QuickTicket]] - quickly create a ticket on homepage with custom fields and status
* [[Extension - Queue Change On Update]] - This is a plugin which adds a callback to RT with the result that you add a Queue change dropdown box to the ticket update page (comment/reply page). Very handy for proper ticket transport between Queue's, especially whena Queue represents a department.
* [[Rich Text Custom Fields]] - convert wiki text custom fields into rich text custom fields
* [[ResolveSendsReply]] - change the "Resolve" link to reply instead of comment by default
* [[ResolveSendsReply]] - change the "Resolve" link to reply instead of comment by default
* [[SelectRequestor]] - allow user to select requestor from drop down lists instead of typing email address;
* [[SelectRequestor]] - allow user to select requestor from drop down lists instead of typing email address;
Line 189: Line 209:
* [[backupRT]] - Run a quick backup of RT files (Debian)
* [[backupRT]] - Run a quick backup of RT files (Debian)
* [[backupRTDB]] - RT Database Backup Script (Debian)
* [[backupRTDB]] - RT Database Backup Script (Debian)
* [http://nextup.cz/bestpractical-rt-widget/ BestPracticalRT Mac OSX Widget] - simple configurable OSX widget for quick posting tickets
* [http://search.cpan.org/dist/Bot-BasicBot-Pluggable-Module-RT Bot::BasicBot::Pluggable::Module::RT] - an IRC Bot module that allows full querying of RT tickets from an IRC session. It can do as much as [http://search.cpan.org/dist/RT-Client-REST/ RT::Client::REST] can.
* [http://search.cpan.org/dist/Bot-BasicBot-Pluggable-Module-RT Bot::BasicBot::Pluggable::Module::RT] - an IRC Bot module that allows full querying of RT tickets from an IRC session. It can do as much as [http://search.cpan.org/dist/RT-Client-REST/ RT::Client::REST] can.
* [[CleanupSessions]] - Clean up old database sessions
* [[CleanupSessions]] - Clean up old database sessions
Line 195: Line 216:
* [[delete-transaction]] - [http://download.bestpractical.com/pub/rt/contrib/3.0/Other/Censorware/delete-transaction Original version] was old, poured out errors and didn;t work well on 3.8. This one is fixed.
* [[delete-transaction]] - [http://download.bestpractical.com/pub/rt/contrib/3.0/Other/Censorware/delete-transaction Original version] was old, poured out errors and didn;t work well on 3.8. This one is fixed.
* [[DenormalizedViewsForReporting]] - Several views to allow SQL reporting outside of RT.
* [[DenormalizedViewsForReporting]] - Several views to allow SQL reporting outside of RT.
* [https://github.com/botsie/dirt Dirt] - A web application that provides kanban boards, scrum taskboards, graphical and tabluar reports on top of RT. 
* Email reminders
* Email reminders
** [[DueDateRemindersByEmail]] - A script (to be run daily) that sends email notifications for expired tickets to owners and Queues/Tickets [[AdminCC]]
** [[DueDateRemindersByEmail]] - A script (to be run daily) that sends email notifications for expired tickets to owners and Queues/Tickets [[AdminCC]]
Line 200: Line 222:
** [[rtReminderMails]] - Cronscript that sends mails about reminders that are due in the next two days to the ticket and reminder owners.
** [[rtReminderMails]] - Cronscript that sends mails about reminders that are due in the next two days to the ticket and reminder owners.
** [[rtUnifiedreminder]] - All the other reminder scripts are based on [[StartDate]], [[DueDate]] or Priority but not all organizations make use of those fields. Also, all the other scripts only send plaintext email to the ticket owner. This script sends one HTML mail (so you can click the tickets and links to RT searches) that lists all tickets that seem to be getting too old without being touched. "Too old" is based on [[LastUpdated]] field, with the amount of time configurable for New, Open and Stalled tickets.
** [[rtUnifiedreminder]] - All the other reminder scripts are based on [[StartDate]], [[DueDate]] or Priority but not all organizations make use of those fields. Also, all the other scripts only send plaintext email to the ticket owner. This script sends one HTML mail (so you can click the tickets and links to RT searches) that lists all tickets that seem to be getting too old without being touched. "Too old" is based on [[LastUpdated]] field, with the amount of time configurable for New, Open and Stalled tickets.
** [[rt-askForFeedback]] - This Script bases on the above "[[DueDateRemindersByEmail]]" and got modified in the way, that it sends Mails to customers other than to administrators and Ticket-Owner. You will be able to "remind" customer to get back to you with a reply if the ticket is in "stalled"-State. If there is no response within a time of "x", you can autoclose the ticket.
* [http://www.bestpractical.com/pub/rt/contrib/3.0/Other/F2Wcvs-to-rt-3.0 F2Wcvs-to-rt] - Tool to help converting from the [http://f2w.sourceforge.net/ F2W] helpdesk system to RT
* [http://www.bestpractical.com/pub/rt/contrib/3.0/Other/F2Wcvs-to-rt-3.0 F2Wcvs-to-rt] - Tool to help converting from the [http://f2w.sourceforge.net/ F2W] helpdesk system to RT
* [http://mit.edu/alexmv/Public/graph-mason-deps graph-mason-deps] uses [http://www.graphviz.org/ GraphViz] to create a graph of which components call each other
* [http://mit.edu/alexmv/Public/graph-mason-deps graph-mason-deps] uses [http://www.graphviz.org/ GraphViz] to create a graph of which components call each other
Line 208: Line 231:
* [http://www.dmo.ca/projects/hacks/RT/RT.bm RT.bm] is a plugin for [http://www.mozilla.org/projects/mozbot/ mozbot] that allows some minimal querying of RT tickets from an IRC session.
* [http://www.dmo.ca/projects/hacks/RT/RT.bm RT.bm] is a plugin for [http://www.mozilla.org/projects/mozbot/ mozbot] that allows some minimal querying of RT tickets from an IRC session.
* [http://www.bestpractical.com/pub/rt/contrib/3.0/Other/rtadduser rt-adduser] ([http://www.bestpractical.com/pub/rt/contrib/3.0/Other/rtadduser.README docs]) - command line tool to add RT users.
* [http://www.bestpractical.com/pub/rt/contrib/3.0/Other/rtadduser rt-adduser] ([http://www.bestpractical.com/pub/rt/contrib/3.0/Other/rtadduser.README docs]) - command line tool to add RT users.
* [[Rt-auth-user|rt-auth-user]] - perl script for authenticating a user against RT (both local and external sources through [[ExternalAuth]] )
* [http://mimosaid.007sites.com/rt-batch-add-users.txt rt-batch-add-users] - command line tool to add a batch of RT users based on data of a csv file.
* [http://mimosaid.007sites.com/rt-batch-add-users.txt rt-batch-add-users] - command line tool to add a batch of RT users based on data of a csv file.
* [rt-batch-stats [[RT3BatchStats]]] - Command Line or batch statistics.
* [rt-batch-stats [[RT3BatchStats]]] - Command Line or batch statistics.
Line 226: Line 250:
* [[MigrateBugzillaToRT]] - Migrate a Bugzilla instance cleanly to RT
* [[MigrateBugzillaToRT]] - Migrate a Bugzilla instance cleanly to RT
* [[IntegrateSphinx]] - How to integrate the Sphinx full-text search engine into RT
* [[IntegrateSphinx]] - How to integrate the Sphinx full-text search engine into RT
* [[SendingCommentsDirectlyToATicketWithExim4]] - How to configure exim4 to send comments to tickets based on ticket ID and custom field values
* [[rt-clonequeue]] - a perl script used to create a new queue using an existing one as a template (copying its custom fields, permissions, templates and scrips but not its tickets).


=== Browser Tools ===
=== Browser Tools ===
Line 240: Line 268:


* [http://www.cs.mu.oz.au/systems/rt.html Department of Computer Science and Software Engineering, The University of Melbourne's RT page]
* [http://www.cs.mu.oz.au/systems/rt.html Department of Computer Science and Software Engineering, The University of Melbourne's RT page]
* [http://page.mi.fu-berlin.de/~pape/rt3screenshots/ Dirk Pape's RT page] (The "Fork" tarball link is broken on this site)
* [http://page.mi.fu-berlin.de/~pape/rt3screenshots/ Dirk Pape's RT page] (Fixed "Fork" tarball link, I hope it is the right Version.)
* [http://web.mit.edu/tooltime/ MIT IS&amp;T RT page]
* [http://web.mit.edu/tooltime/ MIT IS&amp;T RT page]
* [http://www.usit.uio.no/it/rt/modifications/ University of Oslo's RT page]
* [http://www.usit.uio.no/it/rt/modifications/ University of Oslo's RT page]
* [http://www.cs.kent.ac.uk/people/staff/tdb/rt3/ University of Kent's RT page]
* [http://www.cs.kent.ac.uk/people/staff/tdb/rt3/ University of Kent's RT page]

Revision as of 19:30, 10 September 2017

Contributions to RT

Contains info about software that third parties have contributed to RT. If you know of a contribution or enhancement that is not in this list, please add to the best section possible below, in alphabetical order. Also include notes about the RT versions tested.

You may also want to check the Documentation page because many articles there describe how to add features that RT does not have by default.

Packages that have their own installer have been moved to Extensions.

See Also the outdated Patches, whose content should be moved to the appropriate subsections below.

Coping with Spam

The techniques for dealing with spam span the divisions below and have been collected in a single place for easy review. Please see SpamFiltering, limiting additions to tricks that differ significantly from the existing material for conciseness.

ScripConditions

Custom Conditions. Doesn't matter if it's module or text to fill into "user defined condition" block in the WebUI, all live here.

*Please*, start wiki page names with "On" prefix if you don't want to add condition into CustomConditionSnippets.

ScripActions

Nice custom ScripActions that makes your life easier.

Template parts

Code that you can put into your mail Templates, Template page has also some code snippets.

Callbacks

Callbacks are an easy way to CleanlyCustomizeRT

  • CloningQueues - Add user functionality to clone existing queues including templates, scrips, privileges and custom fields during queue creation
  • CreateChildTicket - Add a button to the Ticket display to create a child ticket in another queue
  • HideTransactions - hide messages from a history view
  • ModifyQuery -Change default simple search behavior to in/ex-clude closed tickets, etc.
  • MakeClicky:Fedex - Make a link to Fedex tracking website whenever phrase looks like a tracking number
  • QuickResolveandQuickReject - Create two actions in Display page which allow you to reject or resolve the ticket without no comments.
  • MailtoLinksFromTransactions - Create mailto-inks at the top of transactions
  • TwoColumnTicketLayout - Display a ticket's history and metadata side by side
  • AutoRequestorTicketSearch - Automatically search for requestor's last updated tickets on creation page
  • NewTicketsAlert - Display a messagebox on My RT listing new tickets and add new ticket count to page title

Extensions

Patches, Overlays, Mason components, configuration tools and so on. These extensions are unlikely to become RT core package.

Packages that have their own installer have been moved to Extensions - Below are code bits too small/experimental/etc. to warrant a standalone package:

External utils

Various standalone utilities.

  • backupRT - Run a quick backup of RT files (Debian)
  • backupRTDB - RT Database Backup Script (Debian)
  • BestPracticalRT Mac OSX Widget - simple configurable OSX widget for quick posting tickets
  • Bot::BasicBot::Pluggable::Module::RT - an IRC Bot module that allows full querying of RT tickets from an IRC session. It can do as much as RT::Client::REST can.
  • CleanupSessions - Clean up old database sessions
  • CloseAll - Close all TT in a queue
  • ConvertLegacyToRt - Converts a Legacy Flat File to RT Tickets.
  • delete-transaction - Original version was old, poured out errors and didn;t work well on 3.8. This one is fixed.
  • DenormalizedViewsForReporting - Several views to allow SQL reporting outside of RT.
  • Dirt - A web application that provides kanban boards, scrum taskboards, graphical and tabluar reports on top of RT. 
  • Email reminders
    • DueDateRemindersByEmail - A script (to be run daily) that sends email notifications for expired tickets to owners and Queues/Tickets AdminCC
    • rt-remind - Stick this in your crontab to send out reminders about open tickets.
    • rtReminderMails - Cronscript that sends mails about reminders that are due in the next two days to the ticket and reminder owners.
    • rtUnifiedreminder - All the other reminder scripts are based on StartDate, DueDate or Priority but not all organizations make use of those fields. Also, all the other scripts only send plaintext email to the ticket owner. This script sends one HTML mail (so you can click the tickets and links to RT searches) that lists all tickets that seem to be getting too old without being touched. "Too old" is based on LastUpdated field, with the amount of time configurable for New, Open and Stalled tickets.
    • rt-askForFeedback - This Script bases on the above "DueDateRemindersByEmail" and got modified in the way, that it sends Mails to customers other than to administrators and Ticket-Owner. You will be able to "remind" customer to get back to you with a reply if the ticket is in "stalled"-State. If there is no response within a time of "x", you can autoclose the ticket.
  • F2Wcvs-to-rt - Tool to help converting from the F2W helpdesk system to RT
  • graph-mason-deps uses GraphViz to create a graph of which components call each other
  • html2mime - small perl script used to create a text/plain part from 100% html messages
  • mailfilter - spam checking and more
  • Mbox2Rt - import a unix-style mailbox into RT
  • ProcmailRecipes - procmail recipes used for email filtering
  • RT.bm is a plugin for mozbot that allows some minimal querying of RT tickets from an IRC session.
  • rt-adduser (docs) - command line tool to add RT users.
  • rt-auth-user - perl script for authenticating a user against RT (both local and external sources through ExternalAuth )
  • rt-batch-add-users - command line tool to add a batch of RT users based on data of a csv file.
  • [rt-batch-stats RT3BatchStats] - Command Line or batch statistics.
  • RtBounceHandler - scan bounce email for ticket details, then post essense of bounce info to that ticket.
  • rt-class-map-1.3-pl - Show methods available to specific RT objects.
  • rt-cvsgate (docs) - cvs integration for request tracker.
  • rt-escalate (ConfigureEscalation) - stick this in your crontab to escalate priority on tickets automatically
  • RTLogins - simple php script that creates a login report ("Who's using RT?")
  • rt_logins_email2ldap - script to convert email usernames to LDAP/Active Directory usernames
  • rt-google-charts - produce google charts for queue statistics
  • rt-on-pg-to-mysql - Convert your rt database from postgres to mysql.
  • rt-queues Shellscript called from procmail to sort E-Mails to the correct queue. Parses incoming mails and based on addresses in To: and CC: fields automatically sorts mails to the correct queue. This makes changing your MTA configuration for every new queue obsolete.
  • RtTalkToSelf - a mail filter script that allows a single RT instance to have one ticket as the "external requestor" of another.
  • scan-and-set - sample perl script to all the text attachments of open tickets for a text string and set a custom field with the result.
  • statdump/statcron - script and cronjob to generate RT management reports. The original URL is defunct, but a patched version of the scripts are still in listarchives. An updated version that fixed AverageTickets calcs and CURDATE selection used to be available at http://www.lei.net.au/stats.tgz.
  • CountTickets - a BASH script to count tickets in a MySQL db.
  • ShredderControl - a BASH script to shred tickets using RTx-Shredder.
  • MigrateBugzillaToRT - Migrate a Bugzilla instance cleanly to RT
  • IntegrateSphinx - How to integrate the Sphinx full-text search engine into RT
  • SendingCommentsDirectlyToATicketWithExim4 - How to configure exim4 to send comments to tickets based on ticket ID and custom field values
  • rt-clonequeue - a perl script used to create a new queue using an existing one as a template (copying its custom fields, permissions, templates and scrips but not its tickets).


Browser Tools

Database Queries

Other