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.

Stefan Helzle · Accepted Answer

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

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

Harsha Sharma · Answer

Functionality wise, the plugin supports to read data from document without involving database. For example, all these functions can read and return the excel data in an expression rule which can be used to render data in the grid. 
 
 Read Excel File Paged 
 Read Excel Cell by Name 
 Read Excel Cell by Number 
 Read Excel By Headers 
 
 Depending on your need and load expectations, you can design the app to read data directly from document or db.

Mike Schmitt · Answer

rohithy954798 said: readcsvlogtoCDT() 
 I'm not sure this is actually in *Excel Tools* (if so it's not in a version I can check), but also, the functions named like "read CSV log ..." are specifically geared to reading one of the Appian system's Log files, and can't be fed a user-uploaded file under any circumstances.

Plugins for CSV import

Top Replies