Issue with importing users from csv into powershell

spiceuser-d57vf · 2020-08-07T19:05:07.000Z

I am trying to import users from a csv file, and pull their first, last name, as well as their Email, and their UserLogon name.

I haven’t been able to make it much further than this, as i am just getting started into Powershell, and discovering new things. Please don’t judge me too hard. Here is what i have so far, and im having issues with it.

Import-module ActiveDirectory
$list = import-csv C:\Users\Default\Desktop
$users = a()

foreach ($item in $list)
{
$users += Get-ADUser
}
$users | Select-Object EmailAddress

Neally · 2020-08-07T19:07:00.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

spiceuser-d57vf · 2020-08-07T19:08:27.000Z

Import-module ActiveDirectory
$list = import-csv C:\Users\Default\Desktop
$users = a()

foreach ($item in $list)
{
$users += Get-ADUser
}
$users | Select-Object EmailAddress

Neally · 2020-08-07T19:10:58.000Z

spiceuser-d57vf:

$users += Get-ADUser

you should be getting an error stating that the identity can not be null or something.
also does your CSV have a deader / column name?
more like so:

Import-module ActiveDirectory
$list = import-csv C:\Users\Default\Desktop

$data = 
foreach ($item in $list.ColumnNameHere){
    Get-ADUser $item -properties EmailAddress
}
$data | Select-Object EmailAddress

kenneth782641 · 2020-08-07T19:12:22.000Z

I am no powershell expert but you can try this, it will need a little modification for your file location but should do the trick.

learn.microsoft.com

PowerShell: Bulk create AD Users from CSV file

spiceuser-d57vf · 2020-08-07T19:12:42.000Z

It has a “Users” column.

Neally · 2020-08-07T19:13:29.000Z

spiceuser-d57vf:

It has a “Users” column.

then like so

Import-module ActiveDirectory
$list = import-csv "C:\Users\Default\Desktop\list.csv"

$data = 
foreach ($item in $list.Users){
    Get-ADUser $item -properties EmailAddress
}
$data | Select-Object EmailAddress

Neally · 2020-08-07T19:15:16.000Z

spiceuser-d57vf:

im having issues with it

can you elaborate on the issue actually?

cerbere · 2020-08-07T19:23:17.000Z

For starters, when posting code, you should choose ‘Powershell’ from the drop-down Language menu. That way, you’ll get syntax highlighting, like this:

Import-module ActiveDirectory
$list = import-csv C:\Users\Default\Desktop
$users = a()

foreach ($item in $list)
{
$users += Get-ADUser
}
$users | Select-Object EmailAddress

There are a few issues with your code. First, you are trying to import a CSV, but you haven’t given it a name, only a folder path. You need something like:

$list = import-csv C:\Users\Default\Desktop\UserList.csv

Then your CSV file must have meaningful headers for the first line (FirstName, LastName, Email, UserLogon). And then you can refer to each of these in your script.

For example, the following:

$users += Get-ADUser

is ambiguous. You need to tell the script what user to get. Like this:

$users += Get-ADUser $item.UserLogon

This way, as your script loops through all the users in your CSV, the Get-ADUser command will look for the user with UserLogon (which is referenced in the CSV header), and add it to the $users array.

Play around with it a bit more, and get back to us with any questions.

spiceuser-d57vf · 2020-08-07T19:23:43.000Z

That worked, it is pulling the required information

spiceuser-d57vf · 2020-08-07T19:27:03.000Z

Is there a way i can replace the Email and Userlogonname with the first.last, if it is missing?

Neally · 2020-08-07T19:47:03.000Z

spiceuser-d57vf:

Is there a way i can replace the Email and Userlogonname with the first.last, if it is missing?

yes but you have to add more code to do that.
Userlogonname is actually called ‘UserPricipalName’ in AD

User Logon Name → UPN / UserPricipalName
User Logon Name (Pre-Windows 2000) → SamAccountName

idk something like this

Import-module ActiveDirectory
$list = import-csv "C:\Users\Default\Desktop\list.csv"

$data = 
foreach ($item in $list.Users) {
    $ADInfo = $null
    $ADInfo = Get-ADUser $item -properties EmailAddress
    if ($adinfo.emailaddress) {
        [pscustomobject]@{
            First        = $adinfo.givenname
            Last         = $adinfo.surname
            Userlogonname = $adinfo.userpricipalname
            Emailaddress = $adinfo.emailaddress
        }
    }
    else {
        [pscustomobject]@{
            First        = $adinfo.givenname
            Last         = $adinfo.surname
            Userlogonname = $adinfo.userpricipalname
            Emailaddress = 'n/a'
        }
    }
}
$data