[rt-users] Graph and Dashboards by email

2011-07-07 Thread Raphaël MOUNEYRES
Hi,
still using RT 3.8.8 ;)

i have included multiple Queries to a dashboard, including 2 graphs : A 
pie chart one , and a tickets relationship one
This dashboard is correctly displaying all my queries (tables  graphs) 
inside RT webUI.
But when sending this dashboard on email, the graphs aren't displayed 
(i've got a small red box with a cross instead , meaning image not 
available)...
our mail client is Lotus Notes.
Is it normal ?

Raphaël
#
 Ce courriel et les documents qui lui sont joints peuvent contenir des
informations confidentielles ou ayant un caractère privé. S'ils ne vous sont
pas destinés, nous vous signalons qu'il est strictement interdit de les
divulguer, de les reproduire ou d'en utiliser de quelque manière que ce
soit le contenu. Si ce message vous a été transmis par erreur, merci d'en
informer l'expéditeur et de supprimer immédiatement de votre système
informatique ce courriel ainsi que tous les documents qui y sont attachés.


   **

 This e-mail and any attached documents may contain confidential or
proprietary information. If you are not the intended recipient, you are
notified that any dissemination, copying of this e-mail and any attachments
thereto or use of their contents by any means whatsoever is strictly
prohibited. If you have received this e-mail in error, please advise the
sender immediately and delete this e-mail and all attached documents
from your computer system.
#



2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Search based on User CF's

2011-07-07 Thread Bart
Hi everyone,

Thanks for your input, this helped me out tremendously.

It's a shame that searching based on user CF's isn't possible, in a way
users are connected to tickets and other attributes (the default user
fields) seem to be possible.
Hopefully it will be possible to also search on user CF's in the future :)
(hint hint lol)

For now I'm going to go with the option of filling a ticket CF with the
content of a user CF, I've found these wiki pages that will probably help me
with that task:


   - http://requesttracker.wikia.com/wiki/Contributions
   - http://requesttracker.wikia.com/wiki/AutomaticCustomFieldValue
   - http://requesttracker.wikia.com/wiki/SetCustomFieldViaMail


Thanks again, I'm off to create a nice custom scrip to achieve my goals.


Best regards,

Bart



2011/7/6 Ruslan Zakirov r...@bestpractical.com

 Hi,

 On Wed, Jul 6, 2011 at 4:30 PM, Bart b...@pleh.info wrote:
  Hi,
  I'm having some trouble with searching in RT, we have a situation where
 we
  want the ability search on user CF's.
  What I'm seeing is that I can only select fields that are in a ticket.
 I'd
  need requestor--CF.SomeCF like it's possible to do
 Requestor--organization
  in the search form.
  What would be the best way for achieving this?

 Such searches are not available at the moment. As workaround a scrip
 can be used that duplicates some users' info in ticket's custom fields
 and search performed by tickets' CFs.

  I'm using RT 4, the place where I'm trying the search is on the new
 search
  page.
  Best regards,
 
  Bart
 
 
 
  
  2011 Training: http://bestpractical.com/services/training.html
 



 --
 Best regards, Ruslan.



2011 Training: http://bestpractical.com/services/training.html

[rt-users] Creating overlay for User.pm with the aim to share mail address within more than one user

2011-07-07 Thread Manolo Cotallo
Hi,

I've just coded an overlay for Users.pm that doesn't perform unique
email validation. My aim is that some users can share an email address
(mail list) so that people belonging to a team can receive all
notifications dealing with one ticket, and if the owner is out of work
place, another one people in the team can attend that request.

