Category:BikeSaviours: Difference between revisions

From Traxel Wiki
Jump to navigation Jump to search
No edit summary
Line 13: Line 13:


== Updating Sign-Ins ==
== Updating Sign-Ins ==
# Update the spreadsheet: sign-ins_2021.ods in Marketing > Market Data > Sign-Ins: https://drive.google.com/drive/folders/1WUrkLeC3LK7cjh1Me8UiMOWWSohZLWaU?usp=sharing
# Export the month's sheet as a CSV.
# $ ./parse-sign-in-csv.pl 2021-12 > sql/2021-12.sql
# $ mysql bsbc < sql/2021-12.sql
# $ mysql bsbc
# >

Revision as of 09:48, 5 December 2021


https://www.bikesaviours.org/

Random Notes

Database Notes

Updating Sign-Ins

  1. Update the spreadsheet: sign-ins_2021.ods in Marketing > Market Data > Sign-Ins: https://drive.google.com/drive/folders/1WUrkLeC3LK7cjh1Me8UiMOWWSohZLWaU?usp=sharing
  2. Export the month's sheet as a CSV.
  3. $ ./parse-sign-in-csv.pl 2021-12 > sql/2021-12.sql
  4. $ mysql bsbc < sql/2021-12.sql
  5. $ mysql bsbc
  6. >

Pages in category "BikeSaviours"

The following 2 pages are in this category, out of 2 total.