[rt-users] Weekly tickets report by cron

2012-10-10 Thread Jack Zabolotnyi
Hi everyone. I'm looking for some way to create something like weekly digest for my clients, to send them every friday one email with all tickets that are waiting for their answer. I was looking at rt-crontool but it will require a lot of walkarounds to gather all tickets together. Maybe there i

Re: [rt-users] Large Attachments Table

2012-10-10 Thread shayne.al...@gmail.com
Dear Ken; I will like that branch... and hope it to an alive branch :-/ tnx Dear Maciek; :-) due the type if our attachments which are JPEG files, don't hope compression to help me more! but I serious to test it ASAP. it seems pretty to be able to compress Emails body on side DB engine. tnx On

Re: [rt-users] Large Attachments Table

2012-10-10 Thread shayne.al...@gmail.com
Dear Ke; due the type if our attachments which are JPEG files, don't hope compression to help me more! but I serious to test it ASAP. it seems pretty to be able to compress Emails body on side DB engine. :-) On Wed, Oct 10, 2012 at 10:54 PM, k...@rice.edu wrote: > On Wed, Oct 10, 2012 at 10:36:

Re: [rt-users] Add to all emails a link to the ticket.

2012-10-10 Thread Kenneth Crocker
Juanjillo, You can create or update a template to have the ticket link in it. Kenn On Sat, Oct 6, 2012 at 3:51 PM, Juanjo wrote: > Any help? > El 01/10/2012 17:02, "Juanjo" escribió: > > Hi to all. >> >> When we create or assign a ticket the email that the user receive have a >> link to the t

Re: [rt-users] Large Attachments Table

2012-10-10 Thread Maciej Dobrzanski
Ali, Other than modifying RT itself to store attachments outside of the main database, you could also try InnoDB compression first. It is available in all recent MySQL versions (5.1, 5.5, 5.6) and it is completely transparent to queries or applications. Even with some number of larger attachmen

Re: [rt-users] RT 4.0.X and LimeSurvey 2.X

2012-10-10 Thread Roedel, Mark
Haven't started working with LimeSurvey 2.x yet -- although it's on my radar -- but we do have our RT 4.0.7 working with Lime 1.9's remote control features to generate customer evaluation surveys on ticket resolution (using the steps outlined in the RT wiki). Looking through the Lime 2 release

Re: [rt-users] Large Attachments Table

2012-10-10 Thread k...@rice.edu
On Wed, Oct 10, 2012 at 10:36:22PM +0330, shayne.al...@gmail.com wrote: > Dears; > > I have been face with a problem... after 3 years, out attachments table has > been grown over 300GB in size and it's about 15 Million of records. > for performance tuning I Ihad changes it's Table Engine into Inno

[rt-users] Large Attachments Table

2012-10-10 Thread shayne.al...@gmail.com
Dears; I have been face with a problem... after 3 years, out attachments table has been grown over 300GB in size and it's about 15 Million of records. for performance tuning I Ihad changes it's Table Engine into InnoDB and configured MySQL as file_peer_table with Dynamic Row format to bring out th

[rt-users] RT 4.0.X and LimeSurvey 2.X

2012-10-10 Thread Thomas Misilo
Hi, I was wondering if anyone has gotten LimeSurvey and RT to work at generating surveys? I haven't tried yet, I am currently working at getting it up with 1.9. Thanks! Tom Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring!

Re: [rt-users] Lowercasing of message headers

2012-10-10 Thread Martin Drasar
On 9.10.2012 18:38, Thomas Sibley wrote: > It's possible, yes. I don't know where it may be happening in this > particular case, and it may not even be in RT. Mail headers, however, > are case insensitive, so any change in case shouldn't be affecting your > usage. (And if it is, that sounds like