TheDon54
Scholar

Import Excel

Hi,

 

Does anyone know how to use the Excel Import Service on the K2 Management Site? I get an error when I execute, please see images.

Thanks

 

Kind Regars

Luyanda


import_excel_3657.png
import_error_3658.png
0 Kudos
Reply
6 Replies
Dumisani
Apprentice

Re: 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

0 Kudos
Reply
TheDon54
Scholar

Re: Import Excel

Hi Dumisani,

 

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

Thanks

0 Kudos
Reply
Dumisani
Apprentice

Re: Import Excel

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

0 Kudos
Reply
lkimberly
Apprentice

Re: Import Excel

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.
0 Kudos
Reply
Widson
Apprentice

Re: Import Excel

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.

0 Kudos
Reply
TheDon54
Scholar

Re: Import Excel

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

Reply