Home > Forum > General > Migration of SharePoint List data to Webcon

Migration of SharePoint List data to Webcon
0

Hello,

Is it possible to programmatically migrate SharePoint list data to a Webcon BPS dictionary using PowerShell, especially if the fields in both systems are identical.
or if not, is it possible to migrate just by exporting SharePoint list data to Excel then import it on Webcon dictionary?

Let me know if there are other recommended method to do this and the steps.

Thanks in Advance.

MVP

Hi,
In case of dictionaries i think the easiest way would be using Excel Import/Export it's described here:
* https://community.webcon.com/posts/post/dictionary-processes/112/3

In case of large dictionaries i would consider using API to create those entries, the process would be very similar to one I've written about in my blog post:
* https://blog.lumenn.pl/importing-data-to-webcon-3/

In reply to: Maksymilian Stachowiak

Hi,
In case of dictionaries i think the easiest way would be using Excel Import/Export it's described here:
* https://community.webcon.com/posts/post/dictionary-processes/112/3

In case of large dictionaries i would consider using API to create those entries, the process would be very similar to one I've written about in my blog post:
* https://blog.lumenn.pl/importing-data-to-webcon-3/

Hi Maksymilian and Daniel, thanks for the answers.

For the programatic approach which is by creating a script that exports the data from SharePoint and uses REST API to make an API call to Webcon for data import. Is this possible and is there a documentation for this on how to achieve it. It's ok if there is none, I just want to know whether this is possible or not.

Thanks again,

MVP
In reply to: S Blue

Hi Maksymilian and Daniel, thanks for the answers.

For the programatic approach which is by creating a script that exports the data from SharePoint and uses REST API to make an API call to Webcon for data import. Is this possible and is there a documentation for this on how to achieve it. It's ok if there is none, I just want to know whether this is possible or not.

Thanks again,

Hi,

besides the swagger site there's the developer site with an example on how to start an instance.
https://developer.webcon.com/docs/basic-operations

I can also recommend this PowerShell module, I use it a lot to read /write data to Excel. It's really great because it doesn't use Excel.
https://github.com/dfinke/ImportExcel

You can also take a look at the following repositories:
The official repository with an application to import data. I have never used it.
https://github.com/WEBCON-BPS/RestApi-DataImporter/tree/main

Maks repository:
https://blog.lumenn.pl/importing-data-to-webcon-3/

My repository which uses the Excel PowerShell module and some other WEBCON REST API
https://github.com/Daniel-Krueger/webcon_playwright/blob/iteration3/PowerShell/UtilityFunctions.psm1

Best regards,
Daniel