How to use CSV to import Employee number in powershell.

spiceuser-6qogk · 2019-09-03T12:41:37.000Z

Hi Guys,

I am very new to Powershell and i am currently struggling on writing a script that will import information from a CSV.

Column A has a header of ‘samaccountname’ and column b has a header of ‘employeeNumber’.

I am looking to update all ‘samaccountnames’ with the 'employee number from column B.

I know this is probably something simple. I had success yesterday just importing information from a CSV with the script Import-csv “filename.csv” | %{ add-adgroupmember “groupname” -members $_.samaccountname }

But i cant seem to work out how to make powershell update all of column A with column B. I hope that makes sense.

Sam

Neally · 2019-09-03T12:43:56.000Z

Welcome!

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! .

Neally · 2019-09-03T12:45:46.000Z

samuel.bennett:

update all of column A with column B

that’s a bit weird but sure can be done.

$csv = import-csv $CSVFile

$csv_new = 
foreach($line in $csv){
    $line.columnA = $line.columnB
}

$csv_new | export-csv NewCSVFile.csv

something like so. I am not sure if I’m addressing what you actually want to do.
You have to use the actual column name, rather than ‘columnA/B’

rinomardo2 · 2019-09-03T12:47:04.000Z

samuel.bennett:

Hi Guys,

I am very new to Powershell and i am currently struggling on writing a script that will import information from a CSV.

Column A has a header of ‘samaccountname’ and column b has a header of ‘employeeNumber’.

I am looking to update all ‘samaccountnames’ with the 'employee number from column B.

I know this is probably something simple. I had success yesterday just importing information from a CSV with the script Import-csv “filename.csv” | %{ add-adgroupmember “groupname” -members $_.samaccountname }

But i cant seem to work out how to make powershell update all of column A with column B. I hope that makes sense.

Sam

so you have imported a CSV file and added users to groupname.

now you want to manipulate your CSV file by copying column B to column A?

Evan7191 · 2019-09-03T12:48:53.000Z

Do you want to add employee numbers to the user objects in AD by pulling the information from your CSV file?

jitensh · 2019-09-03T13:01:36.000Z

samuel.bennett:

Hi Guys,

Column A has a header of ‘samaccountname’ and column b has a header of ‘employeeNumber’.

I am looking to update all ‘samaccountnames’ with the 'employee number from column B.

$users=Import-Csv c:\filename.csv
foreach($user in $users){
Get-Aduser $user.samaccountname|set-aduser -employeeid $user.employeeNumber
}

spiceuser-6qogk · 2019-09-03T13:50:44.000Z

Thanks For our responses guys. I believe i may have confused the situation by adding in the Powershell i ran yesterday. That was just an example of how i improted from csv. My knowledge is very minimal at the moment but i am enjoying learning
@jitensh i think that is what i will need.
The attribute i am updating wth the employee number is called employee number the users AD attributes. My company chose to go with employee number rather than employee ID. So will this modification to your script work for that purpose?
$users=Import-Csv c:\filename.csv foreach($user in $users){ Get-Aduser $user.samaccountname|set-aduser -employeenumber $user.employeeNumber.

If i wish to run that as a test do i just add -whatif or do i need to pipe it first.
Thanks for all of your comments guys. Its a really helpful community here
Sam

Evan7191 · 2019-09-03T13:54:47.000Z

samuel.bennett:

If i wish to run that as a test do i just add -whatif or do i need to pipe it first.

You can add -WhatIf, because it is a common parameter available to every native Powershell command.

spiceuser-6qogk · 2019-09-03T14:10:59.000Z

Thanks for your help Guys. That will be my little project for tonight when i am at home.

jitensh · 2019-09-03T14:27:29.000Z

your company may call it employee number but its employee id in AD.

spiceuser-6qogk · 2019-09-04T08:03:40.000Z

@jitensh The field i was updating is employeenumber as that is what my company decided to use.
But thank you for your script it worked perfectly.
Sam

jitensh · 2019-09-04T09:21:03.000Z

Please close the topic but marking the answer as best answer> select answer> manage> best answer