Secure Event Ticketing using CiviCRM & Barcodes

Because the Club’s events processes were so diverse and given the lack of management attention EI developed a specification which tried to envisage all the ways that tickets would eventually be issued. Tickets were to be available in real-time following an event booking in CiviCRM and would contain a unique id generated from the member’s CiviCRM ID, the event ID and the ‘seat number’. This would be produced as a barcode as it was intended that eventually, the ticket would be scanned and the information generated used to update a member’s event status with the information that they attended. Tickets would be delivered as a link to a pdf in the event confirmation email. The secretariat were to have access to all member tickets so that they could either re-email them or print them off and snail mail them to members as members might (and did!) lose tickets and some members did not have email addresses. Having specified the module, 3 UK companies were approached to develop the module. The work was won by Circle Interactive (CI) and was managed for them by David Moreton. CI produced the module based on earlier work by Hershel. The module was tested over a variety of circumstances and was accepted by EI on behalf of the Club.

However, once the module was working in the production environment the Club decided that it was not ready with either its ticket collection processes or with member communications to introduce online ticketing immediately. There had resistance by a (vocal) minority of members even to online booking which had been available for 6 months and the Club’s management decided that it was necessary to give members 3 months prior warning that online ticketing would be introduced. The thought of 90 members turning up to an event where all of them had misunderstood that they should have printed their online ticket and had not done so promised more chaos than the Club was prepared to entertain. Meanwhile some members had been critical of the Civi process that required booking of multiple places at an event to be carried out ‘ticket by ticket’. There was significant confusion over the UI as when booking multiple places as the first place was booked, then the payment processor info was entered and only then were the additional places specified. Each profile required entry of both ticket type and dietary information for each participant. As a result of this feedback the Club’s events administrator decided that they would use the CiviContribute module and combination price sets allowing selection of ‘multiple place’ bookings as a single transaction with specification of the total number of each available dietary requirement in a single screen… However the ticket module had not been designed to accommodate this. The Club did not have the budget for a redesign of the ticket module. Circle Interactive generously adapted the module to work with CiviContribute and at least deliver a single ‘combination ticket’ with a field showing ‘No. of participants’. It was this ticket that was introduced following the three months’ notice to members. For the first event ALL the tickets that had been booked were printed off by the secretariat and held for those members who had not printed their own. About 20% of members attending the first event had not printed their tickets. 4 months on this number has fallen to around 5%. However about 10% of transactions still require telephone support with members either unable to find the link to their ticket in the confirmation email (various formats have been tried) or not having a copy of Acrobat installed and configured to display the ticket after they press the link.

This case history illustrates the problems that are, in our experience, relatively common with smaller not-for-profits moving to and using CiviCRM. The lack of consistent process, lack of management and changes in policy (where policy exists) mitigate against delivering much of the value that CiviCRM might otherwise deliver. Edutech Insight is not a developer. What we do is to try to help organisations to use CiviCRM to gain insight from the data they hold on their constituents such that they can provide better value for them and thereby increase membership/contribution/commitment and reduce churn. Organisations looking to deploy a CRM solution should realise that, in addition to selecting a technology solution they must also pay attention to their processes and management. CiviCRM is a fantastic tool and can provide excellent management support. But if management is lacking the value of the tool will be diluted. With this particular client the lack of management was not confined just to this project but was endemic across a number of Civi initiatives. Eventually this led to a summit with the senior leadership at which this paen (http://edutech-insight.com/sites/default/files/images/managing_with_civicrm.pdf) to systematisation was presented.

We hope this analysis might be useful to existing or potential users of CiviCRM and to other consultants struggling to help their clients understand exactly how they do what they do… Never the less out of this project a useful extension to Civi was produced.

Circle Interactive will eventually release the ticketing module sponsored by us and we both hope the community will find it a valuable addition to the available set of Civi tools. Watch this space!