Migration of SharePoint List data to Webcon

0

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/

I would also opt for the dictionary approach. The most important think here is to actually create a dictionary report and not a table report. Otherwise you could activate the export option but you wouldn't be able to us the import. Besides this the exported file differs also depending on the type.

I've made this error quite a few times. :)


Best regards,
Daniel

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