Forum Discussion
dpimental
Aug 11, 2021Copper Contributor
Automatically pull external files into Sharepoint folder
My company has a process that produces reports pulled from MySQL / Sql Server databases and the files are written to a local drive of a server. We need to pull those reports into a SharePoint Folder. I know we can't use a mapped drive, as Microsoft does not support this and also the account won't stay logged in.
What are my best options to automate this process?
- PowerShell can be used to upload files into a SharePoint folder. You could create a script and run it on a schedule to do this. I have an example script for uploading files on my blog
https://steveknutson.blog/2021/03/16/migrating-m-files-to-sharepoint/
The other option would be to Sync the SharePoint library using OneDrive and copy the files into the local (sync'd) folder for the library.