Skip to main content

Hello every one,

I am using K2 five

I have smart form contain list item view show list of employees.

I want to add an action or control that will allow me to import excel file contain data (list of employees) to my list item view and populate this data also store this data in the my database (sql server)

 

Please provide me with detailed solution 

There isn't native support for this, but one approach is detailed here:
https://community.nintex.com/t5/K2-Five-blackpearl/Excel-CSV-Import-Service-Broker/ta-p/176973

Alternatively you can write your own service (REST or WCF) that you can invoke with the spreadsheet as a parameter and do what needs to be done with it all in code. This is a bit more work but is the approach I've used in the past to have full control of the process.

You could also check out this forum thread: 



https://community.nintex.com/t5/K2-Five-Forum/Import-CSV-file-data-into-List-View/m-p/188366#M6759


Reply