Walkthrough - Import from Box.com to OneDrive for Business with PowerShell

Use PowerShell to automate your Box.com to OneDrive for Business migration.

Note: You can migrate the content of your user's root folder in Box.com, but not the folder itself. If you want to migrate the Box.com content in a separate folder in OneDrive for Business, you will have to create that destination folder first.

Index

•  Prerequisites
• Assign yourself as Site Collection administrator on all your OneDrives
• Create your script

Prerequisites

• Global Administrator or SharePoint Administrator permissions required.

• You authorized ShareGate Desktop in Box.com.

• Your OneDrives have been provisioned.

  • This can be automated with the Get-OneDriveURL cmdlet.

Note: You 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 Site collection admin permissions on all your OneDrives and then remove the Site collection admin permissions as you migrate each Box.com account.

Assign yourself as Site Collection administrator on all your OneDrives

1. Open ShareGate Desktop.
2. Go to All reports.
3. Click on Create custom report in the top right corner.
4. Select OneDrive for Business as your object type.
5. Click Continue without saving.
6. Select your tenant.
7. Click on Run.
8. Select all your OneDrives with the checkmark box at top of the list.
9. Click  Edit in the quick actions menu.
10. Select Add administrators in the Transformations dropdown.
11. Search and add your account in the Select user or group field that appears.
12. Click Apply.

Create your script

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

Import-Module Sharegate
$box = Connect-Box -Email admin@enterprise.com -Admin
$users = Get-BoxUsers -Box $box
$myusername = "myusername"
$mypassword = ConvertTo-SecureString "mypassword" -AsPlainText -Force
$tenant = Connect-Site -Url https://mytenant-admin.sharepoint.com -Username $myusername -Password $mypassword
foreach ($user in $users) {
    If ($user.Status -ne 'inactive') {
        $dstSiteUrl = Get-OneDriveUrl -Tenant $tenant -Email $user.Email
        $dstSite = Connect-Site -Url $dstSiteUrl -Username $myusername -Password $mypassword
        $dstList = Get-List -Site $dstSite -name "Documents"
        Import-BoxDocument -Box $box -DestinationList $dstList -UserEmail $user.Email
        Remove-SiteCollectionAdministrator -Site $dstSite
    }
}

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

• $box: Replace the email by your Box.com admin email.
• $myusername: Replace "myusername" by your Microsoft 365 account user name.
• $mypassword: Replace "mypassword" by your Microsoft 365 account password.
• $tenant: Change the URL to match your tenant's admin center.
• foreach: Used to loop through a set of values. In this case, all the commands between the foreach brackets will be repeated for each user in your Box.com account.
• Connect-site: If you need to change the authentication method, you will find how to do it in the Connect Site article.
• Remove-SiteCollectionAdministrator: Removes your user account as site collection administrator on the OneDrive after its migration.

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