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!
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!