Page MenuHomePhabricator

Andre to provide "New Authors" data from March, April, May 2018 to Srishti in June
Closed, ResolvedPublic

Description

To survey new developers for the final edition of the quarterly report > https://www.mediawiki.org/wiki/User:SSethi_(WMF)/Quarterly/2018-07 (coming soon on this URL).

Event Timeline

srishakatux triaged this task as Medium priority.Jun 4 2018, 9:10 PM
srishakatux created this task.

Alright...

  • https://gitlab.com/Bitergia/c/Wikimedia/support/issues/33 got fixed.
  • Now https://wikimedia.biterg.io/goto/09ac128a3b112ec6e9224b8973846892 shows 50 names in Gerrit for March-May 2018.
  • Got that list as CSV export.
  • Removed WDQSGuiBuilder because it's a bot. (I think. If not, it's some employee, looking at the email address used.)
  • One user registered under the same name as an established user (example) so I excluded them.
  • Created a fresh DB dump file on the production server via SSH.
  • Copied that via scp to my local machine.
  • Imported it into my local DB.
  • Ran SQL query: SELECT DISTINCT name,email FROM identities WHERE source = "gerrit" AND (name = "ABC" OR name = "XYZ");
  • Cleaned output to remove duplicates if needed (not in this case)
  • Sent the email addresses via email to Srishti.

@Aklapper thank you for sharing the list! I've sent the survey to 48 new authors!

Vvjjkkii renamed this task from Andre to provide "New Authors" data from March, April, May 2018 to Srishti in June to jnbaaaaaaa.Jul 1 2018, 1:05 AM
Vvjjkkii reopened this task as Open.
Vvjjkkii removed Aklapper as the assignee of this task.
Vvjjkkii raised the priority of this task from Medium to High.
Vvjjkkii updated the task description. (Show Details)
Vvjjkkii removed a subscriber: Aklapper.
CommunityTechBot renamed this task from jnbaaaaaaa to Andre to provide "New Authors" data from March, April, May 2018 to Srishti in June .Jul 2 2018, 7:10 AM
CommunityTechBot closed this task as Resolved.
CommunityTechBot assigned this task to Aklapper.
CommunityTechBot lowered the priority of this task from High to Medium.
CommunityTechBot updated the task description. (Show Details)
CommunityTechBot added a subscriber: Aklapper.