Archive for January, 2010

Fuel consumption certification site

Saturday, January 30th, 2010

Business view: NZTA wanted a system to help importers comply with a new requirement to provide fuel consumption data for the cars they imported. The success case for the project stipulated that there be zero complaints from importers at the new requirement. We successfully worked with NZTA to create a series of point-and-click steps that matched a car on the dock with records in the fuel consumption database. There were no complaints!

Technical view: Design and creation of a PHP-based lookup site to the SQL Server-based Fuel Consumption Database, connected via web services, containing rapid validation options to match the imported vehicle to known data.

Rightcar for NZTA

Saturday, January 30th, 2010

Business view: NZTA wanted a new website to make vehicle information available to the public more holistic, and in particular to include measures for both safety and environmental sustainability.

Technical view: Extension of the existing Fuel Consumption Database to include various safety ratings and safety features, requiring further data sourcing, cleaning and integration. In-house usability testing, collaborative design, and implementation of a new PHP front end application to drive search, retrieval and side-by-side comparison of vehicles according to economy, safety and environmental ratings.

Fuelsaver for MoT

Saturday, January 30th, 2010

Business view: MoT, in conjuction with NZTA, required a site to help drivers understand how various factors – not least driving habits and the fuel efficiency of their vehicles contribute to their fuel costs.

Technical view: Design, usability testing, and creation of a PHP-based public website and ‘cost calculator’ application, retrieving data from the existing SQL Server Fuel Consumption Database via web services. Sourcing, cleaning and merging of data to support lookup and retrieval of information on new and used vehicles first registered in New Zealand after 2000.

Searchability and efficiency

Saturday, January 30th, 2010

Business view: RRB & RRA wanted improved searchability of their decision databases, to make Abstract creation more efficient, and to provide for greater data integrity.

Technical view: Implementation of MS SQL Server in support of Abstract searches, along with deployment of a custom tag-based structured search facility built in .NET. This became the primary way of navigating the decision library. Integration with case managament system Compass to extract key data for Abstracts. Addition of automated data integrity checks at the point of publication, including a facility  for authorising extentions of structured search metadata.

Fuel labelling for EECA — public users

Saturday, January 30th, 2010

Business view: From April 2008, car sales yards and online car auctions were required to display fuel economy information for vehicles they are selling. EECA wanted an application that would allow car yards to print physical labels, and to provide fuel economy information for online sellers like Trademe. It had to be easy, look great, and deal with millions of requests.

Technical view: Public labelling implemented as a PHP front-end talking to .Net Webservices + Bulk user access management written in .Net

Abstracts for Refugee Status Appeals Authority

Saturday, January 30th, 2010

Business view: The RFAA wanted much better access to relevant decisions, a more efficient way to create Abstracts, and the removal of a legacy document management system.

Technical view: Extraction and data cleaning of existing Folio-managed decision Abstracts. Creation of .NET-based admin tools for constructing , publishing and indexing future Abstracts, including automated checks on data integrity at the point of publication. Addition of custom-built structured search on Abstracts, with tag-based search guidance. Design and usability testing of visual interface, establishment as primary way of navigating the decision library. Removal of Folio.

Appeals Authorities’ websites

Saturday, January 30th, 2010

Business view: Webstruxure was asked to help the three Immigration Appeals Authorities get their first real websites off the ground, along with a backlog of their decisions, which were all in MSWord format. We also helped them start refocusing their internal processes on web-centered publication, aiming for greater efficiency.

Technical view: Design & development of three websites administered with Macromedia Contribute. Conversion to HTML & PDF of existing stock of MSWord-based decisions. Publication & free-text search based on MS Index Server. Creation of MSWord templates to assist authors with consistent formatting, and admin systems to allow future self-publishing.