CSV files for IMAP migration batches
Applies to: Exchange Online
Topic Last Modified: 2013-02-20
The CSV file that you use to migrate the contents of users' mailboxes in an IMAP migration contains a row for each user. Each row contains information about the user's Exchange Online mailbox and IMAP mailbox, and Exchange Online uses this information to process the migration.
Here are the required attributes for each user:
EmailAddress specifies the user ID for the user's Exchange Online mailbox.
UserName specifies the user logon name for the user's mailbox on the IMAP server. You can use either the user name or domain\user name format. For example,
Password is the password for the user's account in the IMAP messaging system.
The migration will fail if any one of these attributes isn't included in the header row of the CSV file. Also, be sure to type the attributes exactly as they’re shown. Attributes can't contain spaces. They must be a single word. For example, Email Address is invalid. You must use EmailAddress.
Here's an example of the format for the CSV file. In this example, end-user credentials are used to migrate three mailboxes:
EmailAddress,UserName,Password firstname.lastname@example.org,contoso\terry.adams,1091990 email@example.com,contoso\ann.beebe,2111991 firstname.lastname@example.org,contoso\paul.cannon,3281986
The first row, or header row, of the CSV file lists the names of the attributes, or fields, specified in the rows that follow. Each attribute name is separated by a comma.
Each row under the header row represents one user and supplies the information that will be used to migrate the user's mailbox. The attribute values in each row must be in the same order as the attribute names in the header row. Each attribute value is separated by a comma.
Use any text editor, or an application like Microsoft Excel, to create the CSV file. Save the file as a .csv or .txt file.
|If the CSV file contains non-ASCII or special characters, save the CSV file with UTF-8 or other Unicode encoding. Depending on the application, saving the CSV file with UTF-8 or other Unicode encoding may be easier when the system locale of the computer matches the language used in the CSV file.|
The CSV file can contain up to 50,000 rows, one row for each user, and can be as large as 10 MB. But it's a good idea to migrate users in several smaller batches.
If you plan to migrate lots of users, decide which ones to include in each batch. For example, if you have 10,000 accounts to migrate, you could run four batches with 2,500 users each. You could also divide the batches alphabetically; by user type, such as faculty, students, and alumni; by class, such as freshman, sophomore, junior, and senior; or in other ways that meet your organization's needs.
|One strategy is to create Exchange Online mailboxes and migrate email for the same group of users. For example, if you import 100 new users to your Office 365 organization, create a migration batch for those same 100 users. This is an effective way to organize and manage your migration from an on-premises messaging system to Exchange Online.|
In the CSV file, you have to provide the user name and password for the user's on-premises account. This enables the migration process to access the account. There are two ways to do this:
Use end-user credentials. This requires that you obtain users' passwords or that you change their passwords to a value that you know so you can include it in the CSV file.
Tip: If you use this option, prevent users from changing the passwords of their on-premises accounts. If users change their passwords after the initial migration, subsequent synchronizations between the mailboxes on the IMAP server and Exchange Online mailboxes will fail.
Use super-user or administrator credentials. This requires that you use an account in your IMAP messaging system that has the necessary rights to access all user mailboxes. In the CSV file, you use the credentials for this account for each row. To learn whether your IMAP server supports this approach and how to enable it, see the documentation for your IMAP server.
Note: It's a good idea to use administrator credentials because it doesn't affect or inconvenience users. For example, it won't matter if users change their passwords after the initial migration.
You can use the user name and password of an administrator account in the UserName and Password fields for each row of the CSV file. The user name for administrator credentials is a combination of the user name for the person whose email is being migrated and the user name for an administrator account that has permission to access all user mailboxes. The supported format for administrator credentials is different depending on the IMAP server you're migrating email from. For more information about how to use administrator credentials, see the documentation for your IMAP server.
|When you submit a new migration request, the CSV file is uploaded to the Microsoft datacenter over a Secure Sockets Layer (SSL) connection. The information from the CSV file is encrypted and stored on the Microsoft Exchange servers at the Microsoft datacenter.|
The following sections explain how to format the administrator credentials in the CSV file that you use to migrate email from different types of IMAP servers.
If you're migrating email from the IMAP implementation for Microsoft Exchange, use the format Domain/Admin_UserName/User_UserName for the UserName attribute in the CSV file. Let's say you're migrating email from Exchange for Terry Adams, Ann Beebe, and Paul Cannon. You have a mail administrator account, where the user name is mailadmin and the password is P@ssw0rd. Here's what your CSV file would look like:
EmailAddress,UserName,Password email@example.com,contoso-students/mailadmin/terry.adams,P@ssw0rd firstname.lastname@example.org,contoso-students/mailadmin/ann.beebe,P@ssw0rd email@example.com,contoso-students/mailadmin/paul.cannon,P@ssw0rd
For IMAP servers that support Simple Authentication and Security Layer (SASL), such as a Dovecot IMAP server, use the format Admin_UserName*User_UserName, where the asterisk ( * ) is a configurable separator character. Let's say you're migrating those same users' email from a Dovecot IMAP server using the administrator credentials mailadmin and P@ssw0rd. Here's what your CSV file would look like:
EmailAddress,UserName,Password firstname.lastname@example.org,mailadmin*terry.adams,P@ssw0rd email@example.com,mailadmin*ann.beebe,P@ssw0rd firstname.lastname@example.org,mailadmin*paul.cannon,P@ssw0rd
If you're migrating email from Mirapoint Message Server, use the format #user@domain#Admin_UserName# for the administrator credentials. To migrate email from Mirapoint using the administrator credentials mailadmin and P@ssw0rd, your CSV file would look like this:
EmailAddress,UserName,Password email@example.com,#firstname.lastname@example.org#mailadmin#,P@ssw0rd email@example.com,#firstname.lastname@example.org#mailadmin#,P@ssw0rd email@example.com,#firstname.lastname@example.org#mailadmin#,P@ssw0rd
Some IMAP servers, such as Courier IMAP, don't support using administrator credentials to migrate mailboxes to Exchange Online. To use administrator credentials to migrate mailboxes, you can configure your IMAP server to use virtual shared folders. Virtual shared folders allow administrators to use the administrator's logon credentials to access user mailboxes on the IMAP server. For more information about how to configure virtual shared folders for Courier IMAP, see Shared Folders.
To migrate mailboxes after you set up virtual shared folders on your IMAP server, you have to include the optional attribute UserRoot in the CSV file. This attribute specifies the location of each user's mailbox in the virtual shared folder structure on the IMAP server.
Here's an example of a CSV file that contains the UserRoot attribute:
EmailAddress,UserName,Password,UserRoot email@example.com,mailadmin,P@ssw0rd,/users/terry.adams firstname.lastname@example.org,mailadmin,P@ssw0rd,/users/ann.beebe email@example.com,mailadmin,P@ssw0rd,/users/paul.cannon