JulieBird
Apprentice

Export from SO and importing data into SharePoint List

Jump to solution

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

 

 

 

 

 

0 Kudos
Reply
2 Replies
khanh1
Apprentice

Re: Export from SO and importing data into SharePoint List

Jump to solution

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/ODataFeedWi...


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/ConfiguringExportToExce...


 

Reply
JulieBird
Apprentice

Re: Export from SO and importing data into SharePoint List

Jump to solution

Many Thanks, Perfect :-)

0 Kudos
Reply