Upload Excel file in interface and show the data in editable grid then send it to Process model

Question

HI ,

In my usecase, i have to open the interface form and upload a excel file to load data in editable grid. Then on pressing submit button the flow goes to Process model where doing some business logic inserting that data to db tbl.
I am able to display data in form after uploading and reading it from excel the problem is updating rule input cdt which is having blank values as not able to set the values read from excel to ruleinput.
.
Flow as of now PM--> Interface form--> PM  --> Same Interface form (User to view and edit data if needed the submit)-

achutaharshavardhanv6069 · Answer

There are few things to consider,

1. How big is the data coming from the excel sheet as read excel plugin costs your system to slow down.

2. Are you showing all the columns in the excel sheet , is the rows are empty or columns are empty.

what i did is

1. Created a temporary table and inserted the data into the temporary table from the excel sheet using import Excel to database plugin (might need to see in APp market). THis imports the data into the DB in seconds.

2. Then read the data from that table and show it in the editable grid. where you might have the primary keys associated with it.

3. edit them accordingly and push to the main table. Flush the temporary table if needed.

Let me know if this helps.

Sign up

Login with SSO

Login to the community

Login with SSO