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

Migration of SharePoint List data to Webcon

0

S Blue

15.08.2024

04:00

S Blue

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.

16.08.2024

11:44

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/

Solution (1)

Helpful (0)

Wrong answer (0)

16.08.2024

17:37

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

Solution (1)

Helpful (0)

Wrong answer (0)