Export more than 1000 rows via the client (Export Data)

[Dekker (Marco Aschwanden)]

This is a noob question: How can I export more than 1000 records via the tryton client at once?

I installed trytond_country and also imported the zip codes for FR, GB, DE.
I created a country search (for FR, GB, DE) and switched to the related ZIP which showed the first 1000 records of the 95K records.

How can I (a user) export all these 95K records via the ‘Export Data’ tool? Or is the export limited to the maximal row settings of the client?

Thanks in advance,
Marco

[sergyo (Sergio Morillo)]

@Dekker

How can I (a user) export all these 95K records via the ‘Export Data’ tool? Or is the export limited to the maximal row settings of the client?

You can increase the rows client limit in the application menu (the Tryton icon on top-left corner).
But I do not recommend you to increase it for getting the 95K records at once due to performance issues.

[Dekker (Marco Aschwanden)]

I feared to hear that answer! But it is how it is…

Thanks for the quick response!

Kind regards,
Marco

[pokoli (Sergi Almacellas Abellana)]

@sergyo

But I do not recommend you to increase it for getting the 95K records at once due to performance issues.

I think we should someway support this kind of export as there should be no issues to browse such amount of records on server side.

[ced (Cédric Krier)]

Indeed except on very low memory hardware (client or server side), this should work if the user waits few seconds.

[Dekker (Marco Aschwanden)]

Exports should work as passthrough - no representation needed in the client - it makes sense to only render 1000 or so rows. But as I can see… only the selected rows will be exported. If only 1000 rows (or as set in preferences) can be selected in the client, it won’t be possible to export more. Except you add checkbox or something that says: Export all found records (instead of selected). I don’t know tryton well enough to know how to “solve” this issue.
Thanks for your thoughts,
Marco

[ced (Cédric Krier)]

@Dekker

I don’t know tryton well enough to know how to “solve” this issue.

As @sergyo said, you can adapt the limit to your need case by case.

[josesalvador (José Salvador)]

@pokoli

I think we should someway support this kind of export as there should be no issues to browse such amount of records on server side.

I agree and…

@Dekker

Exports should work as passthrough

…this sounds good…

[sergyo (Sergio Morillo)]

@Dekker

Except you add checkbox or something that says: Export all found records (instead of selected).

That makes sense to me and many users in our projects request an option in this way.

[albert (Albert Cervera i Areny)]

@sergyo

That makes sense to me and many users in our projects request an option in this way.

+1. It is an often requested feature.

[ced (Cédric Krier)]

@ced

As @sergyo said, you can adapt the limit to your need case by case.

This can be done on the ir.action.act_window with the limit field.

[ced (Cédric Krier)]

For the record: in Issue 9090: Add export CSV route - Tryton issue tracker I added an option to ignore the search limit when doing an export.

[lb1975]

Hi,

Is it working with SAO client ?
If it’s the case where can i find an example of the usage of this “limit” field ?

Tks,
Laurent

[ced (Cédric Krier)]

The export dialog build the export URL and if you choose the “Listed Records” as export, there is a “Ignore search limit” checkbox that can be activated.

[lb1975]

Great tks for the quick answer !