[rt-users] DB layout and getting the requestors for a ticket

2011-02-09 Thread Tobias Hieta
Hello,

First of all I would like to say: I know this is not the best way to do it, I 
know the underlying database will probably change and my non-warranty is even 
more void. BUT, I would like to select requestors and owner etc from a ticket 
directly on the database (I am using MySQL), I have tried to figure out how to 
get the requestor from the tables by looking at the schema and the code, but it 
eludes me. Can someone point me in the right direction on how to make a direct 
select statement to get this information?

Thanks,
Tobias

-- 
Tobias Hieta
Project Manager @ Purple Scout
E-Mail: tobias.hi...@purplescout.se
Cell: +46 732 051 411
www: http://about.me/thieta



[rt-users] Possible Bug in 'Scrips and Recipients' and TransactionBatch

2011-02-09 Thread Tobias Hieta
Hello,

I have noticed that when we switched some of our Scripts to TransactionBatch 
from TransactionCreate the email addresses affected by those scrips where 
removed from the 'Scrips and Recipients' window in Update/Reply to ticket. Is 
this a known bug or am I doing something else wrong?

Thanks,

-- 
Tobias Hieta
Project Manager @ Purple Scout
E-Mail: tobias.hi...@purplescout.se
Cell: +46 732 051 411
www: http://about.me/thieta



[rt-users] Default auto-refresh interval

2011-02-09 Thread Michael Brown
Hi,

I had a customer request to set the default home page refresh interval to 2 
minutes for all users.  I found several suggestions that essentially involved 
modifying the code (e.g. by creating a local version of Elements/Login or 
Elements/Refresh), but wanted to avoid code customisations if at all possible.

I found that I could make this work using mod_rewrite, without having to touch 
the RT code:

  RewriteEngine On
  RewriteRule ^/$ /?HomeRefreshInterval=120 [L,PT,QSA]

(note that this is with RT in the root directory of a virtual host; modify the 
^/$ portion as necessary for other locations).

Posting this message for the record, to save someone else the time it took me 
to figure this out.

Michael


[rt-users] Creating a ticket whose content is foo

2011-02-09 Thread Wolfram Huettermann

Hello,

I think this is a stupid question that I ask you old-timers in RT. I 
intend to create a ticket in the queue test and the content is foo in 
shell, not in MASON.

Here is the code snippet:


my $CurrentUser = GetCurrentUser();
use RT::Tickets;
my $Ticket = RT::Ticket-new($CurrentUser);
my %TicketInput =
(
  Subject = The new ticket today,
  Queue = testq-noc, # an existing one on your RT
  Owner = root,
  Requestor = max\@mustermann.de, # an existing  one on your  RT
  Content = foo,
  Status = new,
);

$Ticket-Create(%TicketInput);

The ticket will be created, but its content remains empty if you look in 
the module Ticket/Display.html. Nevertheless, I want to create a ticket 
whose content is supposed to be foo. I cannot use the function 
CreateTicket, as it only works on RT-MASON, but not on bash.


Greetings,

Wolfram Hüttermann



Re: [rt-users] DB layout and getting the requestors for a ticket

2011-02-09 Thread Gerard FENELON

Tobias

Something similar to

   FROM Tickets AS Ticket
   JOIN Groups  AS ReqGroup   ON 
ReqGroup.instance   = Ticket.id
   JOIN GroupMembersAS ReqGroupMember ON 
ReqGroupMember.GroupId  = ReqGroup.id
   JOIN Users   AS Requestor  ON 
ReqGroupMember.MemberId = Requestor.id


should do the trick

Gerard

On 2011-02-09 11:19, Tobias Hieta wrote:

Hello,

First of all I would like to say: I know this is not the best way to do it, I 
know the underlying database will probably change and my non-warranty is even 
more void. BUT, I would like to select requestors and owner etc from a ticket 
directly on the database (I am using MySQL), I have tried to figure out how to 
get the requestor from the tables by looking at the schema and the code, but it 
eludes me. Can someone point me in the right direction on how to make a direct 
select statement to get this information?

