SquaresDB lives at https://squaresdb.mit.edu/ and is the club's membership database and attendance tracking system. It's unlikely there's much of use on this page unless you're doing administrative stuff of some form.
| Table of Contents |
|---|
Login and Accounts
...
In general it's best to use a personal account linked to Google or Touchstone, but for shared devices (in particular, for gate&books) we support password-based accounts. The "signin" account's password (used on the club tablet) is in the Passwords wiki page.
Standard Operations
...
Doing gate and books requires a device (smartphone works okay, something with a larger screen like a tablet or laptop is preferable – the club has a tablet) and an account on the site. If working on a personal device, ideally one uses a personal account for improved auditability, but the "signin" account is also available – see prior paragraph "Login and Accounts" section for details to get access. The gate&books pages in SquaresDB themselves have some instructions as do the nightly jobs instructions.
New Subscriptions
Once prices for the subscription period have been decided on
...
, you'll need to load them into SquaresDB:
- Go to https://squaresdb.mit.edu/gate/new_period/.
- Enter the first and last dance dates.
- Select the relevant season.
- Time should be correct (assuming the club dance time hasn't changed), and name and slug should populate automatically.
- Change the default price scheme to "normal2023", and fill in the subscription prices.
- Hit create (don't check "confirm").
- Confirm the dates look right, check "confirm", and hit create again.
That should be everything in SquaresDB to create the period. Don't forget to also update Historic Subscription Prices and Squares Pay with the new period, though.
...