[rt-users] Which rtfm version for rt 3.6.3

2007-06-07 Thread Emmanuel Lacour
Hi, I would like to know what is the recommended version of rtfm to use with rt 3.6.3. Is the stable version compatible, or should I use the developpement version? Is this last one stable enough? Thanks for any help :) -- Emmanuel Lacour ___ http

Re: [rt-users] Speed difference between superuser and others

2007-08-06 Thread Emmanuel Lacour
for RH :(), I didn't clearly identify your caching problem in the change file from this release, is 1.43 affected ? 1.49 is packaged at http://dag.wieers.com/rpm/packages/perl-DBIx-SearchBuilder/ since yesterday, so I will try it ;) Thanks for your help :) -- Emmanuel Lacour

Re: [rt-users] Speed difference between superuser and others

2007-08-06 Thread Emmanuel Lacour
On Mon, Aug 06, 2007 at 12:29:03PM +0200, Emmanuel Lacour wrote: 1.49 is packaged at http://dag.wieers.com/rpm/packages/perl-DBIx-SearchBuilder/ since yesterday, so I will try it ;) I tested this last version without any performance improvement :( Rt is 3.6.3, with a backport

Re: [rt-users] Speed difference between superuser and others

2007-08-24 Thread Emmanuel Lacour
On Mon, Aug 06, 2007 at 04:59:48PM +0200, Emmanuel Lacour wrote: On Mon, Aug 06, 2007 at 12:29:03PM +0200, Emmanuel Lacour wrote: 1.49 is packaged at http://dag.wieers.com/rpm/packages/perl-DBIx-SearchBuilder/ since yesterday, so I will try it ;) I tested this last version without

Re: [rt-users] Speed difference between superuser and others

2007-08-24 Thread Emmanuel Lacour
On Fri, Aug 24, 2007 at 07:51:35AM -0500, Kenneth Marshall wrote: On Fri, Aug 24, 2007 at 11:20:36AM +0200, Emmanuel Lacour wrote: That does seem a little bit excessive. 800 SQL queries in 5 minutes is about 1/3 second per query which seems slow to me. You may want to turn on query logging

Re: [rt-users] Error with install Bundle::CPAN

2007-08-24 Thread Emmanuel Lacour
UNIVERSAL-require-0.11 Object-MultiType-0.05 XML-Smart-1.6.9 and of course rt ;) -- Emmanuel Lacour Easter-eggs 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 41 35 00 76 mailto:[EMAIL

Re: [rt-users] Speed difference between superuser and others

2007-09-13 Thread Emmanuel Lacour
On Fri, Aug 24, 2007 at 03:34:08PM +0200, Emmanuel Lacour wrote: On Fri, Aug 24, 2007 at 07:51:35AM -0500, Kenneth Marshall wrote: On Fri, Aug 24, 2007 at 11:20:36AM +0200, Emmanuel Lacour wrote: That does seem a little bit excessive. 800 SQL queries in 5 minutes is about 1/3 second per

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
On Wed, Oct 10, 2007 at 09:43:31AM +0200, Emmanuel Lacour wrote: Dear RT users/developpers ;) I'm trying to draw charts grouped by customfield (using the functionnality at the bottom of a search result) and on a customfiled of type select unique value. But the result graph is empty

[rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
Dear RT users/developpers ;) I'm trying to draw charts grouped by customfield (using the functionnality at the bottom of a search result) and on a customfiled of type select unique value. But the result graph is empty :( It works with other group by like status, queue, ... If someone has some

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
On Wed, Oct 10, 2007 at 09:09:58AM -0400, Jesse Vincent wrote: Hi, dear RT primary Author ;) what shows up in your error logs? That's the good question ... sorry I forgot to look here :( There is DBD prepare errors: RT: RT::Handle=HASH(0x8134df1c) couldn't prepare the query 'SELECT

Re: [rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
On Wed, Oct 10, 2007 at 09:42:21AM -0400, Jesse Vincent wrote: I suspect that it has to do with this was tested on mysql and pg if only I had power to choose the database Engine ... ;) ___

[rt-users] Bug in Chart fonts handling

2007-10-10 Thread Emmanuel Lacour
I played with chart module and found that the fonts settings are incorrect. In share/html/Search/Chart, the only font setting is made by set_legend_font, but there is no legends on graphs so ... not very usefull. Instead it would be better to use one or every of the followings: For bars:

Re: R: [rt-users] Chart grouped by customfield

2007-10-10 Thread Emmanuel Lacour
On Wed, Oct 10, 2007 at 05:46:31PM +0200, Gianluca Cecchi wrote: Sorry main was an alias for Tickets table If I use the same query on mysql 9without the comma...) I get: ERROR 1054 (42S22): Unknown column 'ObjectCustomFieldValues_1.Content' in 'field list' And the oracle error 904