Thanks,
Tobias



--
Gerard FENELON  Corporate Support
Emulation  Verification Engineering
2 bis, voie La Cardon
phone: +33 1 6453 2734  Parc Gutenberg
fax:   +33 1 6453 2740  91120 Palaiseau
http://www.eve-team.com FRANCE



Re: [rt-users] Possible Bug in 'Scrips and Recipients' and TransactionBatch

2011-02-09 Thread Kevin Falcone
On Wed, Feb 09, 2011 at 12:42:46PM +0100, Tobias Hieta wrote:
 I have noticed that when we switched some of our Scripts to
 TransactionBatch from TransactionCreate the email addresses affected
 by those scrips where removed from the 'Scrips and Recipients'
 window in Update/Reply to ticket. Is this a known bug or am I doing
 something else wrong?

Not a bug, just a limitation with TransactionBath.  TransactionBatch
Scrips are run at a different stage in ticket processing and as such
can't currently be included in the DryRun stage used by Scrips and
Recipients.

-kevin


pgpmSbErsST7a.pgp
Description: PGP signature


Re: [rt-users] Question about Scripts

2011-02-09 Thread Kevin Falcone
On Tue, Feb 08, 2011 at 02:43:07PM -0800, Tim Gustafson wrote:
 Hi,
 
 I have an RT installation that is quite old now, and has been handed
 down to me by a person who is no longer with us.  The configuration
 has been modified and modified over the years and I'm not sure how
 closely it resembles the out of the box configuration anymore.
 
 I've been getting some complaints from users about not getting
 notified in certain circumstances, so I was trying to make sure that
 I have all the right scrips set up, and I was wondering if the
 list would care to comment on what I've got set up right now.  I'm
 attaching a little text file that has the list of all the scrips I'm
 using right now.
 
 Is the list I've attached reasonable?  Am I missing anything
 obvious?  Should any of these go away?

You may wish to compare with the @Scrips section of RT 3.8.8's
etc/initialdata to see what we ship these days.  Aside from On Resolve
Notify AdminCcs your scrips look fairly stock

 01 - Notify Requestors of New Ticket  TransactionCreate   On 
 Create   Autoreply To Requestors Autoreply
 02 - Notify Admins of New Ticket  TransactionCreate   On 
 Create   Notify AdminCcs Transaction
 03 - Notify Requestors of Correspondence  TransactionCreate   On 
 Correspond   Notify Requestors and Ccs   Correspondence
 04 - Notify Admins of Correspondence  TransactionCreate   On 
 Correspond   Notify AdminCcs Transaction
 05 - Notify Others of Correspondence  TransactionCreate   On 
 Correspond   Notify Other Recipients Correspondence
 06 - Notify Admins of Comment TransactionCreate   
 On Comment  Notify AdminCcs Transaction
 07 - Notify Others of Comment TransactionCreate   
 On Comment  Notify Other Recipients Correspondence
 08 - Notify Requestors of Resolution  TransactionCreate   On 
 Resolve  Notify Requestors and Ccs   Resolved
 09 - Notify Admins of Resolution  TransactionCreate   On 
 Resolve  Notify AdminCcs Transaction
 10 - Re-Open Ticket on Correspondence TransactionCreate   
 On Correspond   Open Tickets



pgpkNsam0eC6q.pgp
Description: PGP signature


Re: [rt-users] Default auto-refresh interval

2011-02-09 Thread Kevin Falcone
On Wed, Feb 09, 2011 at 01:37:17PM +, Michael Brown wrote:
 I had a customer request to set the default home page refresh interval to 2 
 minutes for all users.  I found several suggestions that essentially involved 
 modifying the code (e.g. by creating a local version of Elements/Login or 
 Elements/Refresh), but wanted to avoid code customisations if at all possible.
 
 I found that I could make this work using mod_rewrite, without having to 
 touch 
 the RT code:
 
   RewriteEngine On
   RewriteRule ^/$ /?HomeRefreshInterval=120 [L,PT,QSA]
 
 (note that this is with RT in the root directory of a virtual host; modify 
 the 
 ^/$ portion as necessary for other locations).
 
 Posting this message for the record, to save someone else the time it took me 
 to figure this out.

I'm not sure How this is better than using the documented config variable
$HomePageRefreshInterval which is also available on a per-user basis.

-kevin


pgpltCpTNOGAp.pgp
Description: PGP signature


Re: [rt-users] DB layout and getting the requestors for a ticket

2011-02-09 Thread Tobias Hieta
Thanks Gerard,

I will try that at once.

-- Tobias

- Original Message -
 Tobias
 
 Something similar to
 
 FROM Tickets AS Ticket
 JOIN Groups AS ReqGroup ON
 ReqGroup.instance = Ticket.id
 JOIN GroupMembers AS ReqGroupMember ON
 ReqGroupMember.GroupId = ReqGroup.id
 JOIN Users AS Requestor ON
 ReqGroupMember.MemberId = Requestor.id
 
 should do the trick
 
 Gerard
 
 On 2011-02-09 11:19, Tobias Hieta wrote:
  Hello,
 
  First of all I would like to say: I know this is not the best way to
  do it, I know the underlying database will probably change and my
  non-warranty is even more void. BUT, I would like to select
  requestors and owner etc from a ticket directly on the database (I
  am using MySQL), I have tried to figure out how to get the requestor
  from the tables by looking at the schema and the code, but it eludes
  me. Can someone point me in the right direction on how to make a
  direct select statement to get this information?
 
  Thanks,
  Tobias
 
 
 --
 Gerard FENELON Corporate Support
 Emulation Verification Engineering
 2 bis, voie La Cardon
 phone: +33 1 6453 2734 Parc Gutenberg
 fax: +33 1 6453 2740 91120 Palaiseau
 http://www.eve-team.com FRANCE

-- 
Tobias Hieta
Project Manager @ Purple Scout
E-Mail: tobias.hi...@purplescout.se
Cell: +46 732 051 411
www: http://about.me/thieta



Re: [rt-users] DB layout and getting the requestors for a ticket

2011-02-09 Thread Ruslan Zakirov
http://requesttracker.wikia.com/wiki/GetWatcherInfoByTicket

On Wed, Feb 9, 2011 at 5:27 PM, Tobias Hieta
tobias.hi...@purplescout.se wrote:
 Thanks Gerard,

 I will try that at once.

 -- Tobias

 - Original Message -
 Tobias

 Something similar to

 FROM Tickets AS Ticket
 JOIN Groups AS ReqGroup ON
 ReqGroup.instance = Ticket.id
 JOIN GroupMembers AS ReqGroupMember ON
 ReqGroupMember.GroupId = ReqGroup.id
 JOIN Users AS Requestor ON
 ReqGroupMember.MemberId = Requestor.id

 should do the trick

 Gerard

 On 2011-02-09 11:19, Tobias Hieta wrote:
  Hello,
 
  First of all I would like to say: I know this is not the best way to
  do it, I know the underlying database will probably change and my
  non-warranty is even more void. BUT, I would like to select
  requestors and owner etc from a ticket directly on the database (I
  am using MySQL), I have tried to figure out how to get the requestor
  from the tables by looking at the schema and the code, but it eludes
  me. Can someone point me in the right direction on how to make a
  direct select statement to get this information?
 
  Thanks,
  Tobias
 

 --
 Gerard FENELON Corporate Support
 Emulation Verification Engineering
 2 bis, voie La Cardon
 phone: +33 1 6453 2734 Parc Gutenberg
 fax: +33 1 6453 2740 91120 Palaiseau
 http://www.eve-team.com FRANCE

 --
 Tobias Hieta
 Project Manager @ Purple Scout
 E-Mail: tobias.hi...@purplescout.se
 Cell: +46 732 051 411
 www: http://about.me/thieta





