Add scripts to automate manual tasks

[themousepotato]

*.csv, *.json et al files are mostly generated by executing some scripts. In some cases, manual addition becomes necessary. It's always advised to write scripts for the above tasks. I'm listing. @thealphadollar Please modify and update as necessary.

• Add college to colleges.json on a request by a student. (via https://github.com/themousepotato/kwoc/commit/bfb7f52c38415ddb9ee59e372d2a11f9df2dd320)
• Add student to the student list, leaderboard et al if he/she is missing due to some technical problem on their request.
• Remove mentors from student list, leaderboard et al. via Remove mentors and duplicates from students.csv #172
• Populate list_of_mentors.json from scratch. (via https://github.com/themousepotato/kwoc/commit/ff347724cdf715e45e93484a21f1b0d8601ab93a)

[Ayushk4]

I have removed mentors from the student's list in the google sheet.

[Ayushk4]

I can send a pr with the code that I used.

[themousepotato]

Great!

[themousepotato]

Also, add instructions to the README to run the script and its use.

[Ayushk4]

👍

[Ayushk4]

I have made changes the google sheet for the same. But seemingly statistics takes input from the file kwoc/gh_login/student.csv . So I need to know the structure of that csv file before I can test it on that.

[Ayushk4]

@thealphadollar ^

[themousepotato]

@Ayushk4 I've shared that with you in slack. Please see.

[thealphadollar]

@Ayushk4

Ujjval Patel,[email protected],Ujjval-Patel,Dhirubhai Ambani Institute of Information and Communication Technology,3,Google,2018-12-09 15:29:18
Prakher Prashank,[email protected],terabo090,Jaypee Institute of Information Technology,1,Through Facebook,2018-12-09 15:35:47
Roshini,[email protected],sleephackers,"National Institute of Technology, Tiruchirappalli",2,I came to know through my coding peers.,2018-12-09 16:16:09
Manas Srivastava,[email protected],manassrv13,VIT University,2,Website,2018-12-09 17:27:54

[thealphadollar]

@themousepotato for the second automation; we can create an authenticated flask endpoint where we can edit and add information by ourself; if we ever setup a database it'll be a lot easier.

[themousepotato]

@Ayushk4 Can we also have a script to edit google sheets on 3rd automation? It'll be cool. 😄

[thealphadollar]

Certainly possible via GScript.

…

On Thu, Dec 20, 2018 at 12:26 AM Navaneeth Suresh ***@***.***> wrote: @Ayushk4 <https://github.com/Ayushk4> Can we also have a script to edit google sheets on 3rd automation? It'll be cool. 😄 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://github.com/kossiitkgp/kwoc/issues/165#issuecomment-448705896>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AfStILEupnEAgqisd11uqajlBxtklNv2ks5u6ovggaJpZM4ZYztj> .

[Ayushk4]

Overkill ^ 🔫

[themousepotato]

Not at all, it’s so cute. We don’t even have to ask for access and all. Just store the token in secrets and execute a script will do.

…

On Thursday, December 20, 2018, Ayush Kaushal ***@***.***> wrote: Overkill ^ 🔫 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://github.com/kossiitkgp/kwoc/issues/165#issuecomment-448889292>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AgXlPm1GQXMwfusBgxO4saHbmcrrBTD0ks5u6y7xgaJpZM4ZYztj> .