Re: [otrs] respect foreign ticket IDs

2013-01-16 Thread Michiel Beijen
Hi Jan, What you're asking for is exactly what our "External Ticket Number Recognition" Feature Add-On does: http://www.otrs.com/en/software/otrs-help-desk/features/otrs-feature-add-ons/feature-add-on-external-ticket-number-recognition/ Michiel Beijen Senior Consultant OTRS BV Schipholweg 103 2

Re: [otrs] respect foreign ticket IDs

2013-01-16 Thread Jan.Dreyer
Hi Renée That sounds like a lot of magic with regexp?! I still did not understand how to do the link. I think, an example would be nice: FID = foreign ID OID = OTRS ID Example: We already received a ticket with FID 0815 and it got the OID 1234. Incoming Mail with FID 0815. PostmasterFilter:

Re: [otrs] respect foreign ticket IDs

2013-01-16 Thread Jan.Dreyer
Hello Michiel Aaaah, you are right! That sounds exactly like what I’m looking for. Let’s see if our client is willing to do a subscription then … Regards Jan Dreyer IT Administrator / Operations Team / M-IT OMS Von: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] Im Auftrag von Michiel B

Re: [otrs] respect foreign ticket IDs

2013-01-16 Thread Renee B
Hi Jan, no magic. You said in the response to Davids mail that you are able to write a script for that purpose, so you likely will be able to write a postmaster filter for that. As I said the Postmaster filters you can create via web frontend aren't suitable here. You have to create a Perl module

Re: [otrs] respect foreign ticket IDs

2013-01-16 Thread Sune T. Tougaard
Hi, I have not tried it at all for something like this, but perhaps a little creativity with the "System Monitoring" package (available from the "OTRS->Admin->Package Manager" interface) could help you along. If not, I'm sure the Add-On that Michiel mentions will fit your needs perfectly. -- /

[otrs] Cannot connect to MS SQL Database

2013-01-16 Thread Bevan Agard
Guys & Gals I need some help here. I am trying to setup OTRS ITSM to prove to my boss that it can do as good if not better job than Maximo. The problem is that they want me to set it up utilizing our existing MS SQL 2005 database. I have OTRS installed on a CentOS 6.3 server. I followed all the

[otrs] OTRS statistics with ticket owner?

2013-01-16 Thread Jurjen Verhoeff
Hi list, We use OTRS 2.4.7 We want to generate an overview with the open tickets and see who handles that ticket. - Is it possible to create a report (with the Statistics module) and have the ticketowner in the report? I do not see the ticketowner field in the selction list when creating a sta

Re: [otrs] Cannot connect to MS SQL Database

2013-01-16 Thread Gerald Young
Start here: https://www.google.com/search?q=site:forums.otterhub.org+mssql On Wed, Jan 16, 2013 at 9:28 AM, Bevan Agard wrote: > Guys & Gals > > I need some help here. I am trying to setup OTRS ITSM to prove to my boss > that it can do as good if not better job than Maximo. The problem is that

Re: [otrs] respect foreign ticket IDs

2013-01-16 Thread David Boyes
On one hand I don't like the idea of spreading this work away from the OTRS, on the other hand I _don't_ control the mail server. I _could_ do a fetchmail/procmail solution though, if nothing else works. Yeah. I would do this outside OTRS because it's really a translation function between OTRS a

Re: [otrs] respect foreign ticket IDs

2013-01-16 Thread David Boyes
http://www.otrs.com/en/software/otrs-help-desk/features/otrs-feature-add-ons/feature-add-on-external-ticket-number-recognition/ Neat! Haven’t encountered that one before. Should have figured that the OTRS folk had encountered this before... 8-) -

[otrs] Can I use multiple ACLs to remove statuses allowed in a view?

2013-01-16 Thread Bogdan Iosif
Hi, Can someone more knowledgeable please confirm the following observation about ACL behavior? In short, I unexpectedly failed to use two different ACLs to remove some allowed values in the statuses available in a given view. I'll fabricate a synthetic example to illustrate the strange behavior

Re: [otrs] Can I use multiple ACLs to remove statuses allowed in a view?

2013-01-16 Thread Gerald Young
probably. Try this. PossibleNot => { Ticket => { State => ['closed unsuccessful','pending reminder'] }, }, On Wed, Jan 16, 2013 at 11:13 AM, Bogdan Iosif wrote: > Hi, > > Can someone more knowledgeable please confirm the following observation > about ACL behavior? > > In short, I unexpectedly f

Re: [otrs] Cannot connect to MS SQL Database

2013-01-16 Thread Bevan Agard
Tried but no luck. Also this is my DSN string. $Self->{DatabaseDSN} = "DBI:ODBC:driver={mssql};server=10.5.0.46;database=otrs;uid=otrs;pwd=Password123;"; $Self->{"Database::Type"}='mssql'; $Self->{DatabaseUserTable} = 'users'; Is there something I am missing? Any guidance would be

Re: [otrs] Can I use multiple ACLs to remove statuses allowed in a view?

2013-01-16 Thread Bogdan Iosif
Thanks for the quick reply. Sure, that works, I already did it as a workaround on my prod env. Still, I'm very interested in knowing for sure if my assesment is right because I see it as a major limitation. Do you think I should ask on dev list? On Jan 16, 2013 6:36 PM, "Gerald Young" wrote: > p

Re: [otrs] Can I use multiple ACLs to remove statuses allowed in a view?

2013-01-16 Thread Gerald Young
Your assessment appears to be correct and expected. The last to match wins. On Wed, Jan 16, 2013 at 12:12 PM, Bogdan Iosif wrote: > Thanks for the quick reply. Sure, that works, I already did it as a > workaround on my prod env. > > Still, I'm very interested in knowing for sure if my assesment

Re: [otrs] Cannot connect to MS SQL Database

2013-01-16 Thread Gerald Young
https://www.google.com/search?q=Data+source+name+not+found%2C+and+no+default+driver+specified+(SQL-IM002) On Wed, Jan 16, 2013 at 11:53 AM, Bevan Agard wrote: > Tried but no luck. > > Also this is my DSN string. > > $Self->{DatabaseDSN} = > "DBI:ODBC:driver={mssql};server=10.5.0.46;database