-- 
Best regards, Ruslan.


[rt-users] getting a group of ticket numbers

2011-02-09 Thread Kenneth Marshall
Maybe I cannot see the forest for the trees, but how
can you select a group of ticket ids? You can type a
single ticket number in the search box and that works,
but what if you want tickets numbered 235-331? Any
ideas?

Cheers,
Ken


Re: [rt-users] getting a group of ticket numbers

2011-02-09 Thread Lander, Scott
ID is less than 332 and id is greater than 235?



-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Marshall
Sent: Wednesday, February 09, 2011 9:39 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] getting a group of ticket numbers

Maybe I cannot see the forest for the trees, but how
can you select a group of ticket ids? You can type a
single ticket number in the search box and that works,
but what if you want tickets numbered 235-331? Any
ideas?

Cheers,
Ken

This e-mail message is intended only for the personal use of the recipient(s) 
named above. If you are not an intended recipient, you may not review, copy or 
distribute this message. If you have received this communication in error, 
please notify the Hearst Service Center (cad...@hearstsc.com) immediately by 
email and delete the original message.




Re: [rt-users] getting a group of ticket numbers

2011-02-09 Thread Kenneth Marshall
Thank you. I could have sworn that I tried that and it
did not work, but it worked now.

Ken

On Wed, Feb 09, 2011 at 09:50:48AM -0500, Lander, Scott wrote:
 ID is less than 332 and id is greater than 235?
 
 
 
 -Original Message-
 From: rt-users-boun...@lists.bestpractical.com 
 [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth 
 Marshall
 Sent: Wednesday, February 09, 2011 9:39 AM
 To: rt-users@lists.bestpractical.com
 Subject: [rt-users] getting a group of ticket numbers
 
 Maybe I cannot see the forest for the trees, but how
 can you select a group of ticket ids? You can type a
 single ticket number in the search box and that works,
 but what if you want tickets numbered 235-331? Any
 ideas?
 
 Cheers,
 Ken
 
 This e-mail message is intended only for the personal use of the recipient(s) 
 named above. If you are not an intended recipient, you may not review, copy 
 or distribute this message. If you have received this communication in error, 
 please notify the Hearst Service Center (cad...@hearstsc.com) immediately by 
 email and delete the original message.
 
 
 


Re: [rt-users] CF appears after update even without SeeCustomField rights

2011-02-09 Thread Kevin Falcone
On Tue, Feb 08, 2011 at 10:31:25AM -0800, David Good wrote:
 I've found an issue in two separate 3.8.8 installations.  Both have one
 or more CustomFields that are not supposed to be visible to most users. 
 The CF is managed entirely by Scrips to contain extra information not
 needed by users.  In one installation, it contains the Cost Center of
 the Requestor. In the other, there's a flag used to enable suppression
 of notifications when a ticket is resolved and another flag used to mark
 a ticket as 'urgent'.
 
 When using the web interface (i.e. via the 'Basics' or 'Jumbo' tab), the
 CF doesn't appear intially but after an update is made to any item and
 saved, the CustomField appear.

David

I'd be interested to know if you can reproduce this on a test box
running the 3.8.9 release candidate

-kevin


pgpzsEOjxw7H7.pgp
Description: PGP signature


Re: [rt-users] CF appears after update even without SeeCustomField rights

2011-02-09 Thread Gerard FENELON

Just a note to say that I am also seeing this issue on my 3.8.8 RT instance
I have not got round to debugging it yet.
Gerard

On 2011-02-09 17:29, Kevin Falcone wrote:

On Tue, Feb 08, 2011 at 10:31:25AM -0800, David Good wrote:

I've found an issue in two separate 3.8.8 installations.  Both have one
or more CustomFields that are not supposed to be visible to most users.
The CF is managed entirely by Scrips to contain extra information not
needed by users.  In one installation, it contains the Cost Center of
the Requestor. In the other, there's a flag used to enable suppression
of notifications when a ticket is resolved and another flag used to mark
a ticket as 'urgent'.

When using the web interface (i.e. via the 'Basics' or 'Jumbo' tab), the
CF doesn't appear intially but after an update is made to any item and
saved, the CustomField appear.

David

I'd be interested to know if you can reproduce this on a test box
running the 3.8.9 release candidate

-kevin




Re: [rt-users] Queue-specific message box contents

2011-02-09 Thread Brian P. Bilbrey
On 02/09/2011 09:08 AM, Dominic Hargreaves wrote:
 On Wed, Feb 09, 2011 at 08:50:35AM -0500, Brian P. Bilbrey wrote:
...
 Does anyone have any guidance for me?
 
 We do exactly this, using a callback which I've attached to this message.
 
 You should install it in your local mason root as
 
 Callbacks/DefaultCreateContent/Ticket/Create.html/Default
 
[snip]

Rockin' !!! Thanks, Dominic - that fit the bill perfectly and works like a 
charm.

Best,

.brian


-- 
Brian Bilbrey : Dynaxys LLC : UNIX Systems : 301.622.0900 x364


Re: [rt-users] Queue-specific message box contents

2011-02-09 Thread Brian P. Bilbrey
On 02/09/2011 11:35 AM, Kenneth Crocker wrote:
 Brian,
 
 We do this as well, but we use individual Custom Fields with specific
 values to select from to get a more precise set of inputs.

Thanks, Kenn.

I also have a number of Custom Fields used for the purpose, but I wanted to
provide some guidelines in the prose portion of the ticket to ensure that the
right boxes were ticked without having to do separate custom fields. It may yet
come to that, but this is a good step, and Dominic hit the target with his 
response.

best,

.brian

-- 
Brian Bilbrey : Dynaxys LLC : UNIX Systems : 301.622.0900 x364


[rt-users] unrecognized time zone name: GMT

2011-02-09 Thread Lee Hughes
Testing RT 3.8.8 with PostgreSQL 9.0.3, seeing these warnings in the  
Apache error log:


[Wed Feb  9 18:46:38 2011] [warning]: DBD::Pg::st execute failed:  
ERROR:  unrecognized time zone name: GMT  
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)
[Wed Feb  9 18:46:38 2011] [warning]: RT::Handle=HASH(0xb14ed7c)  
couldn't execute the query 'SET TIME ZONE 'GMT'' at  
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522


