Google Workspace Organisational Units for Classes - Automation?

[Alex0x7F]

Hello all,

 

My setting has now signed up to the J2E VLE for ICT. We are a Google Workspace school for the pupils and I have successfully created all pupils a J2E account by using the 'Sync with Google' option. Nice and easy! I also user Locker Connect, to automatically create the pupil's Google Workspace accounts accounts once they appear in ScholarPack and suspend leavers etc. However, Locker can only add new create accounts to OU's, NOT pre existing ones!

 

J2E sees Google's organisational units as the pupil's classes, so this is perfect for assigning work to the correct classes etc.

 

My last missing part of the puzzle is... is there a way to automate adding pupil accounts to their correct classes' organisational units?

 

At the moment I'm having to pull all the form registers from ScholarPack and manually type the OU in to Google users bulk update csv. (e.g. Organisational Unit: Accounts/Pupils/Lions) This isn't the end of the world, but it's bound to end up missing mid-term starters out of their classes' OU, and doesn't help with end of term wrap up of accounts.

 

Any ideas for a good workflow for this is appreciated... I don't mind doing it manually if I can figure out a nice workflow. Do any of you add pupils in to OU's based on registration groups? Do any alternative providers to Locker Connect like Salamander provide the ability to do this?

[ThatBoringBloke]

Seems strange that you would need to add each user to a class 'OU'. For instance each of our students are in around 13 unique classes for each suject they take. How would I decide which OU their account would need to be in?

Should the users not just be added to different groups?

[Alex0x7F]

or instance each of our students are in around 13 unique classes

 

Great question! Knew I'd left something out of the original post!

 

This is for two form entry primary school's so they stay with the same registration group all day, so the accounts will only need to be in one OU.

[jthompson]

Secondary here, so pupils are placed in OUs by cohort and never moved.

 

Are you able to set up your provisioning so as to populate pupil's 'Department' attribute in Google with their form name? If so, then some Apps Script might be able to routinely sort users into OUs depending on the value in 'Department'.

[Duke5A]

I'm not at all familiar with any of the services you listed, so if this doesn't apply to what your doing then just ignore it.

 

We're a Google school as well and I've completely automated account provisioning from our SIS to AD to Google. Setup uses Power Shell scripts that I wrote in conjunction with Google Apps Directory Sync. Students are placed in org units according to their graduation year. I can share the scripts if you want. They're pretty involved though since I have it doing pretty much everything.

 

I used to have another script that would create AD security groups based off of class lists for syncing to Google too. Never did end up using that in production, but I still have it laying around.