that'd be pretty cool Momoko. We are currently using Mac systems in the space for inventory tracking and work orders (light speed) and we'd be using an IPad on this network. 

     (  hurry up and finish it!    and many regrets I won't see you at Bike!Bike! but say hi to Pablo Botero and Lauren Warbeck, representing UCB Bike Kitchen and Our Community Bikes!)

  This sounds like a very simple version and probably closest so far to what we need. 

   Please keep me posted as soon as we can apply it in our space. 

 Jesse



On Tue, Sep 22, 2015 at 12:47 PM, momoko saunders <analyst@bikefarm.org> wrote:
I've been working on a mobile app for this. I'm nearly done with it. I was actually hoping to release at Bikebike but I got caught up in other work. 

It does just what you're asking for. A simple sign in app that tracks hours, membership, distinguishes between volunteer and patron. (I should add staff) The only issue is that it's for the iPhone/iPad . 

That's the only platform I currently know how to develop in. My hope is to learn Java after this and make an android app. Would an apple one still work for you? 

How do others feel about adroid or apple? Or if mobile is a bad idea and it really ought to be on a desk top? 

-Momoko


-------------------
I've attached to screenshots. Maybe you get the idea of how it works. The first screen shows a search bar, new user button, and list of all users in order of most recent. If you use the shop a lot, you just click on your name. Else you can start typing and it will filter as you type. If you are new, the you create an account. 

When you sign in. It says thank you, and offers to show you your stats. You can then see how much you've been using the shop. Admins can perform filters, sign people out, edit users, and export data to csv file. 





On Tuesday, September 22, 2015, Jesse Cooper <jessecooper0@gmail.com> wrote:
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.org">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>
>>>
>>
>>
>>
>> --
>> Sincerely,
>>
>> Jonathan Morrison
>> Board of Directors
>> 801-688-0183 cell
>>
>> ____________________________________
>>
>> The ThinkTank mailing List
>> <a
>> href="http://lists.bikecollectives.org/options.cgi/thethinktank-bikecollectives.org">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>
>
>
____________________________________

The ThinkTank mailing List
<a href="http://lists.bikecollectives.org/options.cgi/thethinktank-bikecollectives.org">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>