Importing PST to Office 365 Exchange online mailboxes through the new Import Service
Microsoft has decided to charge for this service (8$ for each GB) ...
Microsoft has launched a new feature that allows administrators to import PST to Exchange online directly through the portal.
In this article I'll guide you through the steps of uploading one PST file and import it to a user's mailbox. Although the steps are identical to Microsoft's TechNet article but it's more detailed and with screenshots. As I was personally reading and following the article at some point I got confused as to what which shared folder is the article speaking of and little tiny bits that are not detailed since Microsoft combines two methods in the same page "Ship data on Physical Drives and Upload files over the network"
So to achieve this, you'll have to first sign in to your Office 365 portal. Open Exchange admin center and follow the below steps:
- Granting Permission
Grant your self-importing PST permission to users by navigating to Exchange admin center -> Permissions> Double click on Compliance Management
Under Roles: click on + and add Mailbox Import Export role
Click on + Under Members and add your user account
2. `Copy Secure URL and secure storage account key
To get the Azure secure storage account key and URL you will have to go back to the Office 365 portal and then click on Import tab on the left pane
Then click on the Key sign below
When you click on it, you will be able to retrieve the key and the URL by clicking on Copy Key and URL .
The secure storage account key is pretty long and you'll have to notice that sometimes you might get confused and copy only the appearing portion of it in the field… if you do so and copied that in the Azcopy command or Azure storage explorer you might get an error …
Here's my Secure Storage account key that I am using on a trial version of Office 365.
Next: Copying the URL.
The URL has an important part which you will be using in Azure Storage Explorer tool in order to login and browse your Tenant's storage which you'll use to upload PST to.
The URL will appear as following.. You will need to copy the part in bold
You have to copy this in to the storage account name
3. Copying PST files to Azure Folder using Azcopy command or Azure Storage Explorer (You can use Azure Storage Explorer too)
In order to upload PST files to Azure, you have two methods. The first is using Azcopy command which is pretty easy and straightforward (but still CMD dependent) or you can use the GUI Application which is Azure Storage explorer
To download azcopy, you can use the following link
Or download them from the Import page as well under Resources:
Once the tool is installed. Right click on it and open it as administrator
The following command will take all the files inside my local folder path C:\Users\Mohammed\Desktop\upload
It will create a folder in Azure's default folder ingestiondata called "Server01/PSTshareR1/"
It will use the destkey that I have retrieved from Office 365 Import window. And will leave all the logs in your local drive c:\PSTupload\Uploadlog.log
AzCopy /Source:C:\Users\Mohammed\Desktop\upload /Dest:https://d49d7ae0e38a4d8e9c93565.blob.core.windows.net/ingestiondata/SERVER01/PSTshareR1/ /Destkey:KA9Z00rEYa1JlqGE4wO222MnsN5ywT0elOgLeNht/fSMIJPe2134hEChuuDJ5mfdknq8ts0+cez6uUvFzcQd6g== /S /V:C:\PSTUpload\Uploadlog.log
To make sure that files are uploaded. I will open Azure Storage Explorer 6 (Preview) and click Add Account on top
On add storage account window I will use the blob name that I have got from the URL earlier and storage secure key in the storage account key below and click on save.
Once I click that I will get a list of directories .. The default directory which is used by Office 365 is the "Ingestiondata" folder .. There our files will be uploaded.
4. Create CSV File to import PST
Assuming you have 150 PST files that you want to upload and import into users which already have been enabled on Exchange online … In order to do so you will have to prepare a CSV file that looks like the below sample
To provide an explanation of what each column stands for .. Microsoft has written a table that clears the dust but some parts were not even clear for me like the FilePath as in the TechNet article it gets you confused with the "Ship data on Physical hard drives" since it uses your drive to upload data directly to Azure through the Import tool on Office 365 portal.
The friendly path here is the path of the folder you have created in Azure through the Azcopy command
AzCopy /Source:C:\Users\Mohammed\Desktop\upload /Dest:https://d49d7ae0e38a4d8e9c93565.blob.core.windows.net/ingestiondata/SERVER01/PSTshareR1/
/Destkey:KA9Z00rEYa1JlqGE4wO222MnsN5ywT0elOgLeNht/fSMIJPe2134hEChuuDJ5mfdknq8ts0+cez6uUvFzcQd6g== /S /V:C:\PSTUpload\Uploadlog.log
So the CSV File is ready.
In Azure Storage Explorer I doubled check if the PST files has finished uploading and it's there.
5. Using the Upload Files over the network
Back to Office 365 portal, go to Import and click on the + Sign and select Upload files over the network
Select I have access to the mapping file as well
Click on + and upload the CSV file that you have prepared for the mapping
Next File is imported, Click on "By checking this box, you agree to the terms and conditions of this service.
As soon as you accept and click next the Import is going to check path, email, folder and will start the import process.
Email before importing
Imported started, folder has been created
Importing is done