Re: [rt-users] Bug in Chart fonts handling

2007-10-11 Thread Emmanuel Lacour
On Thu, Oct 11, 2007 at 04:33:18AM +0400, Ruslan Zakirov wrote: Actually the changes Jesse's talking about are in 3.6.5 :) Thanks! Reminder for me always look at the last release before making cusom changes on code ;) /Reminder for me But there is a typo in RT_Config 3.6.5 for Font name:

Re: R: [rt-users] Chart grouped by customfield

2007-10-11 Thread Emmanuel Lacour
On Thu, Oct 11, 2007 at 06:44:04AM +0400, Ruslan Zakirov wrote: It's an experimental and untested patch that may help. It helps, and works here :)) Thanks you very much! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Re: [rt-users] RT statistics?

2007-10-30 Thread Emmanuel Lacour
it by creating new Mason components). You can also generate graph from a search, look at the bottom of your search result, there is a button to convert it in pie or bar chart. -- Emmanuel Lacour Easter-eggs 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité

[rt-users] Hidding approvals tickets

2007-11-02 Thread Emmanuel Lacour
' = '=', 'VALUE'= $group_name ); $groups-First-Id; } Content: Someone has created a foo ticket. Please review and approve it. ENDOFCONTENT -- Emmanuel Lacour Easter-eggs 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité Phone: +33 (0) 1 43 35 00 37

Re: [rt-users] RT statistics?

2007-11-02 Thread Emmanuel Lacour
and ... edit it to suit your needs ;) -- Emmanuel Lacour ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent

Re: [rt-users] Error when trying to remove a Member of a group

