Tuesday 6 January 2009
The Big Oxford Computer Co. Ltd.

Online Forms Integration Case Study - West Oxfordshire District Council

Overview

West Oxfordshire is a predominantly rural district council covering 714 km2 with a population of 96,000. The district is spread across a large number of relatively small settlements, totalling 83 parishes.

http://www.westoxon.gov.uk/

Objectives

The development and integration of BOCC Forms with the existing content management system (CMS) and back office systems for the WODC website to enable Citizens to request more services online in order to meet with Government targets.

Solution

The forms module was fully integrated with the existing Content Management System (CMS), (which was also developed by BOCC) and other back-office systems at WODC. Forms have been integrated in the following multiple ways:

  • The gazetteer address search passes forward property reference numbers to e-forms pre-populating data fields;
  • E-forms is embedded within the WODC content management system (CMS) page design;
  • Some E-forms, which require a payment, pass the user seamlessly through to the online payments system provided by BOCC;
  • E-forms data are replicated into WODC's customer relationship management (CRM) system.

In addition form data relating to waste services, such as missed collections or purchase of new bins, are passed directly onto the cleaning services contractor without manual intervention.

Each form submission is tagged with a unique reference number. The number is automatically included on the thank-you page after a form has been submitted.

The forms module has a secure web-based administration and form-building tool, which allows WODC users to create and edit the forms and to analyse and report on responses in real-time. Access to the administrative functionality is granted on a user-by-user basis. 

BOCC created a graphical interface design for the forms, which complimented the design for the website. The forms also meet the required accessibility standard of double-A conformance for the W3C web accessibility initiative (WAI) when applied to suitable CMS web pages.

Technologies

The system utilises:

  • Microsoft™ SQL Server 2005
  • Adobe® ColdFusion®
  • Replication of data, which then integrates with WODC back-office systems
  • Secure replication of data to and from internal systems via a virtual private network (VPN)
  • Hosting on fully managed dedicated web servers at BOCC
  • Provision of Disaster Recovery Facilities
  • SSL (Secure Server Certificate)
  • Extensible HyperText Markup Language 1.0
  • Cascading Style Sheets (CSS) 2.0 compliant