Re: [rt-users] remote sql server w/ ssl RT make upgrade-database problem

2014-06-03 Thread andkulb
I had the same problem.

As I find out the update-database task was trying to connect to the DB using
root user, which I don't have access to instead of my RT database user. The
upgrade-database was asking for password, but it did not asked for a user
which should be used. So made a change in /sbin/rt-setup-database:

my $dba_user = my_rt_database_user_name.



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/remote-sql-server-w-ssl-RT-make-upgrade-database-problem-tp57521p57585.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


[rt-users] Different template according to requestor email address

2014-05-30 Thread andkulb
Hello, 

There are tickets coming from internal users (@interal.aa) and from external
users (@gmail.com, @yahoo.com, etc).
I want to send different king of template according to requestor address.

Subject: {$Ticket-Subject}
Content-Type: text/html
{
 if($Ticket-RequestorAddresses =~ /@internal.aa/) {
 You are internal
 } else {
You are external
 }
}

Everything works fine if there are only one requestor (a...@internal.aa or
a...@google.com), but if there are situation like this (a...@internal.aa,
a...@gmail.com) both, the gmail.com and internal.aa mails get message saying
You are internal. 

How can I separate these to get different messages according to their email
address?




--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Different-template-according-to-requestor-email-address-tp57533.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


[rt-users] Custom ticket update page not submiting values

2014-05-26 Thread andkulb
Hello, 

I'm trying to do a ticket feedback page in SelfService, for user to evaluate
the response to the ticket. I took a Update.html code from SelfService/ and
changed it to display only the fields that I need. But after clicking the
submit button, values of the customfield does not change, I get the
Display.html view, but the URL is lef the same: Feedback.html. Logs also
don't show any activity, like nothing was happening. 

How to submit my data so it would update the ticket fields? 


Here I create a form with 2 customfiels and comment box.

 /SelfService/Elements/Header, 
Title =loc('Leave feedback for ticket #[_1]', $Ticket-id) 
 

form action=Feedback.html method=post enctype=multipart/form-data
name=TicketUpdate
input type=quot;hiddenquot; class=quot;hiddenquot;
name=quot;Tokenquot; value=quot;lt;% $ARGS{'Token'} % / 
input type=quot;hiddenquot; class=quot;hiddenquot;
name=quot;idquot; value=quot;lt;%$Ticket-Id% / 
input type=hidden class=hidden name=UpdateType value=response
/
 /Elements/ListActions, actions = \@results  
% while ( my $CustomField = $CustomFields-Next ) { 
%   if(exists($FeedbackCFs-{$CustomField-Id})) { 
%   my @add = (NamePrefix = 'Bulk-Add-CustomField-', CustomField =
$CustomField, Rows = 5, 
%   Multiple = ($CustomField-MaxValues ==1 ? 0 : 1) , Cols = 25, 
%   Default = $ARGS{Add-CustomField-$CustomField-Id-Values} ||
$ARGS{Add-CustomField-$CustomField-Id-Value}, ); 
% 
%   my $Values = $Ticket-CustomFieldValues( $CustomField-Id ); 
%   my $count = $Values-Count; 

tr id=quot;CF-lt;%$CustomField-id%-ShowRow 
input type=quot;hiddenquot; class=quot;hiddenquot; 
   
name=quot;Object-RT::Ticket-lt;%$Ticket-Id%-CustomField-%$CustomField-Id%-Values-Magic
value=1 
% } 
% } 
%} 
% if($showComment) { 
%} 
% $CustomField-Name %:   %   if($count == 0) { 
%   if ($CustomField-Type eq 'Select') { 
 /Elements/EditCustomFieldSelect, @add  
%   } elsif ($CustomField-Type eq 'Combobox') { 
 /Elements/EditCustomFieldCombobox, @add  
%   } elsif ($CustomField-Type eq 'Freeform') { 
 /Elements/EditCustomFieldFreeform, @add  
%   } elsif ($CustomField-Type eq 'Text') { 
 /Elements/EditCustomFieldText, @add  
%   } elsif ($CustomField-Type eq 'Date') { 
 /Elements/EditCustomFieldDate, @add, Default = undef  
%   } elsif ($CustomField-Type eq 'DateTime') { 
% # Pass datemanip format to prevent another tz date conversion 
 /Elements/EditCustomFieldDateTime, @add, Default = undef,
Format = 'datemanip'  
%   } 
%   } else { 
%   $showComment = 0; 
%   unless ( $count ) { 
|/l(no value)/amp;
%   } elsif ( $count == 1 ) { 
%   $print_value-( $CustomField, $Values-First ); 
%   } else { 
ul
%   while ( my $Value = $Values-Next ) { 
li
%   $print_value-( $CustomField, $Value ); 
/li
%   } 
/ul
%   } 
   
Komentaras:  /Elements/MessageBox, Name=UpdateContent,
IncludeSignature = 1, %ARGS  
   
 /Elements/Submit, Label = loc('Submit feedback'), Name =
'SubmitTicket', id = 'SubmitTicket'  
   
/form
 /Elements/ShowHistory, Object = $Ticket, ShowHeaders =
$ARGS{'ShowHeaders'}, DownloadableHeaders = 0  


Here I check for a submit button click and some do some validation.
if ( exists $ARGS{SubmitTicket} ) { 
my $kokybe = $ARGS{'Bulk-Add-CustomField-102-Values'}; 

if($kokybe  $kokybe =~ /Puikiai/) { 
$m-callback(CallbackName = 'BeforeDisplay', Ticket = \$Ticket,
ARGSRef = \%ARGS); 
return $m-comp('Display.html', TicketObj = $Ticket, %ARGS); 
} elsif($kokybe) { 
my $atsiliepimas = $ARGS{'Bulk-Add-CustomField-103-Value'}; 
if($atsiliepimas  $atsiliepimas =~ /Kita/) { 
my $komentaras = $ARGS{'UpdateContent'}; 
if($komentaras) { 
$m-callback(CallbackName = 'BeforeDisplay', Ticket =
\$Ticket, ARGSRef = \%ARGS); 
return $m-comp('Display.html', TicketObj = $Ticket,
%ARGS); 
} else { 
push @results, loc('Fill the field Komentaras with your
comment'); 
} 
} elsif($atsiliepimas) { 
$m-callback(CallbackName = 'BeforeDisplay', Ticket =
\$Ticket, ARGSRef = \%ARGS); 
return $m-comp('Display.html', TicketObj = $Ticket, %ARGS); 
} else { 
push @results, loc('Choose appropriate value for
Atsiliepimas'); 
} 
} 
} 




--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Custom-ticket-update-page-not-submiting-values-tp57496.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


[rt-users] Calculate values in charts by percent

2014-05-26 Thread andkulb
Hello,

http://requesttracker.8502.n7.nabble.com/file/n57497/box.png 

How can I add my own functions to this fields set, to be more specific,
calculate by percent?

Regards



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Calculate-values-in-charts-by-percent-tp57497.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training


[rt-users] No __TimeLeft__ value in search result

2014-02-18 Thread andkulb
Hello, 

I set my custom search format in RT_SiteConfig like this: 



This is the time values for the ticket: 
Created:Tue Feb 18 13:28:25 2014 
Starts: Tue Feb 18 13:28:25 2014 
Started:Tue Feb 18 13:28:25 2014 
Last Contact:   Tue Feb 18 13:30:25 2014 
Due:Wed Feb 19 00:00:00 2014

Still, the __TimeLeft__ field is always blank. What is the problem?



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/No-TimeLeft-value-in-search-result-tp56683.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
-- 
RT Training London, March 19-20 and Dallas May 20-21
http://bestpractical.com/training


[rt-users] RT 4.2.1 RSS feed of articles

2013-12-01 Thread andkulb
Hello,

Is it possible to make a RSS feed from articles  like with the tickets?



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/RT-4-2-1-RSS-feed-of-articles-tp55950.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


[rt-users] Get Queue CustomField value

2013-10-29 Thread andkulb
Hello,

I have a queue named AAA. Then there are a custum field for queues - SubUnit
with values: a, b, c.

Queue AAA has a value 'a' of SubUnit custom field.

How can I extract that value? I want to use that value on scrip.



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Get-Queue-CustomField-value-tp55642.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


[rt-users] Update all tickets of queue

2013-10-29 Thread andkulb
Hello,

Is it posible with the help of scrip to do such thing:

My Queue has a custom field and when you create a ticket in that queue, the
ticket custom field is set by the value of queue custom field value. 

How can I change all queue tickets custom field value on Queue custom field
value change?



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Update-all-tickets-of-queue-tp55643.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


Re: [rt-users] Internal authentification only for REST API

2013-10-18 Thread andkulb
Done that. But now REST doesn't require any password at all? Is it also
possible to require RT internal auth in specific folder?

Thanks in advance.



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Internal-authentification-only-for-REST-API-tp55512p55535.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


[rt-users] Language bar on RT meniu

2013-10-17 Thread andkulb
Hello,

Is it possible or maybe already done somewhere (can't find) to make a
language button for user to change his RT language on demand?

Regards



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Language-bar-on-RT-meniu-tp55510.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


[rt-users] Internal authentification only for REST API

2013-10-17 Thread andkulb
Hello,

I'm using externat auth source (shibboleth) for my RT installation, which
redirect me to the login page, where I need to enter my username and
password. 

While using the REST API, I store my user in RT database, so I could
authenticate using database not the external source. But after succesfull
authentication via REST API I still get redirected to the external login
page.

How to fix that?

Regards,
Andrius



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Internal-authentification-only-for-REST-API-tp55512.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


[rt-users] Group chart by custom field of Queue

2013-10-14 Thread andkulb
Hello, 

My queues in RT belong to some sort of departament (custom field). How can I
get a chart, showing tickets by departament? 

What i find out, is that charts are made by ticked dependencies, but not the
the dependencies of tickets queues. 

Thank you in advance.



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Group-chart-by-custom-field-of-Queue-tp55477.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.