<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div><br></div></div></div></span></span>
</div>
<br><div><div>On Apr 24, 2013, at 7:06 AM, <a href="mailto:rt-users-request@lists.bestpractical.com">rt-users-request@lists.bestpractical.com</a> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Send rt-users mailing list submissions to<br><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br><span class="Apple-tab-span" style="white-space:pre"> </span>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users<br>or, via email, send a message with subject or body 'help' to<br><span class="Apple-tab-span" style="white-space:pre"> </span>rt-users-request@lists.bestpractical.com<br><br>You can reach the person managing the list at<br><span class="Apple-tab-span" style="white-space:pre"> </span>rt-users-owner@lists.bestpractical.com<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of rt-users digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Custom condition for script (Jim Berry)<br> 2. Fwd: Adding Index to several tables to improve shredder<br> performance (Rabin Yasharzadehe)<br> 3. Re: Issue with creating linked tickets (Joe Kirby)<br> 4. How change link labels (Ken Johnson)<br> 5. Re: Custom condition for script (Miles Scruggs)<br> 6. Re: Issue with creating linked tickets (Thomas Sibley)<br> 7. Script to collect info from child tickets (Tyler Harding)<br> 8. Re: How change link labels (Michael Steen)<br> 9. Re: Problems upgrading from 3.9.3 (saxmad)<br> 10. Re: Problems upgrading from 3.9.3 (saxmad)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Tue, 23 Apr 2013 17:01:58 +0000<br>From: Jim Berry <jim.h.berry@frb.gov><br>To: Miles Scruggs <miles@digitalphotobox.net>, RT users<br><span class="Apple-tab-span" style="white-space:pre"> </span><rt-users@lists.bestpractical.com><br>Subject: Re: [rt-users] Custom condition for script<br>Message-ID: <20130423170200.3A7932C4350@ibastion.frb.gov><br>Content-Type: text/plain; charset="us-ascii"<br><br>This should do what you want . It could be generalized to use groups or AdminCc. Create a scrip with<br><br>Condition = On Create<br>Action = User Defined<br>Template = Blank<br>Stage = TransactionCreate<br><br>In the Custom action preparation code box, insert:<br><br>## Add other user as a Cc if ticket is created by either in the users list<br><br>my @users = ('user0@mydomain.com', 'user1@mydomain.com');<br>my $creator = $self->TransactionObj->CreatorObj->EmailAddress;<br>my $Ticket = $self->TicketObj;<br><br>if ($creator eq $users[0]) {<br> $Ticket->AddWatcher(Type => 'Cc', Email => $users[1]);<br>}<br>elsif ($creator eq $users[1]) {<br> $Ticket->AddWatcher(Type => 'Cc', Email => $users[0]);<br>}<br><br>In the Custom action cleanup code box, insert:<br> 1;<br><br><br>-- Jim<br><br><br>From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Miles Scruggs<br>Sent: Monday, April 22, 2013 3:52 PM<br>To: RT users<br>Subject: Re: [rt-users] Custom condition for script<br><br>anyone able to help on this one?<br><br>On Tue, Apr 16, 2013 at 10:46 AM, Miles Scruggs <miles@digitalphotobox.net<mailto:miles@digitalphotobox.net>> wrote:<br>I have a couple users that can't be trained to CC each other, and they need to be CC'd on everything they create, but they also aren't the only ones creating to the queue so I can't just set them as a watcher for the queue.<br><br>Basically I would like to check on create to see if they are one or the other user, and if they are then I would like to add their counterpart as a CC to the ticket. Basically some code that looks like this:<br><br>if(user=bob | bill) {<br> AddUserAsCCToTicket(bob&bill)<br>}<br><br>The bad news here is that I'm incredibly dumb when it comes to perl, and have no grasp at all of the syntax much less the methods to use.<br><br>I'm guessing I put stuff like this in scrips, but I'm not 100% and I'm not sure if that can be put entirely in the condition or if I need to put it in both the condition and the action...<br><br>Cheers<br><br>Miles Scruggs<br>miles@digitalphotobox.net<mailto:miles@digitalphotobox.net><br><br><br><br><br>--<br>Cheers,<br><br>Miles<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/9d8a10aa/attachment-0001.html><br><br>------------------------------<br><br>Message: 2<br>Date: Tue, 23 Apr 2013 21:20:01 +0300<br>From: Rabin Yasharzadehe <rabin@isoc.org.il><br>To: rt-users@lists.bestpractical.com<br>Subject: [rt-users] Fwd: Adding Index to several tables to improve<br><span class="Apple-tab-span" style="white-space:pre"> </span>shredder<span class="Apple-tab-span" style="white-space:pre"> </span>performance<br>Message-ID:<br><span class="Apple-tab-span" style="white-space:pre"> </span><CAKAdUjSaX0+zb3XoV6Cyo6g47uHt-=t9rsMqQQX1V_VLuQXneQ@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>Hello list,<br><br> In preparation for transferring our RT server to a new server<br>I started to clean up RT using the shredder tool,<br><br>For starters, I shred old tickets marked as deleted (mostly spam),<br><br># ./rt-shredder --plugin "Tickets=query,Status = 'Deleted' AND LastUpdated<br><blockquote type="cite">< '30 days ago';limit,100" --sqldump /opt/shredder-restore-tickets-`date<br></blockquote><blockquote type="cite">+%s`.sql --force<br></blockquote><br><br>And the next step was deleting users who have no tickets<br><br># ./rt-shredder --plugin<br><blockquote type="cite">"Users=no_tickets,1;status,any;replace_relations,Nobody;limit,25" --sqldump<br></blockquote><blockquote type="cite">/opt/shredder-restore-tickets-`date +%s`.sql --force<br></blockquote><br><br>Running the following commands from the command line would take me about<br>two hours to finish.<br><br>I'm no database expert, but i start searching around and enabled slow query<br>login for MySQL and i found out that the script hang a lot on query on the<br>Attachment table, the problem seemed to be a missing index for the<br>creator column.<br><br>mysql> ALTER TABLE `Attachments` ADD INDEX ( `Creator` )<br><br><br>After adding the above indexing for this column, the deletion time dropped<br>to less than 5 minutes<br><br>Given the success of the above method, I used it on other tables,<br>and found few more places that I can add indexing to improve shredder<br>timing.<br><br>ALTER TABLE `Transactions` ADD INDEX ( `Creator` )<br><blockquote type="cite">ALTER TABLE `ObjectCustomFieldValues` ADD INDEX ( `ObjectType` )<br></blockquote><blockquote type="cite">ALTER TABLE `ObjectCustomFieldValues` ADD INDEX ( `ObjectId` )<br></blockquote><blockquote type="cite">ALTER TABLE `Groups` ADD INDEX ( `LastUpdatedBy` )<br></blockquote><blockquote type="cite">ALTER TABLE `Principals` ADD INDEX ( `PrincipalType` )<br></blockquote><blockquote type="cite">ALTER TABLE `CachedGroupMembers` ADD INDEX ( `Via` )<br></blockquote><blockquote type="cite">ALTER TABLE `GroupMembers` ADD INDEX ( `LastUpdatedBy` )<br></blockquote><blockquote type="cite">ALTER TABLE `Groups` ADD INDEX ( `Creator` )<br></blockquote><blockquote type="cite">ALTER TABLE `Tickets` ADD INDEX ( `Creator` )<br></blockquote><br><br>My question is,<br>can i leave the above index ?<br>can those changes disturb or harm future upgrades of RT ?<br><br>Thanks in advance,<br>--<br>??<br>Rabin Yasharzadehe<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/57b4ded9/attachment-0001.html><br><br>------------------------------<br><br></div></blockquote><div>I found the following template and it worked great. Thank you all for your continued support on items like this.</div><div>This is a great community!!</div><div>Jim, this is pretty much what you had indicated and I think my regional attempt had an issue with the large subject line I was using. Thanks again</div><div><br></div><div>Joe</div><div><div>===Create-Ticket: Financial Aid and Scholarships - Referral </div><div>Subject: Referral::{$Tickets{'TOP'}->Subject}</div><div>Referred-To-By: {$Tickets{'TOP'}->Id}</div><div>Queue: Financial Aid and Scholarships - Referral</div><div>InitialPriority: 99</div><div>FinalPriority: 99</div><div>Requestor: {$Tickets{'TOP'}->RequestorAddresses}</div><div>Content: This request is a referral from a walk-in customer for Financial Aid and Scholarships. The initial ticket has been closed but linked to this ticket for any pertinent information </div><div>ENDOFCONTENT</div></div><br><blockquote type="cite"><div>Message: 3<br>Date: Tue, 23 Apr 2013 17:42:18 -0400<br>From: Joe Kirby <<a href="mailto:kirby@umbc.edu">kirby@umbc.edu</a>><br>To: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>Subject: Re: [rt-users] Issue with creating linked tickets<br>Message-ID: <<a href="mailto:909DF5A0-ED3A-4B32-A64F-4231C056AA1C@umbc.edu">909DF5A0-ED3A-4B32-A64F-4231C056AA1C@umbc.edu</a>><br>Content-Type: text/plain; charset="us-ascii"<br><br>Jim<br><br>Thanks for the suggestion.<br><br>I tried removing the line and now it does not create linked tickets at all.<br><br>I went to the url you shared and all the examples have the Type: approval<br><br>I hope someone has a suggestion as this is key to my project and it seems like it could work.<br><br>Thanks in advance<br><br>Joe<br><br>Joe Kirby , Assistant Vice President, Business Systems<br>Division of Information Technology (DoIT) <br>Support Response - <a href="http://www.umbc.edu/doit">http://www.umbc.edu/doit</a> <br>Administration 627<br>Office - 410-455-3020 <br>Email - <a href="mailto:kirby@umbc.edu">kirby@umbc.edu</a><br><br>On Apr 22, 2013, at 12:00 PM, <a href="mailto:rt-users-request@lists.bestpractical.com">rt-users-request@lists.bestpractical.com</a> wrote:<br><br><blockquote type="cite">Send rt-users mailing list submissions to<br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">To subscribe or unsubscribe via the World Wide Web, visit<br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br></blockquote><blockquote type="cite">or, via email, send a message with subject or body 'help' to<br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:rt-users-request@lists.bestpractical.com">rt-users-request@lists.bestpractical.com</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">You can reach the person managing the list at<br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:rt-users-owner@lists.bestpractical.com">rt-users-owner@lists.bestpractical.com</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">When replying, please edit your Subject line so it is more specific<br></blockquote><blockquote type="cite">than "Re: Contents of rt-users digest..."<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Today's Topics:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> 1. Issue with creating linked tickets automatically (Joe Kirby)<br></blockquote><blockquote type="cite"> 2. Re: Issue with creating linked tickets automatically (Jim Brandt)<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">----------------------------------------------------------------------<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Message: 1<br></blockquote><blockquote type="cite">Date: Sun, 21 Apr 2013 13:30:45 -0400<br></blockquote><blockquote type="cite">From: Joe Kirby <<a href="mailto:kirby@umbc.edu">kirby@umbc.edu</a>><br></blockquote><blockquote type="cite">To: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br></blockquote><blockquote type="cite">Subject: [rt-users] Issue with creating linked tickets automatically<br></blockquote><blockquote type="cite">Message-ID: <<a href="mailto:1542B2D9-AC07-4917-A372-5684D917B404@umbc.edu">1542B2D9-AC07-4917-A372-5684D917B404@umbc.edu</a>><br></blockquote><blockquote type="cite">Content-Type: text/plain; charset=us-ascii<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I have a extension installed to allow a template to create linked tickets in certain situations.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Everything seems to work great except the query tool does not recognize the tickets in the queue.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">If I go into the parent and see the children and vice versa. If I use the ticket number all is good<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">It just does not show up in any of the reports when selected. This is not an issue when I manually create the link ticket.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I am 4.0.6 and here is the template I am using the following template with a script that has the action of create tickets using this template.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">If I am missing a line or a command that is causing the queue to not be visible please advise.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">===Create-Ticket: Financial Aid and Scholarships - Referral <br></blockquote><blockquote type="cite">Subject: Financial Aid and Scholarships - Referral has been requested from a Phone request for {$Tickets{'TOP'}->Subject}<br></blockquote><blockquote type="cite">Referred-To-By: {$Tickets{'TOP'}->Id}<br></blockquote><blockquote type="cite">Queue: Financial Aid and Scholarships - Referral<br></blockquote><blockquote type="cite">InitialPriority: 99<br></blockquote><blockquote type="cite">FinalPriority: 99<br></blockquote><blockquote type="cite">Requestor: {$Tickets{'TOP'}->RequestorAddresses}<br></blockquote><blockquote type="cite">Type: approval<br></blockquote><blockquote type="cite">Content: This request is a referral from a phone customer for Financial Aid and Scholarships. The initial ticket has been closed but linked to this ticket for any pertinent information <br></blockquote><blockquote type="cite">ENDOFCONTENT<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thanks<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Joe<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Also: Note to Rus. I am having the Commandbymail extension added this coming week. Thank you very much for the suggestion<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Joe Kirby , Assistant Vice President, Business Systems<br></blockquote><blockquote type="cite">Division of Information Technology (DoIT) <br></blockquote><blockquote type="cite">Support Response - <a href="http://www.umbc.edu/doit">http://www.umbc.edu/doit</a> <br></blockquote><blockquote type="cite">Administration 627<br></blockquote><blockquote type="cite">Office - 410-455-3020 <br></blockquote><blockquote type="cite">Email - <a href="mailto:kirby@umbc.edu">kirby@umbc.edu</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">------------------------------<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Message: 2<br></blockquote><blockquote type="cite">Date: Mon, 22 Apr 2013 07:53:38 -0400<br></blockquote><blockquote type="cite">From: Jim Brandt <<a href="mailto:jbrandt@bestpractical.com">jbrandt@bestpractical.com</a>><br></blockquote><blockquote type="cite">To: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br></blockquote><blockquote type="cite">Subject: Re: [rt-users] Issue with creating linked tickets<br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span>automatically<br></blockquote><blockquote type="cite">Message-ID: <<a href="mailto:517524C2.4000007@bestpractical.com">517524C2.4000007@bestpractical.com</a>><br></blockquote><blockquote type="cite">Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">You have Type: approval as one of your lines. Do you intend to create <br></blockquote><blockquote type="cite">approval tickets? (Approval tickets are used in the RT approvals <br></blockquote><blockquote type="cite">process: <a href="http://bestpractical.com/rt/docs/latest/customizing/approvals.html">http://bestpractical.com/rt/docs/latest/customizing/approvals.html</a>)<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">If you just want regular tickets, try removing that line.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On 4/21/13 1:30 PM, Joe Kirby wrote:<br></blockquote><blockquote type="cite"><blockquote type="cite">I have a extension installed to allow a template to create linked tickets in certain situations.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Everything seems to work great except the query tool does not recognize the tickets in the queue.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">If I go into the parent and see the children and vice versa. If I use the ticket number all is good<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">It just does not show up in any of the reports when selected. This is not an issue when I manually create the link ticket.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I am 4.0.6 and here is the template I am using the following template with a script that has the action of create tickets using this template.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">If I am missing a line or a command that is causing the queue to not be visible please advise.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">===Create-Ticket: Financial Aid and Scholarships - Referral<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Subject: Financial Aid and Scholarships - Referral has been requested from a Phone request for {$Tickets{'TOP'}->Subject}<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Referred-To-By: {$Tickets{'TOP'}->Id}<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Queue: Financial Aid and Scholarships - Referral<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">InitialPriority: 99<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">FinalPriority: 99<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Requestor: {$Tickets{'TOP'}->RequestorAddresses}<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Type: approval<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Content: This request is a referral from a phone customer for Financial Aid and Scholarships. The initial ticket has been closed but linked to this ticket for any pertinent information<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ENDOFCONTENT<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Thanks<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Joe<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Also: Note to Rus. I am having the Commandbymail extension added this coming week. Thank you very much for the suggestion<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Joe Kirby , Assistant Vice President, Business Systems<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Division of Information Technology (DoIT)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Support Response - <a href="http://www.umbc.edu/doit">http://www.umbc.edu/doit</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Administration 627<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Office - 410-455-3020<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Email - <a href="mailto:kirby@umbc.edu">kirby@umbc.edu</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">-- <br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">------------------------------<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">--------<br></blockquote><blockquote type="cite">rt-users mailing list<br></blockquote><blockquote type="cite"><a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br></blockquote><blockquote type="cite"><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">End of rt-users Digest, Vol 109, Issue 30<br></blockquote><blockquote type="cite">*****************************************<br></blockquote><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/aba02e5e/attachment-0001.html">http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/aba02e5e/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 4<br>Date: Tue, 23 Apr 2013 16:51:32 -0500<br>From: "Ken Johnson" <<a href="mailto:kjohnson@eclypse.org">kjohnson@eclypse.org</a>><br>To: "'RT users'" <<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><br>Subject: [rt-users] How change link labels<br>Message-ID: <22258089FD4F461EA1DD6254DE0D4D04@KJDESKTOP><br>Content-Type: text/plain;<span class="Apple-tab-span" style="white-space:pre"> </span>charset="us-ascii"<br><br><br>I would like to change the 'Reply' and 'Comment' link labels within RT to<br>something like 'Public Reply' and 'Private Comment' to make their respective<br>functions more obviously explicit to staff who will use RT only<br>occasionally. Unfortunately, I have been unable to structure a google<br>search to return useful information on this topic. I would be grateful for<br>any hints.<br><br>Thank you,<br><br>Ken<br><br><br><br>------------------------------<br><br>Message: 5<br>Date: Tue, 23 Apr 2013 14:54:23 -0700<br>From: Miles Scruggs <<a href="mailto:miles@digitalphotobox.net">miles@digitalphotobox.net</a>><br>To: RT users <<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><br>Subject: Re: [rt-users] Custom condition for script<br>Message-ID: <<a href="mailto:C60612D0-6F99-4299-824E-09CFE47D82A8@digitalphotobox.net">C60612D0-6F99-4299-824E-09CFE47D82A8@digitalphotobox.net</a>><br>Content-Type: text/plain; charset="us-ascii"<br><br>Thanks Jim,<br><br>I think that has got me off and running now. About order of execution, from what I read it is alphabetical, does that group queue specific scripts in with the globals and then order them?<br><br>Cheers<br><br>Miles Scruggs<br><a href="mailto:miles@digitalphotobox.net">miles@digitalphotobox.net</a><br><br><br><br>On Apr 23, 2013, at 10:01 AM, Jim Berry <jim.h.berry@frb.gov> wrote:<br><br><blockquote type="cite">This should do what you want . It could be generalized to use groups or AdminCc. Create a scrip with<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Condition = On Create<br></blockquote><blockquote type="cite">Action = User Defined<br></blockquote><blockquote type="cite">Template = Blank<br></blockquote><blockquote type="cite">Stage = TransactionCreate<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">In the Custom action preparation code box, insert:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">## Add other user as a Cc if ticket is created by either in the users list<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">my @users = ('user0@mydomain.com', 'user1@mydomain.com');<br></blockquote><blockquote type="cite">my $creator = $self->TransactionObj->CreatorObj->EmailAddress;<br></blockquote><blockquote type="cite">my $Ticket = $self->TicketObj;<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">if ($creator eq $users[0]) {<br></blockquote><blockquote type="cite"> $Ticket->AddWatcher(Type => 'Cc', Email => $users[1]);<br></blockquote><blockquote type="cite">}<br></blockquote><blockquote type="cite">elsif ($creator eq $users[1]) {<br></blockquote><blockquote type="cite"> $Ticket->AddWatcher(Type => 'Cc', Email => $users[0]);<br></blockquote><blockquote type="cite">}<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">In the Custom action cleanup code box, insert:<br></blockquote><blockquote type="cite"> 1;<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">-- Jim<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Miles Scruggs<br></blockquote><blockquote type="cite">Sent: Monday, April 22, 2013 3:52 PM<br></blockquote><blockquote type="cite">To: RT users<br></blockquote><blockquote type="cite">Subject: Re: [rt-users] Custom condition for script<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">anyone able to help on this one?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On Tue, Apr 16, 2013 at 10:46 AM, Miles Scruggs <miles@digitalphotobox.net> wrote:<br></blockquote><blockquote type="cite">I have a couple users that can't be trained to CC each other, and they need to be CC'd on everything they create, but they also aren't the only ones creating to the queue so I can't just set them as a watcher for the queue.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Basically I would like to check on create to see if they are one or the other user, and if they are then I would like to add their counterpart as a CC to the ticket. Basically some code that looks like this:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">if(user=bob | bill) {<br></blockquote><blockquote type="cite"> AddUserAsCCToTicket(bob&bill)<br></blockquote><blockquote type="cite">}<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">The bad news here is that I'm incredibly dumb when it comes to perl, and have no grasp at all of the syntax much less the methods to use.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I'm guessing I put stuff like this in scrips, but I'm not 100% and I'm not sure if that can be put entirely in the condition or if I need to put it in both the condition and the action...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Cheers<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Miles Scruggs<br></blockquote><blockquote type="cite">miles@digitalphotobox.net<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">-- <br></blockquote><blockquote type="cite">Cheers,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Miles<br></blockquote><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/59b23350/attachment-0001.html><br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: smime.p7s<br>Type: application/pkcs7-signature<br>Size: 4895 bytes<br>Desc: not available<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/59b23350/attachment-0001.bin><br><br>------------------------------<br><br>Message: 6<br>Date: Tue, 23 Apr 2013 14:56:12 -0700<br>From: Thomas Sibley <trs@bestpractical.com><br>To: rt-users@lists.bestpractical.com<br>Subject: Re: [rt-users] Issue with creating linked tickets<br>Message-ID: <5177037C.6090907@bestpractical.com><br>Content-Type: text/plain; charset=UTF-8<br><br>On 04/23/2013 02:42 PM, Joe Kirby wrote:<br><blockquote type="cite">Jim<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thanks for the suggestion.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I tried removing the line and now it does not create linked tickets at all.<br></blockquote><br>Anything in the error logs? I suspect your template is parsing<br>incorrectly for a different reason.<br><br><blockquote type="cite">I went to the url you shared and all the examples have the Type: approval<br></blockquote><br>... because Jim linked you to the approvals docs after asking if you<br>intended to create approvals. If you're not trying to create approvals,<br>then don't include that line.<br><br><blockquote type="cite"><br></blockquote><blockquote type="cite">I hope someone has a suggestion as this is key to my project and it<br></blockquote><blockquote type="cite">seems like it could work.<br></blockquote><br>It works for lots of folks. There's likely just an error in your template.<br><br><br>------------------------------<br><br>Message: 7<br>Date: Tue, 23 Apr 2013 22:46:15 +0000<br>From: Tyler Harding <tharding@uoregon.edu><br>To: "rt-users@lists.bestpractical.com"<br><span class="Apple-tab-span" style="white-space:pre"> </span><rt-users@lists.bestpractical.com><br>Subject: [rt-users] Script to collect info from child tickets<br>Message-ID: <AD49239A1EAC714F80022E6E13C82CBAE1D667@ad-oh-mbx01><br>Content-Type: text/plain; charset="us-ascii"<br><br>Hello all,<br><br>Apologies if this has been answered before, did my best to search and whatnot.<br><br>I'm writing a script that pokes around in child tickets. My abridged version of it:<br><br>my $Children = $self->TicketObj->Members();<br>while( my $childTicket = $Children->Next ) {<br>my $childId = $childTicket->TargetObj->id;<br># Do some other stuff here....<br>}<br>return 1;<br><br>However the above only gives me information about the ticket I started in (i.e. $self->TicketObj). For whatever reason, the following work as anticipated:<br><br>$self->TicketObj->MemberOf();<br>$self->TicketObj->DependsOn();<br>$self->TicketObj->RefersTo();<br><br>And these simply cough up the same ticket I started with:<br><br>$self->TicketObj->Members();<br>$self->TicketObj->DependedOnBy();<br>$self->TicketObj->ReferredToBy();<br><br>Any ideas?<br><br>Thank you,<br><br>-Tyler<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/3f34634b/attachment-0001.html><br><br>------------------------------<br><br>Message: 8<br>Date: Tue, 23 Apr 2013 20:57:26 -0500<br>From: Michael Steen <michael.steen@livetext.com><br>To: "rt-users@lists.bestpractical.com"<br><span class="Apple-tab-span" style="white-space:pre"> </span><rt-users@lists.bestpractical.com><br>Subject: Re: [rt-users] How change link labels<br>Message-ID:<br><span class="Apple-tab-span" style="white-space:pre"> </span><CAOmWLor7_4v3KKC3LkukHSGA1=_nNeESVJdYRxyM9pV7AP+xRA@mail.gmail.com><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Ken,<br><br>I did something of the sort when a user here said that a particular wording<br>was not indicative of its meaning (basically, he did not like to see "Input<br>must match [Mandatory]"). For our case, I modified our installation as<br>follows:<br><br>Copied:<br>share/html/Elements/ValidateCustomFields<br><br>To:<br>local/html/Elements/ValidateCustomFields<br><br>Changed Line:<br>my $msg = loc("Input must match [_1]", $CF->FriendlyPattern);<br><br>New Line:<br>my $msg = loc("Field must match rule: [_1]", $CF->FriendlyPattern);<br><br><br>I see the "message" you are referring to in<br>/opt/rt3/share/html/m/_elements/ticket_menu. Editing the element for your<br>local installation may or may not be the most portable and maintainable<br>way, but it worked for our site and nobody was harmed. Since your similar<br>situation has come up, I would be interested to find out what the usual or<br>best practice is for site-specific wording. It's clearly a matter of<br>preference for our site, and the message in question does not appear<br>elsewhere (AFAIK), so I left it at that, but perhaps updating<br>local/po/en.po will turn out to be the recommended way. Some information<br>about updating translations is here -><br>http://requesttracker.wikia.com/wiki/Translation.<br><br>Best,<br><br>Mike<br><br><br>On Tue, Apr 23, 2013 at 4:51 PM, Ken Johnson <kjohnson@eclypse.org> wrote:<br><br><blockquote type="cite"><br></blockquote><blockquote type="cite">I would like to change the 'Reply' and 'Comment' link labels within RT to<br></blockquote><blockquote type="cite">something like 'Public Reply' and 'Private Comment' to make their<br></blockquote><blockquote type="cite">respective<br></blockquote><blockquote type="cite">functions more obviously explicit to staff who will use RT only<br></blockquote><blockquote type="cite">occasionally. Unfortunately, I have been unable to structure a google<br></blockquote><blockquote type="cite">search to return useful information on this topic. I would be grateful for<br></blockquote><blockquote type="cite">any hints.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thank you,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Ken<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/89d58484/attachment-0001.html><br><br>------------------------------<br><br>Message: 9<br>Date: Wed, 24 Apr 2013 02:11:17 -0700 (PDT)<br>From: saxmad <g.mason@fairfx.com><br>To: rt-users@lists.bestpractical.com<br>Subject: Re: [rt-users] Problems upgrading from 3.9.3<br>Message-ID: <1366794677920-53596.post@n7.nabble.com><br>Content-Type: text/plain; charset=us-ascii<br><br>Kevin - I think I get what you mean. My postgres knowledge is next to<br>nothing, so hopefully I have got the appropriate information.<br><br>On my original 3.6.7 instance, I have the following :-<br><br> Table "public.acl"<br> Column | Type | Modifiers <br>| Description <br>---------------+-----------------------+--------------------------------------------------+-------------<br> id | integer | not null default<br>nextval('acl_id_seq'::regclass) | <br> principaltype | character varying(25) | not null <br>| <br> principalid | integer | not null <br>| <br> rightname | character varying(25) | not null <br>| <br> objecttype | character varying(25) | not null <br>| <br> objectid | integer | not null default 0 <br>| <br> delegatedby | integer | not null default 0 <br>| <br> delegatedfrom | integer | not null default 0 <br>| <br>Indexes:<br> "acl_pkey" PRIMARY KEY, btree (id)<br> "acl1" btree (rightname, objecttype, objectid, principaltype,<br>principalid)<br>Has OIDs: no<br><br>On my new, upgraded version that is in limbo between 3.9.2 and 3.9.3, I have<br>the following :-<br><br> Table "public.acl"<br> Column | Type | Modifiers <br>| Storage | Stats target | Description <br>---------------+-----------------------------+--------------------------------------------------+----------+--------------+-------------<br> id | integer | not null default<br>nextval('acl_id_seq'::regclass) | plain | | <br> principaltype | character varying(25) | not null <br>| extended | | <br> principalid | integer | not null <br>| plain | | <br> rightname | character varying(25) | not null <br>| extended | | <br> objecttype | character varying(25) | not null <br>| extended | | <br> objectid | integer | not null default 0 <br>| plain | | <br> creator | integer | not null default 0 <br>| plain | | <br> created | timestamp without time zone | <br>| plain | | <br> lastupdatedby | integer | not null default 0 <br>| plain | | <br> lastupdated | timestamp without time zone | <br>| plain | | <br>Indexes:<br> "acl_pkey" PRIMARY KEY, btree (id)<br> "acl1" btree (rightname, objecttype, objectid, principaltype,<br>principalid)<br>Has OIDs: no<br><br>So the DelegatedBy column is definately not there now.<br><br>When I looked at the acl table on a freshly imported version of the dump, I<br>found that it looked exactly like upgraded version, and not like the<br>original 3.6.7 version. I checked the dump file and the acl table was<br>indeed supposed to be set up using the correct formation (3.6.7 version).<br><br>Checking a bit deeper, it seems that I have two acl tables, one within the<br>rtdb database, and another when connected to the default postgres database. <br>If I look at the layout of the spurious postgres version of the acl table,<br>it has the 3.6.7 layout.<br><br>I don't know how this has happened, and is almost certainly the reason why<br>the acl table doesn't upgrade properly, as it is already effectively<br>upgraded before attempting the upgrade procedure.<br><br>I will clear out all traces of the rtdb database, and then check for<br>residual tables etc, before trying another clean import.<br><br>Thanks for hanging in there :)<br><br><br><br>--<br>View this message in context: http://requesttracker.8502.n7.nabble.com/Problems-upgrading-from-3-9-3-tp53543p53596.html<br>Sent from the Request Tracker - User mailing list archive at Nabble.com.<br><br><br>------------------------------<br><br>Message: 10<br>Date: Wed, 24 Apr 2013 04:06:11 -0700 (PDT)<br>From: saxmad <g.mason@fairfx.com><br>To: rt-users@lists.bestpractical.com<br>Subject: Re: [rt-users] Problems upgrading from 3.9.3<br>Message-ID: <1366801571799-53598.post@n7.nabble.com><br>Content-Type: text/plain; charset=us-ascii<br><br>After a lot of trial and error, I think I have worked out what is going on.<br><br>With a clean postgres database, I cannot import my dump file due to the<br>rtuser role not being there.<br><br>So I initialised the database by running the rt-setup-database-4 --action<br>init utility to put that right. Unfortunately, part of this seems to be<br>setting up the initial core data, which looks like it includes the acl<br>table.<br><br>Dropping the database, tables and sequences but leaving the rtuser role<br>intact, I can then import the dump file without any complaints. Tables etc<br>are created and populated, but it does not create the actual rtdb database -<br>\l within psql does not show an rtdb entry. I guess that initialising the<br>database as above would sort that, but then give me the same problem with an<br>pre-existing acl table.<br><br>So I think the answer to my problem is to determine exactly what the pg_dump<br>command is I need to extract everything from my current RT database in order<br>for me to be able to import it on my new server without having to initialise<br>the database first.<br><br>The file I am trying to import was created using pg_dump -f ${Dump_File}<br>rtdb.<br><br>I am aware of numerous options to pg_dump, but inexperience means I don't<br>know which ones to employ in order to get a dump of my RT database with full<br>integrity to enable a seamless import.<br><br>Can someone enlighten me as to exactly how I should use pg_dump to get my<br>data in a suitable format to enable me to simply import it with psql -f<br>datafile.sql so I can dop the upgrade cleanly ?<br><br><br><br><br>--<br>View this message in context: http://requesttracker.8502.n7.nabble.com/Problems-upgrading-from-3-9-3-tp53543p53598.html<br>Sent from the Request Tracker - User mailing list archive at Nabble.com.<br><br><br>------------------------------<br><br>--------<br>rt-users mailing list<br>rt-users@lists.bestpractical.com<br>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users<br><br><br><br>End of rt-users Digest, Vol 109, Issue 32<br>*****************************************<br></div></blockquote></div><br></body></html>