RT Database schema seems to allow this (email is not a primary key,
and there aren't defined unique indexes for this record column).

Does anyone know if this is a potential damage to the structure of RT?
 Can something be broken if we follow this approach?

Kind regards and thanks!

Manuel E. Cotallo.
CETA-CIEMAT, Trujillo, Spain.


2011 Training: http://bestpractical.com/services/training.html


[rt-users] RE Graph and Dashboards by email

2011-07-07 Thread Raphaël MOUNEYRES
After looking more precicely into the mail headers and format, i notice 
that images generated for the graphs have header :
 Content-Transfer-Encoding: base64
 Content-Type: image/png
 Content-Disposition: inline
 Content-ID: 131002560331525265433
and are reffered with : img src=3Dcid:131002560331525265433 /br /

So probably Lotus Notes is either unable to display PNG images, or won't 
accept inline images (i can't have any answer from our IT department)

Is it possible to modify the format of sent image to JPG for example so i 
can make a try ? where to start with in the code, RT or external source ?

thank you for any information,

Raphaël MOUNEYRES




Raphaël MOUNEYRES raphael.mouney...@sagemcom.com 
Envoyé par : rt-users-boun...@lists.bestpractical.com
07/07/2011 09:45

A
rt-users@lists.bestpractical.com
cc

Objet
[rt-users] Graph and Dashboards by email







Hi, 
still using RT 3.8.8 ;) 

i have included multiple Queries to a dashboard, including 2 graphs : A 
pie chart one , and a tickets relationship one 
This dashboard is correctly displaying all my queries (tables  graphs) 
inside RT webUI. 
But when sending this dashboard on email, the graphs aren't displayed 
(i've got a small red box with a cross instead , meaning image not 
available)... 
our mail client is Lotus Notes. 
Is it normal ?

Raphaël

#
 Ce courriel et les documents qui lui sont joints peuvent contenir des
informations confidentielles ou ayant un caractère privé. S'ils ne vous sont
pas destinés, nous vous signalons qu'il est strictement interdit de les
divulguer, de les reproduire ou d'en utiliser de quelque manière que ce
soit le contenu. Si ce message vous a été transmis par erreur, merci d'en
informer l'expéditeur et de supprimer immédiatement de votre système
informatique ce courriel ainsi que tous les documents qui y sont attachés.


   **

 This e-mail and any attached documents may contain confidential or
proprietary information. If you are not the intended recipient, you are
notified that any dissemination, copying of this e-mail and any attachments
thereto or use of their contents by any means whatsoever is strictly
prohibited. If you have received this e-mail in error, please advise the
sender immediately and delete this e-mail and all attached documents
from your computer system.
#



2011 Training: http://bestpractical.com/services/training.html

[rt-users] Tr : RE RE Graph and Dashboards by email

2011-07-07 Thread Raphaël MOUNEYRES
One step further : Lotus Notes won't accept PNG images, but will show GIF 
images

So for the pie chart to be displayed correctly, the following patch did 
the trick :
in  /opt/rt3/share/html/Search/Chart
line 191 
-my @types = ('png' , 'gif');
+my @types = ('gif' , 'png');

but for the tickets relathionship graphs things are harder.

I made some tries on /opt/rt3/share/html/Tickets/Graphs/dhandler lines 71 
through 76, by changing png to gif
but the result is not so immediate. On the WebUI, refreshing my browser, 
the image alterns between, having a black backgound, not displaying at 
all, displaying correctly.
There must be another file to patch...

Raphaël MOUNEYRES





Raphaël MOUNEYRES raphael.mouney...@sagemcom.com 
Envoyé par : rt-users-boun...@lists.bestpractical.com
07/07/2011 14:47

A
rt-users@lists.bestpractical.com
cc

Objet
[rt-users] RE  Graph and Dashboards by email







After looking more precicely into the mail headers and format, i notice 
that images generated for the graphs have header : 
 Content-Transfer-Encoding: base64
Content-Type: image/png
Content-Disposition: inline
Content-ID: 131002560331525265433 
and are reffered with : img src=3Dcid:131002560331525265433 /br / 

So probably Lotus Notes is either unable to display PNG images, or won't 
accept inline images (i can't have any answer from our IT department) 

Is it possible to modify the format of sent image to JPG for example so i 
can make a try ? where to start with in the code, RT or external source ? 

thank you for any information, 

Raphaël MOUNEYRES



Raphaël MOUNEYRES raphael.mouney...@sagemcom.com 
Envoyé par : rt-users-boun...@lists.bestpractical.com 
07/07/2011 09:45 


A
rt-users@lists.bestpractical.com 
cc

Objet
[rt-users] Graph and Dashboards by email









Hi, 
still using RT 3.8.8 ;) 

i have included multiple Queries to a dashboard, including 2 graphs : A 
pie chart one , and a tickets relationship one 
This dashboard is correctly displaying all my queries (tables  graphs) 
inside RT webUI. 
But when sending this dashboard on email, the graphs aren't displayed 
(i've got a small red box with a cross instead , meaning image not 
available)... 
our mail client is Lotus Notes. 
Is it normal ?

Raphaël 

#
 Ce courriel et les documents qui lui sont joints peuvent contenir des
informations confidentielles ou ayant un caractère privé. S'ils ne vous sont
pas destinés, nous vous signalons qu'il est strictement interdit de les
divulguer, de les reproduire ou d'en utiliser de quelque manière que ce
soit le contenu. Si ce message vous a été transmis par erreur, merci d'en
informer l'expéditeur et de supprimer immédiatement de votre système
informatique ce courriel ainsi que tous les documents qui y sont attachés.


   **

 This e-mail and any attached documents may contain confidential or
proprietary information. If you are not the intended recipient, you are
notified that any dissemination, copying of this e-mail and any attachments
thereto or use of their contents by any means whatsoever is strictly
prohibited. If you have received this e-mail in error, please advise the
sender immediately and delete this e-mail and all attached documents
from your computer system.
#



2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Creating overlay for User.pm with the aim to share mail address within more than one user

2011-07-07 Thread Thomas Sibley
On 07/07/2011 05:01 AM, Manolo Cotallo wrote:
 I've just coded an overlay for Users.pm that doesn't perform unique
 email validation. My aim is that some users can share an email address
 (mail list) so that people belonging to a team can receive all
 notifications dealing with one ticket, and if the owner is out of work
 place, another one people in the team can attend that request.

Why can't you simply add each user (with their own email address) to a
group and add that group as an AdminCc to appropriate tickets/queues so
they get all the notifications?

 RT Database schema seems to allow this (email is not a primary key,
 and there aren't defined unique indexes for this record column).
 
 Does anyone know if this is a potential damage to the structure of RT?
  Can something be broken if we follow this approach?

This is bound to break RT in horrible ways.  I strongly suggest you
don't do it.

Thomas


2011 Training: http://bestpractical.com/services/training.html


Re: [rt-users] RTV4.0.0: User Access Restrictions

2011-07-07 Thread Thomas Sibley
On 07/06/2011 06:44 PM, Joanne Keown wrote:
 Back in June I emailed the below question/request for help and I don’t
 believe I have seen a response to that.
 
 Does anyone have any good ideas/pointers on this?  I have searched
 archives  manuals etc. but I can’t see what right I am applying that is
 allowing all my users Admin rights.

The information in the spreadsheet simply isn't enough.  There's many
other places you could be granting them rights.  We can't offer more
than guesses without essentially a database dump of the relevant RT tables.

Thomas


2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Faking {$Transaction-Content()}

2011-07-07 Thread Mauricio Tavares
On Thu, Jul 7, 2011 at 9:59 AM, Mike Johnson mike.john...@nosm.ca wrote:
 Just trying to peice together the workflow from the last few emails, sorry
 if I simplify it too much...

 - previous owner comments on ticket with attachments
 - somehow the owner changes(sounds like the previous owner may do this...
 not sure though)
 - email fires to new owner notifying him he owns this ticket
 - new owner uses email to communicate with requestor

  You got the workflow right. FYI, right now I am able to send an
email to new owner that looks like the last correspondence in the
ticket with two small exceptions:

o I created a header that indicates the new owner. Such header is only
sent to the AdminCcs, not to the requestor or other CCs. Owner can use
that header to filter out correspondence that is addressed to
him/her/it.

o Non-text attachments are shown as links instead of being attached to
the email being sent to the new owner. I would like to have them
attached but right now I do not know how to do it. I probably need to
learn how to create this email as a MIMEObj, which is my weakness
right now.

 Your end state is
 - owner changed
 - requestor gets attachments
 - new owner has a conduit to communicate to requestor via email

 The last part of that workflow makes me assume you have a scrip that
 notifies requestor on correspondence, so to me, the only thing that you need
 to do to get your end state, make the previous owner add the attachments as
 a correspondence instead of comment.

 If your end state also requires the new owner to have a copy of the
 attachments in his email, the previous owner can do a 1 time cc to the new
 owner when he's sending the reply with the attachments.

  But that would mean old owner would have to (a) pass ownership
to new owner and (b) cc the new owner. That makes it easier for old
owner to miss a step.

 If typing in the new owner's email address isn't reliable, there is an
 extension out there that does autocomplete, might be of some use? I've only
 looked at it once... not sure if it can be configured out of the box to do
 what you need, but it would be a starting point.

 Not sure if you can get the attachments from a previous transaction, but a
 little user training may make it so you don't have to.

  You should know by now it is easier to write code than to train users. ;)

 Thanks!
 Mike.
 On Tue, Jul 5, 2011 at 6:33 PM, Mauricio Tavares raubvo...@gmail.com
 wrote:

 On Tue, Jul 5, 2011 at 6:25 PM, Kenneth Crocker kfcroc...@lbl.gov wrote:
  Mauricio,
 
  Why not just keep it simple and send them an email with some simple
  ticket
  info and the ticket id so they can just link to the ticket and see
  whatever
  info they need. They are going to need to go into the ticket anyway.
  Clicking a link to the ticket won't take anymore time than clicking any
  attachment in the email. AND if the ticket has several attachments (as
  many
  of ours do), this simplifies the process a great deal.
 
      I agree; I actually have that working (well the text part of the
 comment is shown on the ticket and then the non-text attachments are
 provided as links). Problem is that is what they want is the new
 ticket owner to get a complete copy of the last ticket correspondence
 so he can reply to it and it will be sent to the requestor. New owner
 should not need to go to the RT web interface to do that. And that has
 turned out to be a bit more challenging than I originally expected. :)

  Just a thought.
 
  Kenn
 
  On Tue, Jul 5, 2011 at 3:01 PM, Mauricio Tavares raubvo...@gmail.com
  wrote:
 
  On Tue, Jul 5, 2011 at 5:55 PM, Mauricio Tavares raubvo...@gmail.com
  wrote:
   On Tue, Jul 5, 2011 at 5:51 PM, Kenneth Crocker kfcroc...@lbl.gov
   wrote:
   Mauricio,
  
   Who are you sending the email to?
  
     The new ticket owner.
  
       Something on these lines (not claiming to be proper or correct)
  is what I am trying to do:
 
  {
    my $Transactions = $Ticket-Transactions;
    $RT::Logger-debug(Find Transaction);
    $Transactions-Limit( FIELD = 'Type',
                           VALUE = Correspond
                         );
    $Transaction = $Transactions-Last;
    $RT::Logger-debug(Found Transaction : $Transaction);
  }To: { $Ticket-OwnerObj-EmailAddress }
  Subject: { $Ticket-Subject() }
  RT-Attach-Message: yes
 
  But I am not able to feed the $Transaction I want (the one I got above
  the headers) to RT-Attach-Message.
 
   Kenn
   LBNL
  
   On Tue, Jul 5, 2011 at 12:35 PM, Mauricio Tavares
   raubvo...@gmail.com
   wrote:
  
   On Tue, Jul 5, 2011 at 2:31 PM, Kenneth Crocker kfcroc...@lbl.gov
   wrote:
