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).
Description
Description
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | srishakatux | T164084 [FY 17-18] Program 12: Onboarding new developers | |||
Resolved | srishakatux | T176481 Goal: Understand how and why new developers start contributing and stay or leave | |||
Resolved | srishakatux | T193819 Release "New Developers Quarterly Report" for April-June 2018 in early July 2018 | |||
Resolved | Aklapper | T196408 Andre to provide "New Authors" data from March, April, May 2018 to Srishti in June |
Event Timeline
Comment Actions
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.