Solved

Export from SO and importing data into SharePoint List

  • 9 April 2020
  • 2 replies
  • 20 views
J

Hi,

 

I have created a smartobject directly from K2 designer, which has a few hundred rows of data in.

I have a corresponding SharePoint list that will miror this data set, but wanted to know how I can get all the rows of data from the K2 SMO into the SP List SO.

 

Is there a way to export all rows out  of one k2 SM and then import (create items) into another via csv etc?
Or would the way to be to put a workflow on the K2 SO and then get it to scan through the K2 SM and create new item in the SP list?

 

Scratching my head on this one as a newbie.

 

Thanks, Julie :-)

 

 

 

 

 

icon

Best answer by khanh1 9 April 2020, 17:16

View original

2 replies

K
Userlevel 6
Badge +16

Hi JulieBird,


 


Perhaps, you can try the following approaches.


 


Option 1: Use the K2 Odata Feed in K2 Five 5.2 or later with Microsoft Excel to export the records and you can later migrate data from CSV file to Sharepoint. 


https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#How-Tos/ODataFeedService/ODataFeedWithExcel.htm


https://sharepointmaven.com/3-ways-import-excel-sharepoint/


Option 2: Build a List view from the SmartObject and use the Excel control to export the data to csv file. After that you can migrate the data to SharePoint list.


https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#Create/Views/ConfiguringExportToExcel.htm?Highlight=excel%20control


 

J

Many Thanks, Perfect :-)

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings