Bulk user operations from CSV in PowerShell - Mini Project: Build & Apply

Bulk user operations from CSV

📖 Scenario: You are an IT assistant who needs to update user accounts in bulk using data from a CSV file. The CSV contains usernames and their new email addresses. You want to automate this task using PowerShell to save time and avoid mistakes.

🎯 Goal: Create a PowerShell script that reads user data from a CSV file, filters users based on a condition, updates their email addresses, and displays the updated information.

📋 What You'll Learn

Create a variable to import CSV data with exact filename 'users.csv'

Create a variable called 'emailDomain' with the value '@example.com'

Use a loop to find users whose username starts with 'user' and update their email

Print the updated user list showing username and new email

💡 Why This Matters

🌍 Real World

Automating bulk updates of user accounts from CSV files is common in IT departments to save time and reduce manual errors.

💼 Career

This skill is useful for system administrators, IT support staff, and anyone managing user data in organizations.

1

Import CSV data

Create a variable called users that imports data from the CSV file named users.csv using Import-Csv.

PowerShell

# Create a variable called users to import users.csv
# Your code here

Hint

Use Import-Csv -Path 'users.csv' to read the CSV file into a variable.

2

Set email domain configuration

Create a variable called emailDomain and set it to the string '@example.com'.

PowerShell

$users = Import-Csv -Path 'users.csv'
# Create a variable called emailDomain with value '@example.com'
# Your code here

Hint

Just assign the string '@example.com' to the variable emailDomain.

3

Update user emails based on username

Use a foreach loop with variable user to go through $users. Inside the loop, check if $user.username starts with 'user'. If yes, update $user.email to be $user.username plus $emailDomain.

PowerShell

$users = Import-Csv -Path 'users.csv'
$emailDomain = '@example.com'
# Loop through users and update email if username starts with 'user'
# Your code here

Hint

Use foreach ($user in $users) and inside check $user.username.StartsWith('user'). Then update $user.email.

4

Display updated users

Use foreach with variable user to loop over $users and print the username and email in the format: Username: [username], Email: [email] using Write-Output.

PowerShell

$users = Import-Csv -Path 'users.csv'
$emailDomain = '@example.com'
foreach ($user in $users) {
    if ($user.username.StartsWith('user')) {
        $user.email = "$($user.username)$emailDomain"
    }
}
# Print updated users
# Your code here

Hint

Loop through $users and use Write-Output to print username and email in the required format.

Practice

1. What is the primary purpose of using Import-Csv in bulk user operations in PowerShell?

easy

A. To create a new CSV file with user details

B. To read user data from a CSV file into PowerShell objects

C. To delete users from Active Directory

D. To export user data to a CSV file

Solution

1. Step 1: Understand Import-Csv function

   Import-Csv reads data from a CSV file and converts each row into a PowerShell object with properties matching the CSV headers.

2. Step 2: Identify its role in bulk user operations

   In bulk user operations, Import-Csv is used to load user data so scripts can process each user easily.

3. Final Answer:

   To read user data from a CSV file into PowerShell objects -> Option B

4. Quick Check:

   Import-Csv reads CSV data [OK]

Hint: Import-Csv always reads data into objects, not writes [OK]

Common Mistakes:

• Confusing Import-Csv with Export-Csv
• Thinking Import-Csv deletes or modifies users
• Assuming Import-Csv creates new CSV files

2. Which of the following is the correct syntax to process each user from a CSV file named users.csv in PowerShell?

easy

A. Import-Csv users.csv | ForEach-Object { Write-Host $_.Name }

B. ForEach-Object Import-Csv users.csv { Write-Host $_.Name }

C. Import-Csv users.csv ForEach { Write-Host $_.Name }

D. Get-Csv users.csv | ForEach-Object { Write-Host $_.Name }

Solution

1. Step 1: Recognize correct pipeline usage

   Import-Csv users.csv outputs objects piped into ForEach-Object to process each user.

2. Step 2: Validate syntax correctness

   Import-Csv users.csv | ForEach-Object { Write-Host $_.Name } correctly uses the pipeline and script block syntax to access each user's Name property.

3. Final Answer:

   Import-Csv users.csv | ForEach-Object { Write-Host $_.Name } -> Option A