Looks like these errors occur on every ticket transaction, for example  
saving a Comment. I confirmed that correct timestamps are getting  
assigned to ticket transactions.


Any ideas are greatly appreciated.

Thanks-

Lee






[rt-users] How to Assign a value to a Custom Field using Requestor Real Name

2011-02-09 Thread Joe Kirby (gmail)
My users would like to have reports on their RT-at-a-Glance page which 
would parse out their tickets from several queues into a report grouped 
by the requestors initial of their last name.


For example group 1 may be A-F, Group 2 G-K, etc.

I was thinking of having a Custom Field associated with their queues 
that was set at time of entry and then have the report use that value in 
this field (A-Z) to select records


My problem is that I do not know the field name for the Requestors Real 
Name as indicated in the ?? marks below.


Additionally, I am VERY open if someone has a better idea.

Below is the script I was going to have exec at New Ticket entry

Any help is greatly appreciated

Thanks

Joe

my $CFName = 'Last Name Grouping';
my $RecTransaction = 1;


 my $QueueObj = $self-TicketObj-QueueObj;
 my $CFObj = RT::CustomField-new( $QueueObj-*??Requestor.RealName?? *);
 $CFObj-LoadByNameAndQueue( Name = $CFName, Queue = $QueueObj-id );
 unless( $CFObj-id ) {
   $RT::Logger-warning(custom field '$CFName' isn't defined for queue 
'. $QueueObj-Name .');

   return undef;
 }



 my $RequestorRealName = '*??Requestor.RealName??*';
 my $LastInitial = substr($RequestorRealName ,instr($RequestorRealName 
,' ',-1,1)+1,1);


 unless( $self-TicketObj-FirstCustomFieldValue( $CFObj-id ) ) {
   my( $st, $msg ) = $self-TicketObj-AddCustomFieldValue(
 Field = $CFObj-id,
 Value = $LastInitial,
 RecordTransaction = 
$RecTransaction );

   unless( $st ) {
 $RT::Logger-warning( Couldn't set $DefaultValue as value for CF 
$CFName:. $msg );

 return undef;
   }
 }

 return 1;

