Update USER for Google Group with CSV File

444 views
Skip to first unread message

Arnaud Besson

unread,
Mar 27, 2018, 5:54:31 AM3/27/18
to GAM for G Suite
Hi ! 

I want to add 2800 users in a group

For this, I have a CSV file containing all e-mail addresses (one per cell)

I use this command line

gam csv C: \ Users \ XXX \ Downloads \ XXXX.csv group update X...@XXX.com add user

When I execute the command, I have this display running in a loop

Thanks,

Arnaud
BUG 00.PNG

✉ Kevin Melillo

unread,
Mar 27, 2018, 7:52:30 AM3/27/18
to google-ap...@googlegroups.com
You need to have a header on the csv file...  the first line...  example

email

Then you can issue the following command

gam csv C:\Users\XXX\Downloads\XXXX.csv gam update group grou...@domain.com add member ~email




--
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-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@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/8ba8968e-c2db-4869-92f0-eb399768b170%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Kevin Melillo
Electronic Communications Analyst
Information Technology
445 Hoes Lane
Piscataway, NJ 08854

Phone:732-465-6609 | Mobile: 732-609-4331

Ross Scroggs

unread,
Mar 27, 2018, 9:36:04 AM3/27/18
to google-ap...@googlegroups.com
Kevin,

In simple cases like this, gam csv is not required.
Assuming the file xxxx.csv has no header row, do the following:
gam update group grou...@domain.com add member file "C:\Users\XXX\Downloads\XXXX.csv"

Assuming the file xxxx.csv has a header row containing the value email, do the following:
gam update group grou...@domain.com add member csvfile "C:\Users\XXX\Downloads\XXXX.csv:email"
Unfortunately, in this case the : after the C is misinterpreted, so, assuming you're already on the C drive, do the following:
gam update group grou...@domain.com add member csvfile "\Users\XXX\Downloads\XXXX.csv:email"

Ross

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.

Arnaud Besson

unread,
Mar 27, 2018, 9:45:46 AM3/27/18
to GAM for G Suite
Thank you !

I managed to place my order,
Reply all
Reply to author
Forward
0 new messages