Re: [rt-users] Due Date in Ticket Creation Page

2008-04-02 Thread Ruslan Zakirov 
It's already there. You just have to click show advanced there on
ticket create page.

On Thu, Apr 3, 2008 at 7:42 AM, Stephen Cochran
<[EMAIL PROTECTED]> wrote:
>
>  Has anyone hacked the Create ticket form to show the due date? Can
>  easily create a custom field that shows on the entry form, but seems
>  silly since the ticket object already has a due date.
>
>
>  In the archives I noticed a lot posts referencing using PHP etc as a
>  front end and just having the forms send mail to RT to be processed
>  in. Is that typical, ie what most people do to provide a more flexible
>  interface (ajax, etc)?
>
>  Thanks,
>  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
>



-- 
Best regards, Ruslan.
___
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] Due Date in Ticket Creation Page

2008-04-02 Thread Stephen Cochran 

Has anyone hacked the Create ticket form to show the due date? Can  
easily create a custom field that shows on the entry form, but seems  
silly since the ticket object already has a due date.


In the archives I noticed a lot posts referencing using PHP etc as a  
front end and just having the forms send mail to RT to be processed  
in. Is that typical, ie what most people do to provide a more flexible  
interface (ajax, etc)?

Thanks,
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

[rt-users] Self Service Permissions

2008-04-02 Thread Stephen Cochran 

Our unprivileged users can't see the queue names (we have multiple  
queues) in the Self Service interface, the field is just blank. What  
permission is needed to see that field? Currently set up with:

unprivileged:
CreateTicket
SeeQueue

requester:
ReplyToTicket
ShowTicket

Thanks,
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

Re: [rt-users] installing on RHEL4

2008-04-02 Thread Mike Peachey 
Nelson Pereira wrote:
> Is there an up to date install instruction apart from:
> 
> http://wiki.bestpractical.com/view/RHEL4InstallGuide
> 
> 
> I see a RPM rt-3.6.6-1.noarch.rpm but it’s missing a WACK load of 
> dependencies….
> 
> How do I install this RPM and satisfy all dependencies?

Personally I would recommend ditching the RPM and the RHEL-specific 
installation and doing a manual installation. There a number of reasons 
why this would be preferable, least of all that your RT directory 
structure will remain separate from the rest of your OS and make life 
that much more simple for you.

Aside from that, Red Hat packaged software is asking for trouble as they 
seem to like to change the defaults that developers have worked on 
carefully to whatever they think they should be.

It is for this reason, for example, that you should be careful if you 
upgrade your Perl installation via RPM because the Red Hat defaults 
cause RT to break in attempting to use Scalar::Util.
-- 
Kind Regards,

__

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com
__
___
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] installing on RHEL4

2008-04-02 Thread Nelson Pereira 
Is there an up to date install instruction apart from:

 

http://wiki.bestpractical.com/view/RHEL4InstallGuide

 

 

I see a RPM rt-3.6.6-1.noarch.rpm but it's missing a WACK load of
dependencies

 

How do I install this RPM and satisfy all dependencies?

 

 

Nelson Pereira 
Senior Network Administrator 

Protus IP Solutions Inc. 
[EMAIL PROTECTED] 
phone: 613.733. ext.528 
MyFax: 613.822.5083 
www.myfax.com 

Refer your friends and colleagues to MyFax! 
Click here for more information.
  

   

 

<>___
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

Re: [rt-users] RT Update and Bulk Update

2008-04-02 Thread Kenneth Crocker 
Hossein,


AAHH! Now I understand. I thought you were just talking about the way 
it updates. You want THAT without the automatic email when the ticket 
status is changed. HHHMM. I wonder if there is a way to identify when 
the transaction is coming from bulk update? Then you could use that in 
your scrips for resolve, etc. I'mnot sure how to do that. sorry.

Kenn
LBNL

