[rt-users] Retrieving information from RT-database

2015-01-29 Thread Luca Mazzaferro
Dear Users, I'm writing a pieces of code in Perl to retrieve information directly from the RT internal database. I would like to know if there are some API provided by RT to interact with the database, for example retrieve the list of users and so on. I need this informations out of the web inte

[rt-users] Connecting to remote MySQL via SSL

2015-01-29 Thread Nathan Cutler
I have been tasked with migrating our RT database (MySQL) to a remote server, connection between RT and the database server must be SSL encrypted. I see at [1] that DBD::mysql supports SSL, but the RT documentation [2] seems to imply that RT only supports SSL with PostgreSQL: $DatabaseRequire

[rt-users] Send mail to create a ticket (error)

2015-01-29 Thread Marisol Rojas
Good day, To request your help to know why not make sending emails to create a new ticket and in updating data and answer the ticket. We are just beginning to know RT version we are currently to implement is the 4.2.9, I hope we can support. Thanks, Greetings !!

[rt-users] Change Control and approvals

2015-01-29 Thread Matt Wells
I've been looking through the documentation on Approvals and hoped to get a little user point of view and help. So far this isn't working. I have a CCB queue and I've made a template named XYZ-CCB ===Create-Ticket: codereview Subject: Code review for {$Tickets{'TOP'}->Subject} Depended-On-By: {$

[rt-users] XLS report failure

2015-01-29 Thread Boris Epstein
Hello everyone, I am running RT 4.2.0 on a CentOS 6 machine. Somehow whenever I run a XLS report (XLS dump of a search) I get the following errors in the log: [25225] [Thu Jan 29 18:27:26 2015] [error]: Undefined subroutine &RT::SQL::PossibleCustomFields called at /opt/rt4/local/plugins/RT-Extens

[rt-users] RT 4.2.8 reply emails go out blank

2015-01-29 Thread juniorsa
On certain email replies the mail arrives blank to the recipient. In syslog Jan 27 09:09:37 irf RT: [12747] Use of uninitialized value $_ in concatenation (.) or string at /usr/local/share/perl/5.14.2/HTML/FormatText/WithLinks/AndTables.pm line 211. Jan 27 09:09:37 irf RT: [12747] Failed to down

Re: [rt-users] XLS report failure

2015-01-29 Thread Alex Peters
Are you using version 0.08 of the extension? On 30 Jan 2015 5:30 am, "Boris Epstein" wrote: > Hello everyone, > > I am running RT 4.2.0 on a CentOS 6 machine. Somehow whenever I run a XLS > report (XLS dump of a search) I get the following errors in the log: > > [25225] [Thu Jan 29 18:27:26 2015]

Re: [rt-users] Request Tracker

2015-01-29 Thread Alex Vandiver
On Wed, 28 Jan 2015 12:29:00 +0200 Andrius Kulbis wrote: > Maybe you can look through my question? > http://requesttracker.8502.n7.nabble.com/Uploading-image-to-Image-CustomField-via-REST-td59382.html Support on the mailing list is provided as we have time to provide it. We support development o

Re: [rt-users] RT 4.2.8 reply emails go out blank

2015-01-29 Thread Alex Vandiver
On Thu, 29 Jan 2015 11:50:25 -0700 (MST) juniorsa wrote: > On certain email replies the mail arrives blank to the recipient. This is caused by failure of the HTML -> Text rendering engine. It triggers on email (or comments/correspondence) which need to be embedded into plain-text templates; the

Re: [rt-users] Connecting to remote MySQL via SSL

2015-01-29 Thread Alex Vandiver
On Thu, 29 Jan 2015 10:59:27 +0100 Nathan Cutler wrote: > I have been tasked with migrating our RT database (MySQL) to a remote > server, connection between RT and the database server must be SSL > encrypted. > > I see at [1] that DBD::mysql supports SSL, but the RT documentation > [2] seems to i

Re: [rt-users] Cancel "Resolve" transaction based on custom fields

