Re: [rt-users] Approval RT 3.8.2 system approver not specified

2009-02-26 Thread Chia-liang Kao
Hi Ton, > correspondence is also saying that Nobody has approved the > ticket (what looks silly in my opinion). you should in fact set the owner of the approval ticket in your template, so the owner is notified of the approval and can perform the approval action. > I have a global scrip that set

[rt-users] log a complaint about invalid timezones?

2009-02-26 Thread Jo Rhett
On Feb 26, 2009, at 10:45 AM, Jo Rhett wrote: We have noticed that although the subscription page says the local timezone next to the time, the reports actually run based on GMT time. I figured it out. On FreeBSD timezone data is stored in /usr/share/ timezones and has some different names.

Re: [rt-users] RTx::WorkflowBuilder - Can't call method "HasUnresolvedDependencies" on an undefined value

2009-02-26 Thread Chia-liang Kao
Hi Richard, It transpires the approval ticket is actually created, although I am unable to see it unless I look up the id directly, even though my user currently has every right imaginable. Further, when I reject the (hidden) approval, this appears to be succesful. However, when I reso

Re: [rt-users] RT 3.6 Change look and feel of customized fields

2009-02-26 Thread Todd Chapman
This might help. http://lists.bestpractical.com/pipermail/rt-users/2008-February/050039.html On Wed, Feb 25, 2009 at 1:47 PM, Eggers, Ken F. wrote: > I am a novice who has easily created customized fields (RT is Great for > that) but now want to change the look and feel to allow the fields to >

Re: [rt-users] Fwd: A little Scrip help

2009-02-26 Thread Aaron Guise
I thought of this scenario already, but I created the ticket from another external email address which is separate from my work one which RT Responds to. I am the owner of the ticket data is merged with and hence I get one email but I have a feeling it may be emailing twice as there is two ticket

Re: [rt-users] Fwd: A little Scrip help

2009-02-26 Thread Kenneth Crocker
Aaron, Are the persons getting the Email in more than 1 role? FOr example; If I am the Requestor & the Owner and someone merges a ticket into mine am I getting 1 email as requestor and 1 as owner? Just a thought. Kenn LBNL On 2/26/2009 3:17 PM, Aaron Guise wrote: > > > -- Fo

[rt-users] Fwd: A little Scrip help

2009-02-26 Thread Aaron Guise
-- Forwarded message -- From: Aaron Guise Date: Fri, Feb 27, 2009 at 12:17 PM Subject: Re: [rt-users] A little Scrip help To: Kenneth Crocker Yeah, Have double checked all of those scrips/templates again. The only one that nets an output matching that is the MergeNotifier Templ

Re: [rt-users] A little Scrip help

2009-02-26 Thread Aaron Guise
On Fri, Feb 27, 2009 at 9:46 AM, Aaron Guise wrote: > Hi, > > I have just now amended our RT_SiteConfig with Set($UseTransactionBatch, > 1); > > Unfortunately it still triggered two emails. The scrip itself is set to > use transaction batch. > > > *Regards,* > > *Aaron Guise > 027 212 6638 > aa.

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Jesse Vincent
> Don't apply this patch. It's making the RT test suite explode. I have no > idea _what_ it would do to your DB. It was a false alarm. The test suite is now happy. Give it a shot? pgpTDMV8gDH9v.pgp Description: PGP signature ___ http://lists.bestprac

Re: [rt-users] Crystal Reports

2009-02-26 Thread estauss
Hello, I was also looking at using Crystal Reports with RT, is it any easier or are there any guides that show you how to do this? Thank you Eric Roy El-Hames wrote: > > Well kind of No, as Todd suggested the relationship within the RT tables > are n't straight forward to do joins/Sql querie

[rt-users] 382 Shredder deleting tickets and attachments?

2009-02-26 Thread Paul Hirose
If I use the built-in shredder to delete a ticket from the MySQL database, should it delete any attachments that were associated with that ticket? Or must I delete attachments separately? Thank you, PH -- Paul Hirose : pthir...@ucdavis.edu : Sysadm Motto: rm -fr /MyLife 1034 Academic

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Jesse Vincent
On Thu 26.Feb'09 at 12:32:46 -0800, Tom Lahti wrote: > > I'll do that in a bit. However, I would try Jesse's patch first. You > > could ALSO write down all the info for the ticket and shred it and then > > re-create it properly. Let me know how it goes with Jesse's patch and > > such. In

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Kenneth Crocker
Tom, Yep. I got it after I wrote my last note. If what you say is true, then that dump would be an excellant way to determine what records need to be updated in the DataBase. Kenn LBNL On 2/26/2009 12:32 PM, Tom Lahti wrote: >> I'll do that in a bit. However, I would try Jesse's

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Tom Lahti
> I'll do that in a bit. However, I would try Jesse's patch first. You > could ALSO write down all the info for the ticket and shred it and then > re-create it properly. Let me know how it goes with Jesse's patch and > such. In the meantime, I'll put together the SQL and instructions. Doe

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Kenneth Crocker
Joachim, I'll do that in a bit. However, I would try Jesse's patch first. You could ALSO write down all the info for the ticket and shred it and then re-create it properly. Let me know how it goes with Jesse's patch and such. In the meantime, I'll put together the SQL and instructions.

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Jesse Vincent
On Thu, Feb 26, 2009 at 02:48:19PM -0500, Jesse Vincent wrote: > > > > On Thu, Feb 26, 2009 at 11:40:02AM -0800, Joachim Thuau wrote: > > Sadly, we already tried that. We can change the owner every which way, > > except for "tom" (who was the guy that worked on it). > > > > Can you try thi

