topic Re: Why exporting to Excel is limited to 100 results? in Nuxeo Forum

Why exporting to Excel is limited to 100 results?

maxr_ — Tue, 19 Jun 2012 19:01:31 GMT

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

Re: Why exporting to Excel is limited to 100 results?

Wojciech_Sulejm — Wed, 20 Jun 2012 17:39:35 GMT

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 <NUXEO_HOME>/bin directory, but you can also look it up in your Nuxeo Control Panel).

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).

Re: Why exporting to Excel is limited to 100 results?

patrek — Wed, 20 Jun 2012 19:41:23 GMT

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

Re: Why exporting to Excel is limited to 100 results?

maxr_ — Fri, 22 Jun 2012 22:10:28 GMT

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?

Re: Why exporting to Excel is limited to 100 results?

Anahide_Tchertc — Tue, 26 Jun 2012 11:23:35 GMT

setting 0 as value, see http