GAM-ADV Parent Sync?

254 views
Skip to first unread message

Kyle Hancock

unread,
Sep 10, 2018, 12:42:22 PM9/10/18
to GAM for G Suite
We are working on automating student rostering from our PowerSchool SIS into Google Classroom.

So far we have automated course syncing and rosters. Our final goal is to invite parents. I can create the invitates no problem but I'm wounding if there is any possibility a sync functionality would be built into GAM-ADV similar to the student and teacher sync?

Thanks!
Kyle

Ross Scroggs

unread,
Sep 10, 2018, 1:01:26 PM9/10/18
to google-ap...@googlegroups.com
Kyle,

I'm not clear on what syncing you are looking for? Are you trying to automate the guardian invites?

Ross

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/c41db646-9f68-4ee7-b9b6-f552ab21c4e6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


--

Kyle Hancock

unread,
Sep 10, 2018, 1:12:48 PM9/10/18
to google-ap...@googlegroups.com

Yes, sorry. We are trying to keep parent invites in sync with our SIS, just like we use GAM-ADV to keep course rosters in sync with our SIS.

 

Kyle

 

Kyle Hancock, MIS
Director of Information Technology

603-883-7765 

Skype for Business Logo khan...@sau81.org

khan...@sau81.org 
SAU81 – Hudson School District

20 Library Street

Hudson, NH 03051 www.sau81.org

 

 

 

 

 

 

 

 


For more options, visit https://groups.google.com/d/optout.


Warning: This message is from outside the SAU81 network. Be careful with attachments and links!

Ross Scroggs

unread,
Sep 10, 2018, 1:39:43 PM9/10/18
to google-ap...@googlegroups.com
Kyle,

Syncing in the Gam sense isn't what you want; you could certainly output a CSV file (let's call it StudentGuardians.csv) from the SIS with two columns: Student,Guardian
Then you could say:

gam csv StudentGuardians.csv gam create guardian ~Guardian ~Student


Ross



For more options, visit https://groups.google.com/d/optout.


--

Kyle Hancock

unread,
Sep 10, 2018, 1:48:18 PM9/10/18
to google-ap...@googlegroups.com

+KimNilsson

unread,
Sep 18, 2018, 4:12:09 AM9/18/18
to GAM for G Suite
@Kyle, this would require that you SIS exports first the deleted guardian email address, with student email, and then export the new guardian email with student email.
Without both those lines there's no way that GAM can "update" the guardian info, since GAM (today) can only create and delete guardians, not update.

Ross Scroggs

unread,
Sep 18, 2018, 9:29:03 AM9/18/18
to google-ap...@googlegroups.com
Kyle and I have worked onthis privately, here's what's coming in the next day or so.
Enhanced all guardian commands to support a syntax similar to other commands.
Added a command to clear all guardian invitations and accepted guardians for a student.
Added a command to sync guardians where the new set of guardians is specified in the command line
and Gam deletes any pending guardian invitations and accepted guardians that are not in the new set and sends
invitations to the members in the new set that don't have a pending invitation or have not accepted.
Multiple guardians can be specified in create, cancel, delete and sync.
Added formatjson option to gam show/print guardians; added quotechar <Character> option to gam print guardians.
    gam <UserTypeEntity> create|add guardian|guardianinvite|inviteguardian <GuardianEntity>
    gam <UserTypeEnfity> cancel guardianinvitation|guardianinvitations <GuardianInvitationIDEntity>
    gam <UserTypeEntity> delete guardian|guardians <GuardianEntity> [accepted|invitations|all]
    gam <UserTypeEntity> clear guardian|guardians [accepted|invitations|all]
    gam <UserTypeEntity> sync guardian|guardians <GuardianEntity>
    gam <UserTypeEntity> show guardian|guardians [accepted|invitations|all] [states <GuardianInvitationStateList>] [invitedguardian <EmailAddress>]
        [showstudentemails] [formatjson]
    gam <UserTypeEntity> print guardian|guardians [todrive <ToDriveAttribute>*] [accepted|invitations|all] [states <GuardianInvitationStateList>] [invitedguardian <EmailAddress>]
        [showstudentemails] [formatjson] [quotechar <Character>]

Ross

On Sep 18, 2018, at 1:12 AM, +KimNilsson <there.is.no...@gmail.com> wrote:

@Kyle, this would require that you SIS exports first the deleted guardian email address, with student email, and then export the new guardian email with student email.
Without both those lines there's no way that GAM can "update" the guardian info, since GAM (today) can only create and delete guardians, not update.

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.

Ross Scroggs

unread,
Sep 21, 2018, 12:34:17 AM9/21/18
to google-ap...@googlegroups.com
Kyle,

Gam 4.61.00 is available.

Enhanced all guardian commands to support a syntax similar to other commands.
* Added a command to clear all guardian invitations and accepted guardians for a student.
* Added a command to sync guardians where the new set of guardians is specified in the command line
and Gam deletes any pending guardian invitations and accepted guardians that are not in the new set and sends
invitations to the members in the new set that don't have a pending invitation or have not accepted.
* Multiple guardians can be specified in create, cancel, delete and sync.
* Added formatjson option to gam show/print guardians; added quotechar <Character> option to gam print guardians.
    gam <UserTypeEntity> create|add guardian|guardianinvite|inviteguardian <GuardianEntity>
    gam <UserTypeEnfity> cancel guardianinvitation|guardianinvitations <GuardianInvitationIDEntity>
    gam <UserTypeEntity> delete guardian|guardians <GuardianEntity> [accepted|invitations|all]
    gam <UserTypeEntity> clear guardian|guardians [accepted|invitations|all]
    gam <UserTypeEntity> sync guardian|guardians <GuardianEntity>
    gam <UserTypeEntity> show guardian|guardians [accepted|invitations|all] [states <GuardianInvitationStateList>] [invitedguardian <EmailAddress>]
        [showstudentemails] [formatjson]
    gam <UserTypeEntity> print guardian|guardians [todrive <ToDriveAttribute>*] [accepted|invitations|all] [states <GuardianInvitationStateList>] [invitedguardian <EmailAddress>]
        [showstudentemails] [formatjson] [quotechar <Character>]

For example, your school SIS produces a CSV file, StudentGuardians.csv, each evening with two columns: Student,Guardian.
There is no indication as to what changes have been made from the night before. The following command will perform the necessary changes.
gam csvkmd users StudentGuardians.csv keyfield Student datafield Guardian sync guardians csvdata Guardian

Ross

On Sep 10, 2018, at 10:48 AM, Kyle Hancock <khan...@sau81.org> wrote:

<image004.png>

Kyle Hancock, MIS
Director of Information Technology

 khan...@sau81.org  
SAU81 – Hudson School District
20 Library Street
Hudson, NH 03051  www.sau81.org
 
From: google-ap...@googlegroups.com <google-ap...@googlegroups.com> On Behalf Of Ross Scroggs
Sent: Monday, September 10, 2018 1:39 PM
To: google-ap...@googlegroups.com
Subject: Re: [GAM] GAM-ADV Parent Sync?
 
Kyle, 
 
Syncing in the Gam sense isn't what you want; you could certainly output a CSV file (let's call it StudentGuardians.csv) from the SIS with two columns: Student,Guardian
Then you could say:
gam csv StudentGuardians.csv gam create guardian ~Guardian ~Student


Ross
 
On Mon, Sep 10, 2018 at 10:12 AM Kyle Hancock <khan...@sau81.org> wrote:

Kyle Hancock, MIS
Director of Information Technology

Jason Komendat

unread,
Nov 27, 2019, 2:43:57 PM11/27/19
to GAM for G Suite
Can I ask how you got Classroom syncing to work? Do you have it set to remove students from classes if they are taken out in the SIS?

Ross Scroggs

unread,
Nov 27, 2019, 3:30:54 PM11/27/19
to google-ap...@googlegroups.com
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages