+ Post New Thread
Results 1 to 6 of 6
How do you do....it? Thread, New years 7 intake + exchange 2013 in Technical; I've got all my new year 7s details in a csv and i've tried programs such as dovestones AD bulk ...
  1. #1
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,541
    Thank Post
    362
    Thanked 263 Times in 215 Posts
    Rep Power
    100

    New years 7 intake + exchange 2013

    I've got all my new year 7s details in a csv and i've tried programs such as dovestones AD bulk user tool but it doesn't support exchange 2013 and keeps trying to create my users as contacts and i can't even seem to disable it from creating the email accounts when it creates the users >_<

    Does anyone have any better suggested methods for importing all the new users?

  2. #2

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,362
    Thank Post
    1,499
    Thanked 1,053 Times in 922 Posts
    Rep Power
    303
    I use this tool - Account Management Spreadsheet combined with Bulk AD Users and some manual (but bulk) stuff via Exchange 2010 (for importing) the users after the other tools have created them never had an issue with it and it just works. Does Exchange 2013 allow you to import existing users and mail enable them which is what I did in 2010.

  3. #3

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,058
    Thank Post
    888
    Thanked 1,731 Times in 1,494 Posts
    Blog Entries
    12
    Rep Power
    454
    Are all your 7 year accounts on 1 group or ou or something? Could run a quick powershell command to mail enable them after the accounts are created.

  4. #4
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,541
    Thank Post
    362
    Thanked 263 Times in 215 Posts
    Rep Power
    100
    Quote Originally Posted by FN-GM View Post
    Are all your 7 year accounts on 1 group or ou or something? Could run a quick powershell command to mail enable them after the accounts are created.
    Just did just that

    AD Infinitum as recommended on here in another thread for creating them and the powershell script for adding the mail accounts. A bit of a pain that microsoft removed the ability to select multiple accounts for creation in a single GUI window though!

  5. #5

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,058
    Thank Post
    888
    Thanked 1,731 Times in 1,494 Posts
    Blog Entries
    12
    Rep Power
    454
    To be honest i didn't use the GUI anyway

  6. #6

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,190
    Thank Post
    875
    Thanked 2,717 Times in 2,302 Posts
    Blog Entries
    11
    Rep Power
    780
    Quote Originally Posted by FN-GM View Post
    To be honest i didn't use the GUI anyway
    damn kids, get off my lawn

    With 2010 I just feed a csv file to this that makes the accounts and the mailboxes:
    Code:
    Function ReadCSV{
     Param([string]$fileName)
     $users = Import-Csv $fileName
     foreach ($user in $users){
     $ht = @{
     'givenName'=$user.fn
     'sn'=$user.ln
     'alias'=$user.alias
     'samAccountName'=$user.alias
     'name' = ($user.fn + ' ' + $user.ln)
     'PW'=$user.pw
     }
     Write-Output $ht
     }
    
    }
    Function CreateUser{
     Param($userInfo)
     $secureString = ConvertTo-SecureString $userInfo['PW'] -AsPlainText –Force
     $UPN = $userInfo['alias'] +  ']school.domain.internal'
     New-Mailbox -Name $userInfo['name']`
     -Alias $userInfo['alias'] -UserPrincipalName $UPN `
     -SamAccountName $userInfo['alias'] `
     -FirstName $userInfo['givenName'] -LastName $userInfo['sn'] `
     -OrganizationalUnit 'school.domain.internal/schoolOU/Users/requiredAdOu`
     -Password $secureString -ResetPasswordOnNextLogon $false
    
    }
    
    Function CreateMailbox{
     PROCESS
     {
     CreateUser $_
     }
    }
    
     ReadCSV c:\PS\testUsers.csv | CreateMailbox
    feed it with small woodland creatures and a c:\PS\testUsers.csv:
    Code:
    fn,ln,alias,pw
    John,Doe,jDoe2013,1234
    Last edited by SYNACK; 21st August 2013 at 02:56 PM.

  7. Thanks to SYNACK from:

    FN-GM (21st August 2013)

SHARE:
+ Post New Thread

Similar Threads

  1. New Exchange 2013 setup - issues with mail flow
    By 3s-gtech in forum Enterprise Software
    Replies: 6
    Last Post: 23rd June 2013, 04:54 PM
  2. Replies: 6
    Last Post: 1st January 2013, 11:55 PM
  3. New Year 7 Induction
    By DSapseid in forum School ICT Policies
    Replies: 7
    Last Post: 18th June 2007, 10:42 AM
  4. Happy New Year!
    By kingswood in forum General Chat
    Replies: 8
    Last Post: 2nd January 2007, 09:26 AM
  5. Replies: 20
    Last Post: 23rd December 2006, 09:36 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •