how bulk update student & teacher on classroom in csv

421 views
Skip to first unread message

rid donlot

unread,
Jul 25, 2022, 5:16:05 AM7/25/22
to GAM for Google Workspace
Hi there,

Im difficult to sync with bulk, an 403 error showed 
my command is
> gam course 526072940872 sync students file list08.csv

Screenshot_12.png

this is the sample csv file that I get from print results
Screenshot_13.png
is there any proper command to sync all student and teacher to a classroom?

thankyou!

Jason Jones

unread,
Jul 25, 2022, 6:04:11 AM7/25/22
to google-ap...@googlegroups.com
Hello! What I do personally is two different CSV's. One for classroom creation/teachers and one for students. 

Classroom Creation/Staff - CSV Headers I use are alias, classname, section, classtitle, room, teacheremail. Then use the following GAM Command...
gam csv CSVNAME.csv gam create course alias ~alias name ~classname section ~section heading ~classtitle room ~room teacher ~teacheremail status PROVISIONED 

I start with provisioned so it's not activated but the primary teacher and domain admins can still access it and can change it to active when ready. 

GAM Mass Adding Students - CSV Headers I use are email, Firstname, Lastname, Org, Course. I then use the following GAM Command.
gam csv CSVNAME.csv gam course ~Course add student ~email

You can add additional teachers to the courses as well by using the same command except switch 'add student' to 'add teacher'

rid donlot

unread,
Jul 26, 2022, 4:59:03 AM7/26/22
to GAM for Google Workspace
big thanks Jason, it worked!
seems like we have to split teacher and student bulk upload because they have different userRole (TEACHER/STUDENT)
Reply all
Reply to author
Forward
0 new messages