Import Excel rows to SmartObject

  • 4 March 2019
  • 6 replies
  • 285 views

I am trying to create a way to import excel row data into a K2 smartobject on K2 cloud. As I cannot create custom control features I am having a little trouble. Has anyone on Cloud been able to successfully import data from Excel into K2?

 

Thank you,

Alexandre


6 replies

Badge +5

Hey alexandremirand,

You can try using the Excel Import Service Broker from K2 Community


to read your Excel file into a SmartObject. From there, you will need to loop through each record, then call a SQL SmartObject to insert the record into your SQL database.

Please note that the service broker is not developed by K2, and is therefore not supported by K2 Support. If you need assistance on using that service broker, please post your queries on our K2 Community forum, or contact the developer of the broker directly.

Thanks,

K2Z

 

If your using K2 Cloud then the use of custom service brokers is not supported

 

I have this requirement a lot whereby I need to bulk load lots of data from excel into SmartBox objects.  I havent found an easy solution yet.

Disappointing that this or something of the like does not exist for cloud. Hopefully this is rectified in the future.  

Badge +5

Good day,


 


I apologize, I must have missed that you are on K2 Cloud in my last post. K2 is slowly adding excel functionality to Cloud as they update the product with FixPacks. They have added the ability to export to excel; however, the functionality to import excel rows to a smartobject is still being considered for a future update. 


 


Please follow this link to vote for the idea on our ideas.k2.com site:


https://ideas.k2.com/ideas/APIT-I-567


 


Thanks,


K2Z


 


 


 

Badge

how to import data from excel  to data base through out  path file ???

Badge +3

K2 doesn’t support this natively - yet. You would need to connect to a service via standard service instance types that offers this feature. for instance, It is possible to build a REST API that could return the data - or you could connect to an SQL DB and feed the file into a USP that will return it as a table.

Making this a C# or SQL challenge opens the door to many solutions when searching how to accomplish this task on those bigger platforms.

Reply