Question

Export to CSV/Excel

0

When exporting more than 1000 rows to Excel or CSV I get the following error: Exporting more than 1000 rows is not allowed. Please use search criteria to limit the number of rows. We use only one column with the email address form all clients. This file needs to contain all email addresses as they are imported into an other application, that can not import increments. Is there a way to raise this limit?

asked 2011-03-21

Maarten van der Weijde

4 answers

Alexander Willemsen · Answer 1 · 2011-03-21

The export to Excel/CSV button has a property Maximum number of rows in the modeler. By default this value is set to 1000, but you can increase this if you want.

Note that increasing this value can also increase the memory consumption (of the Mendix server) when a user presses this button, so use with care.

Maarten van der Weijde · Answer 2 · 2011-03-22

Thanks for the quick responses.

Achiel · Answer 3 · 2011-03-21

A workaround in your case (considering it's so simple: one field) is to build a java action that simple outputs all the values to a string and then store it in a filedocument.

Michel Weststrate · Answer 4 · 2011-03-21

The excel button has a property with the maximum number of allowed rows.