Re: [rt-users] Calculations on custom field values

2011-03-02 Thread Joop
Daniel Farst wrote: I have a couple of things I'd like to do with RT and haven't been able to find any clear answers how to do it, or if it's even possible. Can anyone point me in the right direction? We'd like to do some simple calculations on values stored in a custom fields and on values fr

[rt-users] Login Error and External Auth problem

2011-03-02 Thread Jason Ledford
I am running Debian Lenny, 64b server, 3.8.9 RT and everything seemed to install fine. I noticed this error after trying to get external auth working. "We opened /dev/null to protect FD #1, but descriptor #1 is already occupied at /opt/rt3/bin/webmux.pl line 78. (/opt/rt3/bin/webmux.pl:78)" I

Re: [rt-users] Automatic ticket generation

2011-03-02 Thread Howard Jones
On 02/03/2011 18:51, Thomas Sibley wrote: > You can have your servers (or something else) send email into RT just > fine. To parse the incoming message, you can do it in a scrip or with > something like RT-Extension-ExtractCustomFieldValues. Also, if your other servers are capable of using it, che

Re: [rt-users] Calculations on custom field values

2011-03-02 Thread Michael Coakley
I do things like this similar to how Kenneth described but I use a ODBC connection directly to the database and use Excel Pivot tables to build reports. Very flexible and gives you data mining tools right out of the box. While it isn't built into RT it is in a place where data analysis is easily

Re: [rt-users] JS Gantt extension

2011-03-02 Thread Yan Seiner
On Wed, March 2, 2011 2:20 pm, Thomas Sibley wrote: > You should be looking for a Gantt link at the top of search results or > in the ticket Links box. And there it is! Thanks! --Yan -- If you have eight hours to chop down a tree spend six sharpening your axe. --Abraham Lincoln

Re: [rt-users] Calculations on custom field values

2011-03-02 Thread Daniel Farst
Kenneth, Thanks for the suggestion and I'll look to see if this might be workable on our end, but I was rather hoping that there might be someway to do this all within RT, automatically, to be able to say display on a dashboard or saved search the total cost of all the orders or the average cos

Re: [rt-users] Custom field creation

2011-03-02 Thread Kevin Falcone
On Wed, Mar 02, 2011 at 05:20:17AM -0500, Bernard McCormack wrote: >I'm creating a new user custom field in rt 3.8.8 and I'm not seeing in > the ui till I manually >update table `rt3`.`ObjectCustomFields` with the values(in seeing in the > ui I mean on the >ticket /ui It does appear

Re: [rt-users] Strange bug in Update.html -- maybe cookie related

2011-03-02 Thread Kevin Falcone
On Wed, Mar 02, 2011 at 12:10:41PM +, Raed El-Hames wrote: > Hi: > > RT-3.8.7 > Mysql,Apache2, mod_perl v2.04; HTML::Mason v1.39; > > > When updating 2 tickets (tickets 1,2 as an example) at the same time, using 1 > browser and 2 tabs: > If I upload files A and B into ticket 1, and whil

Re: [rt-users] JS Gantt extension

2011-03-02 Thread Thomas Sibley
You should be looking for a Gantt link at the top of search results or in the ticket Links box. Thomas On 02 Mar 2011 16:43, Yan Seiner wrote: > I've been trying to get the JS Gantt extension working, and so far no joy. > > I'm assuming it's supposed to show up somewhere on the dashboard. It >

[rt-users] JS Gantt extension

2011-03-02 Thread Yan Seiner
I've been trying to get the JS Gantt extension working, and so far no joy. I'm assuming it's supposed to show up somewhere on the dashboard. It doesn't. I've installed it per the README, it's all in the right place (or at least in the correct directory substructure) but no Gantt chart. How do I

Re: [rt-users] Custom field creation

2011-03-02 Thread Kenneth Crocker
Bernard, A couple of questions: 1) is this a GLOBAL CF? If not, it needs to be "Applied" to the Queues where it should reside. 2) Did you grant rights for this CF by Group or by Queue? It makes a difference. I can create all the Global or Queue-level CF's I want, but if I don't grant the rights t

Re: [rt-users] Strange bug in Update.html -- maybe cookie related

2011-03-02 Thread Kenneth Crocker
Raed, Maybe it's cache related and you can set the RT_SiteConfig.pm to reload cache for each session/ticket? Just a shot in the dark here. Kenn LBNL On Wed, Mar 2, 2011 at 4:10 AM, Raed El-Hames < raed.el-ha...@daisygroupplc.com> wrote: > Hi: > > RT-3.8.7 > Mysql,Apache2, mod_perl v2.04; H

Re: [rt-users] Calculations on custom field values