2007-11-16 Thread Emmanuel Lacour
On Fri, Nov 16, 2007 at 11:12:09AM +0100, Emmanuel Lacour wrote: I try to empty a group from his members which are mixed users/groups, and I get those errors for many of those members groups: [Fri Nov 16 09:50:41 2007] [warning]: User not loaded. (/opt/rt/lib/RT/User_Overlay.pm:1792) [Fri

Re: [rt-users] Hidding approvals tickets

2007-11-16 Thread Emmanuel Lacour
On Mon, Nov 05, 2007 at 08:44:21AM +0100, Torsten Brumm wrote: Hi Emmanuel, try the following ideas. 1. After creating the normal Ticket this creates the approval ticket with your scrip/template. Then create a second scrip which sets the normal ticket to a new status (create a new status

Re: [rt-users] Error when trying to remove a Member of a group

2007-11-16 Thread Emmanuel Lacour
On Fri, Nov 16, 2007 at 11:50:10AM +0100, Emmanuel Lacour wrote: It seems I have a problem with the Principals table: SQL select * from principals where id=22525; ID PRINCIPALTYPE OBJECTID DISABLED -- -- -- 22525 Group22525

Re: [rt-users] Error when trying to remove a Member of a group

2007-11-16 Thread Emmanuel Lacour
On Fri, Nov 16, 2007 at 10:02:33AM -0800, Kenneth Crocker wrote: Emmanuel, There could be many reason why you can't remove users from a group. What are your privileges for that group. What are your privileges in changing the privileges of those users? Hi, thanks for having a look

Re: [rt-users] RT3 not sending emails to requestor or owner

2007-11-19 Thread Emmanuel Lacour
On Mon, Nov 19, 2007 at 07:51:23PM +0500, Asrai khn wrote: Hi we are in the process of moving our rt from host host to another, for testing purpose i have installed rt3 using 'yum' on fedora 7, we are using the same mysql dbs from original (by taking dump) Everything looks fine just one

[rt-users] Problem on wiki.bestpractical.com

2007-11-19 Thread Emmanuel Lacour
FYI: there is some Asian/japanese chars on the front page (spam ?) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll

Re: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Emmanuel Lacour
On Mon, Nov 19, 2007 at 10:41:12AM -0600, Micah Gersten wrote: Should we upgrade from 4.0.24 to 4.1.11a? We're running debian and these are the packages available. FYI, I'm running also RT on Debian (etch) here with RT 3.6.3 and mysql-server 5.0.32-7etch1. This server was previously using

Re: [rt-users] Error when trying to remove a Member of a group

2007-11-19 Thread Emmanuel Lacour
On Fri, Nov 16, 2007 at 11:12:09AM +0100, Emmanuel Lacour wrote: I try to empty a group from his members which are mixed users/groups, and I get those errors for many of those members groups: i.e. group groupA as for example the following members: user1 user2 ... group1 group2

[rt-users] Members handling

2007-11-19 Thread Emmanuel Lacour
I just figured out that whan a group A is a member of another group B, in group B, we can see all people of group A as member (fine), but with an unusefull checkbox as when you try to remove one of those Users member, it only say that this user is not a member of group B :( I don't know if it's

Re: R: [rt-users] Chart grouped by customfield

2007-11-26 Thread Emmanuel Lacour
On Sat, Nov 24, 2007 at 04:33:38AM +0300, Ruslan Zakirov wrote: The patch is in DBIx::SearchBuilder 1.50 which on its way to the CPAN. It will be available from mirrors soon. Great, no problem here with this patch. -- Emmanuel Lacour Easter-eggs 44-46

Re: [rt-users] Hidding approvals tickets

2007-11-27 Thread Emmanuel Lacour
On Mon, Nov 05, 2007 at 08:44:21AM +0100, Torsten Brumm wrote: Hi Emmanuel, try the following ideas. 1. After creating the normal Ticket this creates the approval ticket with your scrip/template. Then create a second scrip which sets the normal ticket to a new status (create a new status

[rt-users] Web and Encoding on RedHat EL5

2007-11-27 Thread Emmanuel Lacour
Hi, I try to setup my RT on an ES5, all is working fine, except when I try to update fields (like queues descriptions) via the wen interface with non ascii chars. The result seems to be a mix of UTF-8 / ISO8859-1 :( Same setup worked on RH ES4. It's running with mod_perl2, DefaultCharset is ok

Re: [rt-users] Charts for custom field search

2007-11-28 Thread Emmanuel Lacour
a blank chart. I'm using RT 3.6.4. My custom field has an '_' in it. Is that the cause? Does RT 7 have chart support for custom fields? What kind of Database? If Oracle, DBIx::SearchBuilder 1.50 fixes this. -- Emmanuel Lacour Easter-eggs 44-46 rue de

Re: [rt-users] Charts for custom field search

2007-11-28 Thread Emmanuel Lacour
On Wed, Nov 28, 2007 at 08:41:27PM +0530, Terence Monteiro wrote: Hi Emmanuel, I'm running debian etch and using mysql 5.0.41-Debian_1. Ok, so it's another problem. Do you have the correct information in the table under the blank chart? -- Emmanuel Lacour

Re: [rt-users] How to Configure RT_MAILGATE with MS Exchange 2007

2007-11-28 Thread Emmanuel Lacour
, then configure an smtp like postfix on the RT box to handle those mails and deliver them via rt-mailgate. -- Emmanuel Lacour Easter-eggs 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 41 35 00 76

Re: [rt-users] Integration

2007-11-29 Thread Emmanuel Lacour
On Fri, Nov 30, 2007 at 01:56:41AM -0500, Edward Kovarski wrote: Has anybody done any integration between RT and a billing system? We have been approached at looking at the feasibility of integrating it with Dynamics GP (Great Plains) and I wanted to see if anybody has any experience

[rt-users] HasRight called with no valid object

2007-11-30 Thread Emmanuel Lacour
Ehlo, I have this curious message when running the follwing script on rt 3.6.3/RH4/Oracle9/DBIx::SearchBuilder 1.49 (with patch groupclause): [crit]: HasRight called with no valid object (/pkg/rt/rt/lib/RT/Principal_Overlay.pm:321) It happen many times for SetPrivileged(0), but at the end, the

Re: [rt-users] Web and Encoding on RedHat EL5

2007-12-02 Thread Emmanuel Lacour
On Tue, Nov 27, 2007 at 04:21:00PM +0100, Emmanuel Lacour wrote: Hi, I try to setup my RT on an ES5, all is working fine, except when I try to update fields (like queues descriptions) via the wen interface with non ascii chars. The result seems to be a mix of UTF-8 / ISO8859-1 :( Same

Re: [rt-users] Web and Encoding on RedHat EL5

2007-12-02 Thread Emmanuel Lacour
On Sun, Dec 02, 2007 at 04:17:29PM +0100, Emmanuel Lacour wrote: After configuring fastcgi instead of mod_perl2, it works :( So I will continue investigate with mod_perl2. I can't find the source of this problem, so I will continue using fastcgi, sorry for mod_perl2

Re: [rt-users] Web and Encoding on RedHat EL5

2007-12-02 Thread Emmanuel Lacour
, in /etc/sysconfig/httpd: export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 export NLS_NCHAR=AL32UTF8 -- Emmanuel Lacour ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT

Re: [rt-users] HasRight called with no valid object

2007-12-03 Thread Emmanuel Lacour
On Fri, Nov 30, 2007 at 10:14:27AM +0100, Emmanuel Lacour wrote: Ehlo, I have this curious message when running the follwing script on rt 3.6.3/RH4/Oracle9/DBIx::SearchBuilder 1.49 (with patch groupclause): [crit]: HasRight called with no valid object (/pkg/rt/rt/lib/RT

Re: [rt-users] struggling a bit with RT

2007-12-05 Thread Emmanuel Lacour
On Wed, Dec 05, 2007 at 09:36:49AM +0100, Emmanuel Lacour wrote: On Tue, Dec 04, 2007 at 05:34:02PM -0500, Jesse Vincent wrote: Roy, Issue #1 trying to create CF's with a date popup calendar. Any docs/examples/hints Unfortunately, RT doesn't currently

Re: [rt-users] struggling a bit with RT

2007-12-05 Thread Emmanuel Lacour
on the eventually list. I'm interested too here for a date customfield. I will try to make a patch soon. -- Emmanuel Lacour ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up

Re: [rt-users] fastcgi setup (debian, rt3.6, apache2

2007-12-21 Thread Emmanuel Lacour
On Fri, Dec 21, 2007 at 04:49:04PM -0500, Tom Vier wrote: I'm trying to use libapache2-mod-fcgid (debian apparently has a problem libapache2-mod-fastcgi != libapache2-mod-fcgid install libapache2-mod-fastcgi, and it should works ;) ___

Re: [rt-users] method for adding LDAP users to their queues before they have logged on

2008-01-09 Thread Emmanuel Lacour
On Wed, Jan 09, 2008 at 12:20:23PM +, Tom H wrote: Hi, I have the LDAP overlay working fine with LdapAutocreateAuthCallback, and once my users have logged in I can add them to their groups and give them permissions. However the problem I have at the moment, is that I want to add

Re: [rt-users] Ticket history and Website issue

2008-01-16 Thread Emmanuel Lacour
On Wed, Jan 16, 2008 at 01:49:10PM +0100, Wendler, Jürgen wrote: Hello Folks, I'm running RT 3.6.1-4 on a Debian Etch Linux with Apache2 with mod_perl2 and mysql 5 and it showas a strange behaviour. I got a Ticket where the History isn't shown on the Web Site. I had a similar

Re: [rt-users] How to change mail sender address in envelope

2008-01-16 Thread Emmanuel Lacour
On Wed, Jan 16, 2008 at 07:41:33PM +0100, Michal Rybarik wrote: Hi, some mailservers don't accept emails from our RT. This is caused by sender address in outgoing mail envelope, which is [EMAIL PROTECTED] (apache is web server and equinox.eccenet.sk is server hostname). This mail address

Re: [rt-users] RT log has wrong timezone

2008-01-16 Thread Emmanuel Lacour
On Wed, Jan 16, 2008 at 01:45:01PM -0600, Karl Boyken wrote: I think I've seen this mentioned somewhere, but I can't find it, so--the time stamp in our RT logs appears to be GMT, even though I've set the Timezone to our timezone in RT_SiteConfig.pm. The web interface presents everything

Re: [rt-users] CF type for dates or timestamps

2008-01-16 Thread Emmanuel Lacour
On Wed, Jan 16, 2008 at 05:44:03PM -0700, Ole Craig wrote: It would be Really Nice(tm) to have a timestamp or date type for custom fields that allowed the same comparison operations as RT's built-in date fields (Created, Resolved, Updated, etc) and translated (as the builtins do) to/from

Re: [Junk released by User action] Re: [rt-users] Disable Auto reply message for a group

2008-01-17 Thread Emmanuel Lacour
On Thu, Jan 17, 2008 at 08:48:45AM -0800, Sean McCreadie wrote: Kenn, Thanks for the tip on those actions, I didn't think about that before. I guess im still a little stuck on this because I need to be able to disable the Autoreply action for only those members of my RT group called

Re: [rt-users] MessageBox size

2008-01-17 Thread Emmanuel Lacour
On Thu, Jan 17, 2008 at 02:11:46PM -0800, Kenneth Crocker wrote: Drew, What are the resulting differences between HARD and SOFT? http://www.idocs.com/tags/forms/_TEXTAREA_WRAP.html ___

Re: [rt-users] RTFM Install Problem - not sure what to do

2008-01-18 Thread Emmanuel Lacour
On Fri, Jan 18, 2008 at 08:54:21AM -0800, Greg Evans wrote: I am trying to get RTFM 2.2.1 installed and when I do the very first thing it says perl Makefile.pl this is what is returned. I am not sure what $RT::LocalPath even is or even how to define it. If someone could be so kind as to tell

Re: [rt-users] RTFM Install Problem - not sure what to do

2008-01-19 Thread Emmanuel Lacour
On Fri, Jan 18, 2008 at 12:36:31PM -0800, Greg Evans wrote: I had tried that previously and forgot to put that in my last message. Here are the results when I do that. I looked at /opt/rt3/lib and I didn't see $RT::LocalPath defined anywhere in there. It should be defined in RT.pm: ex:

Re: [rt-users] Simple Question: CustomField of Type SelectOneValue /How to get the Description from a Scrip/Template?

2008-01-21 Thread Emmanuel Lacour
FirstCustomFieldValue in lib/RT/Record.pm to understand it. -- Emmanuel Lacour Easter-eggs 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 41 35 00 76 mailto:[EMAIL PROTECTED] -http

[rt-users] Oracle 9 and Build.html performance

2008-01-21 Thread Emmanuel Lacour
for any help :) -- Emmanuel Lacour ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly

Re: [rt-users] Simple Question: CustomField of Type SelectOneValue /How to get the Description from a Scrip/Template?

2008-01-21 Thread Emmanuel Lacour
have access to description in this kind of object (RT::ObjectCustomFieldValue) :( No more idea :-/ -- Emmanuel Lacour ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support

Re: [rt-users] disable autoreply on one queue only?

2008-01-22 Thread Emmanuel Lacour
On Mon, Jan 21, 2008 at 09:40:51PM -0500, Elijah Wright wrote: Hi, we need to do a bulk import of some emails into tickets, but we want to not flood the original requestors with ticket generation autoreplies. I see that we can disable autoreply by removing the global scrip that does that;

Re: [rt-users] Searches.... and CurrentUser

2008-01-22 Thread Emmanuel Lacour
On Tue, Jan 22, 2008 at 09:22:32AM +0100, Ham MI-ID, Torsten Brumm wrote: Hi RT List, I remember some weeks ago a bigger threat regarding searches with CurrentUser inside. Today i tried to create a global SavedSearch like this: AdminCc.Name = '__CurrentUser__' AND ( Status = 'new' OR

Re: [rt-users] Oracle 9 and Build.html performance

2008-01-22 Thread Emmanuel Lacour
On Mon, Jan 21, 2008 at 07:51:11PM +0300, Ruslan Zakirov wrote: I'm not that good in oracle's optimizer, but I'm pretty sure that the following index will help you: CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'), Instance); Can you add it, generate plan again and sent it to

Re: [rt-users] Oracle 9 and Build.html performance

2008-01-22 Thread Emmanuel Lacour
On Tue, Jan 22, 2008 at 01:16:26PM +0100, Joop wrote: Emmanuel Lacour wrote: SQL set autotrace on SQL CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'), Instance); Index created. SQL execute dbms_utility.analyze_schema( 'RT', 'estimate'); Any particular reason to run

Re: [rt-users] Email notification On Resolve if CF value is

2008-01-22 Thread Emmanuel Lacour
On Tue, Jan 22, 2008 at 01:40:43PM -0300, [EMAIL PROTECTED] wrote: Hi guys, We are looking for a script that triggers and email notification to an address if a Ticket is resolve with a CF specific value. CF name is Billable, and status will be YES. Anyone deal with this request? Not

Re: [rt-users] API $user-create problems

2008-01-25 Thread Emmanuel Lacour
On Thu, Jan 24, 2008 at 03:29:16PM +0100, Krieg, Alexander wrote: Hi, i just created a script to add existing users to existing groups, that works fine. I also can create queues, groups and set rights for all of them. But i cannot create a simple user and find him than over the web-gui,

Re: [rt-users] Set Requestor using current users

2008-01-25 Thread Emmanuel Lacour
On Wed, Jan 23, 2008 at 03:58:32PM -0500, Keith wrote: Still evaluating RT for use in my office and trying to figure out if it can do something our current Ticket software does. Our users aren't going to be using RT to log tickets themselves. They'll either send tickets in by email or call

Re: [rt-users] CF : Comboxbox dynamic content

2008-01-25 Thread Emmanuel Lacour
On Wed, Jan 23, 2008 at 04:03:00PM +0100, Horst Kriegers wrote: Hi all, I'm (very, very) new RT user and don't find the answer to solve my problem. I hope anyone can help me. 2 Custom Fields - combobox The first combobox contains 2 values The values displayed on the second combobox

Re: [rt-users] change date format in query results

2008-01-25 Thread Emmanuel Lacour
On Thu, Jan 24, 2008 at 04:00:00PM -0500, Steve Holmes wrote: Greetings, I want to change the date format (for Due) in the search results page such that it doesn't display the time. I.e. I want something like: Tue Jan 22 2007. I'm sure that if I can find the relevant source code snippet I

Re: [rt-users] RT 3.6.5 and Non LDAP users

2008-01-28 Thread Emmanuel Lacour
and create an aproval for this. -- Emmanuel Lacour Easter-eggs 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 41 35 00 76 mailto:[EMAIL PROTECTED] -http://www.easter-eggs.com

Re: [rt-users] Possible browser-dependent Stylesheet problem between 3.6.3 and 3.6.5

2008-01-28 Thread Emmanuel Lacour
On Wed, Jan 09, 2008 at 09:00:04AM -0800, Mike Friedman wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 9 Jan 2008 at 09:22 (+0100), Emmanuel Lacour wrote: On Tue, Jan 08, 2008 at 04:20:10PM -0800, Mike Friedman wrote: One of our RT systems here was just upgraded from 3.4.5

Re: [rt-users] Seeing approvals

2008-01-30 Thread Emmanuel Lacour
an ETA? Is there another mechanism I could use to make this function happen? There is an example in the wiki covering exactly this behaviour: http://wiki.bestpractical.com/view/ApprovalCreation - Group Approvals -- Emmanuel Lacour Easter-eggs 44-46 rue

Re: [rt-users] Seeing approvals

2008-01-30 Thread Emmanuel Lacour
)rejected (with comments), etc. Of course, it requires an AdminCc to oversee it, but the basic design is there AND the ticket numbers tay the same (great for auditability). Pretty interesting, I will look at your doc :) -- Emmanuel Lacour Easter-eggs 44-46

Re: [rt-users] making 3.6 look like 3.4

2008-01-31 Thread Emmanuel Lacour
On Thu, Jan 31, 2008 at 11:37:17AM -0500, Tom Vier wrote: Is there an easy way? I prefer the old color scheme. In your RT config: Set($WebDefaultStylesheet, '3.4-compat'); -- Emmanuel Lacour Easter-eggs 44-46 rue de l'Ouest - 75014 Paris - France

Re: [rt-users] FW: Seeing approvals

2008-02-01 Thread Emmanuel Lacour
On Thu, Jan 31, 2008 at 04:31:16PM -0800, Roger Mastrude wrote: It's true that the Wiki article has a solution to just this problem, but does that solution work? Emmanuel, have you seen this work? I have tried both giving a group rights to the Approvals queue and giving the grouups rights

Re: [rt-users] Show RealName

2008-02-02 Thread Emmanuel Lacour
On Sat, Feb 02, 2008 at 10:12:58PM -0500, Roy Sowa wrote: I am trying to show the RealName of the requestors and Cc's on the ModifyPeople page in the Current Watcher Area. I have tried editing a local ShowUserEntry, but this did not change things. Can anyboby point me what files I should

Re: [rt-users] Show RealName

2008-02-03 Thread Emmanuel Lacour
On Sun, Feb 03, 2008 at 07:55:37AM -0500, Roy Sowa wrote: Thank you Emmanuel RealNames now showing ps: I also have used your patch to allow calendar pop-up for custom date fields. Working very well. Just wanted to say thanks for helping a novice. You're welcome ;)

Re: [rt-users] Is RTFM compatible with RT 3.6.6?

2008-02-06 Thread Emmanuel Lacour
On Wed, Feb 06, 2008 at 12:07:31PM +, Paul Goffin wrote: I've just tried to install RTFM 2.2.1 into a fresh RT 3.6.6 installation and everything seemed to work except it doesn't seem to have had any effect on the 3.6.6 system. Yes it is, we use it here without trouble. Did you fully

Re: [rt-users] How to determine RTFM version?

2008-02-08 Thread Emmanuel Lacour
On Fri, Feb 08, 2008 at 09:38:03AM -0500, Jason Fenner wrote: I have a quick question that I hope someone can assist me with. We have been using RTFM with our RT installation for quite some time. Recently, I went to check what version of RTFM we were running. I can't seem to be able to

Re: [rt-users] Why Resolve + Comment?

2008-02-09 Thread Emmanuel Lacour
On Fri, Feb 08, 2008 at 06:12:10PM +, Jean-Sebastien Morisset wrote: Hi everyone, I have a small problem with my users... One of them will take ownership of the ticket, work the problem, choose 'Resolve' and write what they did in the text box. This means the requestor doesn't see the

Re: [rt-users] Log in Issues.

2008-02-09 Thread Emmanuel Lacour
On Fri, Feb 08, 2008 at 10:18:50AM -0800, aeternaleto wrote: I am have some difficulties staying logged in as root with Rt Tracker. I have tried googling my problem but can't seem to find a resolution. I am running Gentoo and my browser (Firefox) has been set to accept all cookies Dear

Re: [rt-users] Custom date field search

2008-02-09 Thread Emmanuel Lacour
On Fri, Feb 08, 2008 at 10:51:17PM -0500, Roy Sowa wrote: I have created custom date fields of the format ( -mm-dd ). I would like to create a saved search that would return tickets with upcoming dates less than X days from now. the relational syntax Due ' +5 Days'

Re: [rt-users] Custom date field

2008-02-09 Thread Emmanuel Lacour
On Sat, Feb 09, 2008 at 08:51:16AM -0500, Roy Sowa wrote: Yes , I am using your calendar patch on this serverI just tried the same type queries on my older (unpatched ) box and I am having the same issue.ie: 'now + 5 Days' or 'now' , works with the standard Due date, but not CF date

Re: [rt-users] Searching CF Date field using relative (ie: now + Days)

2008-02-09 Thread Emmanuel Lacour
On Sun, Feb 10, 2008 at 08:52:01AM +0300, Ruslan Zakirov wrote: it's never been working for CFs, only for standard ticket's dates. I thought my patch was enough, but not. I think it requires also to patch the DB schema and some other CF libs to add DATETIME field for ObjectCustomFieldValues

Re: [rt-users] Searching CF Date field using relative (ie: now + Days)

2008-02-11 Thread Emmanuel Lacour
On Sun, Feb 10, 2008 at 11:19:53AM +0300, Ruslan Zakirov wrote: I havn't seen the patch. http://rt3.fsck.com/Ticket/Display.html?id=8721 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help:

Re: [rt-users] RT Reporting - We need your wishlists

2008-02-15 Thread Emmanuel Lacour
On Thu, Feb 14, 2008 at 09:52:52AM -0500, Jesse Vincent wrote: Hi Everybody, I have an RT hacker working on a new, expanded reporting tool for RT. While I can't promise that we'll implement _every_ report you want, we could really use your wishlists. What reporting and statistics do

Re: [rt-users] Getting E-mail from an Imap server?

2008-02-20 Thread Emmanuel Lacour
On Wed, Feb 20, 2008 at 02:48:43PM -0500, Jeffrey Lee wrote: Hi everyone, Is there a simple e-mail setup that will grab e-mails from an imap server an put them into RT? you can use fetchmail which supports imap as well as pop. http://fetchmail.berlios.de/

Re: [rt-users] Disappearing Transactions

2008-02-22 Thread Emmanuel Lacour
On Thu, Feb 21, 2008 at 12:22:19PM -0500, Mathew Snyder wrote: Thanks all. I moved Quoted.pm out of that directory and all of the transactions reappeared. Latest release should theoritically solve this problem. ___

Re: [rt-users] rtx-shredder timeout error when deleting tickets via web ui

2008-02-22 Thread Emmanuel Lacour
On Thu, Feb 21, 2008 at 08:46:06PM -0300, Alex Moura wrote: Greetings, For instance, if we use the RTx-Shredder WebUI (RT v3.6. ) to wipeout only 10 tickets, it locks the sessions and gives a timeout error message in the Apache 1.3.x log: -

Re: [rt-users] finding out the version of an old copy of RT?

2008-02-25 Thread Emmanuel Lacour
On Mon, Feb 25, 2008 at 12:34:01PM +1100, Carl Brewer wrote: I have a mysqldump of an old rt3 instance that I need to bring back to life, but I don't know what version it was dumped from, and not surprisingly a few things don't work - like seeing ticket contents, for example! And

Re: [rt-users] Missing take link for some users

2008-02-25 Thread Emmanuel Lacour
On Sun, Feb 24, 2008 at 07:18:25PM +, Keith Edmunds wrote: Do they have the OwnTicket right for that queue? Yes, the user (for testing purposes) has full rights. Maybe those users have different RT at a glance than global RT at a glance. Look at the query used in his RT at a glance,

Re: [rt-users] Oracle 9 and Build.html performance

2008-02-27 Thread Emmanuel Lacour
On Sun, Feb 24, 2008 at 11:57:46PM +0300, Ruslan Zakirov wrote: Hello, guys. Privet Ruslan ;) (and thanks for commiting my patches in svn :)) I'm reviewing this again after receiving new info from various sources. 1) People say that our function based indexes are incorrect, instead of

Re: [rt-users] Oracle 9 and Build.html performance

2008-02-27 Thread Emmanuel Lacour
On Wed, Feb 27, 2008 at 04:41:55PM +0300, Ruslan Zakirov wrote: Privet. I will be near request-tracker.ru on saturday, flying to Tomck :) Oracle doesn't want to build plan I want it to build :(. I still believe it should use different way. I hope you'll help me by providing more explains

Re: [rt-users] Recommended upgrade method to 3.6.6?

2008-03-18 Thread Emmanuel Lacour
On Mon, Mar 10, 2008 at 02:25:20PM -0400, Phil wrote: Can I import the MySQL database from version 3.4.2 into version 3.6.6? Is the schema the same? If I do a full install of 3.6.6 and then import the MySQL database would that work? Is that recommended? Please look at README and UPGRADING

Re: [rt-users] CustomField Type Date

2008-03-18 Thread Emmanuel Lacour
On Mon, Mar 10, 2008 at 12:21:57PM -0400, Sean wrote: I've seen some mention in the archives about having a CustomField as a Date type (like the regular Dates in a ticket), but nothing plain enough for me to create such a CustomField. So the short question is: How do I make a CustomField

Re: [rt-users] Migrating from RT3.4 to RT3.6

2008-04-07 Thread Emmanuel Lacour
On Mon, Apr 07, 2008 at 11:10:45AM -0400, Jeffrey Lee wrote: Hi I am looking to migrate from 3.4 using Posgres to 3.6 mysql. Are there any instructions on migrating from 3.4 to 3.6? There is, in the README and UPGRADING files ;) For migrating from mysql to postgresql, you will find

Re: [rt-users] Upgrading from 3.4 to 3.6

2008-04-08 Thread Emmanuel Lacour
On Tue, Apr 08, 2008 at 11:55:52AM -0400, Jeffrey Lee wrote: Is there an easy way to upgrade from 3.4 to 3.6? Also is there a step by step wiki document regarding this? This is not a difficult upgrade. All the docs are in the files README/UPGRADING.

Re: [rt-users] Reminder Field

2008-04-15 Thread Emmanuel Lacour
On Mon, Apr 14, 2008 at 02:54:48PM -0400, Candelario, Bill wrote: Hello, Is there a way to use the Reminder's field, in RT 3.6, for sending out an email when that particular ticket is due? I am currently using rt-remind and it will only send out bulk reminders and I would also have to

Re: [rt-users] Dropdown lists for users only show 'Nobody'

2008-05-05 Thread Emmanuel Lacour
On Tue, Apr 29, 2008 at 05:27:16PM +0200, Quentin Garnier wrote: Hi, I'm currently in the process of upgrading our RT installation from 3.4.6 to 3.6.6, and while most of it went ok, I am faced with the weird issue mentioned in the subject. If I set IncludeSystemRights to 0, or at least

Re: [rt-users] Spreeadsheet, utf-8 and ms excel

2008-05-05 Thread Emmanuel Lacour
On Thu, May 01, 2008 at 08:29:36PM +0200, Mailing List SVR wrote: It seems that Excel doesn't use the charset header, it always import the file as Windows-1252 (on Windows). The only solution I found is to export as html entity. I tested the solution proposed here (export as html

Re: [rt-users] Spreeadsheet, utf-8 and ms excel

2008-05-05 Thread Emmanuel Lacour
On Mon, May 05, 2008 at 05:37:50PM +0200, Mailing List SVR wrote: Thanks!! You're welcome. It works just fine, I need to install spreedsheet-excel perl module too, and then change Of course, CPAN should telled you this dependency. the spreedsheet link to Results.xls, Yes, this is

Re: [rt-users] scrips with more than one transaction

2008-05-16 Thread Emmanuel Lacour
On Fri, May 16, 2008 at 10:37:51AM -0300, Alexandre de Medeiros Ribeiro wrote: Hi all, My second test doesn't work because when the transaction type is create the value of cf is null (2 diferent transactions). How can i solve this problem? Look at TransactionBatch

Re: [rt-users] RT with phone support?

2008-05-19 Thread Emmanuel Lacour
On Mon, May 19, 2008 at 09:53:47AM +0200, Ricky Jelm wrote: - one has to look up the e-mail address in another system, copy-paste it into RT (this would be a major burden and probably a no-go for RT) - minor problem, but still a problem: one has to think of deleting one's address. You

Re: [rt-users] SearchBuilder problems with sorting by Custom Fields

2008-05-19 Thread Emmanuel Lacour
On Mon, May 19, 2008 at 09:22:44AM -0700, Kenneth Crocker wrote: To all, I received a complaint from a user that his query wasn't searching by the custom field he selected, using 3.6.4. I checked it out and sure enough, it doesn't work, at all. I read thru almost 100 emails on the

Re: [rt-users] SearchBuilder problems with sorting by Custom Fields

2008-05-20 Thread Emmanuel Lacour
On Mon, May 19, 2008 at 02:34:06PM -0700, Kenneth Crocker wrote: Emmanuel, Also, was the fix to a later version of SearchBuilder? If so, I'd prefer to just upgrade the SearchBuilder rather than another whole upgrade. There is changes in RT and SearchBuilder You have to install

Re: [rt-users] RT with phone support?

2008-05-20 Thread Emmanuel Lacour
On Mon, May 19, 2008 at 09:50:37AM +0100, Kobus Bensch wrote: Hi Emmanuel I have been following this thread and would be most interested in finding out how you do that. Our setup here is: - one queue per customer (it's a choice, not necessarly the best for your needs) - modifications

  1   2   3   4   5   6   >