Re: [rt-users] Problem with RT::SystemUser in escalatePriority

2015-10-29 Thread markus . wildbolz
Hi Christian!

Thanks a lot for your response! This solved my problem!

As we have different lifecycles in place, I stay with looping through all 
queues...


Greetings,
Markus





Von:
Christian Loos 
An:
markus.wildb...@magna.com, rt-users@lists.bestpractical.com, 
Datum:
29.10.2015 15:33
Betreff:
Re: Problem with RT::SystemUser in escalatePriority



Am 29.10.2015 um 13:58 schrieb markus.wildb...@magna.com:
> Hi guys!
> 
> Since a couple of days, I have the problem, that my priority escalation
> script doesn't work anymore. Script is attached...
> 
> 
> 
> The error message is:
> 
> Name "RT::SystemUser" used only once: possible typo at
> ./rt-escalatePriority line 36.
> Can't locate object method "Deprecated" via package "RT" at
> /opt/rt4/lib/RT/Interface/CLI.pm line 93.
> 
> 
> I currently cannot figure out, what's the problem with the mentioned
> line 36:
> 
> my $queues = new RT::Queues($RT::SystemUser);
> 
> 
> Does anybody know this problem?
> 
> 
> Greetings,
> Markus

Hi Markus,

remove the following lines

---
 package RT;

 use RT::Interface::CLI qw(CleanEnv);

 # Clean our the environment

 CleanEnv();

 # Load the RT configuration
 RT::LoadConfig();


 # Initialise RT
 RT::Init();

 my $queues = new RT::Queues($RT::SystemUser);
---

with

---
use RT::Interface::CLI qw(Init);
Init();
my $queues = RT::Queues->new(RT->SystemUser);
---

Also, do you have different Lifecycles defined?
If not, then you can use the rt-crontool with

--search RT::Search::FromSQL

and a search like

-search-arg "Status != 'resolved' AND Status != 'rejected'"

instead if use a Perl script to loop over the queues and then call
rt-crontool from within the Perl script.

See also the second example in
https://www.bestpractical.com/docs/rt/4.2/automating_rt.html#Escalating-Priority


Chris



[rt-users] Problem with RT::SystemUser in escalatePriority

2015-10-29 Thread markus . wildbolz
Hi guys!

Since a couple of days, I have the problem, that my priority escalation 
script doesn't work anymore. Script is attached...



The error message is:

Name "RT::SystemUser" used only once: possible typo at 
./rt-escalatePriority line 36.
Can't locate object method "Deprecated" via package "RT" at 
/opt/rt4/lib/RT/Interface/CLI.pm line 93.


I currently cannot figure out, what's the problem with the mentioned line 
36:

my $queues = new RT::Queues($RT::SystemUser);


Does anybody know this problem?


Greetings,
Markus
#!/usr/bin/perl
 #
 # This script is one way to escalate ticket priorities for all queues.
 #
 # Author: Petter Reinholdtsen
 # Date:   2004-08-31
 #
 # Based on shell version previously on
 # http://wiki.bestpractical.com/index.cgi?ConfigureEscalationExample>
 # and
 # http://wiki.bestpractical.com/index.cgi?ConfigureEscalation>
 #
 # Run from cron as user rt-user, making sure rt-user is also a privileged
 # RT user with 'Unix name' set to rt-user and having global permissions
 # ShowTicket and ModifyTicket.
 
 use strict;
 use warnings;
 
 # Location of RT's libs and scripts
 use lib ("/opt/rt4/lib", "/opt/rt4/local/lib");
 my $crontool = "/opt/rt4/bin/rt-crontool";
 
 package RT;

 use RT::Interface::CLI qw(CleanEnv);
 
 # Clean our the environment

 CleanEnv();
 
 # Load the RT configuration
 RT::LoadConfig();
 

 # Initialise RT
 RT::Init();
 
 my $queues = new RT::Queues($RT::SystemUser);
 $queues->LimitToEnabled();
 
 # escalate tickets for all queues
 while (my $queue = $queues->Next) {
 my $queuename = $queue->Name;
 system("$crontool --search RT::Search::ActiveTicketsInQueue " .
"--search-arg \"$queuename\" ".
"--action RT::Action::MyEscalatePriority");
 }



[rt-users] Antwort: Re: Including latest transactions in RSS-Feed

2015-08-28 Thread Markus . Wildbolz
Hi Christian!

Thanks for your input.
Now I managed to change the RSS content, so that it outputs the latest 
transaction (Comment/Correspond) for each ticket in the search result.

Maybe someone updates this in the release version, because I think, that 
this content is of a bigger interest than just the contents of the 
initially created tickets. Patch file is attached...


