Powershell script to check attribute values are present in each line of csv

Question

I am writing a Powershell script that generates username based on first and last name. I will be giving input csv which has various columns like first name, lastname, manager name, start date etc.
The script should check for mandatory attribute like first name, lastname, manager name, start date etc. for each user in csv, and if any of the mandatory attribute is missing for a particular user, that record should be skipped, and move to next line. And also, generate a different error file for all the skipped records with a reason like firstname is missing, managername is missing.

Answer 1

Try using Import-Csv to read the CSV file. The result is a table that you can use the Where-Object on to filter out rows that are missing values in the columns that you require.

Answer 2

Hi @Freddie ,

maybe this helps to get started:

CSV test file content:

firstname,lastname,manager,description  
paul,miller,mickeymouse,something  
,smith,paul,something  
peter,,someone,something  
Lucie,Meyers,,something  
Kerry,Longy,Peter,  

Script (assuming firstname, lastname and manager`` must be present. description` is optional):

Import-Csv -Path "Junk\checkvalue.csv" | ForEach-Object {  
    if (!$_.firstname -or !$_.lastname -or !$_.manager) {  
        Write-Output "some mandatory details are missing $_ "  
        Export-Csv -Path "Junk\checkvalue_missingdetails.csv" -InputObject $_ -Append -NoTypeInformation  
    }  
    else {  
        Write-Output "line contains all mandatory details ... do something"  
    }  
}  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten