Creating AD Users from CSV with Powershell | ServerAcademy.com 

I needed a refresh as it has been a long while since I have created a script using PowerShell and this is exactly the type of video I needed to get me rolling again. Much appreciated!

I got a job interview and this was part of it. Your video has been easily the most helpful video I have come across for people that have never coded a powershell script. Thank you for the help.

Great Script and Demo - I will note that when we do it for the first time it is not as interactive as yours and the variables do not prepopulate, but just plug thru and it all works - thank you for this.

Man i have to say THANK YOU !!!! there are a lot of tutorials but this one ... I really enjoyed how you describe each step from the beggining to the end, thank you so much !

Paul Hill , You are a Legend. This has been one of the most valueable pieces of resources available on RU-vid. I followed your Instructions in the Vid and created a List of 105 Employees for a Company and it placed all the respective Users in their OU's and DC. I bow to your Superior Knowledge and Skills.

The tutorial is smooth and understandable, thank you for not making shortcuts, easy to understand especially for newbies like me, again Thank you.

Please do more Powershell videos. This is the most clear precise and well don't tutorial i have seen. Thank you for creating it.

Totally agree with azzaf5 This is clear and to the point tutorial better than most, plus your voice is reassuring and relaxed.

Everytime I want to refresh my knowledge. I always comeback to watch your videos

Simple and very well explained! I think I'll enroll on the training just for fun!

I'm excited to try this out. Onboarding new users is so annoying, and I feel this would definitely speed up the process!

Well done, I have used this a couple years ago and just found it again and wanted to like.

Thank you for this Video. This really does help and it was explained very clear and precise. Looking forward on the next video for PowerShell.

Excellent training tool, making me look like a star.......thanks

Very handy, and as an added bonus you sound just like Kyle Gass. Simply soothing!

Need to create about 200 users. This is gonna make things alot easier. ;-) Thank!

Great tutorial. The application of the ForEach cmdlet finally makes sense to me!

you are really good for a teacher , thanks ,you change my prospective about power she'll

Good Video sir I'm Studing for MCSA and it this video help me a lot.

Thank you so much Paul for creating the video. it is a great presentation. Great Job!!!

Thanks for showing it step by step👍

Thank you so much! This saved me hours of work. This is the only code that worked for me!

thank you, great video, been looking for something like this for a long time, and you make it very easy to follow,

Really nice video. Easy to understand.

Vow, great video. Helped me a lot, thank you.

very empowering thank you so much !!

Fantastic video. Nice and clear.

Wish to learn from you. A great explanation.

Awesome video, you helped me a bunch!

Thank you! it's very help me.

Hello Paul, Thanks for the video when I run the script I get WARNING: One or more headers were not specified. Default names starting with "H" have been used in place of any missing headers. any idea what I'm doing wrong?

Great video, helped me a lot

How would you do this if the CSV file you are using doesn't have any headers? As in, if it was just a list of first names and last names but no headers to differentiate them. How would you create those users without the headers with their proper names? And some of the users don't have a last name at all, so how would I make the script skip those names? It all seems so impossible to me at this point..

Keep 'em up ! Thanks

thanks you save my life!

Amazing video thanks !!!!

Большое спасибо. Все работает. Допилю скрипт под свои нужды и на работе буду пинать... Ты крут

Please help me adding upn as it doesn’t show in the user property. Also how to add the email as well. So for the hassle I’m new to this. In fact I have been trying to do this for a while I wasn’t able till I came a cross your video. So thank you very much

Great training video. I have one question though. Would it be possible to also batch upload of user information such Member of a group that has been created in the active directory? Browsed through the list of commands within the New-ADUser but couldn't find one that could be used. Thanks

Thank you, thank you, thank you !!!

Hi thanks for the video, it was really informative. Could you also explain how to make a random generated password for each individual?

thank you so much!!

this is amazing !

What if there are some empty cells in the CSV file? i have created something similar but i get an error when trying to add OtherAttributes like extensionattributes. For example some users have some attributes that the other doesnt have, have can i make this work automatically? When the cell is empy i can say to continue to create and if its not add the attribute.

best tutorial ever

So far the script is working, but when I echo the "$fname" part, I get an output of a bunch of blank spaces. Is my csv formatted in a weird way or is there something I am missing?

Hello Paul. Thank you for the awesome video. Really helpful. Do you mind posting the powershell script as i could not find it here? Thank you

Hi, Thanks for your video. Is it possible to add an incremental number behind a username while there is a same username in the AD? such as if I need to create three users and their username are testdata. Can we edit them to testdata then testdata1, testdata2 by PowerShell?

this video is terrific,I like it.

Thanks you very much!

Thank-you so much for this tutorial.... This helped me alot 👌

How can I add the same users to a security group in specific using the same csv file and script?

It's not showing the upn appropriately..rest looks fine..is it possible to add auto generated password?

On PS it doesn't recognize $Filepath help?

