开云体育

For one of my groups, being a member of the group requires being an elected member of an organization. Over time, people come and go as might be expected.

So, I have the group and I have a spreadsheet with the list of email addresses. Is there an easy way to rectify the group membership against the list (remove those not on the list, invite those not in the group that are on the list)?

Thanks,

Glenn

Probably the easiest would be to export the members list, then import the file into a spreadsheet.? From there you could sort by email address and compare it to the current list.? I use this method for a club where I'm secretary and it works for me.

Duane
--
Help: /static/help
GMF's Wiki: /g/GroupManagersForum/wiki
Search button at the top of Messages list
A few site FAQs: /static/pricing#frequently-asked-questions

On 4/16/2019 05:11, Duane wrote:

Probably the easiest would be to export the members list, then import the file into a spreadsheet.? From there you could sort by email address and compare it to the current list.? I use this method for a club where I'm secretary and it works for me.

Duane

Thanks, Duane.

That had occurred to me, I just hoped/wondered if there might be a more automated way of doing it through the group.

Best,

Glenn

Glenn,

> So, I have the group and I have a spreadsheet with the list of email
> addresses. Is there an easy way to rectify the group membership
> against the list (remove those not on the list, invite those not in
> the group that are on the list)?

The easiest way I know is using Direct Add, to add those not yet
subscribed, and Bulk Remove to remove those who should no longer be.

To identify those two sets of addresses I Download the Groups.io
Members list and paste it into a spare sheet in the Excel workbook
where I keep the (PTA unit) membership. I'll call this sheet List, and
the IRL sheet Members. The Data | Text-to-Columns feature breaks that
pasted column into the separate membership fields.

I'm interested in the Email, Display Name, Username, Joined, and User
Status columns, I hide the rest. Hide, not delete, so that subsequent
pasting of fresh downloads won't affect my added columns.

Then I add a column (past the downloaded data, say M) that I fill with
match functions. In row 2 of that column I put:

=MATCH($A2,Members!E:E,0)

Where you should use whatever column in your Members sheet contains
the email address where I have E in the above example. Then copy/paste
that formula down the column into all the rows occupied by downloaded
data.

The formula evaluates as either #N/A, meaning that this email address
is not in the Members sheet, or to the row number of the members sheet
that has it. This identifies for me the email addresses that need to
be bulk removed from the list (those with an #N/A). You can sort the
List sheet by this column to gather all the #N/A rows together, then
copy/paste their column A (the emails) into the Bulk Remove page.

I do a similar thing in the Members sheet to find all of the email
addresses which aren't in the downloaded List sheet. On this sheet I
also make another column, one with a string function to build the
addresses to copy into the Direct Add (or Invite) page. The purpose of
this column is to combine the member's name and email address into the
proper format to paste:

Name <user@...>

I find using the Excel functions like this to be a substantial
advantage over manual comparison; it makes it relatively easy to
re-rectify the lists as needed; just download a fresh copy from
Groups.io each time.

Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list