Re: [TheThinkTank] members and sign up database software

22 Sep 2015

      could be good to have something like that open sourced. All we need is to
track comings and goings of people, data base skills for future reference
and be able to easily use the data for funders / donours to  see. Many
things about member perks and volunteer perks basically have a lot to do
with space usage time. Also a sign in / out for staff ..
like I said, we would use free hub as it stands but it's super important
for us to have a sign out.
On Tue, Sep 22, 2015 at 12:20 PM, Dustin @ NBW - Philadelphia PA <
dustin@neighborhoodbikeworks.org> wrote:
...
Andrew, definitely open source it, even as-is!
D.
On Tue, Sep 22, 2015 at 2:10 PM, Andrew Shooner ashooner@gmail.com
wrote:
...
I have it in a private repo right now, since I think it includes some
import
...
data. If there is interest I can clean it up and put it on a public
repo. I
...
would not recommend using it as-is, since there is plenty of preferences
that are hard-coded for us.
It was my first Meteor app, so there are plenty of sins against the DRY
gods
...
in there, but i'm willing to rip off that particular band-aid if it
piques
...
interest from other devs :)
On Tue, Sep 22, 2015 at 1:38 PM, Jonathan Morrison
jonathan@bicyclecollective.org wrote:
...
Andrew, do you have a github.com link to the code?
...
---------- Forwarded message ---------
From: Andrew Shooner ashooner@gmail.com
Date: Tue, Sep 22, 2015 at 11:20 AM
Subject: Re: [TheThinkTank] members and sign up database software
To: The Think Tank thethinktank@lists.bikecollectives.org
Hey Jesse,
Since I responded originally, we've launched our node-based app (more
specifically Meteor.js), and have been using it this season with few
problems. Now that Meteor 1.2 is out, I'm going to be rewriting it to
use
...
...
...
React.js, and add a few additional features.
Providing ongoing support always needs to be considered, so I'm
thinking
...
...
...
of following Freehub's model with the next version and providing a
hosted
...
...
...
version of the app. It would be much better if there were more than 1
dev on
...
...
...
the project, so if anyone has an interest in Meteor, please get in
touch!
...
...
...
Depending on 1 random internet guy to keep your shop system running
seems
...
...
...
like a bad idea...
I can probably set up a demo if folks are interested in playing with
the
...
...
...
current version.
Current Features
Records
-Visitor records including name, waiver acceptance, and equity credit.

Timelogs (sign-in / sign-out) which can be volunteering (generates an

equity credit transaction), stand time (generates a cash or equity
debit
...
...
...
transaction), or other activities that don't generate transactions

Transactions (either equity or cash). Cash transactions just create a

notification so the cashier knows how much to charge in our Square
(technically, there is a way to hand it off straight to Square, but we
want
...
...
...
to keep Square's reporting for now). Equity transactions add or
subtract
...
...
...
from the visitor's balance.
Login / Logout Kiosk
A screen that visitors use to sign in and out, and say what they're
doing
...
...
...
in the shop. Also replaces our paper registration/waiver.
Shop Dashboard
For the front desk worker. Shows who is volunteering, who is on stand
time, etc. Also shows today's recent sign-outs. Provides access to
create
...
...
...
equity transactions (e.g. purchasing parts on equity),  notices about
cash
...
...
...
transactions to run, as well as access to browse all people, timelogs,
or
...
...
...
transactions.
New Features (for the next version)
Bikes
For bikes in our workflow. This will help us track which bikes aren't
selling or getting fixed, and let customers browse bikes without
needing to
...
...
...
make it to our limited open shop hours. It will also give us some nice
metrics on how well we're processing bikes.
Shifts
Schedule shifts, and link all timelogs to the shift in which they
occur.
...
...
...
This will let us set which activities are permitted depending on the
kind of
...
...
...
shift (e.g. self-signin volunteering only on volunteer night; free
stand-time on women's night, etc). This will automatically generate a
shift
...
...
...
report that we put together manually right now (volunteers, attendance,
etc).
Inventory
Put our parts prices into the system to make adding up a equity
purchase
...
...
...
easier, as well as give us a full picture of what parts are in highest
demand (right now we only know which parts are purchased with $ through
Square).
Nice-to-haves

Better reporting, for things like volunteer retention and

recruitment.
...
...
...
I want to get a notice when someone volunteers for the first time, or
hits a
...
...
...
certain milestone of volunteering.

Purchase requests: stuff we need to buy, either for a specific bike,

or
...
...
...
just general consumables.

Print-outs for bikes (holds, purchase waivers, evaluations, etc).

On Mon, Sep 21, 2015 at 10:09 PM, Jesse Cooper <jessecooper0@gmail.com
...
...
wrote:
...
Hey Folks!
It's been a couple of years since I first asked about a database /
software for sign ins and stuff.
Has there been any progress on this front for any shops out there
yet?
...
...
...
...
We are interested in Freehub but we need for people to be able to
sign
...
...
...
...
out to accurately track hours, something which Freehub doesn't do.
Can anyone give us (our community bikes) leads on applications that
can
...
...
...
...
allow sign ins / outs, and take info like name, email, whether or not
they
...
...
...
...
want to be emailed, dates, exporting data sheets, distinguish between
staff
...
...
...
...
/ volunteer / member or other categories we deem we need, etc?
Or is anyone able to make a "Freehub" that has in addition to
everything a sign out option?
help?
Jesse
On Thu, Nov 7, 2013 at 11:09 AM, Jesse Cooper <jessecooper0@gmail.com
...
...
...
wrote:
...
Hey Folks!
So at Our Community Bikes in Vancouver, we're thinking it's time to
set
...
...
...
...
...
up a proper sign in / sign out system, combined with a membership and
volunteer database.
Ideally we would like to know what software is out there that can
track people coming in and using our space, a simple laptop or
desktop kiosk
...
...
...
...
...
where folks can type in info, and it would enter our database.
Also to serve as a database that members can register into, and
again
...
...
...
...
...
wherein volunteers can sign up, and log their hours, and tasks
accomplished.
...
...
...
...
...
sooo.. any ideas?
Jesse Cooper

The ThinkTank mailing List
<a
href="
http://lists.bikecollectives.org/options.cgi/thethinktank-bikecollectives.or...
">Unsubscribe
...
...
...
...
from this list</a>

The ThinkTank mailing List
<a
href="
http://lists.bikecollectives.org/options.cgi/thethinktank-bikecollectives.or...
">Unsubscribe
...
...
...
from this list</a>
--
Sincerely,
Jonathan Morrison
Board of Directors
801-688-0183 cell

The ThinkTank mailing List
<a
href="
http://lists.bikecollectives.org/options.cgi/thethinktank-bikecollectives.or...
">Unsubscribe
...
...
from this list</a>

The ThinkTank mailing List
<a
href="
http://lists.bikecollectives.org/options.cgi/thethinktank-bikecollectives.or...
">Unsubscribe
...
from this list</a>

The ThinkTank mailing List
<a href="
http://lists.bikecollectives.org/options.cgi/thethinktank-bikecollectives.org">Unsubscribe
from this list</a>