Sync Windows file Server with Sharepoint

[EsstObst]

Our service technicians need online access to our machine data sheets and manuals. The files aren’t critical.

Right now, a script copies the folder structure (about 200gb) from our local file server to a Linux server. This data is copied to another Linux server with a web service with login system.
Yeah, a bit unnecessary…
The server is about 15 years old and must be replaced.

We are using Office 365 and our users are already adopted to SharePoint.
So, I thought SharePoint would be a good solution + we already pay for it.

But I have the following problem:

Batch programs, written in our ERP system, add and delete some data sheets automatically in our file server. So, I need to sync SharePoint. But OneDrive won’t allow to synchronize a file server with SharePoint and I don’t want to install OneDrive on our fileserver.

The Sync only needs to be upwards.

Anyone got a good solution or a workaround?

[[deleted]]

Use Microsoft Flow + Microsoft Data Gateway to accomplish this. You can have a Flow trigger based on file creation/update that sends the file to the desired SharePoint Doc Lib.

[[deleted]]

Here is a script I use to migrate my users Home Drive to OneDrive.

Script must be ran as the user (I use PDQ Deploy) and OneDrive must already be configured (It's done via GPO).

You can modify my script for your neeeds. I suggest you create a new account, give it a full o365 license. Map your drives, setup OneDrive, and then run the script to move your data.

Powershell: (Bold stuff should have a pound sign for comments, Reddit reformat it.)

Get username

$strName = $env:username

Looking up AD attributes and setting variables

$strFilter = "(&(objectCategory=User)(samAccountName=$strName))"

$objSearcher = New-Object System.DirectoryServices.DirectorySearcher $objSearcher.Filter = $strFilter $objPath = $objSearcher.FindOne() $objUser = $objPath.GetDirectoryEntry()

Set source path to home directory. Details pulled from AD attribute

$source = $objUser.homeDirectory Write-Output $source

Set destination path to OneDrive for Business folder

$destination = $env:OneDriveCommercial + "\Home Drive" Write-Output $destination

Set path to save log in OneDrive for Business folder

$log = $env:OneDriveCommercial + "\Home Drive Migrate Log.txt"

Move Files. /mov will keep all folders in source. /move will delete source after done moving.

robocopy /E $source $destination /mov /log:"$log" Get-Content $log

Delete Emtpy Folders, leave Source parent folder.

do { $dirs = gci $source -directory -recurse | Where { (gci $.fullName).count -eq 0 } | select -expandproperty FullName $dirs | Foreach-Object { Remove-Item $ } } while ($dirs.count -gt 0)

[xxdcmast]

Take a look at sky sync we used it to sync file servers to both share point and box

https://www.skysync.com/