On 4/2/2008 12:18 PM, Hossein Rafighi wrote:
> No. What I want is a way NOT to send email to "Admin Cc" or "Cc" people 
> when ticket(s) are resolved through Bulk Update. I tried "Remove Admin 
> Cc:" but to no avail. I can easily accomplish this when I am resolving 
> tickets individually by checking the boxes next to Admin Cc and Cc names 
> and then clicking on "Save changes" button, but the "Save changes" 
> button is not available in Bulk Update and I don't know how else to do a 
> bulk update  without sending email to Admin Cc and Cc people.
> 
> 
> Cheers,
> Hossein
> 
> 
> Kenneth Crocker wrote:
>> Hossein,
>>
>>
>> UH, actually, I thought that clicking the "Update" button for 
>> "Bulk Update" (after one has made the type of changes they want to 
>> happen to a bunch of tickets, un-checking any ticket that is NOT to be 
>> changed) WAS, in fact, a "Save Changes" button. It may not say it but 
>> IT certainly ACTS like it. Do you just want to change the Title on the 
>> button? The action/results are the same so I don't really understand 
>> the problem.
>>
>>
>> Kenn
>> LBNL
>>
>> On 4/2/2008 8:29 AM, Hossein Rafighi wrote:
>>> Hi all,
>>>
>>> I have a question regarding RT update verses Bulk Update. If we don’t 
>>> wish a message to be sent to a Cc or Bcc member of any given ticket 
>>> we have to check a box in front of their name(s) and then click on 
>>> “Save changes” button, then click on the “Update Ticket” to 
>>> accomplish this which is not a big deal, unless we went wrong during 
>>> the installation. However, the “Save changes” button is not available 
>>> in Bulk Update. Is this by design? If not, can it be added? Is there 
>>> any other way script or otherwise to achieve this? We are using RT 3.6.4
>>>
>>> Many thanks in advance for your replies,
>>> Hossein
>>>
>>
> 

___
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

Re: [rt-users] RT Update and Bulk Update

2008-04-02 Thread Hossein Rafighi 
No. What I want is a way NOT to send email to "Admin Cc" or "Cc" people 
when ticket(s) are resolved through Bulk Update. I tried "Remove Admin 
Cc:" but to no avail. I can easily accomplish this when I am resolving 
tickets individually by checking the boxes next to Admin Cc and Cc names 
and then clicking on "Save changes" button, but the "Save changes" 
button is not available in Bulk Update and I don't know how else to do a 
bulk update  without sending email to Admin Cc and Cc people.


Cheers,
Hossein
 

Kenneth Crocker wrote:
> Hossein,
>
>
> UH, actually, I thought that clicking the "Update" button for 
> "Bulk Update" (after one has made the type of changes they want to 
> happen to a bunch of tickets, un-checking any ticket that is NOT to be 
> changed) WAS, in fact, a "Save Changes" button. It may not say it but 
> IT certainly ACTS like it. Do you just want to change the Title on the 
> button? The action/results are the same so I don't really understand 
> the problem.
>
>
> Kenn
> LBNL
>
> On 4/2/2008 8:29 AM, Hossein Rafighi wrote:
>> Hi all,
>>
>> I have a question regarding RT update verses Bulk Update. If we don’t 
>> wish a message to be sent to a Cc or Bcc member of any given ticket 
>> we have to check a box in front of their name(s) and then click on 
>> “Save changes” button, then click on the “Update Ticket” to 
>> accomplish this which is not a big deal, unless we went wrong during 
>> the installation. However, the “Save changes” button is not available 
>> in Bulk Update. Is this by design? If not, can it be added? Is there 
>> any other way script or otherwise to achieve this? We are using RT 3.6.4
>>
>> Many thanks in advance for your replies,
>> Hossein
>>
>

-- 
  _  _   _  _   _  _   _   Hossein Rafighi
 |_   _||  _  \ |_   _|| | | || \_/ ||  __|TRIUMF, 4004 Wesbrook Mall
   | |  | |_|  )  | |  | | | || || |__ Vancouver BC, Canada, V6T 2A3
   | |  |  _  /   | |  | \_/ || \_/ ||  __|Voice: (604) 222-1047
   | |  | | \ \  _| |_ | || | | || |   Fax:   (604) 222-1074
   |_|  |_|  \_\|_| \___/ |_| |_||_|   Website: http://www.triumf.ca

___
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

Re: [rt-users] How to reset Preferences -> Search options?

