RE: [otrs] IIS and MS SQL setup

2005-04-14 Thread Parent, Cyrille
Yes I know but we already have the licensing for MS SQL/ IIS and the State has some policies and standards that “highly recommend” using the MS products already installed. From the documentation, it looks like IIS should not be a problem provided I load perl etc… Now for MS SQL, I seem to

RE: [otrs] IIS and MS SQL setup

2005-04-14 Thread Parent, Cyrille
Merci Olivier. J'ai utilise l'installer Win32 (pour mes tests) - ca marche bien J'ai vu une option pour ODBC dans le config.pm ou default.pm alors je pensais essayer ca pour MS SQL. Je me demandais si qq'1 l'avait deja fait. Je vais essayer, on verra bien :) Cyrille -Original Message-

[otrs] add FAQ html or plaintext ?

2005-04-14 Thread aloclarit
I noticed that the FAQ editor seems to accept some kind of html/plaintext mixture. It accepts {enter} as a newline whereas a browser ignores {enter} and requires instead. OTRS also accepts and other html code. The problem I'm facing is this : When I create html docs using an html wysiwyg edit

Re: [otrs] IIS and MS SQL setup

2005-04-14 Thread Olivier
Hi, I don't think it's a big prob to use it with iis > juste add the php possibilities. But mssql... i would like to say no, because i think instructions in otrs ask mysql only... If you want to use otrs on a M$ platform, with don't you try otrs4win32 ?? hope this help, Olivier Parent, Cyrille a

RE: [otrs] IIS and MS SQL setup

2005-04-14 Thread Pete McDonnell
If telling your boss about all the licensing costs which will be incurred (SQL, Windows etc) doesn't change his mind, you may wish to discuss the fact that there is an entire community (and a commercial organization!) supporting the product on MySQL and Apache.  Come to think of it, would on

[otrs] IIS and MS SQL setup

2005-04-14 Thread Parent, Cyrille
Hi, Just found out about OTRS yesterday and loaded it on a test box. The boss loves it and wants it in production ASAP to replace our less-than-perfect current solution. My problem: he wants it on IIS with MS SQL on the back-end (separate servers). Is anyone on the list doing it that way

Re: [otrs] sort order of the QueueView

2005-04-14 Thread amg-1
Thanks, Graeme, will do. - Original Message - From: "Graeme Brough" <[EMAIL PROTECTED]> To: "User questions and discussions about OTRS." Sent: Thursday, April 14, 2005 10:51 AM Subject: Re: [otrs] sort order of the QueueView Hi Alain, I will need to have another look at our code. If I

Re: [otrs] POP Filter matching question

2005-04-14 Thread Greg Bolshaw
On 14 Apr 2005, at 16:53, User questions and discussions about OTRS. wrote: I tried to use the POP filter mechanism like this: Match: Header1: Subject; Field: *snom190* Header2: Body; Field: *snom190* This won't work. The match fields accept regular expressions, not wildcards. Try something l

[otrs] POP Filter matching question

2005-04-14 Thread Sven Fischer
Hi, I tried to use the POP filter mechanism like this: Match: Header1: Subject; Field: *snom190* Header2: Body; Field: *snom190* Set: Header1: X-OTRS-Queue; Field: support::phone-support::snom190-queue But with this filter set, the pop is failing at all, so no mail is coming in, but the log sa

Re: [otrs] sort order of the QueueView

2005-04-14 Thread Graeme Brough
Hi Alain, I will need to have another look at our code. If I don't get back to you by mid next week send me an email direct, to remind me. Regards, Graeme amg-1 wrote: > I replaced the two lines with the three you provided, and I have > DefaultQueueSortOrder defined in Config.pm as you sugg

Re: [otrs] sort order of the QueueView

2005-04-14 Thread amg-1
I replaced the two lines with the three you provided, and I have DefaultQueueSortOrder defined in Config.pm as you suggested previously, but this results in no messages being shown at all, regardless of which queue I look at. :-( Restoring the original two lines makes the messages reappear. Ar

Re: [otrs] CustomerID change

2005-04-14 Thread Ritme Informatique
Hi, I think the best way would be to use directly an UPDATE mySQL statement. See the mysql documentation for that. Regards 2005/4/14, Sergey Smirnov <[EMAIL PROTECTED]>: > Hello All, > > Recently, our company migrated to new email addresses, and we > would like to change old customer IDs by ne

[otrs] CustomerID change

2005-04-14 Thread Sergey Smirnov
Hello All, Recently, our company migrated to new email addresses, and we would like to change old customer IDs by new ones. In fact, all we need is just to replace the email domain address of each CustomerID in OTRS database. Is there any script or tool we could use for that? Thank you for any he

Re: [otrs] locked ticked

2005-04-14 Thread Rudolf Harney
Hi, I am not sure, if that's what You need: We had the problem, that all agent sould be able, to answer all follow up tickets. So I created a sub-queue of the standard queue and threw all locked tickets in there. Our agents always answer their tickets with "waiting for successfull close+". If a cu