Thing to Create AD Email/Gmail Groups for "Teachers of %student% / %class%"?

[JRA]

Hi all - that's going to be a very odd one to describe, but we previously used something called MIS2AD, which has become ropey and stopped working. I don't think you can download it any more.

 

What I'd ideally like to do is, probably with a .csv, export a list of teachers and students and classes from SIMS and have email groups created overnight for:

 

- Teachers of classes

- Teachers of each student

- Students in each class

 

These would ofc need to be AD groups with email addresses, and gmail *should* be able to create the groups and modify members itself. I'd also definitely want to be able to manually add teachers to groups, so I have the option to include other staff in emails and not have my automation bin them every night.

 

Does anyone have any idea what I'm talking about and also any idea how to achieve this old garbage?

 

Lol, thanks anyone who's read this far!

[jcs808]

We subscribe to Salamandersoft.co.uk for this, extracts everything from SIMS.

[howartp]

Ditto.

[RLR]

+1 for salamander. They create all our Classes for us.

[CHiLL]

We also use Salamander. I cannot praise it enough, given how much time and effort it has saved my department. It can manage both staff and students, provisioning AD users, Office 365 licenses (including mailboxes) and distribution groups based on classes and year groups. It does this dynamically, so as soon as something is changed in SIMS, it's modified in the next sync of Salamander. It also disable accounts/Office 365 should a student or member of staff leave and have an end date marked in SIMS's leaving date/employment section.

 

Salamander has become one of those systems that I forget about because it just does its job but I'd sure as hell notice it's absence should it go.

Edited June 25, 2019 by CHiLL

[Boredguy]

I used a SIMS report to do this and powershell.

We now have a group per student that contains all teachers of them, including ones where the class is split over different teachers.

 

Not bad for free.

 

{edit} Attached should be a screenshot of the SIMS report fields I am using

Edited June 25, 2019 by Boredguy

[HPlum78]

I would powershell the grass out of that! No need to pay for something when you can just build it...

[AliG]

I use activeman from ANB software. Just added this functionality at my request . Next up is rooms. Competitive price too.

[tech-man]

Would you be willing to share your PS script?

 

 

 

I used a SIMS report to do this and powershell.

We now have a group per student that contains all teachers of them, including ones where the class is split over different teachers.

 

Not bad for free.

 

{edit} Attached should be a screenshot of the SIMS report fields I am using

[Fazza]

Salamander all the way so they have the headache of supporting it when your own script doesnt work! Especially with all the changes that happen each year/month/week/day!