Case study: Bike SA

Case study: Bike SA



Develop a solution for entering Bike SA events online.


Bike SA is the peak cycling organisation in South Australia, lobbying Government for cyclist safety improvements and promoting all facets of cycling. Their cause is largely funded through several events held throughout the year, some attracting thousands of entries. In 2004 the decision was made to migrate this snail-mail / paper based system to an online one. Participants would be able to fill out personal details and select options relating to the event, including meals, transport, and associated social activities. Payment through BPAY, phone (credit card)  and cheque could be made in the final stage of registration.


Smartsite partnered with TRIM Systems, and together developed the project scope with Bike SA. The build consisted of a client-facing site, which would be incorporated into BikeSA’s website, and a secure administration back end. The solution had to run on BikeSA’s Windows Server, and Trim performed installation and configuration to support some of the site’s features.  They also managed data migration from Excel / MS Access Database to MySQL. Smartsite worked on the PHP / MySQL powered forms, developed the new database schema, and designed / built the administration back end. Several of the online forms included complex client side validation and logic, which was handled by Javascript.

Key functions

  • Event registration, email confirmation
  • Data sanitizing
  • Mailing list ( event related )
  • Event payment
  • Administrator manual payment
  • Administrator mail to specific candidate groups / lists
  • Administrator profile edit / update / delete / create
  • Administrator export of entrant details to MS Excel
  • Event Newsletter create / mail ( PDF to e-mail and print / mail merge )

331 thoughts on “Case study: Bike SA

  1. Internal Server Error is a generic error mesagse with no useful information to assist you. You should disable Show Friendly Error mesagses in your Explorer and ask your web server support to enable Vbscript debug. When you get a detailed error mesagse please add that info so we can assist you.[]

  2. Hi, what do you mean by restart Comersus? you have to unzip again?Did you reiceve any description of the error?Why you put Version 4.18 and 4.27?Do you know if exist any problem with the Access DB? it is overload?Did you try to download Diagnostics and Tools and run the tests?[] [url=]ouvqupab[/url] [link=]bwimhwmovfp[/link]

  3. Podolgo vreme One imaat odlichna pnduoa. Verojatno najdobar odnos kvalitet/cena. Ama ova so cena za vospostavuvanje povik im e najglupo neshto shto go napravile. Sami si se vrakjaat od percepcija na operator koj raboti bez skrieni troshoci (i reklami imaa so koja gi trolaa T-Mobile i Vip) vo standarden operator. Tapa poteg. [url=]lohrhmm[/url] [link=]jaarbpq[/link]

  4. I see you don’t use the potential of social websites like pinterest and facebook on your website.
    You can get big traffic from social sites on autopilot
    using one useful tool, for more info search in google for:
    Alufi’s Social Automation

Leave a Reply