Greetings,
Markus


P.S.: Danke nochmal für die Unterstützung - hat mir sehr geholfen!



ResultsRSSView.patch
Description: Binary data


Re: [rt-users] Including latest transactions in RSS-Feed

2015-08-27 Thread Markus . Wildbolz
Hi guys!

I've managed, to play a little bit with the RSS-feed generation at 
/html/Search/Elements/ResultsRSSView

But at the moment I'm stuck at fetching the latest transaction with type 
"Correspond" or "Comment" from the database for displaying the right 
content.
Is anybody out there who could help me with this?

My current code looks like:

while ( my $Ticket = $Tickets->Next()) {
my $transactions = RT::Transactions->new($session{CurrentUser});
$transactions->LimitToTicket($Ticket->id);
 
# Limit to transactions with type "Comment"
$transactions->Limit(
FIELD => 'Type',
VALUE => 'Comment'
); 
 
my $content = $transactions->Last->Content;

...


I get the following error in the logs:
 Can't call method "Content" on an undefined value at 
/opt/rt4-devel/local/html/Search/Elements/ResultsRSSView


I don't know actually, why the variable $transactions has an undefined 
value.


Greetings,
Markus


Re: [rt-users] Accidently removed Admin rights from users, whoopsy daisy

2015-08-26 Thread Markus . Wildbolz
Hi!

Maybe the article at

http://requesttracker.wikia.com/wiki/RecoverSuperUserRights

can help.

You have to consider a version change to RT 4, maybe...


BR,
Markus


Re: [rt-users] Including latest transactions in RSS-Feed

2015-08-19 Thread Markus . Wildbolz
Is anybody out there who could lead me into the right direction?
Maybe der is already a plugin handling this???

BR,
Markus


Re: [rt-users] Customizing with overlays, question about file path

2015-07-17 Thread Markus . Wildbolz
The right path for this is 

/opt/rt4/local


The other path only holds sources...


Regards,
Markus

[rt-users] Including latest transactions in RSS-Feed

2015-07-08 Thread Markus . Wildbolz
Hi guys!

I'm looking for a possibility to include the latest transactions 
(comments, correspondance) in the RSS feed of a saved search.
At the moment, only the content of the FIRST transaction is included into 
the feed.

What I'm looking for is a possibility to have every transaction (of types 
Create, Correspond, Comment, Resolve) for a ticket in the feed.
How could I achieve this?


BR,
Markus


[rt-users] Send dashboard to members of a group

2015-05-29 Thread Markus . Wildbolz
Hi guys!

I have a dashboard which I want to send to all members of a specified 
group. What would be the best way to do this?

Is there a way to force all users to subscribe this dashboard?
Or is there a way through rt-crontool?


I'm not sure at the moment, in which direction i should go. Would be 
great, if someone of you could show me the way...


Regards,
Markus



Re: [rt-users] RT 4.x multi-instances

2015-03-16 Thread Markus . Wildbolz
Hello!

We are running two instances of RT (4.2.9 with MySQL) as two completely 
separated installs (the installation is done in two different 
directories).
Access is separated through Apache Alias configuration.

We haven't had problems in the past, all is working fine...


BR,
Markus


[rt-users] Migrating maildomain

2014-12-19 Thread Markus . Wildbolz
Hi guys!

We are currently in a corporate-wide migration process of our mail 
domains.
Old domain: @xy.company.com
New domain: @company.com

We are using ExternalAuth to connect to our LDAP. At the moment, the mail 
addresses in LDAP correspond to the old maildomain.
If a user logs on at RT (or sends a mail), is the email address updated 
automatically or do we get new users with the new mail adresses?
How could I tell RT, that two mail addresses correspond to the same user?
Is there anything i could configure??


Would be great, if someone has some hints for me where to start...


Greetings,
Markus


Re: [rt-users] Graphical representation of open tickets

2014-10-23 Thread Markus . Wildbolz
As far as I know, there is no possibility to draw line-charts with the 
built in charting functions.

Also, the problem I have is calculating the number of open tickets per 
day.
Is there a CLI-function which I could use? I need to know the number of 
open (not resolved and not rejected) at a specific day!


Greetings,
Markus-- 
RT Training November 4 & 5 Los Angeles
http://bestpractical.com/training


[rt-users] Graphical representation of open tickets

2014-10-23 Thread Markus . Wildbolz
Hi there!

Has anybody done a graphical representation (line graph) of open tickets 
over time? Our management forced me to create such a representation.
I'm looking for a tool doing this graphing, having an x-axis as timeline 
and a graph for "Created", "Resolved" and "Open Tickets" per day (per 
queue, per user?!)

