How to Map Your Members on a Ning Network

[JFarrow]

This is a follow-up discussion to the Design Hack which I posted 2 days ago, as promised.

If you've been looking for a way to map your members on the ning platform but have been pulling your hair out waiting on members to ADD THEMSELVES to the member map application, this is the work around for you.   You can find the finished product on the front page (and every page) of Land Surveyors United as well as the Surveyors Member Map Page.

Keep These Things in Mind:

• The only way this will work is if you have a question in your profile questions which asks for exact location, geodetic coordinates or similar.
• This will have to be reprocessed in the following fashion EVERYTIME you want to update your map
• This will only work as a top level admin or NC 
• Its best to have a Gmail or Google Account to complete this tutorial, so get one if you do not have already.
• In a follow up post I will show you how to give your members custom icons..

Step One:  Export your member data from the member moderation page in dashboard

Step Two:  Import that .CSV file to Google Docs- make sure that ALL COLUMNS HAVE DATA IN THEM because if you have too many empty cells in the spreadsheet, it will not process in the next step.

Step Three:  Head over to Mapalist.com and set up an account using the same Google/Google Docs account used in step 2.  Create a map and when prompted, choose the spreadsheet that you used in step 2.  Follow all of the instructions on Mapalist.com in order to convert the spreadsheet into a map with geolocations.

Step Four:  View/Manage the map you just made-grab the embed code and add it to a page on your network. (See figure 1)

Step Five:  Download the KML file which is at the bottom of the generated map, meant for Google Earth.

Step Six: Go to Google Maps while still logged into your google account and Create a Map which will be added to your "My Maps" section.  Now Import that KML file from step Five into that map which you've just started and named.

Step Seven:  You now have all of your members plotted on a google map, now look on the right hand side of the map and click "Link to This"-under it you will see customize this embed code.  A new screen will open.  Choose the correct size that you would like for your map to be and the embed code will be generated for you to embed in your network.  (see figure 2)

Now look at what you just made....aren't you a genius!

FIGURE 1

FIGURE 2

If you like this workaround, please do me a favor.  Call up every land surveyor that you personally know and ask them to please join Land Surveyors United as we are the best solution for a land surveyor when it comes to trouble shooting problems in the field.  Land Surveyors NEED Land Surveyors United.  Thanks and Enjoy!

[Nederlander]

Thank you TimG - I'm going to study your method closely!

[HELP SEEKER]

hey, which app are you using for map ? i have only found apps.io 

[Emmanuel Ace]

its called Map A list

Its a Manual set up..

You will need to download all your members 

Upload to a google spreadsheet...

Map a list has an integration with Google Docs

Connect your google account to Map A List 

And  use your member list*the one you downloaded* and use it

[HELP SEEKER]

ok but it wont show members profile

[HELP SEEKER]

oh, actually it does , good hack, but can they update/change location them-selfs ?

[Emmanuel Ace]

nope, you will need to update it yourself

[HELP SEEKER]

need someone to write that map script, that would pull a location from profile question 

[Steve Squires]

Brilliant!  Thank you

[JFarrow]

UPDATE:  Before using this method, you may want to remove the columns inside your spreadsheet for Email Address (for privacy),Birthday, Receiving Broadcasts, Age and any other data you don't want displayed on the map.

[JFarrow]

maybe this will help?

[JFarrow]

I wrote this tutorial back in 2010...haha

nevertheless..this inspires me to write a completely new tutorial..because i do it differently these days.... stay tuned..ill try to write it up tomorrow..