Page MenuHomePhabricator

[frwiki] Reassign all Webfil's mentees to other mentors
Closed, ResolvedPublic

Description

Event Timeline

How long can be this message (in characters)? Is it using the same message as the one displayed for ClaimMentee?

How long can be this message (in characters)? Is it using the same message as the one displayed for ClaimMentee?

It's the same message as used for ClaimMentee. To be honest, I'm not sure if it has character limits.

Message can be:

Webfil a quitté l'équipe des mentors.

For the record, this is how I do this kind of things (but hopefully the manual will soon be obsolete with the mentor dashboard :)):

  1. Get list of available mentors formatted as JSON
  2. Get list of mentees to reassign from the database
    1. [urbanecm@stat1005 ~]$ echo 'select user_name from user_properties join user on user_id=up_user where up_property="growthexperiments-mentor-id" and up_value=(select user_id from user where user_name="Webfil")' | analytics-mysql frwiki | sed 1d > mentees.txt
    2. Note: Soon, the information will live elsewhere (T275773)
  3. Download script from P14136, fill in login details, etc.; change MENTORS with list of mentors, REASON with the reason, and download mentees.txt to the same folder as the script
  4. Run the script

Can't wait to see this complicated process becoming obsolete! :D

Done:

mysql:research@dbstore1005.eqiad.wmnet [frwiki]> select user_name from user_properties join user on user_id=up_user where up_property="growthexperiments-mentor-id" and up_value=(select user_id from user where user_name="Webfil") limit 10;
Empty set (0.291 sec)

mysql:research@dbstore1005.eqiad.wmnet [frwiki]>

Can't wait to see this complicated process becoming obsolete! :D

Yeah, definitely!