Modify PowerShell script to upload all Folders and Files to a Sharepoint Library

Question

I would like to modify the Powershell Script found at the following site:

https://gallery.technet.microsoft.com/Tool-to-upload-files-ba0273ee

I would like to upload all Folders, subfolders and files it finds at a specific source on local drive to the Document Library.

And specifically into a folder names: Resources

Local path: C:\Main\Resources

SharePoint online library (for example) :

https://company.sharepoint.com/sites/Company-Public

Within the Documents folder, there is a folder called Resources

I would like to upload all Files and Folders from C:\Main\Resources to that Resources folder on the SharePoint Online site.

Answer 1

I'm recommending to you, use SharePoint Migration tool from Microsoft. You can simply and effectively migrate FileSystem, SharePoint 2013 to SharePoint Online.

Answer 2

For PowerShell solution, you could check the script shared by Romeo Donca.

<#
DESCRIPTION
This script can be useful to update a specific field on a library located on a Sharepoint Online tenant
You need to know 5 mandatory parameters: 
    - url_sharepoint         : the URL for root site collection
    - library                : the name of the destination library
    - url_site               : the relative path of the site

CopyRight
This script can be used as it is or can be changed based on your needs. For more details please feel free to contact me
Romeo Donca, February 2017
[email protected]
http://www.romeodonca.ro
#>

param(
[Parameter(Mandatory=$true,HelpMessage="The root site collection URL")][string]$url_sharepoint,
[Parameter(Mandatory=$true,HelpMessage="The relative path for the site site URL ___ /sites/subsite")][string]$url_site,
[Parameter(Mandatory=$true,HelpMessage="The name for the library")][string]$library
)
$t1  = get-date
$source_folder = ((new-object -com Shell.Application).BrowseForFolder(0, "Select the source folder", 0, "")).Self.Path
$source_folder
$url = $url_sharepoint+$Url_site

cls
Add-Type -Path "your_path\Microsoft.SharePoint.Client.dll" 
Add-Type -Path "your_path\Microsoft.SharePoint.Client.Runtime.dll" 
Import-Module MSOnline
$global:cred1 = Get-Credential
$clientContext = New-Object Microsoft.SharePoint.Client.ClientContext($url)
$cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($cred1.username, $cred1.Password)  
$clientContext.Credentials = $cred
$web = $clientContext.Web
$clientContext.Load($web)
$clientContext.ExecuteQuery()
($web.Lists).Count
$mylist = $web.GetList($url+"/"+$library)
$clientContext.Load($mylist)
$clientContext.ExecuteQuery()
###################### get folders existing  in the SOURCE
$directories= @()
foreach ($file in (Get-ChildItem  -Recurse -Path $source_folder -Attributes Directory))
{
    ($file.FullName.ToLower()).replace($source_folder.ToLower()+'\','')
    $directories +=($file.FullName.ToLower()).replace($source_folder.ToLower()+'\','')
}
foreach ($directory in $directories)
{
    $myfolder = $mylist.RootFolder
    $clientContext.Load($myfolder)
    $clientContext.ExecuteQuery()
    $myfolder = $myfolder.Folders.Add($directory.split('\')[0])
    $clientContext.Load($myfolder)
    $clientContext.ExecuteQuery()
    for ($i = 1; $i -le ($directory.split('\').Count-1) ; $i++)
    { 
        #$directory.split('/')[$i]
        $myfolder = $myfolder.folders.Add(($directory.split('\'))[$i])
        $clientContext.Load($myfolder)
        $clientContext.ExecuteQuery()
    } 
}
cls
$t1  = get-date
$i=1
$count = ((Get-ChildItem -File  -Recurse -Path $source_folder) | Measure-Object -Property FullName ).Count
foreach ($file in (Get-ChildItem -File  -Recurse -Path $source_folder))
{
    $t01  = get-date
    $url_dest = $url_sharepoint+$Url_site+'/'+$library+(($file.FullName.ToLower()).Replace($source_folder.ToLower(),'')).Replace('\','/')
    $FileStream = New-Object IO.FileStream($File.FullName,[System.IO.FileMode]::Open)
    $FileCreationInfo = New-Object Microsoft.SharePoint.Client.FileCreationInformation
    $FileCreationInfo.Overwrite = $true
    $FileCreationInfo.ContentStream = $FileStream
    $FileCreationInfo.URL = $url_dest
    $Upload = $mylist.RootFolder.Files.Add($FileCreationInfo)
    $listItem = $upload.ListItemAllFields
    $listItem['Title']=($file.Name).split('.')[0]
    Write-Host " Uploading file $i/$count $url_dest"
    $listItem.update()
    $clientContext.Load($Upload)
    $clientContext.ExecuteQuery()
    $t02  = get-date
    $speed ="{0:n2}" -f ($file.Length/($t02-$t01).TotalSeconds/1mb)
    Write-Host "...................upload speed was " $speed " MB/sec"
    $i++
}
$t2=get-date
$size = "{0:n2}" -f (gci -path $source_folder -recurse | measure-object -property length -sum).sum
cls
$speed ="{0:n2}" -f ($size/($t2-$t1).TotalSeconds/1mb)
Write-Host "Medium upload speed was " $speed " MB/sec"