Topic: Pro Datable CSV Export Truncates Data
Expected behavior: CSV data export from an MDBDataTableV5 is complete (not truncated).
Actual behavior: In the specific case I'm seeing, the table looks great, and search and sort work as expected, but all 56 rows are not included in the exported CSV file. The file is truncated in the middle of the 25th row. In Excel, the resulting spreadsheet fills less than a page.
Resources (screenshots, code snippets etc.): Code fragment:
MDBDataTableV5 hover scrollX data={datatable2} searchTop searchBottom={false} exportToCSV />
Update: The problem is not a simple truncation. I was seeing other larger and smaller result sets being truncated. After removing a column that contains a relatively long string (a complete mailing address with pipe characters replacing commas), the CSV export results are complete.
Krzysztof Wilk staff commented 4 years ago
Hi!
I added a task for this issue on our board. I think that larger strings can cause a problem. We will look at it as soon as possible, thanks for the report :)
Best regards
FREE CONSULTATION
Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.
Answered
- ForumUser: Priority
- Premium support: Yes
- Technology: MDB React
- MDB Version: 4.27.0
- Device: Mac
- Browser: Safari & chrome
- OS: MacOS
- Provided sample code: No
- Provided link: No