Articles in this section

Walkthrough - Migrate to a new folder in your OneDrives with PowerShell

Updated
Follow

When you migrate to multiple OneDrives with a foreach loop statement, there is no way to create a folder through the ShareGate Desktop commands in PowerShell.

You can however create a new folder in all your OneDrives before you run your PowerShell migration.

Note: With these instructions, you will create a CSV list of all your OneDrives. You can then reuse that same CSV list for your OneDrive migration.

Index

Prerequisites

Note: You will need to be Site collection admin on each OneDrive even if you have higher admin privileges. You will use SharePoint admin or Global admin permissions to apply the Site Collection admin permissions as you create a folder in each OneDrive. We do not go through the process of removing the Site collection admin permissions in this guide as you will use the Site collection admin permissions during your migration.

Script preparation

Create a folder on your local drive and a CSV list of all your OneDrives with the following steps:

  1. On your local drive, create a new folder.
  2. Name the folder as per your preference in your OneDrives (i.e. C:\Migrated data).
  3. Note of the path of the folder.
  4. In ShareGate Desktop go to All reports.
  5. Click on Create custom report in the top right corner.
  6. Select OneDrive for Business one-drive.png as your object type.
  7. Click Continue without saving.
  8. Select your tenant.
  9. Click on Run.
  10. Select all your OneDrives with the checkmark box at top of the list.
  11. Click mceclip0.png Edit in the quick actions menu.
  12. Select Add administrators in the Transformations dropdown.
  13. Search and add your account in the Select user or group field that appears.
  14. Click Apply.
  15. Click Back two times to get back to the your report results.
  16. Click on Export in the top right corner.
  17. Save the file on your drive.
  18. Open the report in Excel.
  19. Add the title ONEDRIVEURL to the first column.
  20. Save this new file as a CSV on your drive (i.e. C:\foldermigration.csv).
  21. Note the path of the CSV file.

Create your script

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

$csvFile = "C:\foldermigration.csv"
$table = Import-Csv $csvFile -Delimiter ","
$MyPassword = ConvertTo-SecureString "My password" -AsPlainText -Force
$MyUsername = "My username"
Set-Variable dstSite, dstList
foreach ($row in $table) {
    Clear-Variable dstSite
    Clear-Variable dstList
    $dstSite = Connect-Site -Url $row.ONEDRIVEURL -UserName $MyUsername -Password $MyPassword
    $dstList = Get-List -Name Documents -Site $dstSite
    Import-Document -SourceFilePath "C:\Migrated data" -DestinationList $dstList
}

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 items in a row. 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 and $MyUsername: Replace "My password" and "My username" by your matching Microsoft 365 credentials.
  • 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.
  • -SourceFilePath: Replace "C:\Migrated data" with the path of the folder you created at step (2).
  • Remove-SiteCollectionAdministrator: Removes your user account as site collection administrator on the OneDrive after its migration.

Run your script once it is property adjusted and tested.

Once the folder is added to all the OneDrives, add -DestinationFolder "Migrated data" to the copy line of your OneDrive migration script (Replace "Migrated data" by the name of the folder you created).

For example, the copy line could look like this in your migration script:

Import-Document -SourceFolder $row.DIRECTORY -DestinationList $dstList -DestinationFolder "Migrated data"

Related articles