Import CSV file data into List View

Hello Nattapon,

The demo solution (CSV Import.kspx) references a database in SQL Server. To be able to deploy the demo solution, you'll need to:

1. Create a database in SQL Server, and create a schema for that database called "test".
2. Run the "CSV Import.sql" script file against the database created in step 1.
3. Grant the account that will be used to connect to the database "db_owner" permissions.
4. Go to K2 Management and create a new SQL Server Service Instance to connect to the database created in step 1 using the credentials that you configured in step 3. Use the details in the "SQL Server Service Instance.txt" file to register the new service instance. For more information, see the product documentation. 
5. Use Package and Deploy to deploy the "CSV Import.kspx" file. When the contents of the package has been loaded, the Service Instance will show with a red icon. Right-click on it and select "Configure". In the popup screen, in the top right-hand corner, click on the ellipses button and select the service instance that you created in step 4. Click on OK and you should be able to deploy.

I hope this points you in the right direction.

Regards,

Eugene

Hi Eugenej,

  Will i be able to use this for Excel?, I need to read  Excel cell value from the smartForm. I tried using  the similar teachnique to Convert Base64 string to plain text. But it is giving me junk value.

This approach wasnt meant to read a specific Excel cell value into a SmartForm. What this example does is to return all the rows and cells in a CSV file as a List method in a SmartObject. You'll need to code a custom web-service for the functionality that you need.