<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On 22 May 2016 at 18:31, Samuel Cantero <span dir="ltr"><<a href="mailto:scanterog@gmail.com" target="_blank">scanterog@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><span class="">On Sat, May 21, 2016 at 7:55 PM, Dave Crossland <span dir="ltr"><<a href="mailto:dave@lab6.com" target="_blank">dave@lab6.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><br></div><div class="gmail_extra">Hi</div><div class="gmail_extra"><br><div class="gmail_quote"><span>On 18 May 2016 at 22:53, Samuel Cantero <span dir="ltr"><<a href="mailto:scanterog@gmail.com" target="_blank">scanterog@gmail.com</a>></span> wrote:<br></span><span><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">Should we verify it against Dave sheet or should we just remove those accounts directly?</blockquote></span></div><div><br></div><div>I made a simple little python program to compare the list of 'never used' accounts to the total account list. </div><div><br></div></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div class="gmail_extra"><div><div>users = [ ... ]</div></div></div><div class="gmail_extra"><div><div>unused = [ ... ]</div></div></div><div class="gmail_extra"><div><div>for user in users:</div></div></div><div class="gmail_extra"><div><div> if user in unused:</div></div></div><div class="gmail_extra"><div><div> print("No")</div></div></div><div class="gmail_extra"><div><div> else:</div></div></div><div class="gmail_extra"><div><div> print("Yes")</div></div></div></blockquote><div class="gmail_extra"><div><br></div><div><br></div><div>Next I would like to check the mailman archives for email addresses posted to the lists, to ensure we don't remove any accounts that belong to people who otherwise interacted with the community. </div><div><br></div><div>Are you able to grep for a list of all emails that have ever posted to any list on <a href="http://lists.sugarlabs.org" target="_blank">lists.sugarlabs.org</a>? <br></div></div></div></blockquote><div><br></div></span><div>I have filtered the "From header" from all the archive lists (active and inactive) since they were created until today.<br></div></div></div></div></blockquote><div><br></div><div>Great!</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div></div><span class=""><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div></div><div>If so, please send them to me or add them to a new sheet in the google docs spreadsheet :) <br></div></div></div></blockquote><div> <br></div></span><div>Done. I've added it to the last spreadsheet you've shared with me named "Sugar Labs Wiki Usernames" in a new sheet named "Mailman Users".</div></div></div></div></blockquote></div><div class="gmail_extra"><br></div>Got it!! Thanks!! <br><br>There are now around 1,000 emails in the wiki user list that I think are not spammer accounts (of about 3,500 total wiki accounts) and 2,175 emails in that list, so this will be very helpful in marking non-spammer accounts correctly :)</div><div class="gmail_extra"><br></div><div class="gmail_extra">I suppose there are also emails in ASLO, Pootle, Gitorious, and perhaps other web services hosted by Sugar Labs, but I don't think its important to get them, because I think its safe to assume that anyone using any of those services will have been a wiki user or posted at least once to at least one SL email list. <br clear="all"><div><br></div>-- <br><div class="gmail_signature">Cheers<br>Dave</div> </div></div>