Mauricio,
   
What is it you want to do? It sounds like you want to put the
last
correspondence of a ticket into an email/template when the owner
of
a
ticket
is changed. Is that right? Technically, there WAS a transaction
record
created, but since it only involved an owner change, that's the
only
info on
 

[rt-users] Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

2011-07-07 Thread Direct Insure Online
Hi All,
 
We just upgraded our RT from 3.8.4 to 4.0.1We upgraded the database also.
 
When we want to create a new custom field we are getting the following errors
 
Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.
Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 620.
 
What could be the problem.
 
With Regards
Vinod.R
 

From: Mauricio Tavares raubvo...@gmail.com
To: Mike Johnson mike.john...@nosm.ca
Cc: rt-users@lists.bestpractical.com
Sent: Thursday, July 7, 2011 10:40 AM
Subject: Re: [rt-users] Faking {$Transaction-Content()}

On Thu, Jul 7, 2011 at 9:59 AM, Mike Johnson mike.john...@nosm.ca wrote:
 Just trying to peice together the workflow from the last few emails, sorry
 if I simplify it too much...

 - previous owner comments on ticket with attachments
 - somehow the owner changes(sounds like the previous owner may do this...
 not sure though)
 - email fires to new owner notifying him he owns this ticket
 - new owner uses email to communicate with requestor

      You got the workflow right. FYI, right now I am able to send an
email to new owner that looks like the last correspondence in the
ticket with two small exceptions:

o I created a header that indicates the new owner. Such header is only
sent to the AdminCcs, not to the requestor or other CCs. Owner can use
that header to filter out correspondence that is addressed to
him/her/it.

o Non-text attachments are shown as links instead of being attached to
the email being sent to the new owner. I would like to have them
attached but right now I do not know how to do it. I probably need to
learn how to create this email as a MIMEObj, which is my weakness
right now.

 Your end state is
 - owner changed
 - requestor gets attachments
 - new owner has a conduit to communicate to requestor via email

 The last part of that workflow makes me assume you have a scrip that
 notifies requestor on correspondence, so to me, the only thing that you need
 to do to get your end state, make the previous owner add the attachments as
 a correspondence instead of comment.

 If your end state also requires the new owner to have a copy of the
 attachments in his email, the previous owner can do a 1 time cc to the new
 owner when he's sending the reply with the attachments.

      But that would mean old owner would have to (a) pass ownership
