Our Principal want it tied into a student's academic classes (of which 1 student has many) so the teacher of that class can send an email to the whole of the class. So for Year 10 Science Group 1, Mr Jones can send them all an email with their homework.
Fortunately our MIS (SIMS) lets you create bespoke reports and export them as spreadsheets so I have created two. One with all the classes listed, and one with all students and the classes they belong to.
Unfortunately the data still requires editing so I'm creating a couple of VBA macros to do that. Then the idea is I will import these csv files (first create the groups, then assign the students to those groups) into AD using a Powershell script. Finally I'll sync all this with Google.
It's a bit of a faff TBH and our class lists change throughout the year too. Fun times ahead!
Studentnet | Make the Cloud Yours!), which can replace GADS and GAPS, as well as pulling student groups and classlists from school admin systems and automatically creating email groups in Google Apps. They are dynamically updated. It can also provide SSO for Zendesk and other systems.
It can do all you want and more.
I have a report in SIMS that outputs pupils and classes, so my workflow is SIMS reports -> bulk AD upload tool (to make AD match SIMS info) -> GADS
After this I have pupils in the correct groups in both AD and Google Apps and group email addresses.
Thanks for that. I've had a look but we don't need that level of granularity (plus I can script something myself to do it).
At the end of the academic year our students go up a year and all their classgroups change.
I can handle the altering of groups within AD but will GADS pick this up and alter their groups accordingly? Otherwise there would be a horrific situation where someone who had gone from Year 9 to Year 10 would be a member (in Google) of all the Year 9 and 10 classlists.
I'm guessing (and hoping) GADS handles this seamlessly but it doesn't harm to ask those of you who have experience.
I'm hoping to try this over the summer for CMIS. One thing I'm not sure on - how do I get CMIS to automatically create the 5 .csv files that SDS needs? Is there any help online for this bit of the system?
One other thing - we have staff on one domain and pupils on another - presumably we can only use this for one (probably the pupil one)?
If this works it will be something I've been after for a couple of years.
Wish me luck...
I was aiming to use the SDS tool rather than GADS - unless they are the same thing? That seems to be set up to use with MIS systems?
My requirements are similar to TallPall's - to create live email groups usable by staff. I found a way of creating them via scripts this year, but a) they were out of date pretty quickly, and b) google have helpfully depreciated the calls I was using.
CMIS staff and student data which may be some help to start.
I've never used powershell in my life so that should fun! I've done shell files and pipes in my dim and distant past so could probably do it... eventually!
I know how to create reports in CMIS, just need to work out how to get those to save as daily .csv files. Presumably there's some way of doing that in CMIS.
There are currently 1 users browsing this thread. (0 members and 1 guests)