csv - FORUM - Ning Creators Social Network2024-03-29T09:51:53Zhttps://creators.ning.com/forum/topics/feed/tag/csvExport members List from 3.0https://creators.ning.com/forum/topics/export-members-list-from-3-02018-05-26T22:54:00.000Z2018-05-26T22:54:00.000ZAlliancehttps://creators.ning.com/members/Alliance<div><p>Can I please have directions on how I can export my member list into a csv file on 3.0.</p><p>I would like to implement my group members with Mailchimp and I hope the file will say what group members are in.</p><p>I really want to know also why was this not installed before as you know from 2.0 this was a need by networks.</p><p>The email contact list belongs to us the creators not NING.</p></div>Update on My Process of Creating Member Maps for Ning Communitieshttps://creators.ning.com/forum/topics/update-on-my-process-of-creating-member-maps-for-ning-communities2017-06-16T21:55:37.000Z2017-06-16T21:55:37.000Z⚡JFarrow⌁https://creators.ning.com/members/JFarrow<div><p>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:</p>
<h3 class="entry-title"><a href="http://creators.ning.com/forum/topics/how-to-map-your-members-on-a">How to Map Your Members on a Ning Network</a></h3>
<h3 class="entry-title"><a href="http://creators.ning.com/forum/topics/3-0-tip-how-to-map-your-ning-network-members-updated">3.0 Tip: How To Map Your Ning Network Members -Updated-</a></h3>
<h3 class="entry-title"><a href="http://creators.ning.com/forum/topics/3-0-mapping-tip-make-your-member-map-responsive">3.0 Mapping Tip: Make Your Member Map Responsive</a></h3>
<p></p>
<p style="text-align: center;"><strong>Here is the short version of how I do it now:</strong></p>
<p>I use the <a rel="nofollow" href="https://chrome.google.com/webstore/detail/geocode-by-awesome-table/cnhboknahecjdnlkjnlodacdjelippfg?hl=en" target="_blank">Geocode Awesome addon for Google Drive</a>. </p>
<p>Export your member data from your community as CSV</p>
<p>Import it into Google Drive and open it as spreadsheet with addon installed to sheets</p>
<p> <em> - 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..</em></p>
<p>Combine the Location column with Country to create a new cell called "Full Address" in the sidebar (it will do it for you)</p>
<p>Geocode that column - it will generate two new columns for Latitude and Longitude and may take as much as an hour</p>
<p><strong>NOTE:</strong> <em>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</em></p>
<p>Then you'll be presented with an <strong>option to create a heat map from the sheet</strong> and you have two choices </p>
<p>1) Either export the sheet as a CSV file to import into other map platforms like Carto.com or Mapbox</p>
<p>2) Generate your map using Awesome table...</p>
<p> Either one you choose, you'll want to edit the HTML of the infobox.</p>
<p><em>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:</em></p>
<p><a href="http://www.surveyearth.com/about.html" target="_blank"><img src="http://storage.ning.com/topology/rest/1.0/file/get/559246?profile=RESIZE_1024x1024" class="align-full" width="750"></a></p>
<p></p>
<p>I hope this helps with you member mapping questions. If you ever need advise or help with any aspect of your community, <a rel="nofollow" href="http://justinfarrow.com/ning.html" target="_blank">simply drop me a line here</a> and we'll get it moving in the right direction, together... Have a great weekend!</p></div>