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

Forum

NC for Hire

Member maps are awesome... they give your members a way to visualize the growth of their community. I've shared many ways of building member maps over the years, but I seem to be getting a lot of questions about it lately so I figured it was time for an update. Today I am going to show you the most rapid method for creating a member map that I have found to date.   If you know of a faster way, please share.   Here are a few of my previous posts:

How to Map Your Members on a Ning Network

3.0 Tip: How To Map Your Ning Network Members -Updated-

3.0 Mapping Tip: Make Your Member Map Responsive

Here is the short version of how I do it now:

I use the Geocode Awesome addon for Google Drive.  

Export your member data from your community as CSV

Import it into Google Drive and open it as spreadsheet with addon installed to sheets

         -  i usually make a copy of the memberdata.csv and name it GEOmemberdata  and strip the email column out and other irrelevant columns the geocode the geo copy..

Combine the Location column with Country to create a new cell called "Full Address" in the sidebar (it will do it for you)

Geocode that column - it will generate two new columns for Latitude and Longitude and may take as much as an hour

NOTE:  While it geocodes your locations, leave the page open and do not switch to a new tabs to do other things....let it run... if you have a lot of members, watch a movie while it runs or it will stop and hang...best to use in Chrome

Then you'll be presented with an option to create a heat map from the sheet and you have two choices  

1) Either export the sheet as a CSV file to import into other map platforms like Carto.com or Mapbox

2) Generate your map using Awesome table...

          Either one you choose, you'll want to edit the HTML of the infobox.

I usually export the CSV file first before generating the heatmap because it adds extra filters to the sheet when you generate the map..  I do this so that I can import the CSV into Carto.com to create a more robust map like this:

I hope this helps with you member mapping questions. If you ever need advise or help with any aspect of your community, simply drop me a line here and we'll get it moving in the right direction, together...  Have a great weekend!

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

Join Ning Creators Social Network

Email me when people reply –

Search the Creators Network

Latest Activity

Suzi Blu replied to Kyryl_Ning_Support's discussion Chat Feature Update on Ning 3.0 is ready!
"My chat disconnects me as soon as it is connected. "
7 hours ago
Kos replied to Anastasiia_NING support's discussion Ning 2Q 2017 plan!
"I agree.  In lieu of a Ning solution, I save a copy in forums under a "site news" category.  Can al…"
9 hours ago
Alliance replied to Anastasiia_NING support's discussion Ning 2Q 2017 plan!
"Also, if I could write a message and delay when to sends,It would save me valuable time as an admin."
9 hours ago
Alliance replied to Anastasiia_NING support's discussion Ning 2Q 2017 plan!
"i just wanted to lay a suggestion for broadcast messages.
It would be so great that ning offers a w…"
9 hours ago
Kos replied to Naveen Jain's discussion How can I disable Ning Search in 3.0
"Thanks Kyryl!"
11 hours ago
Manuel Adame Jimenez replied to Manuel Adame Jimenez's discussion Notifications that arrive to the mobile asin is sure to be able to participate members
"Of course I mean the notifications of the source of the activity"
12 hours ago
Manuel Adame Jimenez replied to Manuel Adame Jimenez's discussion Notifications that arrive to the mobile asin is sure to be able to participate members
"Notifications arrive on cell phone, members are sure to participate"
12 hours ago
Kyryl_Ning_Support replied to Naveen Jain's discussion How can I disable Ning Search in 3.0
"Hi there!
You should put that code in custom CSS field in design studio,
Regards,
Ning Team."
16 hours ago
Cat replied to Yana Ning Support's discussion Great news for Ning 2.0
"I have two common sayings to give you in response this this announcement.  (1) Leave well enough al…"
18 hours ago
Thisisbully replied to Dan Lee's discussion I Will Design Your Ning Network To Make it Look More Professional
"Nice"
21 hours ago
Naveen Jain replied to Naveen Jain's discussion How can I disable Ning Search in 3.0
"where should I put this?"
22 hours ago
Naveen Jain replied to Dan Lee's discussion I Will Design Your Ning Network To Make it Look More Professional
"Just got my network redesign by Ron. He has done wonderful job. Checkout culytics.com"
22 hours ago
Kos replied to Naveen Jain's discussion How can I disable Ning Search in 3.0
"I think this'll do the trick.  Let me know if you have problems.
.globalsearch .globalsearch-button…"
yesterday
Thisisbully replied to Thisisbully's discussion I'm losing members because of 1 silly feature
""
yesterday
Jen replied to Kyryl_Ning_Support's discussion The long-awaited Search Option is now at your fingertips!
"Excellent!"
yesterday
Alida I.Gómez replied to Yana Ning Support's discussion Great news for Ning 2.0
"Quisiera saber si se puede aadir los ofrecimientos gratis a mi red actual en lo que desidimos si ha…"
yesterday
Thisisbully replied to Thisisbully's discussion I'm losing members because of 1 silly feature
"It should be like 2.0 in the activity feed and profile page groups imo iv been dealing with this fo…"
yesterday
Thisisbully replied to Thisisbully's discussion I'm losing members because of 1 silly feature
"His way doesn't even work right it just takes u to the photo page and u still have to click add aga…"
yesterday
Fabricio Giugni replied to Fabricio Giugni's discussion Powered by Ning How to get it out?
"You are just right."
yesterday
Fabricio Giugni replied to Thisisbully's discussion I'm losing members because of 1 silly feature
"I understand that you found a way to do it. And thanks for that.
We should not be punished because…"
yesterday
More…