Re: [rt-users] Convert Other Ticketing System DB to RT?

2011-08-04 Thread Jason Ledford
What database access do you have to those older tickets and what type of database is it? Mine was a homebrew asp app with access db. I created a page in asp that queried the db and wrote the page to look like the offline tool. So I turned off all email notification and then ran through about

Re: [rt-users] Convert Other Ticketing System DB to RT?

2011-08-04 Thread Mark Jenks
We just left the old one behind for reference in case we needed it, and moved over all active tickets to the new system. -Mark From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Michael Steen Sent: Thursday, August 04, 2011 7:29 PM To:

Re: [rt-users] relative data ticket search for monthly report?

2011-08-04 Thread Thomas Sibley
On 08/04/2011 05:28 PM, John Alberts wrote: > The problem is, I can't figure out if it's possible to combine a relative > date with other criterion. For instance, 'last month' returns exactly one > month ago, so since today is Aug 4th, it returns July 4th, although I need > July 1st @midnight. >

[rt-users] Relative month handling

2011-08-04 Thread Chris Herrmann
You'll need to do it from a shell script or similar; that type of syntax doesn't work using the rt query language. I have some scripts that ive posted previously that are probably close to what you want. They are intended to execute from cron and email a tab separated file to you of results. R

Re: [rt-users] Convert Other Ticketing System DB to RT?

2011-08-04 Thread Michael Steen
Kenn, Anything that you can find would be appreciated. Thanks, Mike On Thu, Aug 4, 2011 at 7:08 PM, Kenneth Crocker wrote: > Michael, > > Several years ago we needed to convert some tickets from a "home" ticket > system to RT. We did it via a perl program using the API. I'd have to search > s

Re: [rt-users] Convert Other Ticketing System DB to RT?

2011-08-04 Thread Michael Steen
Kenn, Anything that you can find would be appreciated. Thanks, Mike On Thu, Aug 4, 2011 at 7:08 PM, Kenneth Crocker wrote: > Michael, > > Several years ago we needed to convert some tickets from a "home" ticket > system to RT. We did it via a perl program using the API. I'd have to search > s

Re: [rt-users] Convert Other Ticketing System DB to RT?

2011-08-04 Thread Kenneth Crocker
Michael, Several years ago we needed to convert some tickets from a "home" ticket system to RT. We did it via a perl program using the API. I'd have to search some of my old archives to find it, if you are interested. Kenn LBNL On Thu, Aug 4, 2011 at 3:12 PM, Michael Steen wrote: > All, > > I a

[rt-users] External access for rt

2011-08-04 Thread Chris Herrmann
Is rt configured as a virtual host to only respond to a particular URL? For example surfing to http://10.0.0.1 is not the same as surfing to your external ip or hostname myrt.mycompany.com. Chris Herrmann Far Edge +612 84251400 +614 03393309 http://www.faredge.com.au 2011 Training: h

Re: [rt-users] Convert Other Ticketing System DB to RT?

2011-08-04 Thread Michael Steen
Forgot to mention that we're using RT 3.8.9 On Thu, Aug 4, 2011 at 5:12 PM, Michael Steen wrote: > All, > > I am wondering if anyone has successfully converted a database from another > ticketing system to RT. I found a thread from 2008 about OTRS ( > http://www.gossamer-threads.com/lists/rt/use

[rt-users] Convert Other Ticketing System DB to RT?

2011-08-04 Thread Michael Steen
All, I am wondering if anyone has successfully converted a database from another ticketing system to RT. I found a thread from 2008 about OTRS ( http://www.gossamer-threads.com/lists/rt/users/81165) in which Jesse said that most people abandon their former ticketing systems to start fresh with RT

Re: [rt-users] relative data ticket search for monthly report?

2011-08-04 Thread John Alberts
I know, and I looked at the docs, but I can't figure out how to do what I want. I figured someone on the list must have figured out a way to get last months report easily, regardless of how long it is into the current month. After spending more time on this, it turns out Created >= 'first of last

[rt-users] ExternalAuth seems to do nothing

2011-08-04 Thread Erik Lyons
I have RT 4.0.1 newly installed and functioning on Fedora 15. Additionally, I've installed RT::Authen::ExternalAuth and (I think) added all the corresponding config directives, pointing to an AD server. So far I've seen no indication that any LDAP connection has been attempted, I can only authent

Re: [rt-users] Restricting to one attachment per ticket

2011-08-04 Thread Thierry Thelliez
Thanks for your answers. The use case is that end users are submitting forms as attachments. This works fine until they want to submit updates to these forms. Some are submitting a new ticket with the updated form, some are just adding an attachment (updated form) to an old ticket. Since we are as

[rt-users] Broken images visualization after upgrade 3.6.6 -> 4.0.1

2011-08-04 Thread Luca Villani
Hi. We have upgrade our installation from 3.6.6 to 4.0.1, and now all images will not be show inline in the webinterface: only the text "Message body not shown because it is not plain text." and a link to download the image. In our config there is Set( $ShowTransactionImages, 1); and

Re: [rt-users] Temporary directory for uploaded file when creating a ticket

2011-08-04 Thread Luca Villani
In data giovedì 4 agosto 2011 16:54:01, Kevin Falcone ha scritto: > Depending on your version of RT, it uses HTML::Mason's cgi_object, > which is often CGI.pm, and that should respect TMPDIR We had upgrade yesterday to RT 4.0.1, this is the relevand section in apache config: Order allow,

Re: [rt-users] Temporary directory for uploaded file when creating a ticket

2011-08-04 Thread Kevin Falcone
On Thu, Aug 04, 2011 at 03:03:20PM +0200, Luca Villani wrote: > In our instalaltion, when we create a ticket via webinterface with an > attached > file, it is stored in /var/tmp/ > > In order to clusterize RT we mut change this directory to a nfs mounted > share, > but we have found no configu

Re: [rt-users] Re-opening tickets as 'nobody'

2011-08-04 Thread Kevin Falcone
On Thu, Aug 04, 2011 at 02:29:37PM +0100, Mark Goodge wrote: > Hi, > > How can I configure RT so that a ticket which has previously been > assigned to a user and resolved is automatically re-assigned back to > the default of 'nobody' if re-opened by an incoming email? > > To give some background

Re: [rt-users] relative data ticket search for monthly report?

2011-08-04 Thread Kevin Falcone
On Thu, Aug 04, 2011 at 01:29:53AM +, John Alberts wrote: >Hi. I've found quite a few examples and documentation about using > relative dates to search >RT; however, for the life of me, I can't figure out how to use relative > dates to get a list of >tickets that were created las

[rt-users] Re-opening tickets as 'nobody'

2011-08-04 Thread Mark Goodge
Hi, How can I configure RT so that a ticket which has previously been assigned to a user and resolved is automatically re-assigned back to the default of 'nobody' if re-opened by an incoming email? To give some background on this request, we've recently switched from a normal, 9-5 weekday on

Re: [rt-users] Access RT from behind firewall

2011-08-04 Thread Thomas Sibley
On 08/03/2011 09:54 PM, Rocel M. Lacida wrote: > Yeah it's really weird why it doesn't redirect the traffic to my local > RT server. Where in fact I could access it locally. The firewall NAting > configuration is fine I tried changing this config to other local ip > which point to a webserver it re

[rt-users] Temporary directory for uploaded file when creating a ticket

2011-08-04 Thread Luca Villani
Hi. In our instalaltion, when we create a ticket via webinterface with an attached file, it is stored in /var/tmp/ In order to clusterize RT we mut change this directory to a nfs mounted share, but we have found no configuration keyword for tmpdir handling. We have try to modify the TMPDIR va