Forum Discussion
Automatic Data import
Hi Florent SEGUI,
There are many ways to do this. Do you want to ijmport the data from the external sources or do you want to reference the data.
You could use external lists using the BDC/BCS to talk to your databases. Please be aware of this in Office 365. I've seen very poor performance on very wide tables.
You could use an import scripts (PowerShell could do this for you).
If you want to go for a coding solution then you could access your data maybe through web services.
Alternative option of course are creating a SharePoint Add-in or maybe even the new SPFx could be of some help.
Hello Pieter,
Thanks for your quick reply.
We have a CRM that can export automatically the datas into csv or txt format.
So I think I'd go for the import solution from external source.How to proceed?
I've exlcuded BCS as the CRM database has already some slowness.There might be a better way as you could let CRM do the update work. I could imagine creating a CRM module doing the work. I'm not 100% sure about the options available in CRM but I guess this could be a workflow in CRM doing the update work in SharePoint.
If you have the csv files ready already. then you could read these files using PowerShell and then update SharePoint. Personally I like the PnP PowerShell options available. https://github.com/SharePoint/PnP-PowerShell.
With these commands it is quite easy to create items in SharePoint and/or update them. How are your Powershell skills? I would expect that developing these scripts as somethign that is produciton ready could take a few days.
- For the CRM, I have to contact the software company developping it to check if something already exist.
As for my powershell skills, they are a bit rusty :) but I can try.
