[rt-users] Search problem with linked tickets
Hi, I'm on 3.8.7 I have a problem. I like to build a query that find all the tickets linked to the tickets I own. Is this possible with the web-ui? Best, Björn
Re: [rt-users] Trouble: I need to parse the issue ticket
check that: http://wiki.bestpractical.com/view/ClassObjectsMethods http://wiki.bestpractical.com/view/GlobalObjects http://wiki.bestpractical.com/view/ObjectModel or try one of the great bps training sessions with jesse. -bjoern Am 24.05.2010 02:43, schrieb Pablo Silva: Yes, now works!!, where I can find documentation about methods and object more ilustrative..?, because it's not easy to read the perldoc xxx.pm, there's some tutorial for to learn about object's, methods? Thanks in advance! -Pablo On Sat, May 22, 2010 at 12:11 PM, Bjoern Schulzbjoern.sch...@desy.de wrote: hi, check that http://wiki.bestpractical.com/view/ExtractCustomFieldValues For me it works fine. -bjoern Am 22.05.2010 17:31, schrieb Pablo Silva: Hi!, I would like to parse the issue Ticket on the Create event, because inside the e-mail i need to search word Precio and to get the Value, for Example: [r...@rt ~]# mail rt-comp...@rt.osa.cl Subject: Test Bla bla Precio: 2000 . Cc: [r...@rt ~]# Send an e-mail to rt. I use this code but dosen't work, and don't know why.., the code is: $self-TransactionObj-Content() =~ /Precio: (.*) /i That's my scrip on rt 3.8.7 Condition: On Create Action: User Define Template: Global Template Blank Stage: Transaction Stage Custom action preparation code: my $precio=0; if ($self-TransactionObj-Content() =~ /Precio: (.*) /i ) { $precio=$1 } $RT::Logger-debug(Que es esto? . $self-TransactionObj-Content() ); $self-TicketObj-AddCustomFieldValue( Field ='Precio', Value = $precio ); return 1; Custom action cleanup code: my $funcionario; $funcionario=; if ($self-TicketObj-FirstCustomFieldValue('Precio') le 200){ $funcionario=cfigueroa; } else { $funcionario=msilva; } $self-TicketObj-SetOwner($funcionario,'Give'); $self-TicketObj-SetQueue(General); return 1; Thanks in advance.. Pablo Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Trouble: I need to parse the issue ticket
hi, check that http://wiki.bestpractical.com/view/ExtractCustomFieldValues For me it works fine. -bjoern Am 22.05.2010 17:31, schrieb Pablo Silva: Hi!, I would like to parse the issue Ticket on the Create event, because inside the e-mail i need to search word Precio and to get the Value, for Example: [r...@rt ~]# mail rt-comp...@rt.osa.cl Subject: Test Bla bla Precio: 2000 . Cc: [r...@rt ~]# Send an e-mail to rt. I use this code but dosen't work, and don't know why.., the code is: $self-TransactionObj-Content() =~ /Precio: (.*) /i That's my scrip on rt 3.8.7 Condition: On Create Action: User Define Template: Global Template Blank Stage: Transaction Stage Custom action preparation code: my $precio=0; if ($self-TransactionObj-Content() =~ /Precio: (.*) /i ) { $precio=$1 } $RT::Logger-debug(Que es esto? . $self-TransactionObj-Content() ); $self-TicketObj-AddCustomFieldValue( Field = 'Precio', Value = $precio ); return 1; Custom action cleanup code: my $funcionario; $funcionario=; if ($self-TicketObj-FirstCustomFieldValue('Precio') le 200){ $funcionario=cfigueroa; } else { $funcionario=msilva; } $self-TicketObj-SetOwner($funcionario,'Give'); $self-TicketObj-SetQueue(General); return 1; Thanks in advance.. Pablo Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] rt-mailgate: change timeout default
Hi RT Users, I try to change the rt-mailgate timeout default without changing the source? I don't find this in RT_Config. Any hints or suggestions? Best regards, Björn Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-mailgate: change timeout default
Hi Torsten, Am 09.04.2010 14:13, schrieb Torsten Brumm: Hi Björn, try at the mailgate command: --timeout=seconds I know that, but I like to change the default (180s to 360s) ;-) I don't like to change all my procmail rc's... Schönes Wochenende und geniesse das feine Wetter in Hamburg, Björn Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt-mailgate: change timeout default
Hi Exim-Guy! Am 09.04.2010 14:56, schrieb Torsten Brumm: OK, open rt-mailgate and navigate to: 127 $ua-timeout( exists( $opts{'timeout'} )? $opts{'timeout'}: 180 ); 128 my $r = $ua-post( $full_url, \%args, Content_Type = 'form-data' ); 129 check_failure($r); OK I know that, I don't like to change the source ( as you, if I remember correctly) i think here you can change this for your slow postfix ;-) Maybe it's mysql but who knows... Postfix is not the problem, gell Schönes Wochenende Danke und grüße zu Hause! Postfix-Björn Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Missing menu items - show results etc.
Hi Jesse! That is correct. This is a new option in 3.8.6. The issue you're running into is clearly a bug that we need to fix for 3.8.7. But the workaround should be ok for now, I hope. It's ok! Thx, Björn ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] behavior change after using FCKeditor
Hi together, we observed a behavior change in bulk update if using FCKeditor. Problem: Bulk update to take owner ship for several tickets without FCKeditor enabled sends no mail in our environment. That's the behavior we know. Same with FCKeditor enabled sends mail. That's new and unwanted. Does any body know something about that? Ciao, Björn ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Wiki Home is only SPAM
Hi, http://wiki.bestpractical.com/edit/HomePage is only SPAM. @jesse: I can't edit the homepage, there is a problem with my account. Cheers, Björn ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Merging 2 RT systems
Hi, If I remember correctly, we use RT-Extension-RT2toRT3 several years ago. Kevin programmed it. http://www.cpan.org/authors/id/F/FA/FALCONE/RT-Extension-RT2toRT3-1.26.readme Cheers, Björn Bashir Jahed wrote: Hi All, I have a request from business to merge 2 RT systems. One is RT 3.x and the other is RT 2.x Is this possible, if yes could anyone advise on best route to take? Thanks bashir jahed nha | enhance 5 protea road | claremont | 7708 po box 24 | newlands | 7725 telephone +27 (21) 657-2574 mobile +27 (83) 414-0453 facsimile +27 (21) 657-2575 e-mail | messenger bashir.ja...@nha.co.za mailto:bashir.ja...@nha.co.za this message is subject to the disclaimer at www.nha.co.za/disclaimer.asp http://www.nha.co.za/disclaimer.asp or disclai...@nha.co.za mailto:disclai...@nha.co.za?subject=request%20disclaimer ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT at a glance copy to multiple users
Hi list, is there a way to copy the configuration of RT at a glance from one user to another. The default for RT at a glance is in this case not a solution. We have different user groups dealing with rt and they like to have different RT at a glance configs for there group members. Best regards Björn ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] search case sensitiv
Hi Curtis, thx for your quick reply. Our rt (3.8.1) is an upgrade from rt 3.6.7. On the old RT the table options for the table Attachments are Character Set is cp1252 West European and the collation is latin1_swedish_ci. The Column Content is a LONGTEXT (Character Set cp1252 West European). On the new RT Attachments are Character Set UTF-8 Unicode and the collation is utf8_general_ci. But the Column Content was changed to LONGBLOB, no special CharSet or Collation. IMHO a collation attribute change doesn't help us. Do you know another way to make search in RT case in sensitive? Cheers, Björn Curtis Bruneau wrote: I'm guessing you are using utf8_bin collation, the others are case insensitive. Unfortunately non binary utf8 ones aren't accent sensitive so it lacks a bit compared to latin1 which offers both. If accents aren't a major concern you should be using like utf8_unicode_ci or utf8_general_ci or swedish .. they all have slightly different rules for sorting. Bjoern Schulz wrote: Hi RT Users. after upgrading to 3.8.1 the search for ticket content is case sensitiv. To solve this problem (for us) any hint would be appreciated. Best regards Björn System. SL5 (RHEL5) mysql 5.0.45 perl 5.8.8 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] search case sensitiv
Hi RT Users. after upgrading to 3.8.1 the search for ticket content is case sensitiv. To solve this problem (for us) any hint would be appreciated. Best regards Björn System. SL5 (RHEL5) mysql 5.0.45 perl 5.8.8 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: Subject: [rt-users] Date/Time in exported spreadsheet wrong
Hi Andrew, yes, it is GMT. Jesse gave the hint some day ago. But I haven't got an idea to fix it. cheers, Björn Andrew Dike schrieb: Hi Bjoern, I have noticed the same issue in RT 3.6.0. I'm not sure if I got to the bottom of it but I believe that the time recorded in the database is always GMT. When you view times and dates via the web front end, the settings in RT_SiteConfig.pm come into effect, adjusting the time for your location. However the export function always outputs data direct from the DB. I hope there's a straightforward way to fix this because it's quite frustrating for users. Andrew Date: Tue, 02 Oct 2007 09:18:39 +0200 From: Bjoern Schulz [EMAIL PROTECTED] Subject: [rt-users] Date/Time in exported spreadsheet wrong Hi list, we are using RT 3.6.5 RC2 and I observe the following problem. We like to export search data to a spreadsheet, but there is a different between the date in the web-UI and the exported data. In our case its 2 hours. Our RT_SiteConfig.pm # $Timezone is used to convert times entered by users into GMT and back again # It should be set to a timezone recognized by your local unix box. Set($Timezone , 'Europe/Berlin'); Thanks for any input! bjoern ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Date/Time in exported spreadsheet wrong
Hi list, we are using RT 3.6.5 RC2 and I observe the following problem. We like to export search data to a spreadsheet, but there is a different between the date in the web-UI and the exported data. In our case its 2 hours. Our RT_SiteConfig.pm # $Timezone is used to convert times entered by users into GMT and back again # It should be set to a timezone recognized by your local unix box. Set($Timezone , 'Europe/Berlin'); Thanks for any input! bjoern ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] CC field addressee does not get message
hi kamber, do you have activated scrips for sending email to cc's. Look at Configuration - Global - Scrips or Configuration - Queue - Scrips regards björn Dalal, Kamber Z (Kamber) schrieb: The addressee in the cc field of the reply form of the ticket is not sent the email message. The postfix service is running. Is there a patch, perl module, or config in RT_SiteConfig.pm that needs to be set or corrected? This has been noticed recently, In the ticket history, correspondence is added with a line: RT-Send-CC: (cc'd address) Also only 1 transaction is listed that 'RT_System - Outgoing email recorded' and no transaction listed for the cc'd addressed email. Kamber Dalal ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Sort savedsearches
Hi! One of my users would like to sort his savedsearches alphabetically. I doesn't found a way to do that. Any hints? Greets, Björn ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT 3.6.1 and RTFM2.2.0RC2 system error
Hi All, we have a prob with rtfm. Our setup is OS: SL43 (Scientific Linux Release 4.3 on i386) based on RHEL4 RT 3.6.1 RTFM-2.2.0RC2 mysql apache 2. After generating a new class, we are'nt able to call the topics page... system error below... Any hints? regards Björn Björn SchulzDESY - Deutsches Elektronen-Synchrotron IT Support / Mailmaster et al. Member of the Helmholtz Association D-22603 HamburgNotkestrasse 85 / 22607 Hamburg Tel: +49-40-8998.5005[EMAIL PROTECTED] ~~~ System error error: Can't locate object method ROOT via package Tree::Simple at /opt/rt3/share/html/Admin/RTFM/Classes/Topics.html line 155. context: ... 151:$topics-LimitToObject($ClassObj); 152:$topics-OrderByCols({FIELD = 'Parent'}, {FIELD = 'id'}); 153: 154:use Tree::Simple; 155:my $tree = Tree::Simple-new(Tree::Simple-ROOT); 156:my %lookup = (0 = $tree); 157: 158:my @todo; 159:while (my $topic = $topics-Next) { code stack: /opt/rt3/share/html/Admin/RTFM/Classes/Topics.html:155 /opt/rt3/share/html/Admin/autohandler:47 /opt/rt3/share/html/autohandler:279 raw error Can't locate object method ROOT via package Tree::Simple at /opt/rt3/share/html/Admin/RTFM/Classes/Topics.html line 155. Trace begun at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('Can\'t locate object method ROOT via package Tree::Simple at /opt/rt3/share/html/Admin/RTFM/Classes/Topics.html line 155.^J') called at /opt/rt3/share/html/Admin/RTFM/Classes/Topics.html line 155 HTML::Mason::Commands::__ANON__('id', 4, 'id', 4, 'id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xaf14e88)', 'id', 4, 'id', 4, 'id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1255 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1249 HTML::Mason::Request::comp(undef, undef, 'id', 4, 'id', 4, 'id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 916 HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xaf43d98)', 'id', 4) called at /opt/rt3/share/html/Admin/autohandler line 47 HTML::Mason::Commands::__ANON__('id', 4, 'id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa5d762c)', 'id', 4, 'id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1255 HTML::Mason::Request::comp(undef, undef, 'id', 4, 'id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 916 HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xaf43d98)', 'id', 4) called at /opt/rt3/share/html/autohandler line 279 HTML::Mason::Commands::__ANON__('id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa85f36c)', 'id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1250 HTML::Mason::Request::comp(undef, undef, undef, 'id', 4) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 461 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 461 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 413 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xaf43d98)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 167 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xaf43d98)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 817 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x9568170)', 'Apache2::RequestRec=SCALAR(0xadfd63c)') called at /opt/rt3/bin/webmux.pl line 123 eval {...} at /opt/rt3/bin/webmux.pl line 123 RT::Mason::handler('Apache2::RequestRec=SCALAR(0xadfd63c)') called at -e line 0 eval {...} at -e line 0 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com