https://www.bikesaviours.org/

Random Notes

• Grants
  • The Downtown Phoenix library has access to Foundation Directory Online: https://candid.org/find-us
  • Supposedly you can access it here as well: https://fconline.foundationcenter.org/welcome/quick-start
  • More Sources: https://getfullyfunded.com/5-places-to-find-grants-for-your-nonprofit-for-free/
• SubReddit: https://old.reddit.com/r/BikeSaviours/

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. $ mariadb bsbc < sql/2021-12.sql
5. $ mariadb bsbc
6. > -- only safe because we only had one each Shamus, Nicole, Denzel, or Adam
7. > update bsbc.staff_sign_in i set i.email = 'shamus@bikesaviours.org' where i.short_name = 'Shamus';
8. > update bsbc.staff_sign_in i set i.email = 'nicole@bikesaviours.org' where i.short_name = 'Nicole';
9. > update bsbc.staff_sign_in i set i.email = 'intern' where i.short_name = 'Denzel';
10. > update bsbc.staff_sign_in i set i.email = 'intern' where i.short_name = 'Adam';
11. > -- this is dangerous
12. > set @date = '2021-11-18';
13. > select i.shop_date, i.short_name, i.email from bsbc.staff_sign_in i where i.shop_date = @date;