to new owner and (b) cc the new owner. That makes it easier for old
owner to miss a step.

 If typing in the new owner's email address isn't reliable, there is an
 extension out there that does autocomplete, might be of some use? I've only
 looked at it once... not sure if it can be configured out of the box to do
 what you need, but it would be a starting point.

 Not sure if you can get the attachments from a previous transaction, but a
 little user training may make it so you don't have to.

      You should know by now it is easier to write code than to train users. ;)

 Thanks!
 Mike.
 On Tue, Jul 5, 2011 at 6:33 PM, Mauricio Tavares raubvo...@gmail.com
 wrote:

 On Tue, Jul 5, 2011 at 6:25 PM, Kenneth Crocker kfcroc...@lbl.gov wrote:
  Mauricio,
 
  Why not just keep it simple and send them an email with some simple
  ticket
  info and the ticket id so they can just link to the ticket and see
  whatever
  info they need. They are going to need to go into the ticket anyway.
  Clicking a link to the ticket won't take anymore time than clicking any
  attachment in the email. AND if the ticket has several attachments (as
  many
  of ours do), this simplifies the process a great deal.
 
      I agree; I actually have that working (well the text part of the
 comment is shown on the ticket and then the non-text attachments are
 provided as links). Problem is that is what they want is the new
 ticket owner to get a complete copy of the last ticket correspondence
 so he can reply to it and it will be sent to the requestor. New owner
 should not need to go to the RT web interface to do that. And that has
 turned out to be a bit more challenging than I originally expected. :)

  Just a thought.
 
  Kenn
 
  On Tue, Jul 5, 2011 at 3:01 PM, Mauricio Tavares raubvo...@gmail.com
  wrote:
 
  On Tue, Jul 5, 2011 at 5:55 PM, Mauricio Tavares raubvo...@gmail.com
  wrote:
   On Tue, Jul 5, 2011 at 5:51 PM, Kenneth Crocker kfcroc...@lbl.gov
   wrote:
   Mauricio,
  
   Who are you sending the email to?
  
     The new ticket owner.
  
       Something on these lines (not claiming to be proper or correct)
  is what I am trying to do:
 
  {
    my $Transactions = $Ticket-Transactions;
    $RT::Logger-debug(Find Transaction);
    $Transactions-Limit( FIELD = 'Type',
                           VALUE = Correspond
                         );
    $Transaction = $Transactions-Last;
    $RT::Logger-debug(Found Transaction : $Transaction);
  }To: { $Ticket-OwnerObj-EmailAddress }
  Subject: { $Ticket-Subject() }
  RT-Attach-Message: yes
 
  But I am not able to feed the $Transaction I want (the 

Re: [rt-users] RTV4.0.0: User Access Restrictions

2011-07-07 Thread Alex Vandiver
On Thu, 2011-07-07 at 09:52 -0400, Thomas Sibley wrote:
 On 07/06/2011 06:44 PM, Joanne Keown wrote:
  Back in June I emailed the below question/request for help and I don’t
  believe I have seen a response to that.
  
  Does anyone have any good ideas/pointers on this?  I have searched
  archives  manuals etc. but I can’t see what right I am applying that is
  allowing all my users Admin rights.
 
 The information in the spreadsheet simply isn't enough.  There's many
 other places you could be granting them rights.  We can't offer more
 than guesses without essentially a database dump of the relevant RT tables.

You have likely misapplied the Superuser right on some group the users
are in, directly or indirectly.  The following (which is untested,
simply written off the top of my head), run from your database, should
tell you which group that they are in has this right: 

select Groups.* from Users
  join CachedGroupMembers on CachedGroupMembers.MemberId = Users.id
  join ACL on ACL.PrincipalId = CachedGroupMembers.GroupId
  and ACL.RightName = 'SuperUser'
  join Groups on Groups.id = ACL.PrincipalId
where Users.Name = 'dchapman'

- Alex



2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

2011-07-07 Thread Kevin Falcone
On Thu, Jul 07, 2011 at 08:42:27AM -0700, Direct Insure Online wrote:
We just upgraded our RT from 3.8.4 to 4.0.1
We upgraded the database also.
 
When we want to create a new custom field we are getting the following 
 errors
 
Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
 line 696.
Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
 line 620.
 
What could be the problem.

The most common failure for something like this is that you have a
CustomField_Overlay.pm left over from 3.8 and didn't follow the
directions.  Alternately, you might have a local customization or
extension that affects Custom Fields.

-kevin


pgpeL3YURmr61.pgp
Description: PGP signature


2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Graph and Dashboards by email

2011-07-07 Thread Kenneth Crocker
Raphael,

No it isn't. I have some graphs I send out in a dashboard and they all look
fine. The only problem I've had with dashboards is the No Limit option
doesn't really work and the output gets dropped after a certain number of
lines. The graphs show up fine (I'm still in 3.8.7).

Two considerations, your email provider (Gmail, etc.) may not like the html
or whatever format you are sending and it has to be configured for that type
of info. Maybe it wants text only. The other consideration is what you might
have to do to RT to configure output in email to make graphs display inline.
I really don't know as I haven't had to look into anything like that as yet.

Hope this helped.

Kenn
LBNL

2011/7/7 Raphaël MOUNEYRES raphael.mouney...@sagemcom.com


 Hi,
 still using RT 3.8.8 ;)

 i have included multiple Queries to a dashboard, including 2 graphs : A pie
 chart one , and a tickets relationship one
 This dashboard is correctly displaying all my queries (tables  graphs)
 inside RT webUI.
 But when sending this dashboard on email, the graphs aren't displayed (i've
 got a small red box with a cross instead , meaning image not available)...
 our mail client is Lotus Notes.
 Is it normal ?

 Raphaël

 #
  Ce courriel et les documents qui lui sont joints peuvent contenir des
 informations confidentielles ou ayant un caractère privé. S'ils ne vous sont
 pas destinés, nous vous signalons qu'il est strictement interdit de les
 divulguer, de les reproduire ou d'en utiliser de quelque manière que ce
 soit le contenu. Si ce message vous a été transmis par erreur, merci d'en
 informer l'expéditeur et de supprimer immédiatement de votre système
 informatique ce courriel ainsi que tous les documents qui y sont attachés.


**

  This e-mail and any attached documents may contain confidential or
 proprietary information. If you are not the intended recipient, you are
 notified that any dissemination, copying of this e-mail and any attachments
 thereto or use of their contents by any means whatsoever is strictly
 prohibited. If you have received this e-mail in error, please advise the
 sender immediately and delete this e-mail and all attached documents
 from your computer system.
 #



 
 2011 Training: http://bestpractical.com/services/training.html



2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] RTV4.0.0: User Access Restrictions

2011-07-07 Thread Kenneth Crocker
Joanne,

Have you installed RT::Rights Matrix? I have found that VERY useful in the
past. If someone is getting rights from more than one setting, it will show
up in those results.

Kenn
LBNL


On Thu, Jul 7, 2011 at 9:28 AM, Alex Vandiver ale...@bestpractical.comwrote:

 On Thu, 2011-07-07 at 09:52 -0400, Thomas Sibley wrote:
  On 07/06/2011 06:44 PM, Joanne Keown wrote:
   Back in June I emailed the below question/request for help and I don’t
   believe I have seen a response to that.
  
   Does anyone have any good ideas/pointers on this?  I have searched
   archives  manuals etc. but I can’t see what right I am applying that
 is
   allowing all my users Admin rights.
 
  The information in the spreadsheet simply isn't enough.  There's many
  other places you could be granting them rights.  We can't offer more
  than guesses without essentially a database dump of the relevant RT
 tables.

 You have likely misapplied the Superuser right on some group the users
 are in, directly or indirectly.  The following (which is untested,
 simply written off the top of my head), run from your database, should
 tell you which group that they are in has this right:

 select Groups.* from Users
  join CachedGroupMembers on CachedGroupMembers.MemberId = Users.id
  join ACL on ACL.PrincipalId = CachedGroupMembers.GroupId
  and ACL.RightName = 'SuperUser'
  join Groups on Groups.id = ACL.PrincipalId
 where Users.Name = 'dchapman'

 - Alex


 
 2011 Training: http://bestpractical.com/services/training.html



2011 Training: http://bestpractical.com/services/training.html

[rt-users] (no subject)

2011-07-07 Thread Jared Lynn
I am upgrading from RT3.8.10 to RT4.* and have completed the entire
upgrade up to the point of getting Apache2 to recognize the new
location of RT.

In 3.8.10, I point the /etc/apache2/sites-available/default file to:
Include /etc/request-tracker3.8/apache2-modperl2.conf
RedirectMatch ^/$ /rt

What do I replace in the default file to point apache to the new interface?

RT4 resides in /opt/rt4/

I hope that gives enough information for a solution. I have been
through the /docs and read the web-deployment file and all other
upgrade documentation and still no go...

I know just enough about Apache to be considered dangerous and not
enough to actually understand what I'm messing up.
Jared Lynn
PORTA  CUSD #202 Technology Coordinator
E-mail: jl...@porta202.org
Phone: 217-501-4920


2011 Training: http://bestpractical.com/services/training.html


Re: [rt-users] (no subject)

2011-07-07 Thread Kevin Falcone
On Thu, Jul 07, 2011 at 01:10:07PM -0500, Jared Lynn wrote:
 I am upgrading from RT3.8.10 to RT4.* and have completed the entire
 upgrade up to the point of getting Apache2 to recognize the new
 location of RT.
 
 In 3.8.10, I point the /etc/apache2/sites-available/default file to:
 Include /etc/request-tracker3.8/apache2-modperl2.conf
 RedirectMatch ^/$ /rt
 
 What do I replace in the default file to point apache to the new interface?
 
 RT4 resides in /opt/rt4/
 
 I hope that gives enough information for a solution. I have been
 through the /docs and read the web-deployment file and all other
 upgrade documentation and still no go...
 
 I know just enough about Apache to be considered dangerous and not
 enough to actually understand what I'm messing up.

