home.social

#googleadmin — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #googleadmin, aggregated by home.social.

  1. I spent several frustrating hours trying to figure out an elegant solution to a #GAM problem.

    I did not figure it out. I did a mind-numbing amount of copying and pasting instead.

    But I still want to figure it out for next time, so if you know GAM, #GoogleAdmin, #edtech, #GoogleClassroom, #bash?... seeking hints.

    -----

    I want to add our students to their Google Classroom courses.

    I have the students added to a group.

    Attempt 1: Add the group email to the course as a student (in bulk via CSV). It works when an individual teacher does it, right? Failed.

    Attempt 2: Sync the course participants with the group membership (in bulk via CSV). There's documentation that says this is a feature! But it's a lie. Failed.

    I tried to convince GAM a couple different ways, but the only way I'm left with is to make one *monster* CSV, listing the students one by one for every course.

    So. I've got a CSV of course alias, group email. I've got another CSV with student email, group email. I need to make a CSV with course alias, student email.

    I know in my *bones* there was a way to create that obnoxiously long CSV that didn't involve nearly so much copy-paste. Do you know what it was?