Re: [rt-users] how to delete tickets in RT

2010-02-09 Thread Alberto Villanueva
Hello, You must use Shredder. When you execute a query in tickets, and you are administrator, it will appear a new option in the horizontal menu called Shredder. Also, you can delete tickets from command line. You have more information in next links: -

Re: [rt-users] how to delete tickets in RT

2010-02-09 Thread softouch
Thankz a lot dear, i have successfully deleted the test tickets. i also want to reset the ticket counter to 0. so that when i am going to operational launch of system, it should be a fresh one. Alberto Villanueva wrote: Hello, You must use Shredder. When you execute a query in

[rt-users] Source code display for html attachment

2010-02-09 Thread jet jet
Hello, We have got RT(3.8.1 and 3.8.2) on linux machine(centos). When we send a html attachement with a ticket, it is display as text (the source code) in it. To resolve that we have to record the html file with UTF-8 encodage selected. This is not always possible, and it makes longer the

[rt-users] Feature Request: shredder

2010-02-09 Thread Sven Sternberger
Hello! we are in the process of cleaning up the User table. We have a lot of autocreated user in there which we want to purge by a script we created. We want to utilize the shredder cli to purge them. But in the commandline shredder I could only identify the user by email address. This fails

[rt-users] Exchange From: and To:

2010-02-09 Thread Peter Wieland
I send emails from a system I use to customers with a BCC to rt. After arriving, the ticket has: From: my_email_address To: customer_email_address Fine, but now I want to exchange these values into: From: customer_email_address To: my_email_address Spent a couple of hours in the mailing list

[rt-users] Re : Source code display for html attachment

2010-02-09 Thread jet jet
in order to solve the PB i did theses changes in vain: -- update EmailInputEncodings utf-8, iso-8859-1, us-ascii to EmailInputEncodings iso-8859-1, utf-8, us-ascii -- SET TrustHTMLAttachments to true -- comment adddefaultcharset UTF-8 on httpd.conf Thank you; William --- En date de : Mar

[rt-users] sql generated by search Search - My Tickets

2010-02-09 Thread Raed El-Hames
Hi ; 3.8.7 with Set($UseSQLForACLChecks,'1'); When debugging what sql is generated by what I noticed the system saved search Search - My Tickets is generating the following sql: SELECT DISTINCT main.* FROM Tickets main JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND (

[rt-users] viewing RTFM articles without logging in

2010-02-09 Thread David Griffith
I'm trying to figure out how to create an anonymous user who is allowed to browse RTFM articles without actually being logged in. Has anyone else here felt this need? Can someone give me some pointers on where to start hacking the code to implement this? -- David Griffith

[rt-users] Problems with Concise Spreadsheet

2010-02-09 Thread Ken Crocker
To list, Is anyone out there using the Concise Spreadsheet extension? I've go tit installed, but the linked display shows up at the bottom of the page instead of replacing the Spreadsheet link display. Also, I'm not getting the titles for anything after my second column (Subject), which

[rt-users] How to reset ticket # counter

2010-02-09 Thread softouch
Is there any one who can help me to reset the ticket counter to 0. as i have deleted all test mails from dB so i also want to reset the thicket counter. which table contains information about ticket counter? -- View this message in context:

[rt-users] Expand Toolbar stopped working

2010-02-09 Thread Michael Neuschafer
Hey, I have a user here that is trying to add a comment into a message in a ticket and the Expanded Toolbar in the message box has disappeared. Has anybody experience this in IE 8? It works in firefox but its stopped wowkring in IE 8. Is it java base? Thanks, Michael Neuschafer PC

Re: [rt-users] comments and correspond by mail

2010-02-09 Thread Eleanor J. Evans [Panix Staff]
On Wed, Feb 03, 2010 at 09:32:39PM +0100, Albert Shih wrote: After a new ticket is create (by mail), RT send a mail to the requester and to the watcher of the queue. I would like to known how the watcher can put a comment to this ticket using the mail ? When the watcher reply to the RT

Re: [rt-users] How to reset ticket # counter

2010-02-09 Thread William Graboyes
Hi, What database are you using? MySQL: truncate table Tickets; truncate table Transactions; truncate table ObjectCustomFieldValues; truncate table Attachments. Other Databeses, I don't know. Please note that truncate is a dangerous command, and literally deletes all information in the tables

Re: [rt-users] How to reset ticket # counter

2010-02-09 Thread Jerrad Pierce
Is there any one who can  help me to reset the ticket counter to 0. as i have deleted all test mails from dB so i also want to reset the thicket counter. which table contains information about ticket counter? Other than being fussy, there's really no reason to do this. The ticket ID is what it

[rt-users] Using RT with external mail provider

2010-02-09 Thread Renato S . Yamane
Hi, I´m a newbie in RT. Before start using it, I would like to know if is possible use RT in my intranet setting it to open tickets using my external mail provider. To be clear: - My e-mails are out of my hands. They are in a external provider (like Gmail); - I would like to do that:

Re: [rt-users] Using RT with external mail provider

2010-02-09 Thread Robert Keidel
Hi, if your mail provider has pop3 or imap available and you are installing RT on a Linux OS, you could use fetchmail to pickup the e-mail. Through the mail gate from RT the email will create a ticket. Postfix/Sendmail could be used to deliver the email back to user (your ticket# is 12345)