Fwd: [WSBA] Online Registration Alternative

3 views
Skip to first unread message

Scott Willson

unread,
Jul 29, 2008, 9:37:18 PM7/29/08
to racing-...@googlegroups.com
Forwarding this over to the new group for posterity.

Hey, I'm sure this isn't self-evident, but there already is a results engine behind the WSBA and OBRA sites. The OBRA results go back to 2006. For maximum geek out, see:

Fork away!

Oh, another non-self-evident nugget: there's already a Trac instance with open issues, wiki, etc. that's integrated with the source code repository. You can register yourself to add tickets and make changes, and I'm happy to give to you full privileges to do whatever else you'd like to do there. There are also a variety of RSS feeds, web reports and email notifications.

For instance, here's what I'm working on this month:

Scott


Begin forwarded message:

From: Ryan Rickerts <ry...@cyclocrazed.com>

I'm okay with a Google group.  Maybe send out another invite to the main list to let them know where the conversation moved?

I am willing to meet in person, but I am also trying to coordinate 5 other 'cross promoters right now to get our fall series calendar dialed down.  This takes precedence in my copious "spare-time" for now, but as I stated, my main role will be building the results engine that I can then port over to the WSBA.

For the geek inclined, I will hook up to Scott's Subversion source control repository and start reviewing the code, but I am using Git (so believe I can still talk to the repo using git-svn).  

I will then likely host the forked code in my GitHub account here:  http://github.com/theRocket.   

If you want to get really fancy, we can do project management (i.e. bug requests) via GitHub's integration with LightHouse.  For $10/month, I can have 10 people "in the project", or 2 people for free.  If it's published as an open source project, anyone can view it and post tickets.  

Might be a good way to get some member involvement and keep motivated.  Plus more ways to communicate without spamming or flooding inboxes.

Scott Willson

unread,
Jul 29, 2008, 9:48:26 PM7/29/08
to racing-...@googlegroups.com
More forwarding. I am sure you are sick of email from me already. I doubt this group will be all this noisy later on.


From: "Ian Mensher" <imen...@gmail.com>

This all sounds great, especially all the technical jargon that I fully don't understand.  I am happy to meet up at any point before Aug 4 or after the 12th.  I am happy to lend a hand in any non-technical fashion.
 
One thing that sounds like it might save us time is to have all the racers sign up online using whatever web site we have and there they can input all of their information.  That'd build the database without having one or two of us input a shit-ton of data into a spreadsheet of sorts.  Maybe I'm pointing out the obvious....

There's already a database with quite a bit of information for all members from the last couple of years, as well as an entry for anyone who showed up in the results. So, to focus on Ian's initial idea: if we could build a couple of pages where racers could sign in, look at the schedule (in the database as well), say "I want to do this event," and provide an export page for promoters and officials, we're done. 

Basically, we need to expand the authentication system to include members and add a few pages.

Here's a description of the member information:

Bmx Category
Ccx Category
Ccx Only
Cell Fax
City
Created at
Date of Birth
Dh Category
Email
First Name
Gender
Home Phone
Last Name
License
Member from
Member to
Mtb Category
Notes
Occupation
Print Card
Print Mailing Label
Road Category
State
Street
Team
Track Category
Updated at
Updated by
Work Phone
Zip

theRocket

unread,
Jul 29, 2008, 9:50:27 PM7/29/08
to Racing on Rails
Great. I will look into the results engine.

Sorry to introduce a different repo and issue tracker. You should be
able to take my commits into your Subversion repository, but on my
half of this world, I'll be using Git.

RJR

On Jul 29, 6:37 pm, Scott Willson <sc...@butlerpress.com> wrote:
> Forwarding this over to the new group for posterity.
>
> Hey, I'm sure this isn't self-evident, but there already is a results  
> engine behind the WSBA and OBRA sites. The OBRA results go back to  
> 2006. For maximum geek out, see:http://trac.butlerpress.com/racing_on_rails/browser/trunk/db/schema.rbhttp://trac.butlerpress.com/racing_on_rails/browser/trunk/app/models
>
> Fork away!
>
> Oh, another non-self-evident nugget: there's already a Trac instance  
> with open issues, wiki, etc. that's integrated with the source code  
> repository. You can register yourself to add tickets and make changes,  
> and I'm happy to give to you full privileges to do whatever else you'd  
> like to do there. There are also a variety of RSS feeds, web reports  
> and email notifications.
>
> For instance, here's what I'm working on this month:http://trac.butlerpress.com/racing_on_rails/query?status=new&status=a...
>
> Scott
>
> Begin forwarded message:

theRocket

unread,
Jul 30, 2008, 1:47:05 AM7/30/08
to Racing on Rails
On Jul 29, 6:37 pm, Scott Willson <sc...@butlerpress.com> wrote:

