Current status of the Ning Platform is always available on the Ning Status Blog.

FORUM

Ning 3.0 Group members CSV file

I can't believe I am posting a tip/trick as if I am a web developer but here is something I think Creators will find useful. Soon Ning will solve this issue but until then here is a way out.

until NING solves a very needed issue of our group members list.

Currently we do not have a way to get the members list from a specific group so you can email them seperately via another system such as Mailchimp. 

 

Members CSV File

The first step is to download your members CSV file from your Member Management section of the Admin Portal.

Make sure your settings is on Active members as I have made this mistake in the past. 

Your next step is to look in the bottom right hand side near your pagination and you will see the link for your CSV file to be retrieved.

Once Ning emails you your file, open it to Microsoft Excel.

 

Group Members

Your next step is to go to the group you want to get the list of and go to the Members management of the Group.

There will be no CSV file in here so you are going to have to drag and over the text of each page and copy once it is highlighted.

Fortunately this will past into excel. Go back to your Excel file and click the second tab.

Copy your group members results in cell A1. Great that part is done but yeah I know, no email addresses, hold on.

 

VLook up

You will have to do a Data search called a vlookup to compare data from Table 1 to give you results in Table 2. Here is what the formula will look like  =VLOOKUP(C2,memberdata!A1:M1066,3,FALSE)

Don't get scared as microsoft has a wizard to help you with this. Erase the last two columns of Role and Joined if you wish, as they are just a distraction to our process. 

Click in the row after your last column Header and name that column Email and click in row 2 below it.

Now lets start the magic. Go to Formulas tab and then Lookup and References. Scroll down until you see VLookUP and the dialogue wizard will open.

Select cell C2 from your Groups List as this will represent your usernames unless you made username another column and row for some reason.

for the second answer to the wizard go to the memberdata Tab and select your whole table that NING provided.

Your third answer is 3 as it represents the column where your email addresses are at.

Last answer is False. I dont understand it JUST TRUST ME. False 

Hit enter and Bam there you go!!! and email associated with a Group username.

From there, Drag the Formula Down or double click the bottom right of your cell and excel will populate the rest of the results.

Now from here, yall should be able to handle it. Save as CSV

 

 

 

You need to be a member of Ning Creators Social Network to add comments!

Join Ning Creators Social Network

Email me when people reply –

Replies

This reply was deleted.
 

Some interesting articles related to community management, digital marketing etc. could be found in our digest. Don't hesitate to leave a feedback so we would know that we should continue :-)

Latest Activity

Matthew Aukai Wright replied to Bizz ( John )'s discussion
How To Make Your Feature, Add, Edit Buttons At The Top Of Pages Stand Out Better (Updated 08/01/17)
"Hey there. How can I add a rainbow background picture to the buttons? "
3 hours ago
Suzie Nielsen replied to Rowald's discussion
Ning not GDPR compliant
"new Question same Topic... what if I remove google analytics altogether... that's all I use... coul…"
10 hours ago
⚡JFarrow⌁ commented on Rosas † Negras's blog post Bar Skysa into 3.0
"Yes, skysa works.... you'll want to put it inside the Custom Code Footer box in 3.0... hope this he…"
15 hours ago
Fabricio Giugni replied to Fabricio Giugni's discussion
Chat help
"Hi,
   The only problem is that I can not make it work even if there is lot's of people. No one get…"
16 hours ago
Thisisbully replied to Fabricio Giugni's discussion
Chat help
"on mobile the chat notifications do not show "
17 hours ago
Gavin Brown replied to Kyryl_Ning_Support's discussion
Changes on facebook, and new instructions how the app should be set up
"Thanks for replying Anastasia!"
19 hours ago
Anastasia_Ning_Support replied to Cindy Dean Mccoy's discussion
Trouble tickets just sitting there
"Hi there!
It is true, that in terms of updates and new features, we are focusing on 3.0 platform, b…"
22 hours ago
Anastasia_Ning_Support replied to Fabricio Giugni's discussion
Chat help
"Hi there!
Thank you for checking once again and clarifying. It was made intentionally to leave memb…"
23 hours ago
Matthew Aukai Wright replied to Fire-Tech's discussion
3.0 Tip: Leave Network Button
"how can I make the button rainbow? "
23 hours ago
Anastasia_Ning_Support replied to Fabricio Giugni's discussion
Add Photos location problem.
"Hi there!
No, unfortunately, it is not possible to do so. As an example, we have added such button…"
23 hours ago
Anastasia_Ning_Support replied to Kyryl_Ning_Support's discussion
Changes on facebook, and new instructions how the app should be set up
"Hi there!
Unfortunately no update yet, it`s still in process of solving. 
Best regards,
The NING Te…"
23 hours ago
Lady Shadow replied to Lady Shadow's discussion
my ning 3,0 i HAVE TO BEG ning TO FIX EACH DAY AND PAY 59
"Thanks checking it now"
23 hours ago
More…

Meanwhile, you can check our social media channels