2011-03-02 Thread Kenneth Crocker
Daniel, We DO this! We have over a hundred Queues that are used for Application support in many, many scientific applications as well as the regular AP, AR, GL, etc. Each Queue has a manager and they ALL have a variety of Searches that provide them with such things as Time Estimated, Time Worked (

Re: [rt-users] Calculations on custom field values

2011-03-02 Thread Todd Chapman
Daniel, It is certainly possible to write a scrip that updates custom field values when other custom fields,or core RT fields change. It is also possible to have columns that are calculated on the fly as search results are returned, though it takes a bit more work because RT does not have callback

Re: [rt-users] Checking group membership and change queue

2011-03-02 Thread Ruslan Zakirov
Hi, As I understand you want to put tickets into a queue depending on requestor's information and have only one email address for users to use. You need a queue where all tickets are created by email then transfered to another queue. Use a scrip to transfer tickets. On Tue, Mar 1, 2011 at 1:01 AM

Re: [rt-users] Automatic ticket generation

2011-03-02 Thread Thomas Sibley
You can have your servers (or something else) send email into RT just fine. To parse the incoming message, you can do it in a scrip or with something like RT-Extension-ExtractCustomFieldValues. Thomas On 02 Mar 2011 12:15, Ramsey, Todd (HCTRA) wrote: > Hello, > > > > I have looked through th

Re: [rt-users] Prevent CC address from adding to notification list

2011-03-02 Thread Landon Stewart
Hey Simon, I think you just have to modify the Scrip with the action "Notify Requestors and Ccs" and set it to "Notify Requestors" instead. RT -> Configuration -> Queues -> -> Scrips The ones I'd check out from the defaults are "On Create Notify AdminCcs" and "On Correspond Notify Requestors an

Re: [rt-users] Prevent CC address from adding to notification list

2011-03-02 Thread Simon Gao
Thanks. What about just for one queue, not applied to all other queues? Simon On Wed, Mar 2, 2011 at 10:19 AM, Landon Stewart wrote: > Hi Simon, > > In RT_SiteConfig.pm: > > Set($ParseNewMessageForTicketCcs , 0); > > > On Wed, Mar 2, 2011 at 10:17 AM, Simon Gao wrote: > >> Hi, >> >> Is there a

Re: [rt-users] Prevent CC address from adding to notification list

2011-03-02 Thread Landon Stewart
Hi Simon, In RT_SiteConfig.pm: Set($ParseNewMessageForTicketCcs , 0); On Wed, Mar 2, 2011 at 10:17 AM, Simon Gao wrote: > Hi, > > Is there a way to prevent email addresses on CC list from being added to RT > notification list? > > Simon > -- Landon Stewart SuperbHosting.Net by Superb Inter

[rt-users] Prevent CC address from adding to notification list

2011-03-02 Thread Simon Gao
Hi, Is there a way to prevent email addresses on CC list from being added to RT notification list? Simon

Re: [rt-users] Calculations on custom field values

2011-03-02 Thread Thomas Smith
I am interested in this as well as my company is in a similar situation--this capability would determine whether or not we used RT for tracking information that requires these types of calculations. Can anyone offer a hint as to whether or not this is possible to do? Even if it's a custom extensio

[rt-users] Automatic ticket generation

2011-03-02 Thread Ramsey, Todd (HCTRA)
Hello, I have looked through the documentation, but cannot seem to find any data on whether RT is equipped to create tickets from messages sent by servers. I have machines that generate problem messages with various fields of info that are pipe\delimited and would like to send those to a direct

Re: [rt-users] RTx::EmailCompletion adding name/other fields to pop down display

2011-03-02 Thread Giuseppe Sollazzo
Hi Kevin, hi all. After a couple of tries I've realised that despite maybe not being the most elegant way of doing it, this can be done by modifying /opt/rt3/local/plugins/RTx-EmailCompletion/lib/RTx/EmailCompletion/Ldap.pm. However I seem to have a "strange" issue. One step at a time. Wher

Re: [rt-users] Weird results in search

2011-03-02 Thread Ruslan Zakirov
Hi, It's also possible that some of Web* options in the config are not set correctly, however neither exaplain difference for users with different privileges. On Wed, Mar 2, 2011 at 6:57 PM, Yan Seiner wrote: > OK< thanks.  I think the database is hosed; this has been a demo/testbed > for a coup

Re: [rt-users] Duplicate Emails - On Create and On Resolve

2011-03-02 Thread Ruslan Zakirov
Why did you create scrips? Have you read the following? http://requesttracker.wikia.com/wiki/Template#What_if_I_want_to_override_a_global_template_for_one_of_my_queues.3F Probably now you have global notification scrips and queue specific scrips. RT still runs global and users get two emails. On

[rt-users] Duplicate Emails - On Create and On Resolve

2011-03-02 Thread Alberto Vazquez
Greetings! I've created a separate queue in our existing RT system, scrips and templates. It all appears to be working well, except that when a user send an email to the specific queue, such users receives duplicate email notifications: one, from the original queue (helpdesk) and the other, from

Re: [rt-users] Weird results in search

2011-03-02 Thread Yan Seiner
OK< thanks. I think the database is hosed; this has been a demo/testbed for a couple of years and it's probably just corrupted. There's no valuable information in the db, so I'll probably just delete the whole installation and start over. :-) --Yan On Wed, March 2, 2011 6:04 am, Raed El-Hames

Re: [rt-users] Weird results in search

2011-03-02 Thread Yan Seiner
OK< thanks. I think the database is hosed; this has been a demo/testbed for a couple of years and it's probably just corrupted. There's no valuable information in the db, so I'll probably just delete the whole installation and start over. :-) --Yan On Wed, March 2, 2011 6:04 am, Raed El-Hames

Re: [rt-users] Testing 4.0.0rc5 - experiences upgrading from 3.6.4 on RHEL6

2011-03-02 Thread Chia-liang Kao
Darren, On Feb 24, 2011, at 7:04 PM, Darren Nickerson wrote: That FD is a network connection to our database server: [root@rt4 Plack-0.9970]# ls -l /proc/30310/fd/1 lrwx--. 1 root root 64 Feb 24 17:44 /proc/30310/fd/1 -> socket: [281592] [root@rt4 Plack-0.9970]# netstat -antep | grep 28

Re: [rt-users] Weird results in search

2011-03-02 Thread Raed El-Hames
Yan: I do get this when I have changed the organisation name (re branding etc), where every user that have saved his search options will get the old url in their searches and the new one. Have you had this system installed/set up under a difference url? Do the users who get this , have had searc

Re: [rt-users] Weird results in search

2011-03-02 Thread Yan Seiner
Yan Seiner wrote: I set up a learning/demo site using RT 3.6.7 some time ago. I've been playing with it, showing it to people and using it as a test site to see if it will work for the various applications that come up. Today I found something weird - the search result for tickets returns a bog

[rt-users] Strange bug in Update.html -- maybe cookie related

2011-03-02 Thread Raed El-Hames
Hi: RT-3.8.7 Mysql,Apache2, mod_perl v2.04; HTML::Mason v1.39; When updating 2 tickets (tickets 1,2 as an example) at the same time, using 1 browser and 2 tabs: If I upload files A and B into ticket 1, and while waiting for the file upload to complete I decide to update ticket 2, the secon

Re: [rt-users] Comments get posted twice due to Jumbo interface

2011-03-02 Thread Ruslan Zakirov
Hi, Fixed on 4.0/clean_jumbo_message_box. Not sure where it ends up. It's been this way for ages. On Thu, Feb 24, 2011 at 6:20 PM, Kevin Falcone wrote: > On Thu, Feb 24, 2011 at 02:44:47PM +0100, Gerard FENELON wrote: >>    Hi >> >>    one of my user reported the following issue : >> >>  When I

Re: [rt-users] RT-Shredder directory

2011-03-02 Thread Christian Loos
The directory isn't created by the install script, so you have to create it manually. I opened already a bug for this nearly a year ago: http://issues.bestpractical.com/Ticket/Display.html?id=14640&user=guest&pass=guest -Chris Am 02.03.2011 05:00, schrieb Thomas Smith: > I'm working with a recent

Re: [rt-users] BCC emails on Comment

2011-03-02 Thread Bernard McCormack
What are your other scips? This shouldn't notify your queue cc's. From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Gregory Okoth Sent: Wednesday, March 02, 2011 4:32 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] BCC

[rt-users] Custom field creation

2011-03-02 Thread Bernard McCormack
I'm creating a new user custom field in rt 3.8.8 and I'm not seeing in the ui till I manually update table `rt3`.`ObjectCustomFields` with the values(in seeing in the ui I mean on the ticket /ui It does appear on the edit custom fields page under config). This is only occurring on my production d

Re: [rt-users] RT-Shredder directory

2011-03-02 Thread john s.
Hello Tom You have to set the rights for the Webserver for these Directorys best regards john Thomas Smith-12 wrote: > > I'm working with a recent upgrade from 3.6.6. to 3.8.8. > > When looking at the now included RT-Shredder utility, I got this error > when > I first attempted to access

[rt-users] BCC emails on Comment

2011-03-02 Thread Gregory Okoth
Hi RT Community, I need a clarification with regards to BCC emails. I am using RT 3.8.8 on CentOS 5.5, mysql, postfix When adding comments on tickets and using the Update Ticket button, it sends to those on CC for the queue under which the ticket belongs to, as well as the Originator, as BCC m