Add scripts to automate manual tasks

kossiitkgp / kwoc-2018

Web app for Kharagpur Winter of Code, 2018

https://kwoc.kossiitkgp.org

MIT License

0 stars 0 forks source link

Add scripts to automate manual tasks #165

Open themousepotato opened 5 years ago

themousepotato commented 5 years ago

*.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.

[x] 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.
[x] Remove mentors from student list, leaderboard et al. via #172
[x] Populate list_of_mentors.json from scratch. (via https://github.com/themousepotato/kwoc/commit/ff347724cdf715e45e93484a21f1b0d8601ab93a)

Ayushk4 commented 5 years ago

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

Ayushk4 commented 5 years ago

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

themousepotato commented 5 years ago

Great!

themousepotato commented 5 years ago

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

Ayushk4 commented 5 years ago

:+1:

Ayushk4 commented 5 years ago

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 commented 5 years ago

@thealphadollar ^

themousepotato commented 5 years ago

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

thealphadollar commented 5 years ago

@Ayushk4

Ujjval Patel,patelujjval2206@gmail.com,Ujjval-Patel,Dhirubhai Ambani Institute of Information and Communication Technology,3,Google,2018-12-09 15:29:18
Prakher Prashank,yashsrivastava85p@gmail.com,terabo090,Jaypee Institute of Information Technology,1,Through Facebook,2018-12-09 15:35:47
Roshini,roshini2335@gmail.com,sleephackers,"National Institute of Technology, Tiruchirappalli",2,I came to know through my coding peers.,2018-12-09 16:16:09
Manas Srivastava,manas.srivastava2017@vitstudent.ac.in,manassrv13,VIT University,2,Website,2018-12-09 17:27:54

thealphadollar commented 5 years ago

@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 commented 5 years ago

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

thealphadollar commented 5 years ago

Certainly possible via GScript.

On Thu, Dec 20, 2018 at 12:26 AM Navaneeth Suresh notifications@github.com 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 commented 5 years ago

Overkill ^ :gun:

themousepotato commented 5 years ago

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 notifications@github.com 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 .