2015-01-29 Thread Alex Vandiver
On Wed, 28 Jan 2015 14:27:22 +0100 Jasper Olbrich wrote: > Is it possible to suppress the status change from open to resolved > with a scrip or to include the scrip-induced status change in the > result box? Unfortunately, neither of these is possible in stock RT. Scrips can only run _after_ a c

Re: [rt-users] Problem with attachments

2015-01-29 Thread Alex Vandiver
On Wed, 28 Jan 2015 11:53:53 + Guadagnino Cristiano wrote: > Unfortunately we send attachments very rarely, so I cannot exactly > say when this behaviour started. It could be that it started from the > day I upgraded our installation from 4.2.3 to 4.2.9 (in december), or > later when I added/u

Re: [rt-users] RT 4.2.8 reply emails go out blank

2015-01-29 Thread Gilbert Rebeiro
Is there any work around for now? How would users know their messages went out blank? Any suggestions would be great! Any idea on when 4.2.10 will be released? Thanks, Gilbert. On 1/29/2015 2:49 PM, Alex Vandiver wrote: On Thu, 29 Jan 2015 11:50:25 -0700 (MST) juniorsa wrote: On certain email

Re: [rt-users] RT 4.2.8 reply emails go out blank

2015-01-29 Thread Alex Vandiver
On Thu, 29 Jan 2015 15:01:07 -0500 Gilbert Rebeiro wrote: > Is there any work around for now? Switching to HTML templates is one solution. This will only mask the issue somewhat, however, as the plain-text alternative part will be blank, and the text/html will appear fine. > How would users kno

Re: [rt-users] XLS report failure

2015-01-29 Thread Alex Peters
You need to upgrade to v0.08, which has explicit support for RT v4.2. On 30 Jan 2015 7:01 am, "Boris Epstein" wrote: > According to the PERL code (I am sorry, not sure what the official > location for the version string is) this is RT-Extension-SearchResults-XLS > v 0.07. > > Thanks. > > Boris. >

Re: [rt-users] XLS report failure

2015-01-29 Thread Boris Epstein
Thanks for your help Alex! Do you know if there are any DB changes involved? Boris. On Thu, Jan 29, 2015 at 3:38 PM, Alex Peters wrote: > You need to upgrade to v0.08, which has explicit support for RT v4.2. > On 30 Jan 2015 7:01 am, "Boris Epstein" wrote: > >> According to the PERL code (I a

Re: [rt-users] XLS report failure

2015-01-29 Thread Alex Peters
I have no personal experience with the plugin but its docs seem to suggest that none should be necessary. On 30 Jan 2015 8:01 am, "Boris Epstein" wrote: > Thanks for your help Alex! > > Do you know if there are any DB changes involved? > > Boris. > > On Thu, Jan 29, 2015 at 3:38 PM, Alex Peters

Re: [rt-users] Cancel "Resolve" transaction based on custom fields

2015-01-29 Thread Kevin Falcone
On Thu, Jan 29, 2015 at 03:04:55PM -0500, Alex Vandiver wrote: > On Wed, 28 Jan 2015 14:27:22 +0100 Jasper Olbrich > wrote: > > Is it possible to suppress the status change from open to resolved > > with a scrip or to include the scrip-induced status change in the > > result box? > > Unfortunatel

Re: [rt-users] Cancel "Resolve" transaction based on custom fields

2015-01-29 Thread Landon Stewart
On Jan 28, 2015, at 5:27 AM, Jasper Olbrich wrote: > > Hello, > > I want to cancel or undo the "Mark as Resolved" transaction based on the > content of custom fields. Currently I'm using a Scrip and I'm only able to do > the following: > > * access the custom fields > * make the decision > *

Re: [rt-users] Cancel "Resolve" transaction based on custom fields

2015-01-29 Thread Landon Stewart
On Jan 29, 2015, at 3:05 PM, Landon Stewart wrote: > In the action (commit) section of the Scrip: > $self->TicketObj->Status("open"); > $self->TicketObj->Comment( Content => "Script re-opened because > CustomFieldName is > ".$self->TicketObj->FirstCustomFieldValue("CustomFieldName") ); Oops. S