[rt-users] right to see the user list -- only ShowConfigTab ?

2009-02-26 Thread Jo Rhett
I'd like all privileged users to be able to see the User list, to find other privileged users' contact information. The only thing I've been able to find is ShowConfigTab, which allows them to see a lot of other things and even implies that they can change the other person's info -- they ca

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Jesse Vincent
On Thu, Feb 26, 2009 at 11:40:02AM -0800, Joachim Thuau wrote: > Sadly, we already tried that. We can change the owner every which way, > except for "tom" (who was the guy that worked on it). > Can you try this patch? It's conceptually right but off the cuff. It's against 3.8 but applies to

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Joachim Thuau
I'm a little on the fence about this. I obviously want to "catch up" and get up to 3.8.2 (whoohoo!) but I do need to sort out that ticket first (at least it would make sense...) to make sure it's not going to croak on the reload of the DB. I have looked at the nice relational drawing from the RT-E

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Jesse Vincent
On Thu 26.Feb'09 at 11:04:08 -0800, Joachim Thuau wrote: > Will this cause issues with the upgrade process, if I update to 3.8.2 now? > (ie: will it just "recover" or will the DB choke on it) > > I guess I could just shred that ticket... But history is important... > It's been a while, but I

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Kenneth Crocker
Joachim, You could do this with SQL directly in the DataBase, but I would only do that if Shredder can't handle it. I'm afraid if you shred the ticket, it's gone and there won't be a ticket to own. That might make your Audit department a little testy about your ticket history. I have s

Re: [rt-users] User given Administrator Privelages - Still can't make changes

