Page MenuHomePhabricator

Andre to provide "New Authors" data from Dec, Jan, Feb 2017-18 to Srishti in early March
Closed, ResolvedPublic


To survey new developers for the third edition of the quarterly report >

Event Timeline

srishakatux created this task.

I requested updated data for early March in (manual requesting needed until T151161 is resolved).

Aklapper raised the priority of this task from Medium to High.Mar 1 2018, 11:55 AM

DB index got updated by Jesus in when working on T185316 hence I could proceed.

  • Exported the 57 names for that time frame from
  • Manually excluded Pnorman and Vgutierrez and Bstorm and Tonina Zhelyazkova and Ebba Aniansson because [now] WMF/WMDE staff.
  • Manually excluded PortalsBuilder because bot.
  • Ran SELECT DISTINCT email FROM identities WHERE source = "gerrit" AND (name = "..." OR name = "..."); on a local DB dump (slightly outdated as the tool to update DB dumps has been broken since 20180218).
  • Manually looked up email addresses on for contributors listed on after 20180218, as not in my DB dump (see above).
  • Cleaned output to remove duplicates (some users registered more than one email address on Gerrit).
  • Passed the 52 email addresses to Srishti. (Not sure why there is 1 more address than expected; 57 items - 6 exclusions = 51, but I don't care enough)

Closing as resolved.