If I have to create 500 temporary users, must I type out the info for the 500 ppl in excel?

hi, hopefully i'll get a response to this, first of all thanks for taking the time to make this video, i'm on my first day at my internship and my task is to create AD users with corresponding email and all via powershell. too bad i can't find your script to download and edit, because when using my script, the powershell doesn't return the first names or last names like yours did in the video, eventhough i don't get any errors either? do you have any idea what i could be doing wrong? also kindly let me know how to include email addresses for the users. thank you

I didn't find the attached resources. This is very informative compared to other tutorial video

Great tutorial, one question, where you setup the usernames (UserPrincipalName) how would I do it for first initial surname. E.g. jbloggs ?

Is there a way to add users to security groups during this process using the same script? also attributes like msRTCSIP-PrimaryUserAddress and ProxyAddress for each user?

Where's the link to download the script?

GREAT Informative video. Where can i find the attachment?

What about just updating AD with a CSV?

Hi, can this be done on a client pc that connected to a domain

This is awesome. Explained so well for a scripting newbie, and exactly what I need for an upcoming project. One question, is there a way in this process to have the email address created, but hidden from the GAL? I want to create a big batch of users but not actually have them viewable for another few weeks. thanks!

thank you

Excellent

Good video!

Thanks for this. I am getting an error when I run my code. Powershell does not recognize parameters on line 23. Can you help?

When I create an account in AD. It shows the name as lastname, firstname. How do if fix this in the script? I need a comma and a space. The GUI tools creates the comma automatically.

Hi , I am currently trying to import multiple users to multiple different groups via powershell. The formatting of the CSV is: Group Name Members grp1   user 1 , user 2 , user 3 grp 2   user 5 , user 1 , user 4 grp 3    user 6 , user 5 , user 3 Some of the users that exist within the CSV do not currently exist so i have tried several different methods to import this but keep on getting errors import-csv "C:\Users\sys.c\Desktop\adgroups123.csv" | ForEach-Object {add-ADGroupMember -Identity $_.groupname -Members $_.username} is what im currently using, although i have tried other ways of trying to achieve this. I believe the issue that i am currently having is i need to do a -split(;) as the users are within the same cell , per row. I am therefore if i need to edit this or start over. I was wondering if anyone could help me with this as. I am unsure if i need to edit my csv to a different format or if powershell is capable of doing this within this format. ( i could not see anyone else trying this format on forums) Thanks!

Thanks. Helped a lot. However I have a question: How do you get the OU path if you didn't have the GUI (Where you just copy it from attribute editor)?

Hi, thanks for ur very good video, I have a question, wen i try to import my OUpath is OU=Alidata,OU=Empresas,DC=LIDERMOBILE,DC=LOCAL because is comma separated doesnt import correctly, how can i correct this?

Thank You

Hey Paul what editor are you using to edit the powershell script?

able to provide the script and whether isit able to add SamAccountName and MemberOf?

Hi Paul, great video. I have a question regarding the $fname, $lname, etc. are those attributes pulled from ADSI edit? would $surname and $givenname work the same? would $SamAccountName and $userPrincipalName attributes populate as long as the CSV has columns for that?

Hi, where can I download the script please? Thanks in advance

How do I have access to test AD?

u dont use jtitle?

- Why can't i get it to work from a excel file?? No matter if i take the comma seperated .csv filetype, the script just dosen't work. It works perfectly fine in notepad if i just manually seperate values with commas, but that's not what i wanted.

Paul do you have a powershell course?

*_Not all capes wear heroes!!!_* :D

nice

Господи, спасибо!

How would you make sure that all the users created from this script are unique....? I mean is any user already exsist with the same user name then...

my thing is how did you know to use read-host and use other variables to solve this problem.?

Does this still work?

how do i get the code?

pastebin code? can share code?

where are the downloadable scripts?

Thank you very much💐 What about the user principle name! How can I add that please?

Hello, is there a problem doing this on vmware 12? I am trying to do it step by step as you did on the video, however it doesn't do anything even not displaying the first name users do you know about this problem in vmware 12? is there a way to fix it?

A shame this didn't continue as it's the clearest guide for powershell.

Where can i download the script?

17:37 may i get the link

can you please share the .csv file

good video, however a link in the description to the script, would've gotten you a subscribe and a like :)

So the , are clashing all around and I found a bug in Excell that changes , into ; Shit Aint Working...

Beware: The attribute userprincipalname should be followed with the full user principal name rather than the pre-Windwos 200 username Beware: the script is populating a mail address field but not creating the mail. For those who still use Exchange on premises, take note and run a script of similar complexity in the Exchange administrative console to create the mailboxes. For those who use Microsoft 365, the process is more tedious. Beware: the script has no error checking. While the case of two users with the same first name and last name is rare, it can happen. If so, no account will be created. In the real world, we want to catch the errors and fix them.

I cant see the script here