Increase Customer <-> Service page list size

Moderator: crythias

Post Reply
jbaptiste
Znuny advanced
Posts: 104
Joined: 01 Aug 2015, 03:45
Znuny Version: 6.0.x
Contact:

Increase Customer <-> Service page list size

Post by jbaptiste »

Hi,

I'm working on associating the services defined in OTRS to the customers that come from an external database. The problem is that the Customer<->Service page only list 200 customers and there are over 8 thousand. Is there a way to increase this limit ? or any other ideas on how to do this for this big amount of customers ?
Want to run OTRS on docker ? checkout my OTRS on docker HOWTO | Project's github page
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Increase Customer <-> Service page list size

Post by RStraub »

I think there's a possibility to set a default service.

If that does not help, you could try to filter the customers and add 200 per bulk.

Or you add them via script and/or API:
http://doc.otrs.com/doc/api/otrs/5.0/Pe ... ce.pm.html
see the function "CustomerUserServiceMemberAdd".

If you simply want to increase the limit, change this value:
https://github.com/OTRS/otrs/blob/maste ... Service.pm
(line 35)
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
jbaptiste
Znuny advanced
Posts: 104
Joined: 01 Aug 2015, 03:45
Znuny Version: 6.0.x
Contact:

Re: Increase Customer <-> Service page list size

Post by jbaptiste »

RStraub wrote:I think there's a possibility to set a default service.

If that does not help, you could try to filter the customers and add 200 per bulk.
The problem is that the customer<->service interface does not do any pagination, so you can only see the first 200 customers and I see no way of showing more.
RStraub wrote: If you simply want to increase the limit, change this value:
https://github.com/OTRS/otrs/blob/maste ... Service.pm
(line 35)
I tried this after I made the post and it doesn't work either, I changed the search limit to 10000 and the customer<->services page now shows 250 customers, not the search limit or a pagination button to be able to go to the next 250 customers.

I'll take a look at the API (with my almost non-existant perl skills), but as this is a one time task the search limit increase option would have been the quickest.
Want to run OTRS on docker ? checkout my OTRS on docker HOWTO | Project's github page
Post Reply