Import Excel

Good day LuyandaDaki,

Please see the following link:https://community.k2.com/t5/K2-Five/Import-excel-file/td-p/112542

Let me know if this is of help

Kind regards 

Dumisani

Hi Dumisani,

I saw that post, however is this achievable on K2 Management site?

Thanks

Hi LuyandaDaki,

When asking whether is this achievable from K2 management site are you referring to that this can be achieved by using the K2 management site only?

If so the answer is no because an application database in SQL Server is kindly required to host the stored procedure.  

Could you please elaborate further on the question of is this achievable in the K2 management site.

Best regards,

Dumisani

Hi  @TheDon54 ,

It might be helpful to enable SmartObject logging and then inspect the ServiceBroker logs to see if there is detailed information regarding the error. You may refer to the instructions on the KB article: https://help.k2.com/kb000298. 

Regards,

Kimberly 

K2 will not accept any liability for any issues arising from actions taken in respect of information provided by any forum member.

Hi  @TheDon54 ;

I came across this read,  on how is't achievable at management site(https://k2blackbelt.wordpress.com/2018/01/16/how-to-get-smartobject-data-into-excel/),  i hope it helps someone ou there!

-Widson.

Hi All,

I figured it out, on the SmartObject Service Tester, I created an Excel Import Service SMO and added a button to import. On the rules I call the Excel Import Service SMO and in the Input I passed the SmartObject name (you have to type it for it to work e.g Excel_import_Service_SMO, yours will not look like mine) then drag the File attachment. Done!!!

Thanks

Regards

L