exporting group list with display name?

2,215 views
Skip to first unread message

Luey0517

unread,
Sep 21, 2012, 9:22:11 PM9/21/12
to google-ap...@googlegroups.com
My school has a google domain. I have created groups from our organization and wish to export to excel some of the groups. I have been able to easily export my group members from our organization to csv. What i am unable to do is to have the display name of the user come in with the other, mostly non essential fields. (hour, minute, second joined etc.) is there a way to export my member list with an ability to manage what fields get exported? I need email and display name. Nothing else, or at least the display name to be exported over.
Thank You

Chris Belicose

unread,
Apr 6, 2016, 12:14:18 PM4/6/16
to Google Apps Manager

The original post is a bit dated, but I also have been looking for a solution for quite some time.

When printing (to screen) or exporting a list of group members using GAM, gam info group <group> only provides a list of member email addresses.
Is there any way to retrieve member names, roles, or any additional data when using this GAM command?

Regards,
Chris

Ross Scroggs

unread,
Apr 6, 2016, 12:30:18 PM4/6/16
to google-ap...@googlegroups.com
Chris,

You want gam print groups:
gam print groups [todrive] ([domain <DomainName>] [member <UserItem>])
        [maxresults <Number>] [delimiter <String>]
        [members] [owners] [managers] <GroupFieldNames>* [settings]
<GroupFieldNames> ::=
        admincreated|aliases|description|email|id|name

You migt say: gam print groups delimiter ',' members owners managers description id name settings > groups.csv

Ross

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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/00d87cdd-8adf-410e-9a9b-d6413a93bc2e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Chris Belicose

unread,
Apr 6, 2016, 12:44:33 PM4/6/16
to Google Apps Manager
Thanks Ross.  This does provide data that includes email addresses of members, but not members names.  It also targets all groups.

I am searching for a command that returns the email address and real name of each member in a specified group.



On Wednesday, April 6, 2016 at 12:30:18 PM UTC-4, Ross Scroggs wrote:
Chris,

You want gam print groups:
gam print groups [todrive] ([domain <DomainName>] [member <UserItem>])
        [maxresults <Number>] [delimiter <String>]
        [members] [owners] [managers] <GroupFieldNames>* [settings]
<GroupFieldNames> ::=
        admincreated|aliases|description|email|id|name

You migt say: gam print groups delimiter ',' members owners managers description id name settings > groups.csv

Ross

On Apr 6, 2016, at 8:55 AM, Chris Belicose <cbel...@dwight.edu> wrote:


The original post is a bit dated, but I also have been looking for a solution for quite some time.

When printing (to screen) or exporting a list of group members using GAM, gam info group <group> only provides a list of member email addresses.
Is there any way to retrieve member names, roles, or any additional data when using this GAM command?

Regards,
Chris


On Friday, September 21, 2012 at 9:22:11 PM UTC-4, Luey0517 wrote:
My school has a google domain. I have created groups from our organization and wish to export to excel some of the groups. I have been able to easily export my group members from our organization to csv. What i am unable to do is to have the display name of the user come in with the other, mostly non essential fields. (hour, minute, second joined etc.) is there a way to export my member list with an ability to manage what fields get exported? I need email and display name. Nothing else, or at least the display name to be exported over.
Thank You

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

Ross Scroggs

unread,
Apr 6, 2016, 2:56:27 PM4/6/16
to google-ap...@googlegroups.com
Chris,

There is no API call that gets the data you want. We'd have to get the email addresses and then get the names one at a time. Are you on Windows or Mac/Linux?
I'm thinking to extend: gam print group-members group gr...@bar.com

$ gam print group-members group testgroup membernames

Getting all Members for test...@bar.com

id,role,group,email,type,memberFullName,memberGivenName,memberFamilyName,memberGroupName

111,MEMBER,test...@bar.com,ad...@bar.com,USER,Super admin,Super,admin,

222,MEMBER,test...@bar.com,jb...@bar.com,USER,Joe Blow,Joe,Blow,

333,OWNER,test...@bar.com,jsm...@bar.com,USER,Jim Smith,Jim,Smith,

444,MEMBER,test...@bar.com,sjo...@bar.com,USER,Sally Jones,Sally,Jones,

555,MEMBER,test...@bar.com,tjo...@bar.com,USER,Tom Jones,Tom,Jones,

666,MEMBER,test...@bar.com,msm...@notbar.com,USER,Unknown,Unknown,Unknown,

777,MEMBER,test...@bar.com,testg...@bar.com,GROUP,,,,Test - Group 2

888,MEMBER,test...@bar.com,testg...@bar.com,GROUP,,,,testg...@bar.com


Is this what you're looking for?

Ross

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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/4ac22f67-5300-4438-b1f6-e607087e2678%40googlegroups.com.

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



--

Chris Belicose

unread,
Apr 6, 2016, 3:14:10 PM4/6/16
to Google Apps Manager

Ross,

Thanks for your input on this.  It is definitely closer to what I am trying to achieve.  Ultimately, I would like to see:

Getting all Members for test...@bar.com

email,memberFullName

adm...@bar.com,Super admin

jbl...@bar.com,Joe Blow


But I'll take what I can get.  I am on Mac/Linux.

When you say "extend: gam print group-members gr...@bar.com", can you explain what that means, and what I need to do?

As is, when I enter:  gam print group-members group <group> membernames
I get: "membernames is not a valid argument for "gam print group-members".


Regards,
Chris



On Wednesday, April 6, 2016 at 2:56:27 PM UTC-4, Ross Scroggs wrote:
Chris,

There is no API call that gets the data you want. We'd have to get the email addresses and then get the names one at a time. Are you on Windows or Mac/Linux?
I'm thinking to extend: gam print group-members group gr...@bar.com

$ gam print group-members group testgroup membernames

Getting all Members for test...@bar.com

id,role,group,email,type,memberFullName,memberGivenName,memberFamilyName,memberGroupName

111,MEMBER,test...@bar.com,adm...@bar.com,USER,Super admin,Super,admin,

222,MEMBER,test...@bar.com,jbl...@bar.com,USER,Joe Blow,Joe,Blow,

333,OWNER,test...@bar.com,jsmi...@bar.com,USER,Jim Smith,Jim,Smith,

444,MEMBER,test...@bar.com,sjo...@bar.com,USER,Sally Jones,Sally,Jones,

555,MEMBER,test...@bar.com,tjo...@bar.com,USER,Tom Jones,Tom,Jones,

666,MEMBER,test...@bar.com,msm...@notbar.com,USER,Unknown,Unknown,Unknown,

777,MEMBER,test...@bar.com,testg...@bar.com,GROUP,,,,Test - Group 2

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.



--

Ross Scroggs

unread,
Apr 6, 2016, 3:23:11 PM4/6/16
to google-ap...@googlegroups.com
Chris,

Extend as in "I'm adding the code as we speak."

Ross

On Wed, Apr 6, 2016 at 12:14 PM, Chris Belicose <cbel...@dwight.edu> wrote:

Ross,

Thanks for your input on this.  It is definitely closer to what I am trying to achieve.  Ultimately, I would like to see:

Getting all Members for test...@bar.com

email,memberFullName

adm...@bar.com,Super admin

jbl...@bar.com,Joe Blow


But I'll take what I can get.  I am on Mac/Linux.

When you say "extend: gam print group-members gr...@bar.com", can you explain what that means, and what I need to do?

As is, when I enter:  gam print group-members group <group> membernames
I get: "membernames is not a valid argument for "gam print group-members".


Regards,
Chris



On Wednesday, April 6, 2016 at 2:56:27 PM UTC-4, Ross Scroggs wrote:
Chris,

There is no API call that gets the data you want. We'd have to get the email addresses and then get the names one at a time. Are you on Windows or Mac/Linux?
I'm thinking to extend: gam print group-members group gr...@bar.com

$ gam print group-members group testgroup membernames

Getting all Members for test...@bar.com

id,role,group,email,type,memberFullName,memberGivenName,memberFamilyName,memberGroupName

111,MEMBER,test...@bar.com,ad...@bar.com,USER,Super admin,Super,admin,

222,MEMBER,test...@bar.com,jb...@bar.com,USER,Joe Blow,Joe,Blow,

333,OWNER,test...@bar.com,jsm...@bar.com,USER,Jim Smith,Jim,Smith,

444,MEMBER,test...@bar.com,sjo...@bar.com,USER,Sally Jones,Sally,Jones,

555,MEMBER,test...@bar.com,tjo...@bar.com,USER,Tom Jones,Tom,Jones,

666,MEMBER,test...@bar.com,msm...@notbar.com,USER,Unknown,Unknown,Unknown,

777,MEMBER,test...@bar.com,testg...@bar.com,GROUP,,,,Test - Group 2

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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.



--

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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/eea6ed48-922f-491b-8ac9-44fa24083b4b%40googlegroups.com.

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



--

Ross Scroggs

unread,
Apr 6, 2016, 5:27:20 PM4/6/16
to google-ap...@googlegroups.com
Chris,