> Oh, another non-self-evident nugget: there's already a Trac instance  
> with open issues, wiki, etc. that's integrated with the source code  
> repository. You can register yourself to add tickets and make changes,  
> and I'm happy to give to you full privileges to do whatever else you'd  
> like to do there. There are also a variety of RSS feeds, web reports  
> and email notifications.
>
> For instance, here's what I'm working on this month:http://trac.butlerpress.com/racing_on_rails/query?status=new&status=a...
>
> Scott
>

Scott,

This is nice to see, and I didn't mean to disregard it. I just got me
a Git workflow happening, and I don't think I could achieve the same
on Subversion right now. The LightHouse stuff pretty much comes for
free (with the right syntax in the commit message).

I wonder if I could import your issues into LightHouse? Their API
supports a REST interface (http://www.lighthouseapp.com/api), and it
looks like Trac will output in various formats (XML and CSV). I don't
know if we can get it talking in both directions, though.

theRocket

unread,
Jul 30, 2008, 1:53:05 AM7/30/08
to Racing on Rails


On Jul 29, 10:47 pm, theRocket <edaroc...@gmail.com> wrote:

> I wonder if I could import your issues into LightHouse?  Their API
> supports a REST interface (http://www.lighthouseapp.com/api), and it
> looks like Trac will output in various formats (XML and CSV).  I don't
> know if we can get it talking in both directions, though.

Or here's another drastic course of action:

http://trac-hacks.org/wiki/GitPlugin

Wanna learn a new SCM?

theRocket

unread,
Jul 30, 2008, 1:58:49 AM7/30/08
to Racing on Rails

On Jul 29, 10:47 pm, theRocket <edaroc...@gmail.com> wrote:

> I wonder if I could import your issues into LightHouse?  Their API
> supports a REST interface (http://www.lighthouseapp.com/api), and it
> looks like Trac will output in various formats (XML and CSV).  I don't
> know if we can get it talking in both directions, though.

Or maybe I could just take these, and massage the CSV export:

http://trac.butlerpress.com/racing_on_rails/query?status=assigned&status=new&status=reopened&component=WSBA&order=id&col=id&col=summary&col=status&col=owner&col=type&col=priority&milestone=

I plan to stay in line with your trunk, so maybe any WSBA-specific
issues could go into LightHouse?

Ian Mensher

unread,
Jul 31, 2008, 2:24:44 AM7/31/08
to racing-...@googlegroups.com
Message from Terry Buchanan that may be of no interest to you programmers.  If it is, I can email Terry.  

---------- Forwarded message ----------
From: Terry Buchanan <ter...@zipcon.net>
Date: Wed, Jul 30, 2008 at 6:10 PM
Subject: Re: [WSBA] Online Registration Alternative
To: Ian Mensher <imen...@gmail.com>


Ian,

I already have a good system I use for the circuit races and Star Crossed. It uses MS Access. If want to review let me known.

Terry Buchanan

On Jul 28, 2008, at 4:26 PM, Ian Mensher wrote:

All,
 
Glad this has some appeal (Stangeland aside).  I'm happy to put in time to help start up the database (e.g., data entry) or some related task that doesn't require web-skills. 
 
Thanks,
Ian

 
On 7/28/08, Phil Miller <Ph...@svrdesign.com> wrote:

I may live to regret saying this, but…..

 

This may be a very timely idea.  Right now, one of the big challenges we have regionally is managing what seem to be swirling data bases of riders, point systems and the like.  The info is used for everything from scoring BARR competitions to on-site preparation of start lists, to corroboration of new Finish Lynx photo-finish imagery into rapidly prepared order-of-finish postings.  Everyone's expectations have gone sky-high (and they SHOULD be high), but getting the data to flow predictably is very difficult.  I'm all in favor of developing a wholly self-contained system locally that can be used to collect registrations, sort and print start lists that only have registered riders on them (as an official, this is HUGE), and that then is sorted for order of finish, results, and series points assignments.  A commissaire can dream, can't he?

 

I know the talent exists within the community, but it does cost…..

 

Could be great.

 
 

Phil Miller

project planner

   

SvR Design Company                                            

1205 Second Avenue, Suite 200                                             

Seattle, WA  98101

t. 206.223.0326 x1014  f. 206.223.0125

www.svrdesign.com

 

This message is intended solely for the recipient and should not be opened, read or utilized by any other party. This message shall not be construed as official project information or as a direction except as expressly provided in the contract documents.

 

From: wsba-b...@wsba.wsbaracing.com [mailto:wsba-b...@wsba.wsbaracing.com] On Behalf Of Mike Hone
Sent: Monday, July 28, 2008 4:15 PM
To: Ian Mensher; ws...@wsba.wsbaracing.com
Subject: Re: [WSBA] Online Registration Alternative

 

I think this would be great… I hate paying those fees as well. It would be nice if we had one site to do the payments instead of many cycling sites which are used right now.

 

If we had to pay a small fee for this type of site, I would rather pay the WSBA vs another company that profits from our racing.

 

I know I could design such a system, but the problem is we need someone to build it. Does anyone want to volunteer? I have developers that could make this, but they cost money.

 

Mike Hone | Adobe | Senior Visual Designer | w: 206.675.7300 | m: 206.660.7359

 

From: wsba-b...@wsba.wsbaracing.com [mailto:wsba-b...@wsba.wsbaracing.com] On Behalf Of Ian Mensher
Sent: Monday, July 28, 2008 4:08 PM
To: ws...@wsba.wsbaracing.com
Subject: [WSBA] Online Registration Alternative

 

Hello all,

 

It crossed my mind as I spent an additional 15% to register online for the state TT that there must be some lower-cost alternative for online registration.  I recall that the Methow Valley Stage Race had an online system that charged no service charge.  Frankly, I'd rather pay the 42 cents to mail the registration along with my check and my signed waiver to make the pre-registration process totally complete and much cheaper.  I feel less compelled by the thought of subsidizing some third-party like Active.com.  I realize that Active.com is likely easy to deal with for promoters and the monetary impact appears to fall on the riders.  

 

Is there another way to keep the simplicity of online registration without funding Active.com and other ticketmaster-type entities?  Could the WSBA site create a secure page/system through which racers could pre-register for events?  I don't know anything about how to set this up, so feel free to tell me how ridiculous the idea is.  There might be an alternative method of simply having riders register online without also paying, so as to avoid the problems of setting up some online payment system.  I realize that requries extra volunteers at the start of races to collect fees and the waivers, but having run registration several years, I don't think the burden is onerous. 

 

I'd also suggest to promoters that they might consider permitting both online and mail-in registration for events where preregistration is a necessity. 

 

Any thoughts?

 
 

Thanks,

Ian


_______________________________________________
WSBA mailing list
WS...@wsba.wsbaracing.com
http://wsba.wsbaracing.com/mailman/listinfo/wsba


Phil Miller

unread,
Jul 31, 2008, 11:08:18 AM7/31/08
to racing-...@googlegroups.com

“Good system” in this case is somewhat relative….system outputs matter, although I gather it’s a back-end issue.  I need formats that serve a multitude of purposes and masters, not the least of which is UCI (Starcross, Rad Racing GP of CX). 

 

 

Phil Miller

project planner

   

SvR Design Company                                            

1205 Second Avenue, Suite 200                                             

Seattle, WA  98101

t. 206.223.0326 x1014  f. 206.223.0125

www.svrdesign.com

 

This message is intended solely for the recipient and should not be opened, read or utilized by any other party. This message shall not be construed as official project information or as a direction except as expressly provided in the contract documents.

 

theRocket

unread,
Jul 31, 2008, 1:43:59 PM7/31/08
to Racing on Rails
Phil,

I would be interested in knowing the nitty-gritty details of those
formats, at least the more standardized ones. What do the UCI
require? Maybe you could point me to their rules?

Terry (via Ian?)

No offense, but I'd rather chew on glass then try to translate an MS
Access app (proprietary) over to Scott's back-end (open-source,
standards-based). I couldn't even run it, as by the grace of the
computing gods, I have no Windoze machines.

I would be interested in knowing your key features, either included
(i.e. what is "good"?) and what is missing. If it's really great, I
could try to install it in a virtual machine on my Mac. But really,
it may be easier to just describe it.

Thanks,
RyanR>

On Jul 31, 8:08 am, "Phil Miller" <Ph...@svrdesign.com> wrote:
> "Good system" in this case is somewhat relative....system outputs
> matter, although I gather it's a back-end issue.  I need formats that
> serve a multitude of purposes and masters, not the least of which is UCI
> (Starcross, Rad Racing GP of CX).  
>
> Phil Miller
>
> project planner
>
> SvR Design Company                                            
>

Phil Miller

unread,
Jul 31, 2008, 1:56:13 PM7/31/08
to racing-...@googlegroups.com
I'll try and pull a few together - they exist in a number of places in the regulations, based on the event involved, purpose of form (results, enscriptions, etc)

Phil Miller
project planner

SvR Design Company
1205 Second Avenue, Suite 200
Seattle, WA 98101
t. 206.223.0326 x1014 f. 206.223.0125
www.svrdesign.com

This message is intended solely for the recipient and should not be opened, read or utilized by any other party. This message shall not be construed as official project information or as a direction except as expressly provided in the contract documents.


Reply all
Reply to author
Forward
0 new messages