Articles in this section

Walkthrough - Import Files to OneDrive for Business with PowerShell

Updated

Use PowerShell to automate your file share to OneDrive for Business migration.

Index

Prerequisites

Create a CSV guide for your migration

  1. Generate a list of the names of all the directories contained in the DOMAIN folder using this script:
    dir –Directory Z:\ -Name | Out-File C:\MigrationPlanning\onedrivemigration.csv
    Note: You have to replace the paths with your own.
  2. Open the CSV file generated from the script in Excel.
  3. Insert a new row at the top of the results for the headers.
  4. Name the first column DIRECTORY.
  5. Insert the mapped drive letter before the names of the directories in your columns (i.e.: Z:).
  6. Open ShareGate Desktop.
  7. Go to All reports.
  8. Click on Create custom report in the top right corner.
  9. Select OneDrive for Business one-drive.png as your object type.
  10. Click Continue without saving.
  11. Select your Tenant.
  12. Click on Run.
  13. Click on Export in the top right corner.
  14. Save the file on your drive, and open it.
  15. Replace the Site address header by ONEDRIVEURL.
  16. Combine the two spreadsheets so that each directory corresponds the the correct URL in your rows.Create csv file for OneDrive for Business Migration Note: If sorting alphabetically doesn't work, you can reorganize your data manually or you can look for a solution with macros or PowerShell.
  17. Save this new file as a CSV on your drive.

Create your script

Copy and paste the following script in the PowerShell application of your choice.

Import-Module Sharegate
$csvFile = "C:\MigrationPlanning\onedrivemigration.csv"
$table = Import-Csv $csvFile -Delimiter ","
$mypassword = ConvertTo-SecureString "mypassword" -AsPlainText -Force
Set-Variable dstSite, dstList
foreach ($row in $table) {
    Clear-Variable dstSite
    Clear-Variable dstList
    $dstSite = Connect-Site -Url $row.ONEDRIVEURL -Username "myusername" -Password $mypassword
    Add-SiteCollectionAdministrator -Site $dstSite
    $dstList = Get-List -Name Documents -Site $dstSite
    Import-Document -SourceFolder $row.DIRECTORY -DestinationList $dstList
    Remove-SiteCollectionAdministrator -Site $dstSite
}

Adjust your script so that it will work for you. Here are a few guidelines:

  • $csvFile: Adjust the path so that it points to the CSV file you saved before.
  • $table: The delimiter is the symbol your CSV uses to separate your column items. Make sure your script uses the same delimiter as your file (a quick way to verify this, is by opening the CSV with Notepad).
  • $mypassword: Replace "mypassword" by your Office 365 admin account password.
  • $dstSite: Replace "myusername" by your Office 365 admin account user name.
    • Connect-site: If you need to change the authentication method, you will find how to do it in the Connect Site article.
  • Set-variable and Clear-Variable: These commands help prevent an issue where a connection failure can cause your data to end up in the wrong OneDrive. If you have to use the browser connection method, you will have to remove these lines.
  • foreach: We use foreach to loop through the values in your CSV file. You can find more about it here.
  • Add-SiteCollectionAdministrator and Remove-SiteCollectionAdministrator: Adds your user account as site collection administrator before your migration, and removes it after.

Run your script once it's property adjusted and tested.

Notes:

Comments

8 comments

Sort by Date Votes
  • Avatar
    Dorje McKinnon

    This is a useful start - what would be great is some other examples for other scenarios e.g. incremental update ?

    1
    Comment actions Permalink
  • Avatar
    Alex

    Hello Dorje,

    Thank you so much for the feedback. It is a great idea - we are looking into ways we can improve our PowerShell documentation with more step-by-steps! In the meantime, we think the New Copy Settings and Incremental Update articles will help.

    Have a great day!

    0
    Comment actions Permalink
  • Avatar
    Ginkel van, Marcel

    I know it is possible to add a time filter with Sharepoint migration, but it also possible to add a time filter for onedrive migration within the Powershell script mentioned above?

    0
    Comment actions Permalink
  • Avatar
    Alex

    Hello Marcel!

    Yes, you can, you'll want to use the New Property Template script. 

    Example:

    $propertyTemplate = New-PropertyTemplate -AuthorsAndTimestamps -VersionHistory -Permissions -WebParts -NoLinkCorrection -FlattenFolders -VersionLimit 5 -CheckInAs Publish -ContentApproval SameAsCurrent - From YYYY-MM-DD -To YYYY-MM-DD

    Hope that helps!

    0
    Comment actions Permalink
  • Avatar
    Knibbe, Erik

    Hello Alex,

    We use this script to import the home-folders from our users to OneDrive for Business.

    But we want to skip certain folders inside the home-folders. So, for each home-folder I cycle through all subfolders, selecting which to copy and which not. Then I use this line:

    $Result = Import-Document -SourceFolder "$SourcePath" -DestinationList $DstList -DestinationFolder "$DstFolder" -CopySettings $CopySettings -InsaneMode

    As you can see I added the option -DestinationFolder "$DstFolder"

    This returns the message "The folder X/ does not exist in the destination."

    That's correct, but it has to be created. Unfortunately, I didn't find an option to force that.

    So, my question is: Is there an option to create a folder that doesn't exist in the destination?

    Thanks in advance for your answer!

    Erik Knibbe

     

    0
    Comment actions Permalink
  • Avatar
    Alex

    Hey Erik!

    We are not aware of an option for that! If you do end up finding a workaround, please feel free to share it.

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Amit Patel (Edited )

    Hello Erik

    Did you ever find a solution for this (to create a new folder for each user)?  It looks like SPMT provided by Microsoft has the ability to create folder on the fly during the migration.  I ran into some speed issues with that so have started to look at ShareGate but I'm surprised that ShareGate doesn't natively support this.

    One way I found (probably not the most elegant) is by using the SharePoint online module:

    Install-Module SharePointPnPPowerShellOnline

    $mypassword = ConvertTo-SecureString "Admin Pwd" -AsPlainText -Force
    $mycreds = New-Object System.Management.Automation.PSCredential ("Admin User", $mypassword)
    Connect-PnPOnline -Url https://ORDCODE-my.sharepoint.com/personal/user_1_domain_com/ -Credentials $mycreds
    Add-PnPFolder -name NewFOlder -folder "Documents"

     

     

     

    0
    Comment actions Permalink
  • Avatar
    Knibbe, Erik

    Hello Amit,

    Thanks for your answer!

    We didn't found a solution. Our dirty work-arround is to copy all folders, en tell the users that they can safely remove the special folders that aren't used. ;-)

    Maybe the SharePoint module would have worked, but for now we already started the migration.

    Greetings!

    Erik

    1
    Comment actions Permalink

Please sign in to leave a comment.

Related articles