We’re currently working on transforming some fields on our items and item org units, and as part of our validation process, we want to export everything to ensure the updates were applied correctly.
However, when trying to export, it appears to max out at 100,000 records. We’re trying to understand if this limit is imposed by Nextworld or if there might be a CSV bug?
Has anyone else run into this, or does anyone know what might be causing the export to stop at 100k?
In the Data Export Definition record, there are Export Options. One of these options is Max Rows Per Run. The default is 100K. Change that value to change the number of rows in the output file.
This also may be the list view export to CSV (not through Data Export Definitions). In that case, we limit it to 100k records per export. Larger exports can go through Interactive Reports (from the “Report Quick Start” form action on every list view), which has a 10 million record limit when exporting to CSV.