Using CSV

November 27, 2017 | by iaur | posted as IMAP(EXO), M365 Migration

IMAP MIGRATION USING CSV FILE

Prerequisites

  • Users must be created already in Office 365.
  • Users must have an Exchange Online license
  • Username and password of the source mailboxes
  • Server settings of the source mailboxes.
  •  NO Calendar, Contacts and Tasks will be migrated. If they need these three, refrain from doing the migration.

Steps

  1. Go to Exchange Admin Center > Recipients Tab > Migration > Click the + icon to create a new batch
Machine generated alternative text:

2. Click the Exchange Online and choose IMAP Migration

3. Create a CSV File

> Open a blank Excel File

> On the column header, place the ff:

  • EmailAddress: This is the email address of your Office 365 users
  • Username: This is the email address of the mailbox you will migrate (source email)
  • Password: Password of the Username(source email)

> Save as .csv format

> Click the “ALLOW UNKNOWN COLUMNS IN THE CSV FILE”

> click NEXT

Insert 
X Cut 
Page Layout 
Formulas Data 
Review 
View Tell me what you want to do 
Calibri 
Copy • 
P aste 
•Y Format Painter 
Clipboard 
EmailAddress 
Font 
username 
bernie@sourcedomain.com 
ge Wrap Text 
Merge & Center • 
Alignment 
Password 
m yso urcepass word 
General 
$.96 , 
Number 
00 
2 
bernie@domain.onmicrosoft.com

4. Setup the Server Settings

> Place the IMAP Server and port

             Note: You can check some Server settings here:

                          IMAP SETTINGS FOR DIFFERENT SERVERS

                         If it is not there, you can check their Outlook settings or search it on google

> Authentication = Basic

> Encryption = depending on the server but most of the time SSL

> Click NEXT

5. Set-up Migration Batch

> Set Migration Batch Name

> Set Bad Item Limit –  The BadItemLimit parameter specifies the maximum number of bad items that are allowed before the migration request fails. A bad itemis a corrupt item in the source mailbox that can’t be copied to the target mailbox. Also included in the bad item limit are missing items. Missing items are items in the source mailbox that can’t be found in the target mailbox when the migration request is ready to complete.

> Set Large Item Limit – The LargeItemLimit parameter specifies the maximum number of large items that are allowed before the migration request fails. A large item is a message in the source mailbox that exceeds the maximum message size that’s allowed in the target mailbox.

>  Set ExcludeFolders – For an IMAP migration, the ExcludeFolders parameter specifies mailbox folders that you don’t want to migrate from the on-premises messaging system to the cloud-based mailboxes. 

Machine generated alternative text:

6. Start the batch

> Select the recipient of reports after the migration is finished.

> You can either select how you start the batch

Machine generated alternative text:

You will receive a notification same as this once the migration started.

Machine generated alternative text:

7. Check the details

> Click on the migration batch

> On the right panel, click the “View Details” to see the details of how many items are being synced, skipped of if the migration fails.

Machine generated alternative text:

References

https://technet.microsoft.com/en-us/library/jj218662(v=exchg.160).aspx

https://docs.microsoft.com/en-us/exchange/mailbox-migration/migrating-imap-mailboxes/migrate-other-types-of-imap-mailboxes