Hello, I have searched around for a clear answer to this but it seems there really isnt one. Either way, I have Windows server 2008 and I just setup a DC, what I am trying to do is take all the user information that was giving to me on spreadsheet and import that into active directory. Is there any easy method of doing this, I think I have set all the attributes to what was needed to import with csvde but I keep getting hit with road blocks. Any help would be great and thanks in advance.

Hi, Check this Step-by-Step Guide to Bulk Import and Export to Active Directory http://webcache.googleusercontent.com/search?q=cache:oY3Pp-45U0IJ:technet.microsoft.com/en-us/library/bb727091.aspx+excel+ldifde&cd=1&hl=en&ct=clnk What error do you get? Will appreciate if you give feedback if this has helped you. If yes please select “Mark as answer”. Best Regards, Spas Kaloferov [ MCITP: SA6 | EA6 | VA7 | EDA7 |DBA10 | DBD10 | BID10 | EMA14 | SPA14 ] NetShell Services & Solutions | “Design the future with simplicity and elegance” Visit me at: www.spaskaloferov.com | www: www.netshell-solutions.com

The problem with this is that I do not have a way of making my spreadsheets into a LDIF file. I am importing from a spreadsheet that was sent to me by my manager from FilemakerPro.

Hi, Use CSVDE. It makes the same operation like LDIFTE but supports CSV. You may than export the spreadschit to CSV. Another tool to look into is dsadd. Also some powershel opitons Import users from CVS file to AD http://webcache.googleusercontent.com/search?q=cache:S6__wjG3oOIJ:social.technet.microsoft.com/Forums/en-US/winserverpowershell/thread/826ff014-8c20-4c4d-a68c-26a059dd6096/+winbdows+import+csv+ad&cd=4&hl=en&ct=clnk Using the Import-Csv Cmdlet http://technet.microsoft.com/en-us/library/ee176874.aspx Will appreciate if you give feedback if this has helped you. If yes please select “Mark as answer”. Best Regards, Spas Kaloferov [ MCITP: SA6 | EA6 | VA7 | EDA7 |DBA10 | DBD10 | BID10 | EMA14 | SPA14 ] NetShell Services & Solutions | “Design the future with simplicity and elegance” Visit me at: www.spaskaloferov.com | www: www.netshell-solutions.com

Thanks for the reply, I saw this on another site but was not sure where I would be able to edit the password to be already assigned to the user. I know very little on VBScript, would you be kind to throw a hint my way on where to change the password to not be expired and use the password in the attributes. Thank you all very much for your help

In the CreateUsers.vbs script I linked, the password for each new user is read from the spreadsheet (column E). As written, the program expires the password, but you can prevent this by removing the following lines from the program: ' Set password expired. Must be changed on next logon. objUser.pwdLastSet = 0 ----- If you don't assign zero to the pwdLastSet attribute, the password will not be expired. The password will expire according to your domain policy, the specified number of days after you created the user and set the password. Or, alternatively, you can assign the value -1 (instead of 0) to pwdLastSet. Then the system will change pwdLastSet to a value corresponding to the current date the first time the user logs on, so the password will expire the domain specified number of days after the first logon (instead of the specified number of days after you created the account). The only two values you are allowed to assign to pwdLastSet are 0 and -1. Richard Mueller - MVP Directory Services

Hello, this could be done using: LDIFDE: http://technet.microsoft.com/en-us/library/cc731033(WS.10).aspx CSVDE: http://technet.microsoft.com/en-us/library/cc732101(WS.10).aspx This posting is provided "AS IS" with no warranties or guarantees , and confers no rights. Microsoft Student Partner 2010 / 2011 Microsoft Certified Professional Microsoft Certified Systems Administrator: Security Microsoft Certified Systems Engineer: Security Microsoft Certified Technology Specialist: Windows Server 2008 Active Directory, Configuration Microsoft Certified Technology Specialist: Windows Server 2008 Network Infrastructure, Configuration Microsoft Certified Technology Specialist: Windows Server 2008 Applications Infrastructure, Configuration Microsoft Certified Technology Specialist: Windows 7, Configuring Microsoft Certified IT Professional: Enterprise Administrator Microsoft Certified IT Professional: Server Administrator Microsoft Certified Trainer

I have an example VBScript program to create users in bulk from the information in an Excel spreadsheet linked here: http://www.rlmueller.net/CreateUsers.htm You would need to modify this program for your use, depending on the attribute values you want to assign. One column must have the Distinguished Name of the OU (or container) where each user object will be created. Another column must specify the Common Name of the new user. Richard Mueller - MVP Directory Services

When I used this without the "set password expired", the password did not get entered for any user. Is there a way to redo the import with having the password set or would I just need to change them individually. Never mind, I'll just have them make their own on first log on.