Updating the TBP Eligibles Portal - Tau-Beta-Pi-MIT/website GitHub Wiki

To update the TBP eligibles portal, you will need to ensure the following steps are taken:

  1. Eligibility requirements are kept in a publishable google sheet that has the exact same format as this example google sheet. You can also change the format, but you may need to change the eligibles_landing_page.shtml if you do.

  2. Make sure you use checkboxes to denote if a requirement is completed.

  3. Finally, please make sure that data validation for checkboxes is correct on the Google sheet page that captures all of these requirements. To do this, select all checkboxes, right click, and select "Data Validation". Please make sure the "Checked" and "Unchecked" fields correspond to "Complete" and "Incomplete", respectively, as these will be what's displayed for the eligibles in the eligibles portal.

Once these steps are finished, you can follow the steps below (note these are the same as in the README):

  1. Make sure you are tracking requirements through google sheets. In the eligibles portal, Go to File --> Publish to the Web. Publish in any format.
  2. Make sure that the 4th header/column of the requirements spreadsheet is written exactly as "Kerberos" (without quotations).
  3. Now, go to Share, and find the ID for the google sheet, where the ID can be identified by pattern-matching with this link: https://docs.google.com/spreadsheets/d/<ID>/edit?usp=sharing.
  4. Next, navigate to ./eligibles_landing_page.shtml, line 71, and change the ID of the src link such that it looks like: https://spreadsheets.google.com/feeds/cells/<ID>/1/public/values?alt=json-in-script&callback=doData.
  5. Test this out locally by starting a local server and querying one of the kerberos entries of the new database. If the kerberos is in the database, you should see two rows appear.
  6. Push to GitHub and pull from Athena using the process below. That's it!
  7. NOTE: The password for the eligibles portal is tbp_davinci. You can change this on line 25 of ./eligibles_portal.shtml.