--
Joe Kirby , Assistant Vice President, Business Systems
Division of Information Technology (DoIT)
Support Response - http://www.umbc.edu/oit
Administration 627
Office - 410-455-3020
Email - ki...@umbc.edu



Re: [rt-users] unrecognized time zone name: GMT

2011-02-09 Thread Kevin Falcone
On Wed, Feb 09, 2011 at 11:02:05AM -0800, Lee Hughes wrote:
 Testing RT 3.8.8 with PostgreSQL 9.0.3, seeing these warnings in the
 Apache error log:

That's unusual.  What timezones does your Pg know about?
http://www.postgresql.org/docs/9.0/static/view-pg-timezone-names.html

-kevin

 [Wed Feb  9 18:46:38 2011] [warning]: DBD::Pg::st execute failed:
 ERROR:  unrecognized time zone name: GMT
 (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)
 [Wed Feb  9 18:46:38 2011] [warning]: RT::Handle=HASH(0xb14ed7c)
 couldn't execute the query 'SET TIME ZONE 'GMT'' at
 /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522
 
 Looks like these errors occur on every ticket transaction, for
 example saving a Comment. I confirmed that correct timestamps are
 getting assigned to ticket transactions.
 
 Any ideas are greatly appreciated.
 
 Thanks-
 
 Lee
 
 
 
 


pgpkfiq2koF8j.pgp
Description: PGP signature


[rt-users] RTFM new install question

2011-02-09 Thread Vance Walsh
When I attempt to grant permissions in RTFM I get the following

Can't locate object method ACLEquivalenceObjects via package
RT::FM::System at /opt/rt3/bin/../lib/RT/Principal_Overlay.pm line 327. 

I have 3.8.8 RT running well and just installed RTFM 2.4.1 and fresh
installed it.

Thoughts on how to correct this?

---

Vance Walsh
Network and Systems Administrator
Concord Academy - Concord, Mass.



Re: [rt-users] Default auto-refresh interval

2011-02-09 Thread Michael Brown
On Wednesday 09 Feb 2011 14:23:23 Kevin Falcone wrote:
 On Wed, Feb 09, 2011 at 01:37:17PM +, Michael Brown wrote:
  I had a customer request to set the default home page refresh interval to
  2 minutes for all users.  I found several suggestions that essentially
  involved modifying the code (e.g. by creating a local version of
  Elements/Login or Elements/Refresh), but wanted to avoid code
  customisations if at all possible.
 
  I found that I could make this work using mod_rewrite, without having to
  touch the RT code:
 
RewriteEngine On
RewriteRule ^/$ /?HomeRefreshInterval=120 [L,PT,QSA]
 
  (note that this is with RT in the root directory of a virtual host;
  modify the ^/$ portion as necessary for other locations).
 
  Posting this message for the record, to save someone else the time it
  took me to figure this out.
 
 I'm not sure How this is better than using the documented config variable
 $HomePageRefreshInterval which is also available on a per-user basis.

Doesn't show up in any file my (pre-packaged) version of RT 3.8.1:

  grep -i HomePageRefreshInterval `rpm -ql rt`

nor in a search of the RT wiki.

I assume it's a relatively new setting that isn't yet documented?

