STtools

1.2.3

Tools for school system admins.  Currently setting groups based on arbitrary CSV files is implemented.

Examples:

# Year level groups for students
# Students are assigned to groups according to their year level based n their SCHOOL_YEAR in CASES
# eg. Year7, Year8, ...
Get-STGroupsFromCSV -csvfile "\\path\to$\STUDENT.csv" -prefix "Year" -username_header "STKEY
Tools for school system admins.  Currently setting groups based on arbitrary CSV files is implemented.

Examples:

# Year level groups for students
# Students are assigned to groups according to their year level based n their SCHOOL_YEAR in CASES
# eg. Year7, Year8, ...
Get-STGroupsFromCSV -csvfile "\\path\to$\STUDENT.csv" -prefix "Year" -username_header "STKEY" -group_header "SCHOOL_YEAR" -stripzeros -filter {$_.STATUS -eq "ACTV"} |ForEach-Object {
   Remove-ADGroupMember -Identity $_.Identity -Members $_.NonMembers -Confirm:$false -PassThru
   Add-ADGroupMember -Identity $_.Identity -Members $_.Members -Confirm:$false -PassThru
}

# Year level groups for staff
# Staff are assigned to groups according to the year levels of classes in their timetabler
# eg. 7teachers, 8teachers ...
Get-STGroupsFromCSV -csvfile "\\path\to\classes\taught.csv" -username_header "Teacher Code" -group_header "Roll Class Code" -postfix teachers -onlynumbers |ForEach-Object {
   Remove-ADGroupMember -Identity $_.Identity -Members $_.NonMembers -Confirm:$false -PassThru
   Add-ADGroupMember -Identity $_.Identity -Members $_.Members -Confirm:$false -PassThru
}

# Staff group
# Staff are assigned to the Staff group according to them being active in CASES
Get-STGroupsFromCSV -csvfile "\\path\to\file\with\staff.csv" -username_header "SFKEY" -group_name "Staff" -filter {$_.STAFF_STATUS -eq "ACTV"} |ForEach-Object {
   Remove-ADGroupMember -Identity $_.Identity -Members $_.NonMembers -Confirm:$false -PassThru
   Add-ADGroupMember -Identity $_.Identity -Members $_.Members -Confirm:$false -PassThru
}

# Class groups for students
# Students are assigned to groups according to classes they have in timetabler
# eg. 07ENG1, 08ENG3, ...
Get-STGroupsFromCSV -csvfile "\\path\to\file\with\classes.csv" -username_header "Student Code" -group_header "Class Code" |ForEach-Object {
   Remove-ADGroupMember -Identity $_.Identity -Members $_.NonMembers -Confirm:$false -PassThru
   Add-ADGroupMember -Identity $_.Identity -Members $_.Members -Confirm:$false -PassThru
}
Show more

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name STtools -RequiredVersion 1.2.3

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Author(s)

Eric van de Paverd

Copyright

(c) 2018 Eric van de Paverd. All rights reserved.

Package Details

FileList

Version History

Version Downloads Last updated
1.3.2 280 11/21/2019
1.3.1 73 5/6/2019
1.3.0 40 2/11/2019
1.2.14 21 2/4/2019
1.2.13 15 2/4/2019
1.2.12 15 1/30/2019
1.2.11 50 10/1/2018
1.2.10 26 9/10/2018
1.2.9 18 9/10/2018
1.2.8 23 8/31/2018
1.2.7 25 8/17/2018
1.2.6 18 8/13/2018
1.2.5 19 7/30/2018
1.2.4 16 7/30/2018
1.2.3 (current version) 21 7/19/2018
1.2.2 15 7/16/2018
1.2.1 36 3/26/2018
1.2 16 3/19/2018
1.1 14 3/19/2018
1.0 29 2/19/2018
Show less