2008-04-02 Thread Jean-Sebastien Morisset 
On Wed, Apr 02, 2008 at 06:35:35PM +, Jean-Sebastien Morisset wrote:
> On Wed, Apr 02, 2008 at 05:49:07PM +, Jean-Sebastien Morisset wrote:
>> Hi everyone,
>> 
>> Is there a way to reset the user's Preferences -> Search options to the
>> $DefaultSearchResultFormat? A "Defaults" button on the
>> SearchOptions.html page, for example, could be handy.
> 
> I've been able to add the button, but it screws up the display some:
> 
> # diff ./share/html/Prefs/SearchOptions.html
> ./local/html/Prefs/SearchOptions.html
> 67a68,75
>> 
>> > value="<%$RT::DefaultSearchResultFormat%>" />
>> > />
>> > />
>> > value="50" />
>> <& /Elements/Submit, Name => 'SavePreferences', Label =>
>> loc('Reset to Defaults') &>
>> 
>> 
> 
> Any idea how I can tuck the "Save Changes" and "Reset to Defaults"
> button together?

So this isn't pretty, but it works.

# diff ./share/html/Prefs/SearchOptions.html 
./local/html/Prefs/SearchOptions.html
65c65,68
< <& /Elements/Submit, Name => 'SavePreferences', Label => loc('Save
Changes') &>
---
> 
>   
>   
>   
66a70,78
> 
>   
>  value="<%$RT::DefaultSearchResultFormat%>" />
>  />
>  />
>  value="50" />
>   
>   
> 

js.
-- 
Jean-Sebastien Morisset, Sr. UNIX Administrator <[EMAIL PROTECTED]>
___
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

Re: [rt-users] How to reset Preferences -> Search options?

2008-04-02 Thread Jean-Sebastien Morisset 
On Wed, Apr 02, 2008 at 05:49:07PM +, Jean-Sebastien Morisset wrote:
> Hi everyone,
> 
> Is there a way to reset the user's Preferences -> Search options to the
> $DefaultSearchResultFormat? A "Defaults" button on the
> SearchOptions.html page, for example, could be handy.

I've been able to add the button, but it screws up the display some:

# diff ./share/html/Prefs/SearchOptions.html
./local/html/Prefs/SearchOptions.html
67a68,75
> 
>  value="<%$RT::DefaultSearchResultFormat%>" />
>  />
>  />
>  value="50" />
> <& /Elements/Submit, Name => 'SavePreferences', Label =>
> loc('Reset to Defaults') &>
> 
>

Any idea how I can tuck the "Save Changes" and "Reset to Defaults"
button together?

Thanks,
js.
-- 
Jean-Sebastien Morisset, Sr. UNIX Administrator <[EMAIL PROTECTED]>
___
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] autoreply template content

2008-04-02 Thread Gary & Gina Koteras 

Hello,
 
   It doesn't look like I have privs to the autoreply global template. Would 
anybody be able to email me the content of that template so I can see how it is 
setup?
 
thanks,
Gary
_
More immediate than e-mail? Get instant access with Windows Live Messenger.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008___
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] How to reset Preferences -> Search options?

2008-04-02 Thread Jean-Sebastien Morisset 
Hi everyone,

Is there a way to reset the user's Preferences -> Search options to the
$DefaultSearchResultFormat? A "Defaults" button on the
SearchOptions.html page, for example, could be handy.

Thansk,
js.
-- 
Jean-Sebastien Morisset, Sr. UNIX Administrator <[EMAIL PROTECTED]>
___
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

Re: [rt-users] RT Update and Bulk Update

2008-04-02 Thread Kenneth Crocker 
Hossein,


UH, actually, I thought that clicking the "Update" button for "Bulk 
Update" (after one has made the type of changes they want to happen to a 
bunch of tickets, un-checking any ticket that is NOT to be changed) WAS, 
in fact, a "Save Changes" button. It may not say it but IT certainly 
ACTS like it. Do you just want to change the Title on the button? The 
action/results are the same so I don't really understand the problem.


Kenn
LBNL

On 4/2/2008 8:29 AM, Hossein Rafighi wrote:
> Hi all,
> 
> I have a question regarding RT update verses Bulk Update. If we don’t 
> wish a message to be sent to a Cc or Bcc member of any given ticket we 
> have to check a box in front of their name(s) and then click on “Save 
> changes” button, then click on the “Update Ticket” to accomplish this 
> which is not a big deal, unless we went wrong during the installation. 
> However, the “Save changes” button is not available in Bulk Update. Is 
> this by design? If not, can it be added? Is there any other way script 
> or otherwise to achieve this? We are using RT 3.6.4
> 
> Many thanks in advance for your replies,
> Hossein
> 

___
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] RT Update and Bulk Update

2008-04-02 Thread Hossein Rafighi 
Hi all,

