[rt-users] Search problem with linked tickets

2011-03-05 Thread Bjoern Schulz

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

2010-05-24 Thread Bjoern Schulz

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

2010-05-22 Thread Bjoern Schulz

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

2010-04-09 Thread Bjoern Schulz

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

2010-04-09 Thread Bjoern Schulz

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

2010-04-09 Thread Bjoern Schulz

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.

2009-11-09 Thread Bjoern Schulz
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

2009-07-22 Thread Bjoern Schulz
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

2009-05-06 Thread Bjoern Schulz
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

2009-02-05 Thread Bjoern Schulz
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

2008-11-25 Thread Bjoern Schulz
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

2008-11-17 Thread Bjoern Schulz
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

2008-11-14 Thread Bjoern Schulz
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

2007-10-09 Thread Bjoern Schulz

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

2007-10-02 Thread Bjoern Schulz

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

2007-06-27 Thread Bjoern Schulz

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

2007-06-20 Thread Bjoern Schulz

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

2006-08-23 Thread Bjoern Schulz

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