4. Quick Check:

   Pipeline with Import-Csv and ForEach-Object is correct [OK]

Hint: Use pipeline: Import-Csv | ForEach-Object { } [OK]

Common Mistakes:

• Misplacing ForEach-Object before Import-Csv
• Using Get-Csv which doesn't exist
• Omitting the pipeline operator |

3. Given the CSV file users.csv with content:

Name,Email
Alice,[e-mail]
Bob,[e-mail]

What will the following script output?

Import-Csv users.csv | ForEach-Object { Write-Output $_.Email }

medium

A. [e-mail]
[e-mail]

B. Name
Email

C. Alice
Bob

D. Error: Property 'Email' not found

Solution

1. Step 1: Understand CSV data and properties

   The CSV has two rows with headers Name and Email. Import-Csv creates objects with these properties.

2. Step 2: Trace the script output

   The script outputs the Email property of each object, so it prints [e-mail] and [e-mail] on separate lines.

3. Final Answer:

   [e-mail] [e-mail] -> Option A

4. Quick Check:

   Output emails from CSV rows [OK]

Hint: Output property names exactly as CSV headers [OK]

Common Mistakes:

• Printing header names instead of values
• Confusing Name and Email properties
• Expecting error due to property access

4. You wrote this script to create users from a CSV but it fails with an error:

Import-Csv users.csv | ForEach-Object { New-ADUser -Name $_.Name -EmailAddress $_.Email }

What is the most likely cause?

medium

A. The pipeline operator | is missing

B. The CSV file is empty

C. You forgot to import the Active Directory module

D. The New-ADUser cmdlet does not have an -EmailAddress parameter

Solution

1. Step 1: Check New-ADUser parameters

   New-ADUser does not accept -EmailAddress directly; email is set via -UserPrincipalName or -OtherAttributes.

2. Step 2: Identify error cause

   Using an invalid parameter causes the script to fail with an error about unknown parameter.

3. Final Answer:

   The New-ADUser cmdlet does not have an -EmailAddress parameter -> Option D

4. Quick Check:

   Invalid parameter causes error [OK]

Hint: Check cmdlet parameters with Get-Help [OK]

Common Mistakes:

• Assuming all user properties are direct parameters
• Ignoring module import errors
• Missing pipeline operator in script

5. You want to bulk update users' department from a CSV file update.csv with columns Username and Department. Which script correctly updates the department attribute in Active Directory?

hard

A. Import-Csv update.csv | ForEach-Object { Set-ADUser -Name $_.Username -Email $_.Department }

B. Import-Csv update.csv | ForEach-Object { New-ADUser -Name $_.Username -Department $_.Department }

C. Import-Csv update.csv | ForEach-Object { Set-ADUser -Identity $_.Username -Department $_.Department }

D. Import-Csv update.csv | ForEach-Object { Set-ADUser -UserPrincipalName $_.Username -Department $_.Department }

Solution

1. Step 1: Identify correct cmdlet for updating users

   Set-ADUser updates existing users; New-ADUser creates new users, so Import-Csv update.csv | ForEach-Object { New-ADUser -Name $_.Username -Department $_.Department } is incorrect.

2. Step 2: Check parameters for updating department

   -Identity accepts username or other identifiers; -Department sets the department attribute correctly. Import-Csv update.csv | ForEach-Object { Set-ADUser -Identity $_.Username -Department $_.Department } uses these properly.

3. Step 3: Evaluate other options

   Import-Csv update.csv | ForEach-Object { Set-ADUser -Name $_.Username -Email $_.Department } uses invalid -Email parameter; Import-Csv update.csv | ForEach-Object { Set-ADUser -UserPrincipalName $_.Username -Department $_.Department } uses -UserPrincipalName which may not match Username column, risking errors.

4. Final Answer:

   Import-Csv update.csv | ForEach-Object { Set-ADUser -Identity $_.Username -Department $_.Department } -> Option C

5. Quick Check:

   Set-ADUser with -Identity and -Department updates users [OK]

Hint: Use Set-ADUser with -Identity to update existing users [OK]

Common Mistakes:

• Using New-ADUser instead of Set-ADUser for updates
• Confusing parameter names like -Email vs -Department
• Using wrong identity parameter causing errors