Hey Jesse,

If your shop has internet access, you could take a look at:

http://freehub.bikekitchen.org/

We have not used it, but I imagine others on the list have and could give you some feedback. We were hoping to avoid writing something ourselves, so this looked good. Unfortunately we needed to add a shop credit component to it, and I think the Freehub app is more in maintenance mode at this point.

I'm messing with a node-based app for us, but it's still just a prototype.

Andy Broke Spoke Community BIke Shop Lexington, KY

On Thu, Nov 7, 2013 at 2:09 PM, 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

---

Thethinktank mailing list Thethinktank@lists.bikecollectives.org To unsubscribe, send a blank email to TheThinkTank-leave@bikecollectives.org To manage your subscription, plase visit:

http://lists.bikecollectives.org/listinfo.cgi/thethinktank-bikecollectives.o...

At Plan B, we have an old iBook with no internet connection that we host a server on and run a modified version of Austin Yellow Bike's log-in system. There is no built-in email capability or any function to export data to a spreadsheet, but both of those can be accomplished through other software. Setting it up will take more work than using FreeHub, but shouldn't be too difficult for anyone who has any experience with php and mysql. Email me if you want to try it out.

Ryan Peterson The New Orleans Community Bike Project 1024 Elysian Fields Ave New Orleans, LA 70116 920-539-9407

On 11/7/2013 1:09 PM, Jesse Cooper 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

---

Thethinktank mailing list Thethinktank@lists.bikecollectives.org To unsubscribe, send a blank email to TheThinkTank-leave@bikecollectives.org To manage your subscription, plase visit: http://lists.bikecollectives.org/listinfo.cgi/thethinktank-bikecollectives.o...

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>

Hi,

I might have time to add this to freehub and Alon (freehub's maintainer) has had this request before https://github.com/asalant/freehub/issues/21#issuecomment-142455472

For organizations that want a sign-out what do you want to happen if the person is never signed-out? You could have shop opening hours and auto-sign out everyone at close but that wouldn't help if volunteers were helping out of hours or stayed an extra hour after closing. Already that is beginning to add quite a bit of work, any thoughts on how this part should work simply (ideally on github)?

I started trying to upgrade Freehub to Rails 3 (or even a more modern ruby) but it is a lot of work and I don't really have much time. If there were more people that would contribute if it was on rails 3 (or even 4) then that would help motivate me.

On 23 September 2015 at 06:26, Jonathan Rosenbaum gnuser@gmail.com wrote:

Hi Jesse,

As part of Positive Spin's project to determine which software would best fit our needs, Docker demos were created from all known existing F/OSS community bike shop software, and are available at http://bikebike.wvcompletestreets.org .

We have been happily using YBDB http://ybdb.wvcompletestreets.org/. This software program is configurable, people can opt-in to our mailing list, it allows us to export transaction data to our accounting program, and it is stable. More importantly, it just works, and is simple for people to learn how to use.

I am looking forward to adding Andrew Shooner's application to the demos http://bikebike.wvcompletestreets.org once he releases the source code.

-Jonathan

On 09/21/2015 10:09 PM, Jesse Cooper 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..." 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>