gam print group-members group gr...@domain.com membernames

Ross
--

Chris Belicose

unread,
Apr 7, 2016, 10:33:26 AM4/7/16
to Google Apps Manager

Hi Ross,

I wanted you to know that I really appreciate it that you took the time to work on this.  At best, I had hoped that perhaps someone knew of a command that I was not aware of.

This is so helpful.  As you may or may not know, currently, when exporting group member lists via the GUI, the data contains email addresses and nicknames (which are sometimes blank), not real names.
Your contribution provides exactly what we and i'm sure many others have been looking for- an easy and quick way to get a view on the members of any group.

Would it be possible to enable parameters, so that a user could choose which fields (group,memberName,email,role,type,id) are returned?
If not, no worries, that is a minimal task.

Thank you, thank you.

Regards,

Chris

111,MEMBER,test...@bar.com,admi...@bar.com,USER,Super admin,Super,admin,

222,MEMBER,test...@bar.com,jblo...@bar.com,USER,Joe Blow,Joe,Blow,

333,OWNER,test...@bar.com,jsmit...@bar.com,USER,Jim Smith,Jim,Smith,

444,MEMBER,test...@bar.com,sjon...@bar.com,USER,Sally Jones,Sally,Jones,

555,MEMBER,test...@bar.com,tjon...@bar.com,USER,Tom Jones,Tom,Jones,

666,MEMBER,test...@bar.com,msmi...@notbar.com,USER,Unknown,Unknown,Unknown,

777,MEMBER,test...@bar.com,testgr...@bar.com,GROUP,,,,Test - Group 2

888,MEMBER,test...@bar.com,testgr...@bar.com,GROUP,,,,testgro...@bar.com

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.



--

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.



--



--

Ross Scroggs

unread,
Apr 8, 2016, 10:44:59 AM4/8/16
to google-ap...@googlegroups.com
Chris,

I updated my version to allow field selection: https://github.com/taers232c/GAM/releases/tag/v3.66

gam print group-members|groups-members [todrive] [membernames] [fields <MembersFieldNameList>] [group <GroupItem>]
<MembersFieldNames> ::= email | group | id | name | role | type
<MembersFieldNameList> ::= '<MembersFieldName(,<MembersFieldName>)*'

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.
Visit this group at https://groups.google.com/group/google-apps-manager.

Chris Belicose

unread,
Apr 11, 2016, 8:28:55 AM4/11/16
to Google Apps Manager

Hi Ross,

Can you give me an example?  I'm having trouble getting this to work.


Regards,
Chris

Ross Scroggs

unread,
Apr 11, 2016, 9:21:37 AM4/11/16
to google-ap...@googlegroups.com
Chris,

gam print group-members group f...@domain.com fields email,name

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.

Chris Belicose

unread,
Apr 11, 2016, 9:30:41 AM4/11/16
to Google Apps Manager
Thanks Ross.

I am getting:  

ERROR: fields is not a valid argument for "gam print group-members"


Regards,

Chris

Ross Scroggs

unread,
Apr 11, 2016, 9:36:42 AM4/11/16
to google-ap...@googlegroups.com
Chris,

I posted the version with this change mid-day Friday, be sure that you've downloaded the latest version.

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.

Chris Belicose

unread,
Apr 11, 2016, 10:10:33 AM4/11/16
to Google Apps Manager

Ross,

I could have swore that I updated my source files this morning, but maybe I confused my folders.  It works as described.

Again, many thanks adding this functionality.  This is a great contribution that I'm sure many users will find helpful.

Regards,
Chris

Chris Belicose

unread,
Sep 15, 2016, 1:54:10 PM9/15/16
to google-ap...@googlegroups.com
Hi Ross,

I hope you are well.  As you might recall, several months ago, you graciously took the time to extend "gam print group-members" to enable retrieval of real names and email addresses, i.e. gam print group-members group foo@bar fields name,email 

This has been a great tool for us.

Would it be possible to add organizational unit (ou) as a valid argument (field) for "gam print group-members"?

Regards,
Chris

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@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.



--

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@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.



--



--

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@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.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Manager" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/brmXG5PUG0g/unsubscribe.
To unsubscribe from this group and all its topics, 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/b2c53955-dd34-4356-bb6e-5365e1e376ed%40googlegroups.com.

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



--
Chris Belicose Technology Support Coordinator
Dwight School | 18 West 89th Street | NY, NY 10024
p 212.724.6360 x399 | f 212.874.4232 | dwight.edu
Igniting the spark of genius in every child
Reply all
Reply to author
Forward
0 new messages