[otrs] Retrieving information from Surveys

2010-01-12 Thread Arpit2 G
Hello All, Is it possible in otrs to generate a report based on survey statistics. My aim is generate survey report according to the queue. Thanks & Regards Arpit Gupta ESM Sub Focus Area, TEG Open Source Platform Tata Consultancy Services Cell:- 91-9769256991 Mailto: arpit...@tcs.com Website: ht

Re: [otrs] Oracle database backend

2010-01-12 Thread Michiel Beijen
Hi Jose, Can I ask what Perl version you are using? You can check that via the Support module. Regards, -- Michiel Beijen R&D OTRS AG Norsk-Data-Str 1. 61352 Bad Homburg Germany T: +31 (0) 6457 42418 F: +49 (0) 9421 56818-18 I: http://www.otrs.com/ Business location: Bad Homburg, Country Cou

[otrs] Frontend::Customer::Auth Digest::MD5

2010-01-12 Thread Sagy Volkov
Hi, I need to get OTRS (2.4.5) to somehow change the method in Frontend::Customer::Auth to support another option, (not just plain,MD5, crypt) but also support Digest:: MD5, i.e. use Digest::MD5 qw(md5_hex); my testpass=md5_hex("password"); I know in terms of security its less secured, but becau

Re: [otrs] Tickets ReOpening

2010-01-12 Thread Nils Leideck - ITSM
Hi, On 13.01.2010, at 00:37, Christopher Ross wrote: > Is there any way to disable the reopening of tickets by email once they are > already closed? There are people at the place that I work that forget to > remove the system address from the CC when closing out a ticket and therefore > it jus

Re: [otrs] Restricting Agent login to a found AuthModule::LDAP::GroupDN

2010-01-12 Thread Nils Leideck - ITSM
Hi Dant, On 12.01.2010, at 23:35, Dan Trainor wrote: > My question is, however, can I use AuthModule::LDAP::GroupDN more than once? > If you're still following me, I'd like to use AuthModule::LDAP::GroupDN once > for each AD group present, so I don't need to maintain a separate list of > grou

[otrs] Tickets ReOpening

2010-01-12 Thread Christopher Ross
Is there any way to disable the reopening of tickets by email once they are already closed? There are people at the place that I work that forget to remove the system address from the CC when closing out a ticket and therefore it just reopens the ticket again. I don't want to remove the autofill CC

[otrs] AuthModule::LDAP::AccessAttr not being overridden