You have to follow the mod_perl2 directions in docs/web_deployment.pod
or use the request-tracker4 packages that are available in debian
testing (since you appear to be using packages for 3.8)

-kevin


pgp3E7GpS8YfE.pgp
Description: PGP signature


2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] (no subject)

2011-07-07 Thread Jared Lynn
Do you remove the default virtualHost information and then update the
ports file?
Jared Lynn
PORTA  CUSD #202 Technology Coordinator
E-mail: jl...@porta202.org
Phone: 217-501-4920



On Thu, Jul 7, 2011 at 1:21 PM, Kevin Falcone falc...@bestpractical.com wrote:
 On Thu, Jul 07, 2011 at 01:10:07PM -0500, Jared Lynn wrote:
 I am upgrading from RT3.8.10 to RT4.* and have completed the entire
 upgrade up to the point of getting Apache2 to recognize the new
 location of RT.

 In 3.8.10, I point the /etc/apache2/sites-available/default file to:
 Include /etc/request-tracker3.8/apache2-modperl2.conf
 RedirectMatch ^/$ /rt

 What do I replace in the default file to point apache to the new interface?

 RT4 resides in /opt/rt4/

 I hope that gives enough information for a solution. I have been
 through the /docs and read the web-deployment file and all other
 upgrade documentation and still no go...

 I know just enough about Apache to be considered dangerous and not
 enough to actually understand what I'm messing up.

 You have to follow the mod_perl2 directions in docs/web_deployment.pod
 or use the request-tracker4 packages that are available in debian
 testing (since you appear to be using packages for 3.8)

 -kevin


 
 2011 Training: http://bestpractical.com/services/training.html



2011 Training: http://bestpractical.com/services/training.html


Re: [rt-users] rt4: edit search to display resolved tickets

2011-07-07 Thread Gregor Binder
hi,

thanks for the hint but these don't change the default behavior for the 
searchfield thats in the upper right corner. to search for someticket 
resolved are also no solution because we need to search always for tickets in 
the whole lifecycle.

greetings
gregor

- Original Message -
 From: Michael Steen michael.st...@livetext.com
 To: Gregor Binder gregor.bin...@gmx.net
 Sent: Thursday, 7 July, 2011 7:19:36 PM
 Subject: Re: [rt-users] rt4: edit search to display resolved tickets
 
 You probably want to look at how to save a search, then how to edit
 your RT At A Glance screen on the wiki
 
 http://requesttracker.wikia.com/wiki/ManualSearchTickets
 
 
 On Wed, Jul 6, 2011 at 4:11 PM, Gregor Binder  gregor.bin...@gmx.net
  wrote:
 
 
 hi,
 
 how can i edit the search in the upper right to display all tickets
 also resolved?
 
 greetings
 gregor
 
 
 2011 Training: http://bestpractical.com/services/training.html
 
 


2011 Training: http://bestpractical.com/services/training.html


Re: [rt-users] rt4: edit search to display resolved tickets

2011-07-07 Thread Kevin Falcone
On Thu, Jul 07, 2011 at 09:46:49PM +0200, Gregor Binder wrote:
 thanks for the hint but these don't change the default behavior for
 the searchfield thats in the upper right corner. to search for
 someticket resolved are also no solution because we need to search
 always for tickets in the whole lifecycle.

As I mentioned in #rt - there's a config option for that in RT4

-kevin

 
 - Original Message -
  From: Michael Steen michael.st...@livetext.com
  To: Gregor Binder gregor.bin...@gmx.net
  Sent: Thursday, 7 July, 2011 7:19:36 PM
  Subject: Re: [rt-users] rt4: edit search to display resolved tickets
  
  You probably want to look at how to save a search, then how to edit
  your RT At A Glance screen on the wiki
  
  http://requesttracker.wikia.com/wiki/ManualSearchTickets
  
  
  On Wed, Jul 6, 2011 at 4:11 PM, Gregor Binder  gregor.bin...@gmx.net
   wrote:
  
  
  hi,
  
  how can i edit the search in the upper right to display all tickets
  also resolved?


pgpViSaVbzL0J.pgp
Description: PGP signature


2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

2011-07-07 Thread Direct Insure Online
Hi Kevin,
 
I deleted all *_Overlay.pm files when I upgraded and I have the following 
setting in RT_SiteConfig.pm
Set(@Plugins, qw(
 RT::Authen::ExternalAuth
 RT::Extension::CustomField::Checkbox
    ));

If I comment the above one I am getting the following error
could not find component for path 'EditCustomFieldSelectCheckbox' 
 
If I enable the above in RT_SiteConfig.pm I am getting the following error
Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.
Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 620.

With Regards
Vinod.R
 

From: Kevin Falcone falc...@bestpractical.com
To: rt-users@lists.bestpractical.com
Sent: Thursday, July 7, 2011 12:46 PM
Subject: Re: [rt-users] Can't coerce array into hash at 
/opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

On Thu, Jul 07, 2011 at 08:42:27AM -0700, Direct Insure Online wrote:
    We just upgraded our RT from 3.8.4 to 4.0.1
    We upgraded the database also.
 
    When we want to create a new custom field we are getting the following 
errors
 
    Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
line 696.
    Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
line 620.
 
    What could be the problem.

The most common failure for something like this is that you have a
CustomField_Overlay.pm left over from 3.8 and didn't follow the
directions.  Alternately, you might have a local customization or
extension that affects Custom Fields.

-kevin



2011 Training: http://bestpractical.com/services/training.html

2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

2011-07-07 Thread Kevin Falcone
On Thu, Jul 07, 2011 at 01:01:27PM -0700, Direct Insure Online wrote:
 Hi Kevin,
  
 I deleted all *_Overlay.pm files when I upgraded and I have the following 
 setting in RT_SiteConfig.pm
 Set(@Plugins, qw(
  RT::Authen::ExternalAuth
  RT::Extension::CustomField::Checkbox
     ));

Ah, there's the problem.

RT-Extension-CustomField-Checkbox has been superseded by RT4 (and in
fact is really incompatible with RT4).  Unfortunately, there isn't
currently an upgrade script, although we'll make sure this gets into
the bug tracker.

You *should* be able to do something like this in your development
environment.

Find the entry in your CustomFields table with the Checkbox entry,
update Type to Select and DisplayType to List.

-kevin

 If I comment the above one I am getting the following error
 could not find component for path 'EditCustomFieldSelectCheckbox' 
  
 If I enable the above in RT_SiteConfig.pm I am getting the following error
 Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 
 696.
 Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 
 620.
 
 With Regards
 Vinod.R
  
 
 From: Kevin Falcone falc...@bestpractical.com
 To: rt-users@lists.bestpractical.com
 Sent: Thursday, July 7, 2011 12:46 PM
 Subject: Re: [rt-users] Can't coerce array into hash at 
 /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.
 
 On Thu, Jul 07, 2011 at 08:42:27AM -0700, Direct Insure Online wrote:
     We just upgraded our RT from 3.8.4 to 4.0.1
     We upgraded the database also.
  
     When we want to create a new custom field we are getting the following 
 errors
  
     Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
 line 696.
     Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
 line 620.
  
     What could be the problem.
 
 The most common failure for something like this is that you have a
 CustomField_Overlay.pm left over from 3.8 and didn't follow the
 directions.  Alternately, you might have a local customization or
 extension that affects Custom Fields.


