Re: [otrs] Dynamic Fields... direct access in the DB

2016-06-10 Thread Olivier Macchioni
On 10 Jun 2016, at 14:59, Olivier Macchioni <olivier.macchi...@wingo.ch> > wrote: > > Hello Renée, > > Thank you for your idea. > > This is definitely an option - I could even create this table automatically > at the beginning of my SQL query using WITH > <

Re: [otrs] Dynamic Fields... direct access in the DB

2016-06-10 Thread Olivier Macchioni
d_value) with > unique (field_id, field_key) > * change the backend module for Dropdown fields where the possible values are > stored to the new table (every time the dynamic field is changed) > * use that new table in the SQL query > > - Renée > > Am 10.06.2016 um 14:13 schrieb

[otrs] Dynamic Fields... direct access in the DB

2016-06-10 Thread Olivier Macchioni
Hello dear list, I’m trying to export a list of tickets directly from the OTRS DB - I’m computing 20 columns, there are 7 joins… the request is not that small… And it takes approx. 50 seconds to generate 5’000 rows I need. Knowing that I will eventually need to export much more than 5’000

Re: [otrs] Adding custom columns in TicketOverviewSmall - OTRS 3.3

2014-03-10 Thread Olivier Macchioni
On Mar 6, 2014, at 08:19, Mathias Braeunling mathias.otrsmailingli...@gmail.com wrote: Hi, a bit tricky in my case because the data is stored in an external DB. Olivier or you might store this information (customer language) directly in a dynamic field, which you can then display in

Re: [otrs] Adding custom columns in TicketOverviewSmall - OTRS 3.3

2014-03-05 Thread Olivier Macchioni
in an external DB. Olivier On Mar 4, 2014, at 20:24, Olivier Macchioni olivier.macchi...@wingo.ch wrote: Hello dear list, There are to a few web pages describing how to add custom Columns in TicketOverviewSmall - for instance http://techiesfromthecradle.blogspot.ch/2012/08/customizing

[otrs] Adding custom columns in TicketOverviewSmall - OTRS 3.3

2014-03-04 Thread Olivier Macchioni
Hello dear list, There are to a few web pages describing how to add custom Columns in TicketOverviewSmall - for instance http://techiesfromthecradle.blogspot.ch/2012/08/customizing-otrs-list-views.html This doesn't seem to be applicable any more with OTRS 3.3 - the file has completely

[otrs] Adding filters in the AgentTicketQueue

2014-02-16 Thread Olivier Macchioni
Hello dear List, Today, the AgentTicketQueue allows to sort tickets by various columns (Age, Ticket Number, State, ...) - I've added some more columns for our own needs (Customer Language for instance). I wonder if it's possible to add the option to Filter the tickets depending the value in

Re: [otrs] Adding more fields to the table users / user_preferences with an LDAP integration

2013-10-01 Thread Olivier Macchioni
Thank you Gerald, For what it's worth, I've implemented a simple Perl script to do this synchronization LDAP - DB. Olivier On Sep 23, 2013, at 17:33, Gerald Young wrote: AuthSync doesn't handle additional fields. On Mon, Sep 23, 2013 at 11:18 AM, Olivier Macchioni olivier.macchi

[otrs] Adding more fields to the table users / user_preferences with an LDAP integration

2013-09-23 Thread Olivier Macchioni
Hello dear list, I'm using an LDAP integration for the AuthSyncModule For reporting reasons, I'd like to add one more information in OTRS - the Agent's departmentNumber, which is of course stored in LDAP. I tried adding it to AuthSyncModule::LDAP::UserSyncMap:

Re: [otrs] Auto-Answer for phone and API-generated tickets?

2013-07-31 Thread Olivier Macchioni
behavior. Met vriendelijke groet / Gruß / Best Regards, Jurjen Verhoeff ___  Please consider the environment before printing this e-mail -Oorspronkelijk bericht- Van: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] Namens Olivier

[otrs] Auto-Answer for phone and API-generated tickets?

2013-07-30 Thread Olivier Macchioni
Hello dear OTRS user list, Our problem is the following: If the customer opens a ticket via e-mail, we want to notify him that we have received his mail and that we are going to process it. If the we open a ticket via any other method (New phone ticket or using our company's My account

[otrs] Multi-level tickets classification?

2012-10-09 Thread Olivier Macchioni
Hello, I need to classify my tickets based on a multi-level tree - I actually have 3 levels, for instance: Customer / Shipment / Not delivered Customer / Shipment / Broken Customer / Payment / Invoice not received Customer / Payment / Invoice dispute Supplier / Goods reception / Quality Problem

[otrs] Automatically filtering tickets based on Customer properties?...

2012-04-24 Thread Olivier Macchioni
Hello List, My customers are stored in a DB, and they all have a state ('lead', 'active_customer', 'former_customer', ...). OTRS is linked to this DB, and he knows about their states because I've added a customer field - I've used this method:

[otrs] Delegating the management of Response Templates

2011-12-13 Thread Olivier Macchioni
Hello, I'd like to delegate the management of Response Templates - typically editing those templates - to one of our Agents. Is there a way to do so without granting him full Admin rights? Thanks, Olivier - OTRS mailing list:

Re: [otrs] Problem with IE8 - 'CKEDITOR' is undefined

2011-06-24 Thread Olivier Macchioni
or so? And could it be that they can't resolve the value you have set for Core::FQDN over DNS? Still. I would say it's not a great error message... -- Mike On Thu, Jun 23, 2011 at 21:14, Olivier Macchioni olivier.macchi...@wingo.ch wrote: Hello All, Some of my users are reporting

[otrs] Problem with IE8 - 'CKEDITOR' is undefined

2011-06-23 Thread Olivier Macchioni
Hello All, Some of my users are reporting an error with IE8 on OTRS 3.0.6 when trying to answer to a ticket: Détails de l’erreur de la page Web Agent utilisateur : Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152;

[otrs] Managing customer languages

2011-05-02 Thread Olivier Macchioni
Hello dear list, We're providing support in a multi-lingual area. What can OTRS offer us in terms of language management for customers? I'm specifically interested in the following questions: - is there a specific way to link customers to languages? (we're using an external customer DB) -