updating existing groups

[M Anon]

Hi,

We generate a CSV that lists the student's email and the groups they belong to. We want to use it to:

1. Create the group if it doesn't exist

2. Update the group membership to contain only the students in the current CSV

We achieve the 1st part via "gam csv filename.csv gam create group ~GROUP" which just errors out if the group already exists. The 2nd part is trickier:

gam csv filename.csv gam update group ~GROUP_EMAIL remove all users

gam csv filename.csv gam update group ~GROUP_EMAIL add member user ~STUDENT

It appears to work but was wondering if there is a simpler way that I might not be aware of?

[M Anon]

I meant to say "It DOES NOT appear to work and was wondering if there is a simpler way" ....

[Ross Scroggs]

gam csv filename.csv gam update group ~GROUP_EMAIL clear members

gam csv filename.csv gam update group ~GROUP_EMAIL add member user ~STUDENT

Ross

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/d875ac74-e460-49eb-93c5-fcaf2e2f1d30n%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[M Anon]

Thanks Ross.

I tried it (BTW it accepts member only not memberS) and interestingly enough, using my test CSV with only 2 groups, it cleared the users out of the 2nd group but not the first. As a test, I added more groups and repeated the test and I can see some have been cleared but some are not (random).

I am on the latest 6.07 version.

[Maj Marshall Giguere]

Ross;

I noted the "clear member" option.  Can you point me the the api doc for the semantics.  I looked and came up empty.

Thanks

-Marsh

Maj Marshall E. Giguere, CAP

NH Wing Director of IT

U.S. Air Force Auxiliary

nhwg.cap.gov

GoCivilAirPatrol.com

 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS-AR7ODZQCq%2Bjybv6D2bFi8oizC-522_as1LTTtv%3DHaUA%40mail.gmail.com.

[Ross Scroggs]

Marsh,

It's not in the API, gam gets the members and then tosses them,

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CADSK1vshr-x_2QADUBnB2tz4v%3DbDrE6YUqpmLPT51pqEygxdAg%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

[Maj Marshall Giguere]

Ross;

So, gam "clear" is a convenience function.  Does what I do with my database app, but with less work on my part. ;-)

Maj Marshall E. Giguere, CAP

NH Wing Director of IT

U.S. Air Force Auxiliary

nhwg.cap.gov

GoCivilAirPatrol.com

 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS9TjxcKfwdZwi8W6%2BFYjDe%3Dpa-y-CLAMie5md8Z3A6hVw%40mail.gmail.com.

[Ross Scroggs]

Yep. That's me, Mr. Convenience.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CADSK1vvtrvnc3dGU6hkawDHofEmNQObiWwBErWfN%2B8YAsdYm7Q%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

[M Anon]

Hi,

gam clear unfortunately, does not work for us ... the members and owners are still there. Any other recommendations?

[Ross Scroggs]

gam update group <GroupItem> clear [member] [manager] [owner] [notsuspended|suspended]

If you want to clear the owners and mangers, you have to indidate that's what you wantto do.

gam update group gr...@domain.com clear manager owner

Ross

--

ross.s...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/8ed47bb8-f572-4ab4-bbc3-d43737257cben%40googlegroups.com.

[M Anon]

Hi Ross,

My apologies for not being clear. Yes, that's what I meant:

gam csv groups.csv gam update group ~GRP_EMAIL clear owner

gam csv groups.csv gam update group ~GRP_EMAIL clear member

The 2 commands above does not work. When I do a:

gam info group 11-EXAMPL...@ourschool.domain

It shows the owners (teachers) and members (students) still there.

[Ross Scroggs]

M Anon,

What is the output from these commands?

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/5da3598b-cd2a-4906-a427-2d5f6be60346n%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[M Anon]

As I was trying to capture the output, I noticed that it works when I run it without the "GAM CSV" prefix. But as soon as I use it with "gam csv", it fails:

I also notice that when I use it with GAM CSV, it doesn't tell me it's removing the users whereas with just GAM UPDATE, it does tell me (green arrow)

[Ross Scroggs]

You are using Jay's Standard GAM. It does not correctly process bulk group membersship changes when you do gam csv.

Advanced GAM handles this correctly; see: https://github.com/taers232c/GAMADV-XTD3/wiki/How-to-Upgrade-from-Standard-GAM

Ross

--

ross.s...@gmail.com

On Aug 24, 2021, at 5:01 PM, M Anon <afn2...@gmail.com> wrote:

As I was trying to capture the output, I noticed that it works when I run it without the "GAM CSV" prefix. But as soon as I use it with "gam csv", it fails:

<gam clear 1.png>

<gam clear 2.png>

I also notice that when I use it with GAM CSV, it doesn't tell me it's removing the users whereas with just GAM UPDATE, it does tell me (green arrow)

<gam clear 3.png>

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/fe2393c5-7c5a-4ba9-b702-7591c5877becn%40googlegroups.com.
<gam clear 2.png><gam clear 1.png><gam clear 3.png>

[M Anon]

Thank you Ross.

I'll try the upgrade and report back.

[M Anon]

That worked. Thanks Ross!