2009-02-26 Thread Kenneth Crocker
Ryan, Are you talking about a specific User or a specific type of user, like AdminCc or Oqner, or even a User-defined group? The rights for Custom Fields are in two ares. First is the ability to just create one and define it in terms of what can be entered (ie. select on value and THOS

Re: [rt-users] A little Scrip help

2009-02-26 Thread Kenneth Crocker
Aaron, You need to turn on TransactionBatch in your RT_SiteConfig.pm file in /RTHOME/etc directory. That should allow you to use that stage option. Kenn LBNL On 2/26/2009 10:33 AM, Aaron Guise wrote: > If set to transaction batch which is marked Transaction Batch(Disabled) > it seems

Re: [rt-users] Ticket taken twice

2009-02-26 Thread Joachim Thuau
Will this cause issues with the upgrade process, if I update to 3.8.2 now? (ie: will it just "recover" or will the DB choke on it) I guess I could just shred that ticket... But history is important... Jok > -Original Message- > From: Todd Chapman [mailto:t...@chaka.net] > Sent: Wednesd

Re: [rt-users] RTx::WorkflowBuilder - Can't call method "HasUnresolvedDependencies" on an undefined value

2009-02-26 Thread Richard Foley
On Thursday 26 February 2009 19:19:18 Jesse Vincent wrote: > > On Thu 26.Feb'09 at 19:17:28 +0100, Richard Foley wrote: > > Hi Chia-liang et al, > > > > It transpires the approval ticket is actually created, although I am unable to > > see it unless I look up the id directly, even though my use

[rt-users] bug - Dashboard subscription says "US/Pacific" but runs in GMT

2009-02-26 Thread Jo Rhett
We have noticed that although the subscription page says the local timezone next to the time, the reports actually run based on GMT time. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ htt

Re: [rt-users] A little Scrip help

2009-02-26 Thread Aaron Guise
If set to transaction batch which is marked Transaction Batch(Disabled) it seems the script is just disabled as no email is sent. On Fri, Feb 27, 2009 at 1:32 AM, Potla, Ashish Bassaliel < c_apo...@qualcomm.com> wrote: > > > From: Potla, Ashish Bassaliel >

Re: [rt-users] RTx::WorkflowBuilder - Unrecognized character \xE2

2009-02-26 Thread Richard Foley
On Thursday 26 February 2009 19:14:54 Jesse Vincent wrote: > > > I made sure each subject line was on single line and replaced a couple of stray dashes, (I think the \xE2 was > > a "−>" thing instead of a "−>" thing in the auto-generated template from bin/rt-workflow - which was installed via

Re: [rt-users] RTx::WorkflowBuilder - Can't call method "HasUnresolvedDependencies" on an undefined value

2009-02-26 Thread Jesse Vincent
On Thu 26.Feb'09 at 19:17:28 +0100, Richard Foley wrote: > Hi Chia-liang et al, > > It transpires the approval ticket is actually created, although I am unable > to > see it unless I look up the id directly, even though my user currently has > every right imaginable. Approval tickets are o

Re: [rt-users] RTx::WorkflowBuilder - Can't call method "HasUnresolvedDependencies" on an undefined value

2009-02-26 Thread Richard Foley
Hi Chia-liang et al, It transpires the approval ticket is actually created, although I am unable to see it unless I look up the id directly, even though my user currently has every right imaginable. Further, when I reject the (hidden) approval, this appears to be succesful. However, when I re

Re: [rt-users] RTx::WorkflowBuilder - Unrecognized character \xE2

2009-02-26 Thread Jesse Vincent
> I made sure each subject line was on single line and replaced a couple of > stray dashes, (I think the \xE2 was > a "−>" thing instead of a "−>" thing in the auto-generated template from > bin/rt-workflow - which was installed via > the CPAN), like this: Did you copy and paste from perldoc

Re: [rt-users] How to display a logo in RT 3.8.2

2009-02-26 Thread Matthew Seaman
Jet Wilda wrote: Hi, I followed these http://wiki.bestpractical.com/view/ChangeLogo directions, but there still isn't any logo getting displayed. When I do a view source I see the code for the logo but nothing is displayed on the page. I also found this http://www.gossamer-threads.com/

Re: [rt-users] Relative Dates in Search

2009-02-26 Thread Cassandra Phillips-Sears
Thanks Hans! -- Cassandra Phillips-Sears cassan...@bestpractical.com Office Manager Best Practical Solutions, LLC http://www.bestpractical.com On Feb 26, 2009, at 11:34 AM 2/26/09, Hans Dieter Pearcey wrote: > On Thu, Feb 26, 2009 at 11:36:57AM -0500, Cassandra Phillips-Sears > wrote: >> It lo

Re: [rt-users] RTx::WorkflowBuilder - Unrecognized character \xE2

2009-02-26 Thread Richard Foley
Oh, wait a minute, there's more. 1. Going into: Configuration -> Queues -> crs -> Scrips I made sure each subject line was on single line and replaced a couple of stray dashes, (I think the \xE2 was a "−>" thing instead of a "−>" thing in the auto-generated template from bin/r

Re: [rt-users] Relative Dates in Search

2009-02-26 Thread Cassandra Phillips-Sears
Hi Stephen. I think I've got it. You can use + and - signs in front to increment the numbers of weeks, months, etc. So, if you want to see all tickets due in the past 2 weeks before today, you'd add this to your search: ( Due < 'today' AND Due > '-2 week' ) If you wanted to see all the tic

Re: [rt-users] Relative Dates in Search

2009-02-26 Thread Hans Dieter Pearcey
On Thu, Feb 26, 2009 at 11:36:57AM -0500, Cassandra Phillips-Sears wrote: > It looks like you can get it down to 1 week in either direction, but I > don't know how it would be adapted to show something like "two weeks > ago" or "the week before last week," though. Use numerals instead of words

Re: [rt-users] Relative Dates in Search

2009-02-26 Thread Cassandra Phillips-Sears
Hi Stephen. I use some dashboard searches that work like this. I usually calculate my searches from the ticket's due date, but you could use the "started" date or "created" or any other date you wanted. To see things that are due today and were due any time in the past, I use the following s

[rt-users] Relative Dates in Search

2009-02-26 Thread Stephen Cochran
Is there a way to specific a relative date in a search so that when saved it will calculate off the current date? For example tickets from the past two weeks but without having to adjust the date in the search? ___ http://lists.bestpractical.com/cgi-bin/m

Re: [rt-users] RT 3.6 Change look and feel of customized fields

2009-02-26 Thread Simon Jester
Eggers, Ken F. mitre.org> writes: > Can the fields look and feel as displayed in the browser be > altered (see how much I am a novice!)?? > > Not looking to major radical changes, just some simple > sizing to allow text in the field to display completely. > > Ken > I created local EditCusto

Re: [rt-users] How to display a logo in RT 3.8.2

2009-02-26 Thread Jet Wilda
Also when I navigate directly to the image I get: The image “http://servername/rt/NoAuth/images/logo.gif” cannot be displayed, because it contains errors. However if I open up Firefox on that machine and then open up that image file it opens fine. Any ideas? Jet Wilda wrote: > Hi, > > I f

Re: [rt-users] RTx::WorkflowBuilder is now available on CPAN

2009-02-26 Thread Richard Foley
On Tuesday 24 February 2009 12:42:15 Chia-liang Kao wrote: > Hi, > > RTx::WorkflowBuilder is a tool that helps you configure multi-stage > approval workflow in rt. > > It is now available at http://search.cpan.org/dist/RTx-WorkflowBuilder/. > Hi Chia-liang, This looks good, although it doesn'

[rt-users] How to display a logo in RT 3.8.2

2009-02-26 Thread Jet Wilda
Hi, I followed these http://wiki.bestpractical.com/view/ChangeLogo directions, but there still isn't any logo getting displayed. When I do a view source I see the code for the logo but nothing is displayed on the page. I also found this http://www.gossamer-threads.com/lists/rt/users/7824

Re: [rt-users] colorize status

2009-02-26 Thread Richard Foley
On Thursday 26 February 2009 15:03:37 Alex Young wrote: > I have attached the exact files I am using for you to try. > Hi Alex, Thanks very much for those - they were not so very different from what I started with (apart from the dupes ;) I may go in and clarify the instructions on the wiki wi

[rt-users] Don't close the ticket if a custom field is empty

2009-02-26 Thread Michel L'HOSTIS
Hi everyone, I'm new on scrips writing. I'm looking for a way to send a notification to the owner of a ticket if he forgot to fill a specific custom field. I'd like to keep the ticket opened as long as there is no value to this custom field. I can detect if the custom field is empty or not. -

[rt-users] Problems with creating ticket linked from an asset in version 3.8.2

2009-02-26 Thread Peter Boguszewski
Hi all, Every time one of our users add a ticket that is linked to an asset, from the asset view, a ticket gets created but the content is only the first word of the body that is broken up to the first letter, then a blank space, then the rest of the word with nothing else. It is nice that

Re: [rt-users] colorize status

2009-02-26 Thread Alex Young
I have attached the exact files I am using for you to try. If you have cleared the mason cache and restarted Apache i dont know what else to suggest. I have noticed that RT doesnt reload .css files unless its had an apache restart, rather than reload. Also make sure you clear your browser cache.

Re: [rt-users] colorize status

2009-02-26 Thread Richard Foley
On Thursday 26 February 2009 14:22:56 Alex Young wrote: > Hi Alex, Thanks for that, that seems very close to what I had apart from the duplicates, it's identical now, so there must be something else dozy going on. The css file is not picked up, and all my statuses continue to remain black. I

Re: [rt-users] colorize status

2009-02-26 Thread Alex Young
This is what I have: /opt/rt3/local/html# tree Callbacks/ NoAuth/ Callbacks/ `-- MyCallbacks |-- Elements | `-- RT__Ticket | `-- ColumnMap | |-- ColumnMap `-- NoAuth `-- css `-- web2 `-- main.css `-- End

Re: [rt-users] colorize status

2009-02-26 Thread Richard Foley
On Wednesday 25 February 2009 17:29:10 Alex Young wrote: > You say your file is: > /opt/rt3/local/html/Callbacks/MyCallbacks/Elements/RT__Ticket/Columnmap/ > Columnmap > > That's wrong. Columnmap should me ColumnMap in both instances. > Hi Alex, Having fixed the beginners mistake, (whoops :-] an

Re: [rt-users] A little Scrip help

2009-02-26 Thread Potla, Ashish Bassaliel
From: Potla, Ashish Bassaliel Sent: Thursday, February 26, 2009 5:59 PM To: Aaron Guise Subject: RE: [rt-users] A little Scrip help Is the scrip set to 'Transaction Batch' or 'Transaction Create'? Set it to Transaction Batch. -Ashish _

[rt-users] A little Scrip help

2009-02-26 Thread Aaron Guise
Hi, I have implemented a scrip to notify the owner in the event someone else merges data into one of their tickets. All works well but alas it actually sends the notification twice. There is probably a real simple answer but it is baffling me. Have just ignored it the last few months but now I

Re: [rt-users] Problem for new users in RT 3.8.2 " RT could not load avalid user"

2009-02-26 Thread Calvin Chiang
Hi i did a new install onto 3.8.2 I'm pretty sure i had this problem when my LDAP access user had not been given the correct rights etc. Are the users getting the bouncebacks on an LDAP system? if not you'll need to set the value below to 1. (you'll find this in your RT_SiteConfig.pm) # I