Plugins for CSV import

OK. Did you check the app market for any fitting plugins?

Excel Tools is what I have found so far. But from the description it looks like we have to import the file to DB and then read from table to display the grid data.

Depending on the data volume, this might be the right approach.

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.

Hi Shubham, can you share the Import CSV to Database plugin URL?

It's Same Plugin Excel Tools
https://community.appian.com/b/appmarket/posts/excel-tools

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:

Thanks! Good to know.