Question Re: Upload CSV file in CAP JAVA, Validate rows and return... in Technology Q&A

Upload CSV file in CAP JAVA, Validate rows and return a List/ArrayList

DC — Mon, 29 Apr 2024 10:53:23 GMT

Hi Team,

We have a requirement where we need to upload a CVS file then

Validate file and content for each row. At this stage, NO DB activity needs to happen
Return a List to UI for further UI activities - we want to show users the CVS file contents in a table with values populated and any errors regarding the line shown in a column
Once user is happy, we will present a button to insert into DB

I have looked at the samples but struggling to return the list to the UI/ caller.

If anyone have some ideas, please free free to share 🙂

Please let me know if you need more information.

Cheers

skymu89 — Mon, 20 May 2024 08:15:03 GMT

Hello,

CAP Java provided Media Type Processing support

which process inputstream in the backend, you need implement other parts with custom code.

This one maybe more match your use case https://spreadsheet-importer.com/

Best regards, Sky

Marian_Zeis — Tue, 08 Oct 2024 10:21:10 GMT

Thank you @skymu89 for mentioning my open source project!