Plugins for CSV import

Question

Hi 
 Can I have some plugins for the following requirement, 
 
 We need to offer the user to import a CSV file and once the user uploads the file, we need to parse the data in the file and show it on a grid below. CSV file is going to follow a template with defined set of columns, the number of rows alone would vary.

Shubham Aware · Answer

There are two approaches for CSV import -> readcsvpaging() for in-memory parsing and the Import CSV to Database plugin for direct database import. Since your requirement involves a fixed template CSV with only varying row counts, I recommend using the Import CSV to Database plugin. This approach directly imports data into a temp table in a single operation, which you can then query through Records and display in a read-only grid. It's faster and more robust than in-memory processing, especially for large datasets, as it bypasses memory constraints and leverages database-level operations. Additionally, using Records as your data source automatically provides filtering, sorting, and pagination capabilities for the grid. This makes it the optimal solution for handling CSV imports with varying row counts while maintaining performance and flexibility.

Mike Schmitt · Answer

Shubham Aware said: CSV import -> readcsvpaging() 
 Are you sure this is a function within Excel Tools? I think you might be thinking of readExcelSheetPaging(). I'm currently building a CSV parser and, sadly, I had to resort to the function "previewcsvforimport()", which while similar, has less flexibility (no actual way to call it in pages, for instance).