Importing Users into AD
Posted on 2011-09-23
I"ve run into an issue trying to import users into Active Directory. I know there are other methods, I just can't figure out why this method isn't working. I have an Excel worksheet that in the first column is the user first name, second column is the last name, third column is the child OU, forth column is the parent OU. On the second Excel worksheet is a concantenate formula which puts everything into the correct format from the information provided from the first worksheet. The third worksheet is a summary that is saved as a formatted text file. I then save that file as a batch file on the root drive and run it from the command prompt. If everything is correct it will put the users into the assigned OU with a first initial last name account, assign a password and have the user change it at log on.
My problem is the import works, but it does not assign the first initial last name. It assigns only the last name. What I did initially was copy and paste the first names from one Excel sheet into the second one that I use for importing. I copy and paste first names, then second names. The strange part is, if I manually type the first name into the Excel worksheet used for importing, it works the way it should. If I copy and paste, it leave out the first initial of the first name.
My question is why does the manual entry of the first name work and copy and paste doesn't? Copy and paste works for the second name, but not the first. I'm doing this on Server 2008 R2.