Importing users to AD with CSV, cannot get some fields to work

Question

Been trying to build a CSV file to import users into Active Directory. I can get everything to populate, except for E-mail, Password, and Enabling the user. Just using this cmdlet in Powershell.

Import-CSV "C:\Users\Administrator\Downloads\adimport.csv" | new-ADUser

This is what my CSV looks like.

CSV File

For some reason the E-Mail field in the General tab won't fill. I'm also not sure what column header to use to enable the profile, and I think password is userPassword, right?

Is there something i'm doing wrong that the E-Mail field won't fill in?

score 3 · Accepted Answer · edited Apr 26 '15 at 12:14

3

Try rename field in csv from mail to EmailAddress

New-ADUser accepts a property of EmailAddress, but not mail. Some of these correspond to an AD attribute, but not all.

New-ADUser
https://technet.microsoft.com/en-us/library/ee617253.aspx

edited Apr 26 '15 at 12:14

Greg Askew

35,880
5
54
82

answered Apr 22 '15 at 17:49

Dmitry Gorozhanin

153
7

That was it, didn't see that anywhere in the Attribute Editor and everything I had read said to use `mail` – Matt Fogleman Apr 22 '15 at 17:55
You can try: `get-AdUser -filter 'samAccountName -like "Administrator"' -properties *|Get-Member` to view all properties of the object – Dmitry Gorozhanin Apr 22 '15 at 18:20
Ahh, thank you so much. Most of the stuff I was reading was from Server 2008, so maybe they changed that property name. – Matt Fogleman Apr 22 '15 at 18:25

score 1 · Answer 2 · answered Apr 26 '15 at 09:24

1

Here is list of all Get-aduser default and extended properties.

http://social.technet.microsoft.com/wiki/contents/articles/12037.active-directory-get-aduser-default-and-extended-properties.aspx

answered Apr 26 '15 at 09:24

Ankh2054

1,414
13
23

Importing users to AD with CSV, cannot get some fields to work

2 Answers2