danineamati / arcresearchpage

The research page for the Caltech ARC (Academic and Research Committee).
0 stars 0 forks source link

Smoother data-update workflow #5

Open danineamati opened 3 years ago

danineamati commented 3 years ago

Current workflow:

  1. Send google form survey
  2. Change the headers on the google spreadsheet to the JSON headers
  3. Save as CSV and convert to JSON (or use the barebones python file in the repo)
  4. Add relevant entries to the JSON Database
  5. Push to main

Possible new workflow

  1. Send google form survey
  2. Save as CSV
  3. Python script (new) merges the CSV data into the JSON file
  4. Push to main