Plugins for CSV import

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.

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).

You are right readExcelSheetPaging() i was referring to.

Mike Schmitt said:

  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).

Excited to use if available as plugin.

To clarify, the parser I'm building is just for my application using OOB functionality + existing plug-in functionality.  The function itself seems to be included in Excel Tools also, even though the plug-in page does not seem to advertise the existence of any such function.  But it is mentioned on the plug-in's informational read-out in Admin Console:

To clarify, the parser I'm building is just for my application using OOB functionality + existing plug-in functionality.  The function itself seems to be included in Excel Tools also, even though the plug-in page does not seem to advertise the existence of any such function.  But it is mentioned on the plug-in's informational read-out in Admin Console:

Thanks! Good to know.