• Link to Facebook
  • Link to LinkedIn
  • Link to Youtube
Priasoft
  • O365 & Exchange Server Management Tools
    • Office 365 & Exchange Migration Solutions
      • Public Folder Migration & Synchronization Manager
      • Priasoft Migration Suite for Exchange & Office 365
      • Mailbox Migration Manager
      • Office 365 Tenant-to-Tenant Migration
      • Collaboration Suite for Exchange (GALSync) – Two-way Sync AD organizations
      • Outlook Rules Migration Utility
      • Outlook Profile Update Manager for M365
    • eDiscovery & Compliance for Exchange
      • Exchange Data Discovery Lab
        • Exchange Data Discovery Lab – For Government Agencies
        • Exchange Data Discovery Lab – For HR & Compliance
        • Exchange Data Discovery Lab – For AI & Data Science
        • Exchange Data Discovery Lab – For IT Operations
        • Exchange Data Discovery Lab – For Legal Professionals
    • Exchange Data & Reporting Tools
      • Public Folder Analyzer for Office 365
      • Super-ExMerge – ExMerge for Exchange
    • Other Solutions and Free Tools
      • AutoDiscover Test Tool
  • Office 365 Migration Services
    • Expert Exchange Public Folder Cleanup & Discovery Services
    • Public Folder Migration Service for Office 365
    • Microsoft 365 Migration Success & Planning Workshop
  • Exchange Insights & Tips
    • How to Migrate Public Folders – Complete Guide
    • How to Backup Public Folders to PST
    • Best Way to Import Quickly PST’s to Office 365
    • Resources Library
  • Company
    • About Priasoft
    • Contact Us
    • Customer Success Stories
    • Press and Latest News
    • Priasoft Community Blog
    • Product Support
      • FAQs
      • Knowledge Base
      • Contact Support Team
      • Support Documents
    • Partners
      • Recommend a Partner
    • Why Priasoft?
      • What’s New Priasoft
      • Priasoft Migration Suite Features
  • Start Evaluating
  • Menu Menu

Answer for What’s the best format to use (csv/tab file) when loading source mailboxes into the migration window.

The batch wizard supports several different options for selecting user accounts.  Choosing the best option is a bit subjective, but may be helped with more detailed understanding of the options available.
TAB Import File
This simple feature allows for one to create a text file that lists all the source accounts to be selected.  The format of this file is very simple and is as follows:
The first line in the file must be:  DisplayName<TAB>DistinguishedName.  (the <TAB> is an actual ‘Tab’ character).
The rest of the lines in the file are the display name and AD distinuishedName values of the users to select.
Note that for each entry, validation is done by querying Active Directory and getting detail about each account.  If the list is very large (1000s of users), it can take considerable time to load the list – be patient.
 
The AD Browser utility
A very powerful feature is the AD browser utility.  This tool has several features to that can make finding and selecting accounts easy.
Containers
The first and most common way to select accounts is to simple navigate to the container or OU in the domain and select one or more accounts that are contained there.
Show object from sub-containers
This option, in the lower left of the browser, causes all mailboxes that can be found in the selected container and any sub-containers to be shown in a flat list.  If the root of the domain is selected, this will cause all mailboxes in the domain to be shown at once.
LDAP Filter
In conjunction with the above options, an LDAP filter can be applied to limit the objects that are returned.  Any AD attribute can be used as a filter, for example Department=*Sales* would show all mailboxes that have the word ‘Sales’ anywhere in the department field.  Note that LDAP filters are not case-sensitive.  For more detail, this link describes LDAP filters: link.
The LDAP filter only filters based on what would normally be shown based on the current container and the sub-containers option.  In order to have the filter apply to all users in the domain, be sure to select the root of the domain AND check the box for sub-containers.
Load list from clipboard
This feature, found on the left side of the browser, allows one to enter either very specific or non-specific details into a textbox from which an AD ANR (see this and this) search is performed.  This feature is most helpful when a list is already being maintained by another group or system.  For example, if the list of accounts to be migrated are in a SharePoint list, one could simply copy and paste either the email addresses or logon names of the accounts from the list and paste them in the ‘load list from clipboard’ dialog.  The tool will execute an ANR search for the objects.  If very unique values are used, a one-to-one matching will be resulted.
However, and sometimes more convenient, if a more ambiguous value is used, all accounts matching that value can be returned.  For example, if all accounts with ‘rich’ in the name needed to be selected, simply entering ‘rich’ would work.  ‘Richard’, ‘Richardson’, ‘Dunrich’, and ‘Goodrich’ will all be returned.  This can be especially helpful in finding an account for which only some detail is known.
Load Selections
This feature allows one to load a previously saved user list file.  The page on which database assignments are made has an option to save the selections to a file.  The resulting file is a binary file that contains the selected source accounts, the matching target accounts, and any database assignments that were made.
Priasoft recommends using this feature as it does not go thru the validation steps that the other options have.  This can be valuable to avoid delays in the start of a batch.  In addition, because all the details are recorded, an administrator can hand the work off to someone of no experience to load the list and the migration will work on the users as the admin designed.
Furthermore, selecting accounts can be a time consuming endeavor.  It is best to do the selection work a few days before a production migration and save to a user list file.  There can be cases where questions are raised about who to migrate, or cannot be found, and the like that if faced with such on migration day, can delay the start until such things are sorted out.
 

August 31, 2015
Share this entry
  • Share on Facebook
  • Share on X
  • Share on Pinterest
  • Share on LinkedIn
  • Share on Tumblr
  • Share on Reddit
  • Share by Mail
/wp-content/uploads/2016/01/Pria_email_logo.png 0 0 Eriq VanBibber /wp-content/uploads/2016/01/Pria_email_logo.png Eriq VanBibber2015-08-31 22:55:372015-08-31 22:55:37Answer for What’s the best format to use (csv/tab file) when loading source mailboxes into the migration window.

Recent Posts

  • Office 365 Tenant to Tenant
    Tenant-to-Tenant Migration Checklist: What to Do Before You Move a Single MailboxMay 19, 2026 - 2:00 pm
  • Super-ExMerge (SXM)
    What Is Super-ExMerge and Why Do IT Teams Still Need It in 2026?May 12, 2026 - 2:00 pm
  • Priasoft Migration Suite for Exchange (PMSE)
    Exchange 2019 Patches Just Ended. Here Is What IT Teams Need to Do This Month.May 5, 2026 - 2:00 pm

Archives

Categories

  • Compliance
  • eDiscovery
  • Guide
  • How to
  • Microsoft 365
  • News
  • Outlook PST
  • Press Release
  • PST Data Management
  • Public Folders
  • Security
  • Technical

The Exchange Experts – Who Are We?

Priasoft, a Microsoft Partner, offers enterprise-class solutions for Exchange migration, management, and eDiscovery. Supporting Exchange 2010, 2013, 2016, 2019, and Office 365/Exchange Online, our platform enables secure migration, management, and organization of email data, with advanced tools for compliance, public folder analysis, and AI-driven insights.


YouTube Play Button  LinkedIn LogoFacebook Logo

Exchange Quick Links

• Exchange Data Discovery Lab (eDiscovery)
• Public Folder Migration to Office 365
• Public Folder Analyzer for Office 365
• Super-ExMerge for Office 365
• Collaboration Suite (GalSync)
• Microsoft Outlook Profile Update Manager
• Privacy Policy
• Terms of Use

Recent Posts

  • Tenant-to-Tenant Migration Checklist: What to Do Before You Move a Single Mailbox
  • What Is Super-ExMerge and Why Do IT Teams Still Need It in 2026?
  • Exchange 2019 Patches Just Ended. Here Is What IT Teams Need to Do This Month.

Contact Priasoft – The Exchange Experts

Have questions? Speak to a Priasoft Engineer
Email: sales (at) priasoft.com
+1 (480) 520-0873

Scroll to top Scroll to top Scroll to top

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.

OKLearn more

Cookie and Privacy Settings



How we use cookies

We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.

Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.

Essential Website Cookies

These cookies are strictly necessary to provide you with services available through our website and to use some of its features.

Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.

We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.

We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.

Other external services

We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.

Google Webfont Settings:

Google Map Settings:

Google reCaptcha Settings:

Vimeo and Youtube video embeds:

Privacy Policy

You can read about our cookies and privacy settings in detail on our Privacy Policy Page.

Privacy Policy
Accept settingsHide notification only