pgpSByCzm8TXQ.pgp
Description: PGP signature


2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

2011-07-07 Thread Direct Insure Online
Hi Kevin,
 
Updated the database as you suggested.
Now on the form there are no radio button's
 
With Regards
Vinod.R

From: Kevin Falcone falc...@bestpractical.com
To: Direct Insure Online vinod.rap...@yahoo.com
Sent: Thursday, July 7, 2011 4:31 PM
Subject: Re: [rt-users] Can't coerce array into hash at 
/opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

On Thu, Jul 07, 2011 at 01:01:27PM -0700, Direct Insure Online wrote:
 Hi Kevin,
  
 I deleted all *_Overlay.pm files when I upgraded and I have the following 
 setting in RT_SiteConfig.pm
 Set(@Plugins, qw(
  RT::Authen::ExternalAuth
  RT::Extension::CustomField::Checkbox
     ));

Ah, there's the problem.

RT-Extension-CustomField-Checkbox has been superseded by RT4 (and in
fact is really incompatible with RT4).  Unfortunately, there isn't
currently an upgrade script, although we'll make sure this gets into
the bug tracker.

You *should* be able to do something like this in your development
environment.

Find the entry in your CustomFields table with the Checkbox entry,
update Type to Select and DisplayType to List.

-kevin

 If I comment the above one I am getting the following error
 could not find component for path 'EditCustomFieldSelectCheckbox' 
  
 If I enable the above in RT_SiteConfig.pm I am getting the following error
 Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 
 696.
 Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 
 620.
 
 With Regards
 Vinod.R
  
 
 From: Kevin Falcone falc...@bestpractical.com
 To: rt-users@lists.bestpractical.com
 Sent: Thursday, July 7, 2011 12:46 PM
 Subject: Re: [rt-users] Can't coerce array into hash at 
 /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.
 
 On Thu, Jul 07, 2011 at 08:42:27AM -0700, Direct Insure Online wrote:
     We just upgraded our RT from 3.8.4 to 4.0.1
     We upgraded the database also.
  
     When we want to create a new custom field we are getting the following 
 errors
  
     Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
 line 696.
     Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
 line 620.
  
     What could be the problem.
 
 The most common failure for something like this is that you have a
 CustomField_Overlay.pm left over from 3.8 and didn't follow the
 directions.  Alternately, you might have a local customization or
 extension that affects Custom Fields.

2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] RTx::Tags

2011-07-07 Thread Yan Seiner


On Wed, July 6, 2011 4:36 pm, Edward Frye wrote:
 I am trying to work with this plugin, I would like to limit what gets
displayed to those where a tag is used more than one time rather than
every
 tag I have which has gotten out of hand.

I can't help you but thanks for pointing this out.

I installed the plugin as well.  I attached it to transactions as we need
to be able to find specific comments.

The search function doesn't work.  :-(

The Sinmple Search | Tag Cloud searches appear and the Transaction pane
has my tags in it.  But if I click on any of the tags I just get pointed
right back to the Tag Cloud page.  Using .Tags:MyTag yields 0 results.

Any thoughts?

--Yan



-- 
My daughter is racing a triathlon to raise money for her swim club.  Want
to help?

http://akari.seiner.com




2011 Training: http://bestpractical.com/services/training.html


Re: [rt-users] New install of RT4 crashes Internet Explorer 8

2011-07-07 Thread Christopher Lasater
I believe me and a coworker have found the problem, if we comment out the line 
in the following file the problem goes away.  I assume it has to do with the 
PIE.htc which is at version 1.0beta2 current version is beta4, which I tried 
and did not help :/ 

/*behavior: url(/NoAuth/css/images/PIE.htc); */

http://server.net/NoAuth/css/aileron/msie-pie.css


The following site does mention an issue with things not being loaded correctly 
outside of 100% zoom, but it does not mention CPU going to 100%.  

http://css3pie.com/documentation/known-issues/


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Tuesday, July 05, 2011 1:33 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] New install of RT4 crashes Internet Explorer 8

On Tue, Jul 05, 2011 at 12:56:16PM -0400, Christopher Lasater wrote:
 Unfortunately I experience the problem with my local RT4.0.1 but not 
 the issues.bestpractical.com. So its more than just what version of IE 
 you have. When changing the zoom level I can even get it to lock up 
 before logging in. Do you have any config changes on the apache side 
 for issues.bestpractical.com? mod_perl or fastcgi?

We're running a very vanilla mod_fastcgi setup, based on the documentation we 
ship with RT.

 IE Version 8.0.7600.16385 both 32 and 64bit version Windows 7 x64

I'm on an older IE8 release, but with WinXP for my IE8 machine.
Unfortunately, my Win7 machines are already running IE9 for testing.

-kevin

 -Original Message-
 From: rt-users-boun...@lists.bestpractical.com 
 [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin 
 Falcone
 Sent: Tuesday, July 05, 2011 9:24 AM
 To: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] New install of RT4 crashes Internet Explorer 8
 
 On Mon, Jul 04, 2011 at 11:21:28AM +0100, Sean McDaid wrote:
 Hi, yes zooming also causes the same problem. When I turn off either 
  scripting or CSS the
 problem disappears.
 I'm trying to figure out what IE is doing differently than Firefox/Chome.
 
 Unfortunately, I'm unable to replicate this with IE8 on 
 issues.bestpractical.com.  I can believe that IE has issues with zooming, but 
 without being able to replicate it, it's hard to fix.
 
 Can you tell us more about your specific version of IE and windows 
 versions.  There are too many variables at play with IE
 
 -kevin
 
 
 On Sat, Jul 2, 2011 at 2:11 PM, Christopher Lasater 
  [1]clasa...@taleo.com wrote:
  
   Hey Sean,
   Does zooming make the problem worse or do we have different issues?
   -Original Message-
   From: [2]rt-users-boun...@lists.bestpractical.com
   [mailto:[3]rt-users-boun...@lists.bestpractical.com] On Behalf Of 
  Christopher Lasater
   Sent: Friday, July 01, 2011 3:20 PM
   To: [4]rt-users@lists.bestpractical.com
   Subject: Re: [rt-users] New install of RT4 crashes Internet 
  Explorer 8
  
   It sounds dumb, but I think the issues I related to zooming in. If I 
  have no zoom at 100%
   everything works fine. The second I try to zoom its freezes and if I 
  am at 115%, which was
   my default, then it freezes when I get into rt at a glance. I can zoom 
  in and out like crazy
   in Firefox without experiencing any problems.
   -Original Message-
   From: [5]rt-users-boun...@lists.bestpractical.com
   [mailto:[6]rt-users-boun...@lists.bestpractical.com] On Behalf Of 
  Christopher Lasater
   Sent: Friday, July 01, 2011 3:04 PM
   To: [7]rt-users@lists.bestpractical.com
   Subject: Re: [rt-users] New install of RT4 crashes Internet 
  Explorer 8
  
   Mod_perl2, External Auth to an LDAP server, LDAP Importer. Not sure 
  what else you would be
   interested in.
  
   Problem occurs with or without IE compatibility mode.
  
   VirtualHost [8]server.example.com:80
  
   AddDefaultCharset UTF-8
  
   DocumentRoot /opt/rt4/share/html
   Location /
   Order allow,deny
   Allow from all
  
   SetHandler perl-script
   PerlResponseHandler Plack::Handler::Apache2
   PerlSetVar psgi_app /opt/rt4/sbin/rt-server
   /Location
   Perl
   use Plack::Handler::Apache2;
   Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server);
   /Perl
   /VirtualHost
  
   Set( $rtname, '[9]server.example.com');
   Set ($WebPath , );
   Set ($WebBaseUrl , [10]server.example.com:80); Set ($WebURL ,
   [11]http://server.example.com/;); Set ($WebDomain, 
  [12]server.example.com);
  
   Obviosly I changed my servername to [13]server.example.com all 
  FQDN

 -BEGIN PGP SIGNATURE-
 Version: 10.1.0 (Build 860)
 
 iQEVAwUBThNCMHUEnna91A87AQjh5wf/UDuwf+y+PcLFxlPrdOn9jYykKSzjfWKg
 qJZnBcc7DK+OM/XES0puVrfj5B6pKrOSc50kx22GQez0L8fyTbKxEHUcIzTpIrEK
 dq8sqgUDBPjSYXSGxDOBxkubvzelEKBdHhYsrVeYTpkNaha+UESd13cImn8ucnzS
 

Re: [rt-users] Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

2011-07-07 Thread Ruslan Zakirov
Hi,

Try the following SQL query that should help. I'm preparing a new
version of the extension to stop people from using it under RT4 and
help them upgrade. We'll try to automate process in 4.0.2.

UPDATE CustomFields SET Type = 'Select' AND RenderType = 'List'
WHERE Type = 'SelectCheckbox';


On Fri, Jul 8, 2011 at 12:38 AM, Kevin Falcone
falc...@bestpractical.com wrote:
 On Thu, Jul 07, 2011 at 01:01:27PM -0700, Direct Insure Online wrote:
 Hi Kevin,

 I deleted all *_Overlay.pm files when I upgraded and I have the following 
 setting in RT_SiteConfig.pm
 Set(@Plugins, qw(
  RT::Authen::ExternalAuth
  RT::Extension::CustomField::Checkbox
     ));

 Ah, there's the problem.

 RT-Extension-CustomField-Checkbox has been superseded by RT4 (and in
 fact is really incompatible with RT4).  Unfortunately, there isn't
 currently an upgrade script, although we'll make sure this gets into
 the bug tracker.

 You *should* be able to do something like this in your development
 environment.

 Find the entry in your CustomFields table with the Checkbox entry,
 update Type to Select and DisplayType to List.

 -kevin

 If I comment the above one I am getting the following error
 could not find component for path 'EditCustomFieldSelectCheckbox'

 If I enable the above in RT_SiteConfig.pm I am getting the following error
 Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 
 696.
 Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 
 620.

 With Regards
 Vinod.R


 From: Kevin Falcone falc...@bestpractical.com
 To: rt-users@lists.bestpractical.com
 Sent: Thursday, July 7, 2011 12:46 PM
 Subject: Re: [rt-users] Can't coerce array into hash at 
 /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

 On Thu, Jul 07, 2011 at 08:42:27AM -0700, Direct Insure Online wrote:
     We just upgraded our RT from 3.8.4 to 4.0.1
     We upgraded the database also.
 
     When we want to create a new custom field we are getting the following 
 errors
 
     Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
 line 696.
     Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm 
 line 620.
 
     What could be the problem.

 The most common failure for something like this is that you have a
 CustomField_Overlay.pm left over from 3.8 and didn't follow the
 directions.  Alternately, you might have a local customization or
 extension that affects Custom Fields.


 
 2011 Training: http://bestpractical.com/services/training.html




-- 
Best regards, Ruslan.


2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

2011-07-07 Thread Kevin Falcone
On Thu, Jul 07, 2011 at 02:25:54PM -0700, Direct Insure Online wrote:
Updated the database as you suggested.
Now on the form there are no radio button's

You don't say what *is* on the form.
I suspect you only updated part of the table.
Now that you've made RT not throw an error, you can fix it in the
Admin UI for that CF.

-kevin


pgpteAB6wtu3S.pgp
Description: PGP signature


2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

2011-07-07 Thread Ruslan Zakirov
Hi,

In RT4 it's slightly different. See screenshots.

On Fri, Jul 8, 2011 at 1:25 AM, Direct Insure Online
vinod.rap...@yahoo.com wrote:
 Hi Kevin,

 Updated the database as you suggested.
 Now on the form there are no radio button's

 With Regards
 Vinod.R
 From: Kevin Falcone falc...@bestpractical.com
 To: Direct Insure Online vinod.rap...@yahoo.com
 Sent: Thursday, July 7, 2011 4:31 PM
 Subject: Re: [rt-users] Can't coerce array into hash at
 /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

 On Thu, Jul 07, 2011 at 01:01:27PM -0700, Direct Insure Online wrote:
 Hi Kevin,

 I deleted all *_Overlay.pm files when I upgraded and I have the following
 setting in RT_SiteConfig.pm
 Set(@Plugins, qw(
  RT::Authen::ExternalAuth
  RT::Extension::CustomField::Checkbox
     ));

 Ah, there's the problem.

 RT-Extension-CustomField-Checkbox has been superseded by RT4 (and in
 fact is really incompatible with RT4).  Unfortunately, there isn't
 currently an upgrade script, although we'll make sure this gets into
 the bug tracker.

 You *should* be able to do something like this in your development
 environment.

 Find the entry in your CustomFields table with the Checkbox entry,
 update Type to Select and DisplayType to List.

 -kevin

 If I comment the above one I am getting the following error
 could not find component for path 'EditCustomFieldSelectCheckbox'

 If I enable the above in RT_SiteConfig.pm I am getting the following error
 Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm
 line 696.
 Can't coerce array into hash at /opt/rt3/sbin/../lib/RT/CustomField.pm
 line 620.

 With Regards
 Vinod.R


 From: Kevin Falcone falc...@bestpractical.com
 To: rt-users@lists.bestpractical.com
 Sent: Thursday, July 7, 2011 12:46 PM
 Subject: Re: [rt-users] Can't coerce array into hash at
 /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.

 On Thu, Jul 07, 2011 at 08:42:27AM -0700, Direct Insure Online wrote:
     We just upgraded our RT from 3.8.4 to 4.0.1
     We upgraded the database also.
 
     When we want to create a new custom field we are getting the
  following errors
 
     Can't coerce array into hash at
  /opt/rt3/sbin/../lib/RT/CustomField.pm line 696.
     Can't coerce array into hash at
  /opt/rt3/sbin/../lib/RT/CustomField.pm line 620.
 
     What could be the problem.

 The most common failure for something like this is that you have a
 CustomField_Overlay.pm left over from 3.8 and didn't follow the
 directions.  Alternately, you might have a local customization or
 extension that affects Custom Fields.




 
 2011 Training: http://bestpractical.com/services/training.html




