List Manager Support

List Manager support
Public write access is disabled. Please login

Require a filter before exporting 21.10.2015 21:04

Is it possible to require a user to filter a list before being able to export?
I have more than 30K records and if they export the entire list, it times out. I would like to limit them being able to do that.

Re: Require a filter before exporting 22.10.2015 11:56

there is no configuration parameter for that purpouse. We think forcing a filter won't fully solve your problem because user can launch a filter that can exclude for ex just 100 or 200 records, thus not avoiding the mass export and your server timeout.
We suggest another approach instead, a good guess of how many records user is trying to export is the number of total pages * the number of records per page being shown, so you could add a simple js tweak with a limit on this number. This would be the code:

var numrecords=LMJQ("[id$='porpag']").val()*LMJQ("[id$='pagtotales']").html();
alert("Your message here");
return true;

You can change the 1000 limit for the number of records you prefer

This tweak can be included at the beginning of the functions of the export buttons you're using


LMJQ('..........exportexcelfiltered').click(function(e) {

//the code here

LMJQ('..........exportpdffiltered').click(function(e) {

//the code here

LMJQ('............exportrtffiltered').click(function(e) {

//the code here


It will restrict the filtered export to the number of records you configure, hope this will do the work for your case.

Moonsoft Team
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Our clients' feedback