{"id":2126,"date":"2017-05-16T21:13:47","date_gmt":"2017-05-16T21:13:47","guid":{"rendered":"http:\/\/microsoftgeek.com\/?p=2126"},"modified":"2017-05-16T21:13:47","modified_gmt":"2017-05-16T21:13:47","slug":"how-to-import-users-via-csv-in-exchange-2010","status":"publish","type":"post","link":"https:\/\/microsoftgeek.com\/?p=2126","title":{"rendered":"How to Import Users via CSV in Exchange 2010"},"content":{"rendered":"<p>Create an csv file with the necessary information across the top row of the file as such:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"image\" src=\"http:\/\/port25.files.wordpress.com\/2012\/01\/image_thumb.png\" alt=\"image\" width=\"450\" height=\"75\" border=\"0\" \/><\/p>\n<p>The top row is going to coordinate with the <strong>S_.<em>value<\/em><\/strong> that you are going to use in the following Exchange Shell command:<\/p>\n<p><strong>Import-CSV \u201cC:Mailboxes.csv\u201d | foreach {new-mailbox \u2013Name $_.name \u2013Alias $_.alias \u2013UserPrincipalName $_.userprincipalname \u2013Database $_.Database \u2013OrganizationalUnit $_.organizationalunit \u2013password (ConvertTo-SecureString $_.password \u2013AsPlainText \u2013force)}<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"image\" src=\"http:\/\/port25.files.wordpress.com\/2012\/01\/image_thumb1.png\" alt=\"image\" width=\"450\" height=\"24\" border=\"0\" \/><\/p>\n<p>And you should see the mailbox\u2019s created below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Untitled\" src=\"http:\/\/port25.files.wordpress.com\/2012\/01\/untitled_thumb.jpg\" alt=\"Untitled\" width=\"450\" height=\"63\" border=\"0\" \/><\/p>\n<p>That\u2019s it.\u00a0 You can see how the values map with their respective column names.\u00a0 You can add as many users as you want, and change it so they go to different database\u2019s.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create an csv file with the necessary information across the top row of the file as such: The top row is going to coordinate with the S_.value that you are going to use in the following Exchange Shell command: Import-CSV \u201cC:Mailboxes.csv\u201d | foreach {new-mailbox \u2013Name $_.name \u2013Alias $_.alias \u2013UserPrincipalName $_.userprincipalname \u2013Database $_.Database \u2013OrganizationalUnit $_.organizationalunit \u2013password [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[],"class_list":["post-2126","post","type-post","status-publish","format-standard","hentry","category-exchange-2010"],"_links":{"self":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2126"}],"version-history":[{"count":1,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2126\/revisions"}],"predecessor-version":[{"id":2127,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2126\/revisions\/2127"}],"wp:attachment":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}