Re: [rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread Thomas Sibley
On 12/11/2012 09:11 PM, John Kelsh wrote:
> Hi Thomas,
> 
> Thanks for the information.
> 
> I tried the obvious combinations, including the formats you
> suggested.
> 
> Do you know when this feature was introduced? I'm working on an older
> version of RT so it may not be implemented?

I believe CF.{42} has been supported since RT 3.8.3.  What version are
you using?

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread John Kelsh
Hi Thomas,

Thanks for the information.

I tried the obvious combinations, including the formats you suggested.

Do you know when this feature was introduced? I'm working on an older version 
of RT so it may not be implemented?

Thanks,

On 12/12/2012, at 1:49 PM, Thomas Sibley  wrote:

> On 12/11/2012 05:42 PM, John Kelsh wrote:
>> Hi All,
>> 
>> Is this possible? i.e. can a custom field value be selected by custom field 
>> id?
>> 
>> I want to use this to distinguish between two identically named custom 
>> fields.
> 
> Have you tried it?
> 
> CF.42 = 'foo' works just fine.  So does 'CF.{42}'.  If your two CFs are
> applied to different queues, you can also use the syntax:
> 'CF.QueueName.{CF Name}'
> 
> 
> We're hiring! http://bestpractical.com/jobs


We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread Thomas Sibley
On 12/11/2012 05:42 PM, John Kelsh wrote:
> Hi All,
> 
> Is this possible? i.e. can a custom field value be selected by custom field 
> id?
> 
> I want to use this to distinguish between two identically named custom fields.

Have you tried it?

CF.42 = 'foo' works just fine.  So does 'CF.{42}'.  If your two CFs are
applied to different queues, you can also use the syntax:
'CF.QueueName.{CF Name}'


We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread Kenneth Crocker
Try giving those two Custom fields some sort of identifier, like a prefix
or suffix. Might help.


Kenn

On Tue, Dec 11, 2012 at 5:42 PM, John Kelsh  wrote:

> Hi All,
>
> Is this possible? i.e. can a custom field value be selected by custom
> field id?
>
> I want to use this to distinguish between two identically named custom
> fields.
>
> Thanks,
> 
> We're hiring! http://bestpractical.com/jobs
>

We're hiring! http://bestpractical.com/jobs


[rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread John Kelsh
Hi All,

Is this possible? i.e. can a custom field value be selected by custom field id?

I want to use this to distinguish between two identically named custom fields.

Thanks,

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Show HTML tables in tickets

2012-12-11 Thread Russell Jones
Just bumping back up for a possible answer. Would be nice to get this 
working :)



On 12/6/2012 4:18 PM, Russell Jones wrote:

On 06.12.2012 15:37, Thomas Sibley wrote:


On 12/06/2012 01:08 PM, Russell Jones wrote:

Here's the Web_Local.pm: [root@hous0301 Interface]# pwd 
/var/www/html/local/lib/RT/Interface [root@hous0301 Interface]# cat 
Web_Local.pm package HTML::Mason::Commands; # Let tables through push 
@SCRUBBER_ALLOWED_TAGS, qw(TABLE THEAD TBODY TFOOT TR TD TH); 1;



Readable by apache?  We're hiring! http://bestpractical.com/jobs



Yes:


[root@hous0301 html]# ls -ld local
drwxr-xr-x 7 apache apache 4096 Feb 8 2012 local



[root@hous0301 local]# ll
total 40
drwxr-xr-x 2 apache apache 4096 Feb 8 2012 etc
drwxr-xr-x 5 apache apache 4096 Jun 7 10:41 html
drwxr-xr-x 3 apache apache 4096 Dec 6 10:59 lib
drwxr-xr-x 2 apache apache 4096 Feb 8 2012 plugins
drwxr-xr-x 2 apache apache 4096 Feb 8 2012 po



[root@hous0301 local]# cd lib
[root@hous0301 lib]# ll
total 4
drwxr-xr-x 3 apache apache 4096 Dec 6 10:59 RT



[root@hous0301 RT]# ll
total 4
drwxr-xr-x 2 apache apache 4096 Dec 6 11:12 Interface



[root@hous0301 Interface]# ll
total 4
-rw-r--r-- 1 apache apache 122 Dec 6 11:01 Web_Local.pm





Here is the results from a test ticket where I created a table. The 
"download with headers" shows that the table seems to be being made, 
but when displayed on the page all "tableness" is lost and it becomes 
just one long sentence. The "PreferRichText" setting is set to 1:



PreferRichText 1 site config





Here's the ticket source:


MIME-Version: 1.0

In-Reply-To: 
X-Mailer: MIME-tools 5.502 (Entity 5.502)
Content-Disposition: inline
References: 
Content-Type: text/html; charset="UTF-8"
Message-ID: 
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
RT-Send-CC:
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 273






test1

a



test2

b



test3

c













We're hiring! http://bestpractical.com/jobs




We're hiring! http://bestpractical.com/jobs


[rt-users] Multi-tenant

2012-12-11 Thread CB
Is it possible to set up RT 4 in a multi-tenant environment? Each tenant
would have their own domain name/look/queues/scrips etc without requiring a
separate RT install.

Cameron
<>
We're hiring! http://bestpractical.com/jobs


Re: [rt-users] message body not shown in web interface

2012-12-11 Thread Jim Brandt

You don't mention your version of RT, but you might be running into this:

http://issues.bestpractical.com/Ticket/Display.html?id=21411

Setting PreferRichText = 1 is a partial workaround.


On 12/11/12 5:48 AM, Marko Cupać wrote:

Requester has submitted ticket by e-mail from MS Outlook client. Ticket
has been created, but in web interface I do not see message body.
Automatic e-mail that informs tech support workers contains message
body of the original request, as inserted with $Transaction->Content()
in the template.

When i click on download/untitled in message history i see text of
original e-mail:

--


Dear Sir or Madam,
 
Blahblahblahblah   S
Poštovanjem,  
--

So far I noticed this for one request only. Any ideas why is this
happening, and how to prevent it?

Thank youn in advance,

Marko

We're hiring! http://bestpractical.com/jobs



--


We're hiring! http://bestpractical.com/jobs


[rt-users] message body not shown in web interface

2012-12-11 Thread Marko Cupać
Requester has submitted ticket by e-mail from MS Outlook client. Ticket
has been created, but in web interface I do not see message body.
Automatic e-mail that informs tech support workers contains message
body of the original request, as inserted with $Transaction->Content()
in the template.

When i click on download/untitled in message history i see text of
original e-mail:

--


Dear Sir or Madam,
 
Blahblahblahblah   S
Poštovanjem,  
--

So far I noticed this for one request only. Any ideas why is this
happening, and how to prevent it?

Thank youn in advance,

Marko

We're hiring! http://bestpractical.com/jobs