Before I start to code these things I wanted to ask you, if there are 
maybe some snippets of code which I could use.
Has anybody done such things before?


Greetings,
Markus-- 
RT Training November 4 & 5 Los Angeles
http://bestpractical.com/training


[rt-users] How to correctly dump metadata other RT environment?

2014-10-07 Thread Markus . Wildbolz
Hi guys!

I'm trying to move all customizations I did in our productive environment 
to our test environment (on a clean, fresh installation).
I do not want to transfer the complete database because I dont need the 
tickets (and all the other stuff like transactions, etc.). So I thought 
the right way is to use the rt-dump-metadata program.
If I try to import the metadata-file through rt-setup-database into the 
test-environment I get errors and the configuration is not transferred 
successfully!



Could someone of you give me an explanation, what the definite steps for 
moving this metadata are?
My approach was the following:

Export:
rt4/sbin/rt-dump-metadata -a -s > metadata.xml

Import:
rt4-devel/sbin/rt-setup-database --action drop
rt4-devel/sbin/rt-setup-database --action create,schema
rt4-devel/sbin/rt-setup-database --action insert --datafile 
../rt4/metadata.xml


Did I miss a step? I don't know if I have to do --action acl,coredata 
first or not. However, I get many different errors.

I'm using two completely separated instances of RT 4.2.7 with MySQL 5.5.38 
on Debian 7

Would be fine, if someone has some input for me! I will try the 
recommended steps and get the definite error messages for you 
afterwards...



Greetings,

Markus Wildbolz-- 
RT Training November 4 & 5 Los Angeles
http://bestpractical.com/training


Re: [rt-users] Missing translation of "Take" after upgrade to 4.2.7

2014-09-22 Thread Markus . Wildbolz
Hi Kevin!

Thanks for the input. I already tried a fresh installation (deleted 
database and initialize-database) on my development environment with no 
effect.
Maybe the problem was a not correctly cleaned mason cache?!?! (Today I 
tried a completely new installation and then the translation was correct!)

I now have re-imported the saved search attribute from the 
initialdata-file via

# repair-search.txt
@Attributes = (
{ Name => 'Search - Unowned Tickets',
  Description => '[_1] newest unowned tickets', # loc
  Content =>
# 'Take' #loc
  { Format =>  q{'__id__/TITLE:#',}
 . q{'__Subject__/TITLE:Subject',}
 . q{QueueName, ExtendedStatus, CreatedRelative, }
 . q{'__loc(Take)__/TITLE:NBSP'},
Query   => " Owner = 'Nobody' AND ( Status = 'new' OR Status = 
'open')",
OrderBy => 'Created',
Order   => 'DESC'
  },
},
);



./sbin/rt-setup-database --action insert --datafile repair-search.txt 
--dba mysql

and now it is working fine. Thanks!


Greetings.-- 
RT Training November 4 & 5 Los Angeles
http://bestpractical.com/training


[rt-users] Missing translation of "Take" after upgrade to 4.2.7

2014-09-19 Thread Markus . Wildbolz
Hi there!

I've encountered a problem after the upgrade to 4.2.7:
In the system saved search "10 newest unowned tickets " the string "Take" 
is not translated anymore. Is there something i can do?
All worked fine before the update. What is missing now?


Greetings,
Markus
-- 
RT Training November 4 & 5 Los Angeles
http://bestpractical.com/training


[rt-users] Problem with translation - different translation of the english word 'open' regarding the context

2014-09-19 Thread Markus . Wildbolz
Hi there!


Since the update to 4.2.7 i figured out, that there is a new issue 
regarding the (german) translation.

For the ticket-status, "open" has to be translated to "offen". On the 
other hand,
in the Self-Service area, "open" hast o be translated to "offenen" because 
of the context "Meine offenen Tickets" (My open tickets).


Is there a possibility to fix this problem?
Is it possible to translate the same english word differently?

As I remember, there was a change coming in 4.2.7 regarding a translation 
issue in the SelfService pages (commit 
1d0b91823db7856be3727fd351a3d7d3d5a9a2c5).


Greetings,
Markus-- 
RT Training November 4 & 5 Los Angeles
http://bestpractical.com/training


Re: [rt-users] Notify about tickets that are Due in 48 hours

2014-09-15 Thread Markus . Wildbolz
Hi!

Thats not a big thing, if you read and follow the instructions at

http://requesttracker.wikia.com/wiki/Reminders

This is working for me like a charm!



Greetings,

Markus-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Number of displayed rows of a saved search in dashboard