I have a question regarding RT update verses Bulk Update. If we don’t 
wish a message to be sent to a Cc or Bcc member of any given ticket we 
have to check a box in front of their name(s) and then click on “Save 
changes” button, then click on the “Update Ticket” to accomplish this 
which is not a big deal, unless we went wrong during the installation. 
However, the “Save changes” button is not available in Bulk Update. Is 
this by design? If not, can it be added? Is there any other way script 
or otherwise to achieve this? We are using RT 3.6.4

Many thanks in advance for your replies,
Hossein

-- 
  _  _   _  _   _  _   _   Hossein Rafighi
 |_   _||  _  \ |_   _|| | | || \_/ ||  __|TRIUMF, 4004 Wesbrook Mall
   | |  | |_|  )  | |  | | | || || |__ Vancouver BC, Canada, V6T 2A3
   | |  |  _  /   | |  | \_/ || \_/ ||  __|Voice: (604) 222-1047
   | |  | | \ \  _| |_ | || | | || |   Fax:   (604) 222-1074
   |_|  |_|  \_\|_| \___/ |_| |_||_|   Website: http://www.triumf.ca

___
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

Re: [rt-users] Enhancements and workflows that we have added

2008-04-02 Thread Kenneth Crocker 
Aaron,


Sure. Thanks for asking. The following is a copy of the code just above 
what your addition is to just below:

*** beginning copy **
my $EditComponent = "EditCustomField$Type";
$m->comp('/Elements/Callback', _CallbackName => 'EditComponentName', 
Name => \$
EditComponent, CustomField => $CustomField, Object => $Object );
$EditComponent = "EditCustomField$Type" unless 
$m->comp_exists($EditComponent);

# Custom Field formatting overlays===
If ($Type eq "Text") {
 $Rows = 6;
 $Columns = 20;
} elsif ($Type eq "Wikitext") {
 $Rows = 8;
 $Columns = 15;
} elsif ($Type eq "Select") {
 $Rows = 1;
 $Columns = 10;
}
# end of custom overlay code

return $m->comp(
 $EditComponent,
 %ARGS,
 Rows => $Rows,
 Cols => $Cols,
 Default => $Default,
 Object => $Object,
 Values => $Values,
 MaxValues => $MaxValues,
 Multiple => ($MaxValues != 1),
 NamePrefix => $NamePrefix,
 CustomField => $CustomField,
);


I included the befor and after code just in case I accidently erased or 
modified something I was supposed to. Thanks for your help.


Kenn
LBNL


On 4/1/2008 5:38 PM, Aaron Sallade wrote:
> Can you send me a copy of your EditCustomField file?
> 
> Aaron Sallade'
> Application Manager
> PTSO of Washington
> "Shared Technology for Community Health"
> (206) 613-8938 Desk
> (206) 521-8833 Main
> (206) 613-5078 Fax
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: Kenneth Crocker [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, April 01, 2008 4:46 PM
> To: Aaron Sallade
> Cc: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] Enhancements and workflows that we have added
> 
> Aaron,
> 
> 
>   I just put in those changes and I get a syntax error on $Type.
> The 
> error message says the folowing:
> 
> "Error during compilation of 
> /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField:
> syntax error at /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField 
> line 79, near ") {"
> Global symbol "$Columns" requires explicit package name at 
> /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField line 81,  
> line 361.
> syntax error at /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField 
> line 82, near "} elsif"
> Global symbol "$Type" requires explicit package name at 
> /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField line 82,  
> line 361.
> Global symbol "$Rows" requires explicit package name at 
> /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField line 83,  
> line 361.
> Global symbol "$Columns" requires explicit package name at 
> /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField line 84,  
> line 361.
> syntax error at /apps/rt/rt-3.6.4/local/html/Elements/EditCustomField 
> line 85, near ";
> }"
> 
>   I'm not sure why it doesn't like $Type. Any ideas? I'm not real 
> experienced at perl. Just learning. Thanks.
> 
> Kenn
> LBNL
> 
> On 4/1/2008 11:47 AM, Aaron Sallade wrote:
>> For the width of freetext boxes etc, as well as the height - 
>>
>> Copy your/share/html/elements/EditCustomField to
>> local/html/elements/EditCustomField and add the following changes.
>>
>> Put this after
>> $EditComponent = "EditCustomField$Type" unless
>> $m->comp_exists($EditComponent);
>>
>>
>> # My custom field formatting overlays===
>> If ($Type eq "Text") {
>>  $Rows = 6;
>>  $Columns = 20;
>> } elsif ($Type eq "Wikitext") {
>>  $Rows = 8;
>>  $Columns = 15;
>> } elsif ($Type eq "Select") {
>>  $Rows = 1;
>>  $Columns = 10;
>> }
>>
>> # CustomField id # 14 is the specific ID of a field that I want to
> have
>> unique display 
>> If (CustomField->Id == 14) {
>>  $Rows = 7;
>> }
>>
>> # End of my overlay=
>>
>>
>>
>>
>> Aaron Sallade'
>> Application Manager
>> PTSO of Washington
>> "Shared Technology for Community Health"
>> (206) 613-8938 Desk
>> (206) 521-8833 Main
>> (206) 613-5078 Fax
>> [EMAIL PROTECTED]
>>
>>
>> -Original Message-
>> From: Kenneth Crocker [mailto:[EMAIL PROTECTED] 
>> Sent: Tuesday, April 01, 2008 9:25 AM
>> To: Aaron Sallade
>> Cc: rt-users@lists.bestpractical.com
>> Subject: Re: [rt-users] Enhancements and workflows that we have added
>>
>> Aaron,
>>
>>
>>  We are VERY interested in what you have developed. Whether or
>> not you 
>> post to the list, please send us what you have. It will be extremely 
>> appreciated. Also, do you have anything that increases the box size of
> a
>> free-test CF?. Thanks in advance.
>>
>>
>> Kenn
>> LBNL
>>
>> On 3/31/2008 4:54 PM, Aaron Sallade wrote:
>>> Just in case these are of interest to anyone else-
>>>
>>> Added a scrip and template that adds a reply to a DependedOnBy Parent
>>> ticket when the child is resolved. Resolving a sub task (child) will
>> add
>>> a comment to the parent noting that the prerequisite is now complete,
>> it
>>> will also email the owner of the parent task.
>>>
>>> Set the Row count

Re: [rt-users] Archiving the Attachments Table

2008-04-02 Thread Justin Hayes 
Thanks I'll take a look at the Shredder - I was thinking about  
deleting rows using SQL but if there's an extension to do it I'll use  
that.

However am I easily going to be able to get files back from the backup  
if I need them?

The files are stored as data in a column of that table. If 3 months  
down the line I need a file from a Ticket, will I be able to find out  
which row I need in my backup if the Shredder has removed it from the  
live RT? Also will I be able to out the data back into a file?

Or are you suggesting setting up an archive install of RT and having  
that run off the backup. So I have a live streamlined install and a  
bloated backup install.

Cheers,

Justin
--
Justin Hayes
Support Manager
[EMAIL PROTECTED]



On 2 Apr 2008, at 14:18, Benjamin Weser wrote:

> Why don't you make a general backup of your mysql database (you can  
> also
> export this table only) and then use the Shredder to get rid of the
> attachments?
>
> Justin Hayes schrieb:
>> Hi,
>>
>> Our attachments table is currently taking up 2.3gb and is easily the
>> largest table in our RT 3.6.3 DB.
>>
>> I know that that table contains both the text of comments/replies as
>> well as the files that are attached to tickets.
>>
>> Has anyone looked at archiving this table? Ideally I'd like to keep
>> textual comment/replies but remove attached files. I'd also like to  
>> do
>> it in a way that would mean I could get them back later if needed.
>>
>> Any ideas?
>>
>> Justin
>>
>> --
>> Justin Hayes
>> Support Manager
>> [EMAIL PROTECTED]
>>
>>
>>
>> ___
>> 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
>>
>
> ___
> 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

___
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

Re: [rt-users] Archiving the Attachments Table

2008-04-02 Thread Benjamin Weser 
Why don't you make a general backup of your mysql database (you can also 
export this table only) and then use the Shredder to get rid of the 
attachments?

Justin Hayes schrieb:
> Hi,
>
> Our attachments table is currently taking up 2.3gb and is easily the  
> largest table in our RT 3.6.3 DB.
>
> I know that that table contains both the text of comments/replies as  
> well as the files that are attached to tickets.
>
> Has anyone looked at archiving this table? Ideally I'd like to keep  
> textual comment/replies but remove attached files. I'd also like to do  
> it in a way that would mean I could get them back later if needed.
>
> Any ideas?
>
> Justin
>
> --
> Justin Hayes
> Support Manager
> [EMAIL PROTECTED]
>
>
>
> ___
> 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
>   

___
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] Archiving the Attachments Table

2008-04-02 Thread Justin Hayes 
Hi,

Our attachments table is currently taking up 2.3gb and is easily the  
largest table in our RT 3.6.3 DB.

I know that that table contains both the text of comments/replies as  
well as the files that are attached to tickets.

Has anyone looked at archiving this table? Ideally I'd like to keep  
textual comment/replies but remove attached files. I'd also like to do  
it in a way that would mean I could get them back later if needed.

Any ideas?

Justin

--
Justin Hayes
Support Manager
[EMAIL PROTECTED]



___
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] RT-3.6.1-4 - DB connection problem

2008-04-02 Thread Albert Czarnecki 
Hi

I'm using debian etch and RT version 3.6.1-4 , now I have problem to 
connect DB, when I run from shell:
perl /usr/share/request-tracker3.6/libexec/mason_handler.fcgi
I get some error:
DBI connect('dbname=rt_test;host=192.168.1.11;port=3306','rt_test',...) 
failed: received invalid response to SSL negotiation: F
 at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 106
Connect Failed received invalid response to SSL negotiation: F

Someone know where is the problem? The databases have off ssl 
connection, Can I off ssl connection in RT config?

Regards,

Albert
___
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

Re: [rt-users] Welcome to the "RT-Users" mailing list (Digest mode)

2008-04-02 Thread andrew fay 

Hi,

I am running RT 3.6.4 on ubuntu, most of our end users use outlook 2000/2003 to 
email our support address which adds the tickets to request tracker.

The problem I am having is that if the user has an HTML signature which most of 
them do, at the bottom of the first response from RT it says


This transaction appears to have no content

and sometimes it mangles the signature of the person that sent the request at 
the bottom of request trackers response,

How would I go about sorting this? I am hoping other people use outlook to send 
to request tracker! ^_^

Cheers,

Andy

_
Welcome to the next generation of Windows Live
http://www.windowslive.co.uk/get-live___
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

Re: [rt-users] A hopefully quick question...

2008-04-02 Thread Hoogstraten, Ton 
 
Greg,

Try this:

My $queue = $Ticket->QueueObj->Name;

Cheers,

Ton

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg
Evans
Sent: Wednesday, April 02, 2008 2:03 AM
To: 'RT Users'
Subject: [rt-users] A hopefully quick question...

I implemented SHowStatusInCOlor from the wiki today
(http://wiki.bestpractical.com/view/ShowStatusInColor) and it is quite
handy for what we are doing here. Now I would also like to color the
queue names in a similar fashion. I used the first implementation shown
on the Wiki page (instead of the CSS version) and then thought, OK easy
enough I can just change this around a bit and do the same thing on the
"Queue" column.

As everyone is well aware I consider myself a newb, and definitey NOT a
perl hacker or even close to resembling one, though I do have a copy of
the Perl books from O'Reilly, so maybe someday :)

Anyway, after my success with the status coloring, I did this and it
doesn't work :/ Can anyone tell me what I did wrong :)  I have a sneaky
suspicion that it involves the whole $Ticket->Queue bit, and I was
admittedly just guessing that $Ticket->Queue would be proper. 

sub queueInColor {
   my $Ticket = shift;
   my $queue = $Ticket->Queue;
   my $qcolor = undef;

   if ($queue eq 'queue1') {
   $qcolor = "#660099";
   } elsif ($queue eq ' queue2') {
   $qcolor = "#90";
   } elsif ($queue eq ' queue3') {
   $qcolor = "#99";
   } elsif ($queue eq ' queue4') {
   $qcolor = "#FF6600";
   } elsif ($queue eq ' queue5') {
   $qcolor = "#009000";
   } elsif ($queue eq ' queue6') {
   $qcolor = "#90";
   } elsif ($queue eq ' queue7') {
   $qcolor = "#AA8000";
   } elsif ($queue eq ' queue8') {
   $qcolor = "#00";
   } elsif ($queue eq ' queue9') {
   $qcolor = "#996633";
   }

   $queue = loc($queue);

if ($qcolor) {
   $queue = "$queue"
   }

   return \"$queue";

}

Queue names have been changed to protect the innocent ;) As always, any
insight is appreciated.

Thanks in advance,

Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212 


___
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
___
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