2010-01-12 Thread Dan Trainor
Hello again - I've learned that Active Directory has no 'member' attribute (well, its blank by default) that OTRS tries to look for as a search filter when authenticating groups for my Agent. I'm familiar with the AuthModule::LDAP::AccessAttr setting, however when this is set to: $Self->{'A

[otrs] Restricting Agent login to a found AuthModule::LDAP::GroupDN

2010-01-12 Thread Dan Trainor
Hi, all - I think I'm wandering down the right path here, but I thought I'd ask, in an attempt to not get lost too much. I've managed to integrate OTRS with Active Directory, and that works (sort-of) alright. It needs some polishing, but the functionality is there. I've created Roles in OT

[otrs] Oracle database backend

2010-01-12 Thread Jose Luis Spahr
Hi List, Is anyone using Oracle as the backend database? I am having problems with the Stats module/icon under the Agent login site. This is the error I get: Software error: Can't locate object method "GetObjectName" via package "Kernel::System::Stats::Static::StateAction" at ../..//Kernel/Syste

Re: [otrs] Stuck in Time Accounting

2010-01-12 Thread Timothy J. Deerinck
Marco, Yes it does solve the problem, but if you look at that solution, it says he was the lonely admin. If a user does not have another admin account, the method I described will at least let them remove the time accounting loop to fix things! ~Tim From: Marco Vannini [mailto:marco.vann...@

Re: [otrs] Stuck in Time Accounting

2010-01-12 Thread Timothy J. Deerinck
Gordon, It will work to correct the problem. Look at step 2 carefully. Do not click on ANYTHING but the "Setting" link on the right side of the tool bar. ~Tim From: Gordon O'Brien [mailto:gordon.obr...@mediasquare.co.uk] Sent: Tuesday, January 12, 2010 2:01 AM To: User questions and discussio

Re: [otrs] Converting from MySQL to MS SQL 2005

2010-01-12 Thread mono...@gmx.net
http://www.golem.de/1001/72356.html 2010/1/12 Brad Gayler > *I am wanting to convert working OTRS database from MySQL on one server > to SQL database (MS SQL 2005) on another server.* > > *I am sure this has been done before. Could someone steer me in the right > direction as to where I may fi

Re: [otrs] SSL Error

2010-01-12 Thread Michiel Beijen
Hi Boyd, This confuses me a little. Could you please explain when exactly the issues with LDAPS started? When you switched to ActiveState or when you switched mod_perl on? In both cases, it might still be the same issue I pointed out: mod_perl - it could be that the language environment variabl

[otrs] I will be taking off on Jan 12, 2010

2010-01-12 Thread Sri . Ramadurai
I will be out of the office starting 01/12/2010 and will not return until 01/13/2010. I will be taking off on Jan 12, 2010. On urgent SAP Production Support Issues, please call the Hotline at 408-717-8500 and cc Chiu Peng Fang. My Management delegate is Mary Tran available at 408-717-7004 All

Re: [otrs] SSL Error

2010-01-12 Thread JEWETT Boyd
Michiel, Thank you but this was not the fix for issue I'm having. Let me give a little more background to my issue. I'm using OTRS 2.4.5 on windows with ActiveState Perl 5.10.1 because I couldn't get StawberryPerl to install mod_perl. I had everything up and running just the way we wanted it

[otrs] Converting from MySQL to MS SQL 2005

2010-01-12 Thread Brad Gayler
I am wanting to convert working OTRS database from MySQL on one server to SQL database (MS SQL 2005) on another server. I am sure this has been done before. Could someone steer me in the right direction as to where I may find instructions and anything else that may be helpful? Thanks, Brad Ga

Re: [otrs] Private tickets

2010-01-12 Thread Михаил Лукин
They have admin permissions in queues which are in groups that they have rw access in. You can create your own group and queue in it, so that they can not access tickets of this queue even through the search. On Tue, Jan 12, 2010 at 12:30 AM, Gordon O'Brien < gordon.obr...@mediasquare.co.uk> wrote

Re: [otrs] Customer User Management - Multiple email Id configuration

2010-01-12 Thread Михаил Лукин
I think this could be achieved through group email addresses on your smtp server On Tue, Jan 12, 2010 at 9:48 AM, Sourabh Sarwate wrote: > Hi, > > Any one can suggest how can we can map mulitiple email id to single > customer user under - Customer User Management. > > What we want to achieve

Re: [otrs] Service and SLA

2010-01-12 Thread Leonardo Certuche
Hi Zak, Please remember to associate Customers to Services (or define default services) at http://yourserver/otrs/index.pl?Action=AdminCustomerUserService Leonardo Certuche On Mon, Jan 11, 2010 at 10:41 AM, Mohamed Zakaria < mohamedzaka...@msiships.com> wrote: > Hi, > > Is it possible to set a

[otrs] including a custom query in stats

2010-01-12 Thread Leonardo Certuche
Hi Community, Altought stats are plenty and very useful, unfortunately the available fields to include in them seem to be not enough for the reporting needs we have. That's why we decided to create our own queries which would be nice to include them as stats in order to take advantage of mkStats.p

[otrs] How to increase the limit in Customer IDs Field

2010-01-12 Thread Sourabh Sarwate
Hi All, In Company Ticket I am not able to add more than 12 CustomerIDs. Any one can guide me how I can increase this figure. -- Regards, Sourabh Sarwate Mobile No : +91-9948894587 - OTRS mailing list: otrs - Webpage: http://ot

Re: [otrs] Stuck in Time Accounting

2010-01-12 Thread Gordon O'Brien
Doh! That makes sense! Thanks Marco From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Marco Vannini Sent: 12 January 2010 10:05 To: User questions and discussions about OTRS. Subject: Re: [otrs] Stuck in Time Accounting doesn't this thread solved the problems ? for

[otrs] OTRS:Delivery Of Stats Reports on Mail

2010-01-12 Thread Gazizov Andrey
Hi Marco. You should add in cron something of it: /usr/local/otrs/bin/mkStats.pl -n 10013 -r recipi...@otrs.org -s sen...@otrs.org -m 'Last day report' -f Print where 10013 - stat number It was generate the report automatically and send it via email to recipient. Hope this helps ;-) Mar

Re: [otrs] Stuck in Time Accounting

2010-01-12 Thread Marco Vannini
doesn't this thread solved the problems ? for me yes http://www.mail-archive.com/otrs@otrs.org/msg23689.html MV On Tue, Jan 12, 2010 at 11:01 AM, Gordon O'Brien < gordon.obr...@mediasquare.co.uk> wrote: > I have this problem too. > > Your suggestions below bring back the menu bar temporarily

Re: [otrs] OTRS:Delivery Of Stats Reports on Mail

2010-01-12 Thread Marco Vannini
unfortunatly I don't have any experience with WAMP but I think that makestat.pl should run either in win. On Tue, Jan 12, 2010 at 10:23 AM, Sourabh Sarwate wrote: > Hi Marco, > > Thanks but is it possible that we can generate the report automatically by > using GenericAgent or some other util

Re: [otrs] Stuck in Time Accounting

2010-01-12 Thread Gordon O'Brien
I have this problem too. Your suggestions below bring back the menu bar temporarily but clicking of for example the Tickets menu returns me back to the Time Accounting screen. This is obviously a huge bug. I can't even get into the admin section to uninstall the module. From: otrs-

Re: [otrs] OTRS:Delivery Of Stats Reports on Mail

2010-01-12 Thread Sourabh Sarwate
Hi Marco, Thanks but is it possible that we can generate the report automatically by using GenericAgent or some other utility. I am using windows 2003 server +OTRS 2.4.5 Regards Sourabh Sarwate On Tue, Jan 12, 2010 at 2:41 PM, Marco Vannini wrote: > Hi S, > > > If you have the report ready y

Re: [otrs] OTRS:Delivery Of Stats Reports on Mail

2010-01-12 Thread Marco Vannini
Hi S, If you have the report ready you can schedule it with /opt/otrs/bin/mkStats.pl use mkStats.pl --help for usage. HTH MV On Tue, Jan 12, 2010 at 10:07 AM, Sourabh Sarwate wrote: > Hi All > > Is it possible that we can generate some daywise automatic reports say > closed and open ticket

[otrs] OTRS:Delivery Of Stats Reports on Mail

2010-01-12 Thread Sourabh Sarwate
Hi All Is it possible that we can generate some daywise automatic reports say closed and open ticket and mail it automatically on some configured id. -- Regards, Sourabh Sarwate Mobile No : +91-9948894587 - OTRS mailing list: