SquaresDB lives at https://mv-ezproxy-com.ezproxy.canberra.edu.au/ and is the club's membership database and attendance tracking system.
Login and Accounts
SquaresDB supports SSO with Google and Touchstone (MIT Athena accounts, and also Touchstone Collaboration accounts, if you have one – they seem to have shut down account creation). It also supports password login, which should generally be avoided. To log in, use the "login" link at the top right. Logging in will automatically create an account if you don't have one already. Once you do, it can be assigned permissions by a superuser (currently just Alex). There's a lot of permissions, so the usual approach is to use a group: "signin" if somebody just needs gate&books access, the -readonly groups for readonly access, and the -edit groups allow editing the majority of data in the site (updating names, deleting attendance records, creating dances, etc.).
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.
Gate & Books
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 for details to get access. The gate&books pages themselves have some instructions as do the nightly jobs instructions.
New Subscriptions
Once prices have been set decided on for the subscription period, go you'll need to load them into SquaresDB:
- Go to https://mv-ezproxy-com.ezproxy.canberra.edu.au/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 "normal", 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 Squares Pay with the new period, though.
...