2014-09-10 Thread Markus . Wildbolz
I figured out, that if I change and save the settings for number of rows 
in the subscription view (rt/Dashboards/Subscription.html), this also 
effects the number of rows displayed within the dashboard (even if I 
select "never" within the subscriptions frequency).

Is that a bug or a feature?

In my opinion, it would be best to have a seperated control for the number 
of rows displayed in the WebUI, completly separated from the 
subscriptions.



Greetings,
Markus-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

[rt-users] Number of displayed rows of a saved search in dashboard

2014-09-09 Thread Markus . Wildbolz
Hi guys.

I've constructed several saved searches (everyone with the number of rows 
per page set to 10) and wanted to get them into a dashboard for overview.

I now have the problem, that the dashboard shows more than the specified 
10 rows and i cannot find any other possibility to get rid of this.
Also, it is interesting, that the system saved searches (e.g. Saved 
Search: My Tickets) also come up with " 50 highest priority tickets I own"
.

Does anyone have a clue for me where to start searching for the problem? 
Is there maybe any other configuration-option i missed?


Thanks in advance,

Markus-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Inclusion of commit 1d0b91823db7856be3727fd351a3d7d3d5a9a2c5 - Translate the full title string, not as piecemeal bits

2014-09-02 Thread Markus Wildbolz
Hi Alex!

Thanks for the explanation...

Waiting for rc now :-)

Greetings,
Markus
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

[rt-users] Inclusion of commit 1d0b91823db7856be3727fd351a3d7d3d5a9a2c5 - Translate the full title string, not as piecemeal bits

2014-09-01 Thread Markus Wildbolz
Hi guys!

I just wanted to ask, why the commit '1d0b91823db7856be3727fd351a3d7d3d5a9a2c5' 
from the git-repo isn't included in the current stable 4.2.6 release?!?



Greetings,

Markus
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

[rt-users] Possible bug updating user information from LDAP - A charset issue?

2014-06-21 Thread Markus Wildbolz
Hi guys!

I've connected my RT installation via RT::Authen::ExternalAuth to my active 
directory server.
All now is working fine, but I found in the logs, that my user information is 
updated every time i log on to RT saying in the logs

[8682] [Sat Jun 21 11:19:10 2014] [debug]: UPDATED user markus.wildbolz: User 
markus.wildbolz: City changed from 'G?ssendorf' to 'G?ssendorf' 
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:452)

But there is no change in the user information in AD. Maybe this has something 
todo with the used character set, because the right value would be 'Gössendorf' 
(or same issue with 'Österreich').

Is there any possibility to get rid of this??


Greetings,

Markus
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

Re: [rt-users] Problem with WYSIWYG Editor in tickets

2014-06-02 Thread Markus Wildbolz
You are great. The update to 4.2.5rc1 definitely solved my problems!

Thanks for the quick response!


Greetings from Austria,
Markus


-Ursprüngliche Nachricht-
Von: Kevin Falcone [mailto:falc...@bestpractical.com]
Gesendet: Mo 02.06.2014 16:48
An: rt-users@lists.bestpractical.com
Betreff: Re: [rt-users] Problem with WYSIWYG Editor in tickets
 
On Mon, Jun 02, 2014 at 12:18:56PM +0100, Keith Macpherson wrote:
>    Markus Wildbolz wrote, On 01/06/2014 21:00:
> 
>  I have made a new installation of RT 4.2.4 on Debian 7.
>  I now have the problem (in comparison to my old system running RT 4.0.1) 
> that it is not
>  possible to create a HTML-Table via the WYSIWYG interface. If i click 
> the button, the screen
>  is gray for a moment and nothing happens!
>  Also, I cannot paste content from MS-Word via the appropriate button.
> 
>Sounds like you are experiencing similar issues I have with the CKEditor 
> element. Alex
>commented last week that there are some fixes scheduled for inclusion in 
> the 4.2.5 update
>which may be in rc1 this week. I'd suggest waiting for that update.

RC1 was released last week.  Reports of successes or failures are
useful.

http://www.gossamer-threads.com/lists/rt/devel/123459

-kevin

-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

[rt-users] Problem with WYSIWYG Editor in tickets

2014-06-01 Thread Markus Wildbolz
Hi there!

I have made a new installation of RT 4.2.4 on Debian 7.
I now have the problem (in comparison to my old system running RT 4.0.1)
that it is not possible to create a HTML-Table via the WYSIWYG
interface. If i click the button, the screen is gray for a moment and
nothing happens!
Also, I cannot paste content from MS-Word via the appropriate button.

Do you have any recommendations for my what i can check?

Maybe I should notice, that I upgraded the database from my old
system...



Thanks in advance,

Markus W.



-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training