Why exporting to Excel is limited to 100 results?

Why exporting to Excel is limited to 100 results in the export option? Is there a way to increase this limit?

0 votes

1 answers

3533 views

ANSWER



The Excel export is limited to 100 entries because Nuxeo uses a default max page size of that size.

This value can be changed by modifying the nuxeo property called:

nuxeo.pageprovider.default-max-page-size

which can be set to a value that is more appropriate for you, e.g.

nuxeo.pageprovider.default-max-page-size=150

You can simply add that line (with an appropriate value) to your nuxeo.conf file (this file is often located in

See: Nuxeo configuration parameters

Please note that a larger value will affect the system performance, but that depends also on usage patterns in your system as well as number of records that is returned by specific queries generated from your requests).

1 votes



Page size is good when we have paging, like through the web interface, but is problematic when you want to export the data.

Could there be a way to increase only in the case of an Excel export? Could it be achieved by creating a specific action?

06/20/2012

This is a strange behavior for exporting. When we export something, we don't want a sample of it, we want everything. Is there a way to export everything?
06/22/2012

setting 0 as value, see http://doc.nuxeo.com/x/FQ4z
06/26/2012