-- 
Best regards, Ruslan.
attachment: Снимок экрана 2011-07-08 в 2.06.41.pngattachment: Снимок экрана 2011-07-08 в 2.06.58.png

2011 Training: http://bestpractical.com/services/training.html

Re: [rt-users] how to access content for an attachment in scrip?

2011-07-07 Thread John Alberts
Thanks for the tip.  It led me in the right direction and I ended up with
this, which finally works.

my $T_Obj = $self-TicketObj;
   my $a = RT::Attachments-new($self-TransactionObj-CurrentUser);
   my $b = RT::Attachments-new($self-TransactionObj-CurrentUser);
   my $AttachObj = $self-TransactionObj-Attachments;
   while ( $a = $AttachObj-Next ) {
  $b = $a;
  next unless $a-Filename eq env-vars.txt;
   }
   my $content = $b-Content;


I don't understand why I had to do this, but I had to assign $b = $a in
order to get access to the attachment content after I was outside of the
loop.  If I try $a-Content, I always get an error.  I assume it has to do
with the scope of $a, but my Perl skills are close to nil, and I couldn¹t
figure it out.

John





On 7/6/11 11:24 PM, Mauricio Tavares raubvo...@gmail.com wrote:

On 07/06/2011 08:52 PM, John Alberts wrote:
 I've found several unanswered questions in the mail list archives with
 similar questions about looping through attachments.
 I saw several times it suggested to loop through attachments using
 something like
 while ( my $AttachObj = $self-TransactionObj-Attachments-Next ) {
 # do something with $AttachObj
 }

 This code doesn't work because -Next doesn't exist for the Attachment
 object. Is there any other way to do this? Sorry if this is incredibly
 simple to do. I'm not familiar with Perl and try to poke around and see
 if I can figure it out.

   Take a look at the code I put in my question Faking
{$Transaction-Content()}. I still do not have an answer to my own
question but it might be useful to you: see what I've done to locate all
attachments. The multipart/mixed part AFAIK is just the list of all the
other attachments or something like that. In other words, ignore it.
About env-vars.txt, is it a plain text file or, say, a Windows one (with
CRLF)? If that is the case, you might be able to select it (see the if
statements I did for ideas) and print it out.



 --

 John Alberts

 Cloud Optimization Engineer

 Ex Libris (USA) Inc.
 1350 E. Touhy Ave. Suite 200 East
 Des Plaines, IL 60018
 Phone: 1-219-979-6560

 *Follow Ex Libris on Twitter: @exlibrisgroup
 http://twitter.com/ExLibrisGroup*


 From: John Alberts john.albe...@exlibrisgroup.com
 mailto:john.albe...@exlibrisgroup.com
 Date: Wed, 6 Jul 2011 22:01:47 +
 To: rt-users@lists.bestpractical.com
 mailto:rt-users@lists.bestpractical.com
 rt-users@lists.bestpractical.com
mailto:rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] how to access content for an attachment in
scrip?

 Using the rt console, I can see that there are actually 3 attachments,
 even though the I only sent one and the web ui only shows 1, so I'm sure
 the problem is that I'm selecting the wrong attachment.

 Here's what I see from the console.
 ./rt show 2075/attachments
 19671: (Unnamed) (multipart/mixed / 0b),
 19672: (Unnamed) (text/plain / 305b),
 19673: env-vars.txt (application/octet-stream / 16.8k)


 The attachment I would like will always be named env-vars.txt. How can I
 get the contents for the attachment name env-vars.txt?

 Thanks

 John


 From: John Alberts john.albe...@exlibrisgroup.com
 mailto:john.albe...@exlibrisgroup.com
 Date: Wed, 6 Jul 2011 20:06:34 +
 To: rt-users@lists.bestpractical.com
 mailto:rt-users@lists.bestpractical.com
 rt-users@lists.bestpractical.com
mailto:rt-users@lists.bestpractical.com
 Subject: [rt-users] how to access content for an attachment in scrip?

 Hi. I'm trying to customize the scrip shown at the bottom of this wiki
 page: 
http://requesttracker.wikia.com/wiki/AutoCloseOnNagiosRecoveryMessages

 I know there is an extension that does merging, but I want to do some
 other things with the Nagios variables I have attached as a plain text
 file to the ticket that Nagios creates in RT.
 The first few lines in the scrip attempt to get the content of an
 attachment and put it in a variable named $content. I suspected that
 this was not working, so I added a debug line to dump the contents of
 $contents and it is empty.

 Here is the scrip code.
 my $T_Obj = $self-TicketObj;
 my $AttachObj = $self-TransactionObj-Attachments-First;
 my $content = $AttachObj-Content;
 $RT::Logger-debug(Contents:  . $content);


 The log output shows:
 [Wed Jul 6 19:47:49 2011] [debug]: Contents: ((eval 3934):4)


 The attachment is attached to the ticket. I can see it in the web ui and
 can open and read it with no problems. Any idea what I'm doing wrong
here?


 Thanks


 John


  2011 Training: http://bestpractical.com/services/training.html
  2011 Training: http://bestpractical.com/services/training.html




 
 2011 Training: http://bestpractical.com/services/training.html



2011 Training: http://bestpractical.com/services/training.html



2011 Training: http://bestpractical.com/services/training.html


Re: [rt-users] how to access content for an attachment in scrip?

2011-07-07 Thread Thomas Sibley
On 07/07/2011 07:21 PM, John Alberts wrote:
 Thanks for the tip.  It led me in the right direction and I ended up with
 this, which finally works.
 
 my $T_Obj = $self-TicketObj;
my $a = RT::Attachments-new($self-TransactionObj-CurrentUser);
my $b = RT::Attachments-new($self-TransactionObj-CurrentUser);
my $AttachObj = $self-TransactionObj-Attachments;
while ( $a = $AttachObj-Next ) {
   $b = $a;
   next unless $a-Filename eq env-vars.txt;
}
my $content = $b-Content;

The above will fail when env-vars.txt isn't the last attachment RT
parsed.  Try this (untested) much simpler version:

my $attachments = $self-TransactionObj-Attachments;
my $content;
while (my $attach = $attachments-Next) {
if ($attach-Filename eq env-vars.txt) {
$content = $attach-Content;
last; # we found it, no need to keep looking
}
}
# use $content for whatever you'd like here

There are better, faster ways to do this than looping over the
attachments, but looping is the easiest to understand.

Thomas


2011 Training: http://bestpractical.com/services/training.html