I start my day with 2 slices of humble pie with my coffee which is a nice way to say I know my limitations and when to ask for help and advice.
I work with a small school system and have run into a minor challenge
I download an error report from our Dept. of Education in a csv format, we have an alternative school program which has a separate school ID. I am able to export the active students from our Student Information System for the alternative school our extract for the DOE from our SIS does not include the Alternative School Program instead we use a school override code to report the student in the school they would be attending.
my goal is to use the Get-Content function for the csv list of the active students in the Alternative Program compare the student SSAN from the Alternative School List to the Student SSAN in the error report downloaded from our DOE and output the record to a separate file.
there are numerous errors that can be present for each student from attendance, discipline, course, etc. I need to pass the value from the Get-content and compare it to the entire error list and output each record found. the column heading for the DOE file are:
SYSTEM_ID SCHOOL_ID STUDENT_ID STUDENT_NAME GRADE_LEVEL COURSE_NUMBER ERROR_CODE DESCRIPTION FIELD_NAME FIELD_CONTENT RECORD_TYPE MODIFIED_DATE
I can adjust my SIS export to include school number and student SSAN which is our Student ID
I went back and reviewed the MVA Jumpstart for PowerShell 3.0 presented by Jason Helmick and Jeffery Snover
I am sure this is one of the real world opportunities they were talking about
any and all help appreciated and thanks for taking the time to look this problem over.