[rt-users] New ticket in Dropdown size

2009-06-22 Thread Flynn, Timothy J
Simple question here.  Where do I change the width for the New ticket
in dropdown queue list box?  The standard width truncates the names of
our queues.  RT 3.8.4

Thanks!
-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Size limit in RT 3.8.2 rich text editor?

2009-06-11 Thread Flynn, Timothy J
I have users that type large messages and/or paste text into the RT
editor that say it is getting truncated.  Is there a size limit to the
amount of text that the rich text box can handle, or another reason why
it would truncate?  Would this pertain to some of the IE bugs that were
fixed in RT 3.8.3?

Thanks,
-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Possible bug in ExtractCustomFieldValues 2.99_01

2009-05-28 Thread Flynn, Timothy J
Thanks Kevin I think that did the trick.  I looked at the CPAN page for
this module and it referred to sa...@bestpractical.com of all places.
I've never figured out that code checkout so far so I appreciate your
help.

-Tim
   

-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin
Falcone
Sent: Wednesday, May 27, 2009 4:08 PM
To: RT Users
Subject: Re: [rt-users] Possible bug in ExtractCustomFieldValues 2.99_01


On May 27, 2009, at 4:47 PM, Flynn, Timothy J wrote:

 I have been using ExtractCustomFieldValues 2.99_01 for a few months 
 now with RT 3.8.2 and it seemed to work well.  Recently I added some 
 new global custom fields and then applied them to a new queue and I've

 been getting errors unless I remove the new custom fields from the 
 template when emails are parsed.

I think you want:
http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision/?rev=19391

2.99_01 is a developer release, sounds like there needs to be a 2.99_02

-kevin



 [Wed May 27 19:26:51 2009] [debug]: Looking for CF Job Name 
 (/usr/local/rt3/local/plugins/RT-Extension-ExtractCustomFieldValues/
 lib/
 RT/Action/ExtractCustomFieldValues.pm:105)
 [Wed May 27 19:26:51 2009] [error]: Scrip Commit 15 died. - Can't call

 method id on an undefined value at 
 /usr/local/rt3/local/plugins/RT-Extension-ExtractCustomFieldValues/
 lib/R
 T/Action/ExtractCustomFieldValues.pm line 119.

 Stack:

 [/usr/local/rt3/local/plugins/RT-Extension-ExtractCustomFieldValues/
 lib/
 RT/Action/ExtractCustomFieldValues.pm:119]

 [/usr/local/rt3/local/plugins/RT-Extension-ExtractCustomFieldValues/
 lib/
 RT/Action/ExtractCustomFieldValues.pm:81]
  [/usr/local/rt3/bin/../lib/RT/ScripAction_Overlay.pm:238]
  [/usr/local/rt3/bin/../lib/RT/Scrip_Overlay.pm:464]
  [/usr/local/rt3/bin/../lib/RT/Scrips_Overlay.pm:196]
  [/usr/local/rt3/bin/../lib/RT/Transaction_Overlay.pm:188]
  [/usr/local/rt3/bin/../lib/RT/Record.pm:1456]
  [/usr/local/rt3/bin/../lib/RT/Ticket_Overlay.pm:648]
  [/usr/local/rt3/bin/../lib/RT/Interface/Email.pm:1357]
  [/usr/local/rt3/share/html/REST/1.0/NoAuth/mail-gateway:61]
 (/usr/local/rt3/bin/../lib/RT/Scrip_Overlay.pm:472)



 I believe it is because in this area of code it tries to see if a 
 field pertains to a queue or not and makes the assumtion that if it is

 global it is in all queues or if it isn't global it is there.  We have

 global custom fields that don't apply to all queues.

 101 sub LoadCF {
 102 my $self = shift;
 103 my %args= @_;
 104 my $CustomFieldName = $args{Name};
 105 $RT::Logger-debug( Looking for CF $CustomFieldName);
 106
 107 # We do this by hand instead of using LoadByNameAndQueue  
 because
 108 # that can find disabled queues
 109 my $cfs = RT::CustomFields-new($RT::SystemUser);
 110 $cfs-LimitToGlobalOrQueue($self-Queue);
 111 $cfs-Limit(
 112 FIELD = 'Name',
 113 VALUE = $CustomFieldName,
 114 CASESENSITIVE = 0
 115 );
 116 $cfs-RowsPerPage(1);
 117
 118 my $cf = $cfs-First;
 119 if ( $cf-id ) {
 120 $RT::Logger-debug( Found CF id  . $cf-id );
 121 } elsif ( not $args{Quiet} ) {
 122 $RT::Logger-error( Couldn't load CF $CustomFieldName!);
 123 }
 124
 125 return $cf;



 It would seem to me that the limit method isn't limiting enough?
 Meaning that it just checks if a custom field is global or not but 
 doesn't seem to check if it is applied or not??  This is my first 
 guess.
 Any ideas on a resolution?


 Thanks,
 -Tim
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com Commercial support: 
 sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Possible bug in ExtractCustomFieldValues 2.99_01

2009-05-27 Thread Flynn, Timothy J
I have been using ExtractCustomFieldValues 2.99_01 for a few months now
with RT 3.8.2 and it seemed to work well.  Recently I added some new
global custom fields and then applied them to a new queue and I've been
getting errors unless I remove the new custom fields from the template
when emails are parsed.

[Wed May 27 19:26:51 2009] [debug]: Looking for CF Job Name
(/usr/local/rt3/local/plugins/RT-Extension-ExtractCustomFieldValues/lib/
RT/Action/ExtractCustomFieldValues.pm:105)
[Wed May 27 19:26:51 2009] [error]: Scrip Commit 15 died. - Can't call
method id on an undefined value at
/usr/local/rt3/local/plugins/RT-Extension-ExtractCustomFieldValues/lib/R
T/Action/ExtractCustomFieldValues.pm line 119.

Stack:
 
[/usr/local/rt3/local/plugins/RT-Extension-ExtractCustomFieldValues/lib/
RT/Action/ExtractCustomFieldValues.pm:119]
 
[/usr/local/rt3/local/plugins/RT-Extension-ExtractCustomFieldValues/lib/
RT/Action/ExtractCustomFieldValues.pm:81]
  [/usr/local/rt3/bin/../lib/RT/ScripAction_Overlay.pm:238]
  [/usr/local/rt3/bin/../lib/RT/Scrip_Overlay.pm:464]
  [/usr/local/rt3/bin/../lib/RT/Scrips_Overlay.pm:196]
  [/usr/local/rt3/bin/../lib/RT/Transaction_Overlay.pm:188]
  [/usr/local/rt3/bin/../lib/RT/Record.pm:1456]
  [/usr/local/rt3/bin/../lib/RT/Ticket_Overlay.pm:648]
  [/usr/local/rt3/bin/../lib/RT/Interface/Email.pm:1357]
  [/usr/local/rt3/share/html/REST/1.0/NoAuth/mail-gateway:61]
(/usr/local/rt3/bin/../lib/RT/Scrip_Overlay.pm:472)



I believe it is because in this area of code it tries to see if a field
pertains to a queue or not and makes the assumtion that if it is global
it is in all queues or if it isn't global it is there.  We have global
custom fields that don't apply to all queues.

101 sub LoadCF {
102 my $self = shift;
103 my %args= @_;
104 my $CustomFieldName = $args{Name};
105 $RT::Logger-debug( Looking for CF $CustomFieldName);
106 
107 # We do this by hand instead of using LoadByNameAndQueue because
108 # that can find disabled queues
109 my $cfs = RT::CustomFields-new($RT::SystemUser);
110 $cfs-LimitToGlobalOrQueue($self-Queue);
111 $cfs-Limit(
112 FIELD = 'Name',
113 VALUE = $CustomFieldName,
114 CASESENSITIVE = 0
115 );
116 $cfs-RowsPerPage(1);
117 
118 my $cf = $cfs-First;
119 if ( $cf-id ) {
120 $RT::Logger-debug( Found CF id  . $cf-id );
121 } elsif ( not $args{Quiet} ) {
122 $RT::Logger-error( Couldn't load CF $CustomFieldName!);
123 }
124 
125 return $cf;



It would seem to me that the limit method isn't limiting enough?
Meaning that it just checks if a custom field is global or not but
doesn't seem to check if it is applied or not??  This is my first guess.
Any ideas on a resolution?


Thanks,
-Tim 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Max # displayed queues for quick search?

2009-04-29 Thread Flynn, Timothy J
Is there a maximum number of displayed queues in the quick search for RT
3.8.2?  I just added another queue that is both enabled and set to be
seen and also I am a super user so I should see it anyway.  It doesn't
appear in the list.  I am probably close to or over 100 enabled queues
at this point.

-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Max # displayed queues for quick search?

2009-04-29 Thread Flynn, Timothy J
That was it.  Thank you!
-Tim
 

-Original Message-
From: Raed El-Hames [mailto:r...@vialtus.com] 
Sent: Wednesday, April 29, 2009 10:56 AM
To: Flynn, Timothy J
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Max # displayed queues for quick search?

Tim;

You need to logout then back in, the queue list is cached to speed
things up a bit

Roy

This email is subject to:

http://www.vialtus.com/disclaimer.html

 

 



Flynn, Timothy J wrote:
 Is there a maximum number of displayed queues in the quick search for 
 RT 3.8.2?  I just added another queue that is both enabled and set to 
 be seen and also I am a super user so I should see it anyway.  It 
 doesn't appear in the list.  I am probably close to or over 100 
 enabled queues at this point.

 -Tim
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com Commercial support: 
 sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
   
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Auditing ticket accesses

2009-04-27 Thread Flynn, Timothy J
Jesse I think they just want to see for a particular ticket who accessed
it and when.  It would be nice if it was searchable and reportable so
another table does make sense.  But I am not sure how another table
would be accessed from RT.  I also liked the idea of a mutivalue custom
field.  For each user that accessed a ticket it could have 1 entry.

-Tim 



Notice: This UI Health Care e-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and 
may be legally privileged.  If you are not the intended recipient, you are 
hereby notified that any retention, dissemination, distribution, or copying of 
this communication is strictly prohibited.  Please reply to the sender that you 
have received the message in error, then delete it.  Thank you.
-Original Message-
From: Jesse Vincent [mailto:je...@bestpractical.com] 
Sent: Friday, April 24, 2009 7:18 PM
To: Flynn, Timothy J
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Auditing ticket accesses




On Fri 24.Apr'09 at 12:25:35 -0500, Flynn, Timothy J wrote:
 I am looking for a way to record when someone views a ticket and log 
 it somehow.  I know the url accesses are in apache logs.  I am looking

 for something long term that people could easily see when a ticket was

 accessed, by who, and when.  I was thinking about a scrip to do this 
 to record instances to a ticket itself.  Also the RT logfile came to 
 mind but it is full of other messages and errors.  Has anyone done 
 something similar?

I think an on-display callback that wrote to a custom table or custom
logfile would be your best bet. Do you care about accesses to subpages,
ticket search results, CLI usage, or API usage?

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Auditing ticket accesses

2009-04-24 Thread Flynn, Timothy J
I am looking for a way to record when someone views a ticket and log it
somehow.  I know the url accesses are in apache logs.  I am looking for
something long term that people could easily see when a ticket was
accessed, by who, and when.  I was thinking about a scrip to do this to
record instances to a ticket itself.  Also the RT logfile came to mind
but it is full of other messages and errors.  Has anyone done something
similar?

RT 3.8.2

Thanks!
-Tim


Notice: This UI Health Care e-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and 
may be legally privileged.  If you are not the intended recipient, you are 
hereby notified that any retention, dissemination, distribution, or copying of 
this communication is strictly prohibited.  Please reply to the sender that you 
have received the message in error, then delete it.  Thank you.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] First Method and others

2009-04-15 Thread Flynn, Timothy J
I have had an issue with extract custom fields which I tracked down to
it hardcoding the first attachment as the text attachment.  I need to
change it so it will review all the attachments to find which one is the
text one.  I can't find the First method that is used anywhere.  I'm not
used to the SUPER:: class.  Can someone point me to the file(s) where I
can review the other methods available to Attachments so I can fix
Extract Custom Fields so it finds the email body attachment?

-Tim


Notice: This UI Health Care e-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and 
may be legally privileged.  If you are not the intended recipient, you are 
hereby notified that any retention, dissemination, distribution, or copying of 
this communication is strictly prohibited.  Please reply to the sender that you 
have received the message in error, then delete it.  Thank you.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Custom Fields Periodically not working

2009-04-14 Thread Flynn, Timothy J
For these tickets I see that the scrips aren't even firing.  I have
other scrips with the same conditions that are firing.

The condition is On Create and the stage is Transaction Create.  Should
the Stage be Transaction Batch instead?

-Tim


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Flynn,
Timothy J
Sent: Monday, April 13, 2009 3:44 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Custom Fields Periodically not working

Hi we recently upgraded from 3.4.5 to 3.8.2.  At the same time I updated
to Extract Custom Fields 2.0.  We use a webform which validates an email
generation to a queue.  The form has not changed.  

In some tickets we will not have any custom fields loaded.  The emails
that create them visually look the same.  Here is an example record from
the Custom Field template:


Description|body|Description:\s*(.+)\s*|

I see that there are 2 options that are omitted, the parsing command and
the final q or * option.  Is there some reason that we could visually
see the fields but they do not apply on seemingly random tickets?  Does
this have anything to do with MIME attachments?

Any help greatly appreciated!

-Tim


Notice: This UI Health Care e-mail (including attachments) is covered by
the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is
confidential and may be legally privileged.  If you are not the intended
recipient, you are hereby notified that any retention, dissemination,
distribution, or copying of this communication is strictly prohibited.
Please reply to the sender that you have received the message in error,
then delete it.  Thank you.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Custom Fields Periodically not working

2009-04-14 Thread Flynn, Timothy J
It appears that tickets that are created from incoming emails with
attachments are the tickets that the custom fields are not working on.
I see a note in the modules history that attachments were broken and
fixed in a very early version.  Any help appreciated at this point.

Thanks,
-Tim


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Flynn,
Timothy J
Sent: Tuesday, April 14, 2009 11:04 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Custom Fields Periodically not working

For these tickets I see that the scrips aren't even firing.  I have
other scrips with the same conditions that are firing.

The condition is On Create and the stage is Transaction Create.  Should
the Stage be Transaction Batch instead?

-Tim


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Flynn,
Timothy J
Sent: Monday, April 13, 2009 3:44 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Custom Fields Periodically not working

Hi we recently upgraded from 3.4.5 to 3.8.2.  At the same time I updated
to Extract Custom Fields 2.0.  We use a webform which validates an email
generation to a queue.  The form has not changed.  

In some tickets we will not have any custom fields loaded.  The emails
that create them visually look the same.  Here is an example record from
the Custom Field template:


Description|body|Description:\s*(.+)\s*|

I see that there are 2 options that are omitted, the parsing command and
the final q or * option.  Is there some reason that we could visually
see the fields but they do not apply on seemingly random tickets?  Does
this have anything to do with MIME attachments?

Any help greatly appreciated!

-Tim


Notice: This UI Health Care e-mail (including attachments) is covered by
the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is
confidential and may be legally privileged.  If you are not the intended
recipient, you are hereby notified that any retention, dissemination,
distribution, or copying of this communication is strictly prohibited.
Please reply to the sender that you have received the message in error,
then delete it.  Thank you.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Custom Fields Periodically not working

2009-04-13 Thread Flynn, Timothy J
Hi we recently upgraded from 3.4.5 to 3.8.2.  At the same time I updated
to Extract Custom Fields 2.0.  We use a webform which validates an email
generation to a queue.  The form has not changed.  

In some tickets we will not have any custom fields loaded.  The emails
that create them visually look the same.  Here is an example record from
the Custom Field template:


Description|body|Description:\s*(.+)\s*|

I see that there are 2 options that are omitted, the parsing command and
the final q or * option.  Is there some reason that we could visually
see the fields but they do not apply on seemingly random tickets?  Does
this have anything to do with MIME attachments?

Any help greatly appreciated!

-Tim


Notice: This UI Health Care e-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and 
may be legally privileged.  If you are not the intended recipient, you are 
hereby notified that any retention, dissemination, distribution, or copying of 
this communication is strictly prohibited.  Please reply to the sender that you 
have received the message in error, then delete it.  Thank you.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Help with SVN site

2009-03-02 Thread Flynn, Timothy J
Hi I am trying to download RT-View-ConciseSpreadsheet.  I haven't used
SVN before so this is becoming a trick.  Can someone shed some light on
what I am doing wrong?  I just want a local copy so I can install it.  


svn checkout
http://svn.bestpractical.com/cgi-bin/index.cgi/bps/browse/RT-View-Concis
eSpreadsheet temp
svn: PROPFIND request failed on
'/cgi-bin/index.cgi/bps/browse/RT-View-ConciseSpreadsheet'
svn: PROPFIND of
'/cgi-bin/index.cgi/bps/browse/RT-View-ConciseSpreadsheet': 200 OK
(http://svn.bestpractical.com)


Thanks,
-Tim


Notice: This UI Health Care e-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and 
may be legally privileged.  If you are not the intended recipient, you are 
hereby notified that any retention, dissemination, distribution, or copying of 
this communication is strictly prohibited.  Please reply to the sender that you 
have received the message in error, then delete it.  Thank you.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] RT 3.8.2 SpreadsheetDisplayedFields

2009-01-28 Thread Flynn, Timothy J


Hi we used SpreadsheetDisplayedFields in RT 3.4.5.  Has anyone been
using this in 3.8.2?  There were some obvious changes in files that
needed to be edited.  For some reason I am missing the id column and I
believe some others and the columns that are there are shifted to the
right 4 columns.  I am working on it now but I just wanted to make sure
I wasn't reinventing the wheel here.

Thanks,
-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Can't call method Content on an undefined value at/usr/local/rt3/share/html/Admin/Global/MyRT.html line 97, line 225

2009-01-20 Thread Flynn, Timothy J


When I look at the piece of code in question it mentions a default
portlet.  Is this saying that I don't have a default portlet and if so
how do I create one?


 86 my @panes = $m-comp(
 87 '/Admin/Elements/ConfigureMyRT',
 88 panes  = ['body', 'summary'],
 89 Action = 'MyRT.html',
 90 items = \...@items,
 91 current_portlets = $default_portlets-Content,
 92 OnSave = sub {
 93 my ( $conf, $pane ) = @_;
 94 $default_portlets-SetContent( $conf );
 95 push @actions, loc( 'Global portlet [_1] saved.', $pane );
 96 }
 97 );


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, January 14, 2009 4:29 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Can't call method Content on an undefined value
at/usr/local/rt3/share/html/Admin/Global/MyRT.html line 97, line 225

Hi I am upgrading to RT 3.8.2 on a Red Hat 5 Enterprise system.  I am
also getting the error message


Can't call method Content on an undefined value at
/usr/local/rt3/share/html/Admin/Global/MyRT.html line 97,  line 225


I have Postgres so the MySQL recommendations I have read about don't
apply.

I am at the following versions:

DBD::Pg v2.11.6;
DBI v1.607;
DBIx::SearchBuilder v1.54;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;

I was upgrading from RT 3.4.5.  I did a clean install as recommended but
I didn't see any sql scripts to run for the 3.4.5 = 3.8.2 update.

What other things can I check?  I have turned on debugging and fixed the
error messages for GraphViz. 


Thanks!
-Tim



Notice: This UI Health Care e-mail (including attachments) is covered by
the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is
confidential and may be legally privileged.  If you are not the intended
recipient, you are hereby notified that any retention, dissemination,
distribution, or copying of this communication is strictly prohibited.
Please reply to the sender that you have received the message in error,
then delete it.  Thank you.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Can't call method Content on an undefined valueat/usr/local/rt3/share/html/Admin/Global/MyRT.html line 97, line 225

2009-01-20 Thread Flynn, Timothy J
Sorry I have fixed my issue.  If I would have read the whole README file
I would have seen the upgrade db command.

-Tim


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Flynn,
Timothy J
Sent: Tuesday, January 20, 2009 10:24 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Can't call method Content on an undefined
valueat/usr/local/rt3/share/html/Admin/Global/MyRT.html line 97, line
225



When I look at the piece of code in question it mentions a default
portlet.  Is this saying that I don't have a default portlet and if so
how do I create one?


 86 my @panes = $m-comp(
 87 '/Admin/Elements/ConfigureMyRT',
 88 panes  = ['body', 'summary'],
 89 Action = 'MyRT.html',
 90 items = \...@items,
 91 current_portlets = $default_portlets-Content,
 92 OnSave = sub {
 93 my ( $conf, $pane ) = @_;
 94 $default_portlets-SetContent( $conf );
 95 push @actions, loc( 'Global portlet [_1] saved.', $pane );
 96 }
 97 );


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, January 14, 2009 4:29 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Can't call method Content on an undefined value
at/usr/local/rt3/share/html/Admin/Global/MyRT.html line 97, line 225

Hi I am upgrading to RT 3.8.2 on a Red Hat 5 Enterprise system.  I am
also getting the error message


Can't call method Content on an undefined value at
/usr/local/rt3/share/html/Admin/Global/MyRT.html line 97,  line 225


I have Postgres so the MySQL recommendations I have read about don't
apply.

I am at the following versions:

DBD::Pg v2.11.6;
DBI v1.607;
DBIx::SearchBuilder v1.54;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;

I was upgrading from RT 3.4.5.  I did a clean install as recommended but
I didn't see any sql scripts to run for the 3.4.5 = 3.8.2 update.

What other things can I check?  I have turned on debugging and fixed the
error messages for GraphViz. 


Thanks!
-Tim



Notice: This UI Health Care e-mail (including attachments) is covered by
the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is
confidential and may be legally privileged.  If you are not the intended
recipient, you are hereby notified that any retention, dissemination,
distribution, or copying of this communication is strictly prohibited.
Please reply to the sender that you have received the message in error,
then delete it.  Thank you.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Can't call method Content on an undefined value at /usr/local/rt3/share/html/Admin/Global/MyRT.html line 97, line 225

2009-01-14 Thread Flynn, Timothy J
Hi I am upgrading to RT 3.8.2 on a Red Hat 5 Enterprise system.  I am
also getting the error message


Can't call method Content on an undefined value at
/usr/local/rt3/share/html/Admin/Global/MyRT.html line 97,  line 225


I have Postgres so the MySQL recommendations I have read about don't
apply.

I am at the following versions:

DBD::Pg v2.11.6;
DBI v1.607;
DBIx::SearchBuilder v1.54;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;

I was upgrading from RT 3.4.5.  I did a clean install as recommended but
I didn't see any sql scripts to run for the 3.4.5 = 3.8.2 update.

What other things can I check?  I have turned on debugging and fixed the
error messages for GraphViz. 


Thanks!
-Tim



Notice: This UI Health Care e-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and 
may be legally privileged.  If you are not the intended recipient, you are 
hereby notified that any retention, dissemination, distribution, or copying of 
this communication is strictly prohibited.  Please reply to the sender that you 
have received the message in error, then delete it.  Thank you.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Depended on by vs. Parent

2007-04-02 Thread Flynn, Timothy J

What is the difference between depended on by vs. parent?

Thanks,

-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Problems on production box with 'comp' parameter after patching

2006-09-13 Thread Flynn, Timothy J
Hi,

I am running Redhat and running up2date and I get the error:

[Wed Sep 13 13:45:46 2006] [crit]: The 'comp' parameter (undef) to
HTML::Mason::Request::CGI-new() was an 'undef', which is not one of the
allowed types: scalar object

Stack:
  [/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm:127]
  [/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/CGIHandler.pm:63]
  [/usr/local/rt3/bin/webmux.pl:123]
  [-e:0]
 (/usr/local/rt3/bin/webmux.pl:125)

After applying the patches and opening the website.  Looking at this
does anyone have any ideas what module is causing this and how to
correct?  We were able to rollback the changes when this first happened
but when we tried the patches again this time we are unable to rollback
the patches.  This is a critical error on our production system so any
immediate help is greatly appreciated.

-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Question about pulling custom fields from email and field types

2006-08-10 Thread Flynn, Timothy J
I am creating custom fields that are the select one value type in rt
3.4.5.  I am reading my tickets in from email and I'd like the email to
be able to populate the custom field.  My question is in the email do I
just use the name of the custom field value or do I need to use the sort
number in the list?

Thanks,
-Tim

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Problem with make fixdeps on redhat

2006-06-20 Thread Flynn, Timothy J
I was trying to test rt 3.6.0 and I kept getting CPAN errors with
dependencies.  I rolled back several VM Ware sessions just in case I had
messed something up recently with the same results.  I am on Redhat and
had the exact same issues and results as discussed by Jim Meyer in this
February posting:

http://lists.bestpractical.com/pipermail/rt-users/2006-February/037648.h
tml


I think there may be an issue with RedHat and the fixdeps process.  As
Jim reported I was able to manually install the modules from CPAN's
command interface but not through the fixdeps process.  I've spent 2
days on this but I was glad to find Jim's work so I had a fix.

Thanks,
-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] Merge User Function?

2006-06-06 Thread Flynn, Timothy J


RT 3.4.5

When a user is autocreated from an email and then later tries to login
through the web the email address cannot be added since it already
exists for a different user.  Is there a way to merge the two user
accounts to show that they are one in the same?  Since tickets may be
associated to the autocreated account I can't really just deactivate
that account and move it to the appropriate user.

Thanks,
-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Spreadsheet view displays more columns than in search

2006-05-25 Thread Flynn, Timothy J
Just an FYI, it was the double quote that was causing the issues with
Excel and rows not showing properly.  I am using Excel 2003.  I ended up
doing this:

$val =~ s/[^\032-\041\043-\176]/ /g;

-Tim


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 9:55 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

After reviewing my changes further I believe I came up with a better
solution for escaping tabs.

In the file rtroot/share/html/Search/Elements/Results.tsv 


Instead of the line:
$val =~ s/(\n|\r)//g;

And instead of the previous change I suggested:

$val =~ s/(\n|\r|\t)//g;

I am going to change it to this:

$val =~ s/\s/ /g;

My thinking is if the intent of a newline, tab, or other whitespace
character was to separate data, then a single space would be more
fitting than nothing at all.  Hope this helps someone else.  Also
wouldn't be a bad idea to add this fix to future versions even if it
doesn't match what I did above.  I would think having tabs escaped would
be required for a tab delimited file to work properly.

-Tim


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 9:16 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

 
Woops, just found this:

 $val =~ s/(\n|\r)//g;

Looks like I just need to change to:

$val =~ s/(\n|\r|\t)//g;


-Tim

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 9:15 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

I think I found the root of the problem.  It doesn't appear that tab
characters or newlines are being escaped from the result set.  This
would cause issues with the presentation in Excel.  I will add some
coding to do this to the rows after I apply the patch.  I am surprised
this never affected anyone before.

Thanks,
-Tim
 

-Original Message-
From: Stephen Turner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 24, 2006 9:04 AM
To: Flynn, Timothy J; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

At Tuesday 5/23/2006 04:50 PM, Flynn, Timothy J wrote:
Thanks Eric,  do you know why I'd be getting different results in
spreadsheet vs the web list?  On one report I am getting 14 tickets in
the web view and in the spreadsheet I am getting 11 and the data is
wrong..  FYI the web results are correct and the spreadsheet is not.
Is
something not being escaped that is affecting the query?

-Tim


The mechanism use in searching for the web view is different from 
that used in the full spreadsheet download.

That said, you should still see the same number of rows. When you get 
14 rows in the web view are you actually seeing 14 tickets in the 
list, or is that number from the 'Found 14 tickets' message? It's 
just possible that you only have permission to see 11 of the 14 rows
returned.

Steve 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Spreadsheet view displays more columns than in search

2006-05-24 Thread Flynn, Timothy J
Eric,

That's the weird part.  It is the same exact query.  They perform the
search and see the web results, then they click the spreadsheet link and
it comes up different than what is in the web results.  I haven't
applied the patch yet.  Will that fix it?

Thanks,
-Tim
 

-Original Message-
From: Schultz, Eric [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 23, 2006 3:57 PM
To: Flynn, Timothy J; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

Only thing I can think of is that you somehow modified the query before
doing one query vs. the other?  Maybe using the browser navigation vs.
the application navigation?  If the spreadsheet had more, I would say it
could be something with that query being less restrictive, but that's
not the case.

 Thanks Eric,  do you know why I'd be getting different results in
 spreadsheet vs the web list?  On one report I am getting 14 tickets in
 the web view and in the spreadsheet I am getting 11 and the data is
 wrong..  FYI the web results are correct and the spreadsheet 
 is not.  Is
 something not being escaped that is affecting the query?
 
 -Tim
  
 
 -Original Message-
 From: Schultz, Eric [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, May 23, 2006 3:32 PM
 To: Flynn, Timothy J; rt-users@lists.bestpractical.com
 Subject: RE: [rt-users] Spreadsheet view displays more columns than in
 search 
 
 
  When my users are searching for tickets, they select the 
 columns they
  want and then search.  A lot of them like the spreadsheet 
 view so they
  can make reports.  One problem is in the spreadsheet view 
 there are a
  lot of extra columns that they didn't add.  They appear to 
 be most of
  the default time fields in RT (IE, told date, due date, etc). 
   Is there
  a way to omit these?
  
  RT 3.4.5
 
 This is what you want:
 http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields
 It was vandalized, so I reverted to the previous saved version.
 
 Eric Schultz
 United Online
 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Spreadsheet view displays more columns than in search

2006-05-24 Thread Flynn, Timothy J
Eric,

I just dumped the TSV results to a txt file and opened with
ultraedit and the data is fine.  Excel is messing up the data somehow.
Doesn't appear to be an RT issue, but it might be an escaping issue due
to some of the content in the ticket.

Thanks for the link on the patch for the columns!

-Tim
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 8:05 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

Eric,

That's the weird part.  It is the same exact query.  They perform the
search and see the web results, then they click the spreadsheet link and
it comes up different than what is in the web results.  I haven't
applied the patch yet.  Will that fix it?

Thanks,
-Tim
 

-Original Message-
From: Schultz, Eric [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 23, 2006 3:57 PM
To: Flynn, Timothy J; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

Only thing I can think of is that you somehow modified the query before
doing one query vs. the other?  Maybe using the browser navigation vs.
the application navigation?  If the spreadsheet had more, I would say it
could be something with that query being less restrictive, but that's
not the case.

 Thanks Eric,  do you know why I'd be getting different results in
 spreadsheet vs the web list?  On one report I am getting 14 tickets in
 the web view and in the spreadsheet I am getting 11 and the data is
 wrong..  FYI the web results are correct and the spreadsheet 
 is not.  Is
 something not being escaped that is affecting the query?
 
 -Tim
  
 
 -Original Message-
 From: Schultz, Eric [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, May 23, 2006 3:32 PM
 To: Flynn, Timothy J; rt-users@lists.bestpractical.com
 Subject: RE: [rt-users] Spreadsheet view displays more columns than in
 search 
 
 
  When my users are searching for tickets, they select the 
 columns they
  want and then search.  A lot of them like the spreadsheet 
 view so they
  can make reports.  One problem is in the spreadsheet view 
 there are a
  lot of extra columns that they didn't add.  They appear to 
 be most of
  the default time fields in RT (IE, told date, due date, etc). 
   Is there
  a way to omit these?
  
  RT 3.4.5
 
 This is what you want:
 http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields
 It was vandalized, so I reverted to the previous saved version.
 
 Eric Schultz
 United Online
 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Spreadsheet view displays more columns than in search

2006-05-24 Thread Flynn, Timothy J
After reviewing my changes further I believe I came up with a better
solution for escaping tabs.

In the file rtroot/share/html/Search/Elements/Results.tsv 


Instead of the line:
$val =~ s/(\n|\r)//g;

And instead of the previous change I suggested:

$val =~ s/(\n|\r|\t)//g;

I am going to change it to this:

$val =~ s/\s/ /g;

My thinking is if the intent of a newline, tab, or other whitespace
character was to separate data, then a single space would be more
fitting than nothing at all.  Hope this helps someone else.  Also
wouldn't be a bad idea to add this fix to future versions even if it
doesn't match what I did above.  I would think having tabs escaped would
be required for a tab delimited file to work properly.

-Tim


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 9:16 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

 
Woops, just found this:

 $val =~ s/(\n|\r)//g;

Looks like I just need to change to:

$val =~ s/(\n|\r|\t)//g;


-Tim

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Flynn,
Timothy J
Sent: Wednesday, May 24, 2006 9:15 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

I think I found the root of the problem.  It doesn't appear that tab
characters or newlines are being escaped from the result set.  This
would cause issues with the presentation in Excel.  I will add some
coding to do this to the rows after I apply the patch.  I am surprised
this never affected anyone before.

Thanks,
-Tim
 

-Original Message-
From: Stephen Turner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 24, 2006 9:04 AM
To: Flynn, Timothy J; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

At Tuesday 5/23/2006 04:50 PM, Flynn, Timothy J wrote:
Thanks Eric,  do you know why I'd be getting different results in
spreadsheet vs the web list?  On one report I am getting 14 tickets in
the web view and in the spreadsheet I am getting 11 and the data is
wrong..  FYI the web results are correct and the spreadsheet is not.
Is
something not being escaped that is affecting the query?

-Tim


The mechanism use in searching for the web view is different from 
that used in the full spreadsheet download.

That said, you should still see the same number of rows. When you get 
14 rows in the web view are you actually seeing 14 tickets in the 
list, or is that number from the 'Found 14 tickets' message? It's 
just possible that you only have permission to see 11 of the 14 rows
returned.

Steve 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] Spreadsheet view displays more columns than in search

2006-05-23 Thread Flynn, Timothy J

When my users are searching for tickets, they select the columns they
want and then search.  A lot of them like the spreadsheet view so they
can make reports.  One problem is in the spreadsheet view there are a
lot of extra columns that they didn't add.  They appear to be most of
the default time fields in RT (IE, told date, due date, etc).  Is there
a way to omit these?

RT 3.4.5

Thanks!
-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Spreadsheet view displays more columns than in search

2006-05-23 Thread Flynn, Timothy J
Thanks Eric,  do you know why I'd be getting different results in
spreadsheet vs the web list?  On one report I am getting 14 tickets in
the web view and in the spreadsheet I am getting 11 and the data is
wrong..  FYI the web results are correct and the spreadsheet is not.  Is
something not being escaped that is affecting the query?

-Tim
 

-Original Message-
From: Schultz, Eric [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 23, 2006 3:32 PM
To: Flynn, Timothy J; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 


 When my users are searching for tickets, they select the columns they
 want and then search.  A lot of them like the spreadsheet view so they
 can make reports.  One problem is in the spreadsheet view there are a
 lot of extra columns that they didn't add.  They appear to be most of
 the default time fields in RT (IE, told date, due date, etc). 
  Is there
 a way to omit these?
 
 RT 3.4.5

This is what you want:
http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields
It was vandalized, so I reverted to the previous saved version.

Eric Schultz
United Online
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] Error with ticket search builder

2006-05-11 Thread Flynn, Timothy J
I am getting this error in the bottom right screen of search builder
periodically.  Any ideas?

System is RT 3.4.5 on Postgres 8.1



error:  RT::Attribute::Name Unimplemented in RT::Attributes.
(/usr/local/rt3/lib/RT/Attributes_Overlay.pm line 81)
context:
... 
492:else {
493:my ( $package, $filename, $line );
494:( $package, $filename, $line ) = caller;
495:
496:die $AUTOLOAD Unimplemented in $package. ($filename line $line)
\n;
497:}
498:
499:}
500:
... 
code stack:
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm:496
/usr/local/rt3/lib/RT/Attributes_Overlay.pm:81
/usr/local/rt3/lib/RT/Attributes_Overlay.pm:73
/usr/local/rt3/lib/RT/Attributes_Overlay.pm:88
/usr/local/rt3/lib/RT/Attributes_Overlay.pm:119
/usr/local/rt3/share/html/Search/Elements/SelectSearchesForObjects:58
/usr/local/rt3/share/html/Search/Elements/EditSearches:75
/usr/local/rt3/share/html/Search/Build.html:99
/usr/local/rt3/share/html/autohandler:215
raw error


Thanks,
-Tim
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html