GSoC proposal export for our student grading sheet

README.md

Instructions

Export JSON from the GSoC dashbaord. When signed in as an org admin, for 2019, it's this URL: https://summerofcode.withgoogle.com/api/om/program/2019/proposal/?ignored=false&is_complete=true&order=title_lower&page=1&page_size=50&shared_with_org_members=true

Paste it into the script.js file.

To run the script, navigate to the directory where the script is stored, e.g.

cd downloads
node script.js > proposals.txt

Assuming you have node installed, this will create a file called proposals.txt with the entries from the json formatted as csv, ready to be pasted into a spreadsheet.

script.js

var students = {} //replace {} with the exported JSON above!

//to see what a single result looks like: 
//console.log(students.results[0])

var response = "";

students.results.map(function(proposal) {
  response += [proposal["subcategory"],
               proposal["title"],
               proposal["student"]["display_name"]
              ].join(",");
  response += "\n";
});

console.log(response);