Michael


Re: [rt-users] RTFM new install question

2011-02-09 Thread Kevin Falcone
On Wed, Feb 09, 2011 at 03:29:02PM -0500, Vance Walsh wrote:
When I attempt to grant permissions in RTFM I get the following
Can't locate object method ACLEquivalenceObjects via package 
 RT::FM::System at
/opt/rt3/bin/../lib/RT/Principal_Overlay.pm line 327.
I have 3.8.8 RT running well and just installed RTFM 2.4.1 and fresh 
 installed it.
Thoughts on how to correct this?

Try the current version of RTFM, 2.4.3

-kevin


pgpncpBKZUt6c.pgp
Description: PGP signature


Re: [rt-users] unrecognized time zone name: GMT

2011-02-09 Thread Lee Hughes
Great question Kevin, turns out the timezone files were not readable  
by postgres. This fix worked:


chmod o+r /usr/local/pgsql/share/timezone/*

Thanks again for your prompt and excellent help.

Lee


That's unusual.  What timezones does your Pg know about?
http://www.postgresql.org/docs/9.0/static/view-pg-timezone-names.html

-kevin





Re: [rt-users] CF appears after update even without SeeCustomField rights

2011-02-09 Thread David Good
On 2/9/2011 8:29 AM, Kevin Falcone wrote:
 On Tue, Feb 08, 2011 at 10:31:25AM -0800, David Good wrote:
 I've found an issue in two separate 3.8.8 installations.  Both have one
 or more CustomFields that are not supposed to be visible to most users. 
 The CF is managed entirely by Scrips to contain extra information not
 needed by users.  In one installation, it contains the Cost Center of
 the Requestor. In the other, there's a flag used to enable suppression
 of notifications when a ticket is resolved and another flag used to mark
 a ticket as 'urgent'.

 When using the web interface (i.e. via the 'Basics' or 'Jumbo' tab), the
 CF doesn't appear intially but after an update is made to any item and
 saved, the CustomField appear.
 David

 I'd be interested to know if you can reproduce this on a test box
 running the 3.8.9 release candidate

 -kevin

I don't have a test box handy, but I'll see if I can get one setup.



Re: [rt-users] Default auto-refresh interval

2011-02-09 Thread Michael Brown
On Wednesday 09 Feb 2011 21:24:17 Kevin Falcone wrote:
 Please obey the Reply-To, I subscribe to the list and don't need
 personal email.

Of course, since you ask so nicely.

  Doesn't show up in any file my (pre-packaged) version of RT 3.8.1:
 
 3.8.1 is 2.5 years old and vulnerable to multiple security issues.
 Hopefully you've been patching.

Didn't realise the distro package was so old.  Have updated the package to 
3.8.8.  In the unlikely event that anyone else wants a Mandriva RPM updated to 
3.8.8, the SRPM is available at

  http://www.fensystems.co.uk/~mcb30/rt-3.8.8-1fs2010.0.src.rpm

grep -i HomePageRefreshInterval `rpm -ql rt`
 
  nor in a search of the RT wiki.
 
  I assume it's a relatively new setting that isn't yet documented?
 
 It was added in 3.8.3 which is more than 1.5 years old

Updated http://requesttracker.wikia.com/wiki/UserConfigurableRefreshPeriods to 
reflect the fact that it is no longer necessary to hack the source code.

Michael


Re: [rt-users] Overlay - local Problem

2011-02-09 Thread Violetta J. Wawryk

Hi,

Thanks for the replys. Yes, sorry I forgot to write it is a debian 
system. Therefore 
/usr/local/share/request-tracker3.6/lib/RT/Interface/Email.pm worked.


Regards,

Violetta


Am 05.02.2011 19:54, schrieb Dominic Hargreaves:

On Fri, Feb 04, 2011 at 11:58:17PM +0100, Christian Loos wrote:

Am 04.02.2011 13:57, schrieb Violetta J. Wawryk:

# ll /usr/share/request-tracker3.6/local/RT/Interface/Email.pm


You use the wrong path, you should change it to:
/usr/share/request-tracker3.6/local/lib/RT/Interface/Email.pm


This looks like a Debian-related path. On Debian (using the packages),
the local path would be

/usr/local/share/request-tracker3.6/lib/RT/Interface/Email.pm

not either of the two options currently suggested.



--
Vorstand/Board of Management:
Dr. Bernd Finkbeiner, Dr. Roland Niemeier, 
Dr. Arno Steitz, Dr. Ingrid Zech

Vorsitzender des Aufsichtsrats/
Chairman of the Supervisory Board:
Michel Lepert
Sitz/Registered Office: Tuebingen
Registergericht/Registration Court: Stuttgart
Registernummer/Commercial Register No.: HRB 382196 





Re: [rt-users] Can't change logo

2011-02-09 Thread Jim



Jason A. Smith smithj4 at bnl.gov writes:

 
 On 09/10/2010 11:55 AM, John Alberts wrote:
  I'm trying to change the bp logo that is in the lower right corner of
  every page. I followed the instruction at:
 
 You should probably leave the logo at the bottom right of the page 
 alone, as this just indicates the software tool being used and gives 
 proper credit to Best Practical.
 
  http://wiki.bestpractical.com/view/ChangeLogo and nothing has changed.
 
 This changes the logo at the top left of the webpage, and as noted in 
 the 3.8 section of the Wiki, you also have to modify the style sheet so 
 it will not hide the logo.  We use the following patch to do that:
 
 diff -urN rt-3.8.8-dist/share/html/NoAuth/css/web2/layout.css 
 rt-3.8.8/share/html/NoAuth/css/web2/layout.css
 --- rt-3.8.8-dist/share/html/NoAuth/css/web2/layout.css 2010-05-05 
 16:09:21.0 -0400
 +++ rt-3.8.8/share/html/NoAuth/css/web2/layout.css  2010-05-11 
 10:23:26.0 -0400
 @@ -171,12 +171,11 @@
 
   div#logo a {
 - display: none;
   position: absolute;
 -left: 0;
 -bottom: 0;
   }
   div#logo a img {
 +z-index: 100;
 +position: absolute;
   border: 0;
   }
   div#logo .rtname {
 
  I've restarted apache multiple times, cleared the mason_data/obj files.
  It still shows the bp logo. Any ideas?
 
 
 
  I'm using RT 3.8.8 on CentOS 5.5
 
  -=grep '($Logo' /opt/rt3/etc/RT_SiteConfig.pm
  Set($LogoURL, RT-Config-Get('WebImagesURL') . company_logo.gif);
  Set($LogoLinkURL, http://exlibrisgroup.com;);
  Set($LogoAltText, Hosted Services, Ex Libris USA);
  Set($LogoImageHeight, 55);
  Set($LogoImageWidth, 383);
 
 
  Thanks
  John
 
 
 
 Attachment (smime.p7s): application/pkcs7-signature, 4068 bytes
 
 
 RT Training in Washington DC, USA on Oct 25  26 2010
 Last one this year -- Learn how to get the most out of RT!

I have similar issue.

I have updated RT_SiteConfig.pm as below

Set($LogoURL, RT-Config-Get('WebImagesURL') . bplogo.gif);
Set($LogoLinkURL, http://www.example.com;);
Set($LogoAltText, Ankray LLC);

Copied bplogo.gif to RT_PATH/local/html/NoAuth/images
Copied layout.css to RT_PATH/local/html/NoAuth/css/web2/layout

and made following changes


div#logo a {
position: absolute;
left: 1%;
bottom: 1%;
}
div#logo a img {
border: 0;
}

Now I do see a Box on lower left corner which links to correct URL as in 
config but I don't see logo. 
It is just an outline with ? in it like it is not able to access gif file.

Any ideas?

Thanks