Projects

The Genealogical Master List

A genealogical research tool, built to combine data from 20+ years of genealogical research into one huge, combined index of searchable data. The Master List is web-based and includes a high-speed, custom genealogical search and cross-referencing capabilities. To build the Master List a huge amount of data from about 25 earlier indexes was pulled together. The source data was then migrated to a modern document database (sometimes requiring antique computer systems to be resurrected to read it), cleaned up and a custom search engine built on top.

• Spring Boot
• MongoDB
• Python

Kiwi Living

TVNZ's Kiwi Living website. This was a responsive site, built with ExpressionEngine, that tied into the TV show of the same name. We also hosted this website, which generated very significant traffic.

• Responsive Design
• Bootstrap
• ExpressionEngine CMS

My Kitchen Rules NZ

My Kitchen Rules NZ, the site of the popular reality TV show. Clearfield was brought in to update and tweak the site for Season 2. We also hosted it. It was based on ExpressionEngine.

• Responsive Design
• Bootstrap
• ExpressionEngine CMS
• Hosting
• Varnish Cache

Vanuu Furniture Configurator

An online furniture design tool for Vanuu.de, a small German furniture startup. Vanuu made custom high-end cabinetry based on what you designed online on their website. You could visually design a piece of furniture from scratch and then Vanuu would manufacture and ship the furniture from your specifications. Clearfield built the configurator and integrated it into Vanuu's Shopware website. The Configurator was multi-lingual: German and English.

• Javascript
• Shopware e-Commerce

Miles Nelson

Development of a customised website providing a wide range of hardware fittings to overseas shoppers. Includes dynamically generated product pages, shopping cart, credit card ordering, staff order tracking and maintenance facilities.

• E-Commerce
• Custom Shopping Cart
• PHP
• MySQL
• Smarty
• Doctrine

Securimax

Development of dynamic website content based on flexible template-based PHP pages to easily display ventilation and lighting products in their respective categories.

• Configurator
• JavaScript
• PHP
• Smarty

Whats On Report

Development of an Amber application to allow Whats On Ltd subscribers access to a broad range of up-to-date construction industry information.

• Amber
• Java
• Microsoft SQL Server
• MySQL

ESB Lite

A middleware service to convert messages to and from SAP iDoc format.

• Spring
• SOAP
• Java
• WebSphere
• iDoc
• SOAP Web Services

Virtual Katy

Widely-used tool in the movie industry to bring audio tracks into sync with video after the video has been edited. It is a labour-saving program used by sound engineers, along with their regular sound editing suite, to simplify the task of movie editing.

• C++
• Protools plugin
• Nuendo plugin
• Windows
• Macintosh

Virtual Katy Connect

Virtual Katy Connect is a collaboration and workflow product for the sound effects industry.

VKC is revolutionary in that - as well as being a full project-management tool - it acts as a central repository for all the audio assets in a project. This means that sound engineers can now go online and submit their work to their peers and supervisors, instead of the traditional practice of copying files to a hard drive and couriering that to another sound department in another city.

• Google Web Toolkit
• C++
• Java
• Spring
• Hibernate

KiwiRail AMICUS Application Server Configuration & Support

KiwiRail uses a COBOL/IBM CICS (TXSeries) application server system running on IBM hardware. Clearfield handled the configuration of the CICS/AIX application server, tuning it for optimal performance. This involved optimising the backend database and configuring the CICS server and ongoing management. Clearfield also configured the WebSphere MQ Series which the CICS server uses to communicate with a separate WebSphere server.

• CICS
• TXSeries
• COBOL
• AIX
• IBM DB2
• MQ Series

KiwiRail Batch Script Conversion

As part of a large project to migrate KiwiRail from an IBM iSeries mainframe to an AIX infrastructure, Clearfield handled the conversion of the overnight batch scripts from JCL to Unix shell scripts. The batch scripts are involved in billing, revenue management, cargo tracking, data mining and data warehousing, and involve large amounts of SAS and COBOL. Clearfield also optimised the scripts to make them faster and more able to run concurrently with other processing.

• JCL
• Korn Shell
• Scripting
• SAS
• IBM DB2

Monitoring Device Prototyping

Development of proof-of-concept embedded Linux code to control a small consumer device running on custom hardware. This device communicated to a server through a variety of pluggable communications protocols. Clearfield was involved in the hardware and software prototyping, and also wrote an Amber-based server side application to visualise, monitor and control large numbers of these devices from a central location.

• Embedded Linux
• Custom Hardware
• C++
• Amber

KiwiRail Mainframe to COBOL Migration

Porting of a large proprietary COBOL system from an IBM iSeries mainframe onto a newly commissioned AIX system. Clearfield handled all the DB2 database administration duties, much of the operating system configuration, performed buildmaster duties, managed nightly builds from various third parties and administered the CICS and MQ Series setup throughout the new infrastructure.

• IBM DB2
• MQ Series
• AIX 5.2
• CICS/AIX

Encrypted Voice Over IP

Development of a commercial product to perform secure voice over IP and fax over IP.

• C++
• SSL
• XML

Elektron

Development of the Amber GUI designer. Features on-the-fly code round-tripping and specific support for designing Amber GUIs.

• Amber

Roboforge Translation

Internationalisation of the Roboforge client, and translation of the UI into German.

• Java
• Internationalisation

Java HL7 Stack

Java implementation of the Health Level 7 (HL7) stack, used within New Zealand for intercommunication in the Health industry.

• Java
• HL7

SportsCardMart

Design and development of the SportsCardMart website, a specialist sports-card collection website based in Richmond, California.

• E-commerce
• Java
• CORBA
• Oracle

Liquorland Retailer Website

Development of a website for the use of Liquorland retail branches, to assist them in tracking and reordering stock.

• Delphi
• MS SQL Server

Roboforge Hosting

Hosting of the Oracle database, tournament server and rendering farm for the Roboforge site. Included database maintenance.

• Web Hosting
• Oracle

Liquorland Product Maintenance Application

Development of an application to allow Liquorland retail branches to track stock availability and assist in pricing and reordering stock items.

• Delphi
• MS SQL Server

Terralink Test Scripts

Provided independent JUnit test scripts for regression and security testing a newly implemented third-party Java application.

• Java
• JUnit

Gogo Website Implementation

Implemented a large multilingual (Chinese & English) website for a Hong Kong based record label.

• ATG Dynamo
• Java
• Oracle
• Interwoven
• Teamsite

Gogo VPN Setup

Design and implementation of two IPSEC based VPN’s for the development and maintenance of a major overseas website.

• Hardware Setup & Maintenance

Networking Device Driver

Development of a DOS network shim to allow a 32bit DOS application to use the PXE/UNDI interface instead of the PacketDriver/NDIS2 interface.

• Assembler
• Device Driver

Ticketek to Clear Payment Gateway

Development of a Solaris based gateway between a vertical market Solaris software application and a secure payment gateway using SSL.

• C
• SSL

Health UI

Rewrite of the Health windows user interface to a central back end server through X.25 communications.

• C++
• X.25

Telecom Secure LDAP Shopping Lookup System

Development of a Java servlet application using LDAP to implement a secure shopping middleware redirector.

• Java
• Servlets
• C++
• LDAP
• SSL

PhoneCommander

Development of an NT service to log serial data from a PABX to an SQL database.

• C++
• Delphi
• Serial Comms
• MS SQL Server

X.25 Thunk

Development of a 32bit component to allow a 16bit legacy app to communicate to X.25 32 bit drivers.

• C
• Device Driver

Insurance Company Security Audit

Review of online security for an insurance company’s Internet site.

• Security Audit

Governmental VPN Rollout

Design and production rollout of a secure virtual private network (VPN) for a government department, to connect multiple sites across the country to a central database host. This includes experience in 128-bit encryption technology and IP routing.

• Hardware Setup & Maintenance
• SSL

Government Department Security Audit

Review of online security for a government department’s Internet site.

• Security Audit

Online Casino Site Security Audit

Review of network security procedures for an online casino in Australia.

• Security Audit

Atlas

Java-based product to allow remote administration of SBE brand routers. This software is a redesign and reimplementation of the earlier Workshop product (also by Clearfield).

• Java
• SNMP

Java SNMP Stack

An SNMP over IP and MAC transport and network layer written in Java.

• Java
• SNMP

South Auckland Health Gateway

A Unix gateway between Windows clients and an Oracle database for South Auckland Health.

• C
• Oracle

Imagecast

A hard disk duplication program which performs simultaneous disk copies over a network using custom developed IP multicasting protocols. At the time, an award-wining product on the market world-wide.

• C++
• Device Drivers
• TCP
• UDP
• Multicasting

Telecom Online Services (TOLS)

Setup, configuration and maintenance of a trial Internet Service System for Telecom New Zealand, including Sendmail, web server, proxy server, user accounts, backup procedures and routing.

• Software Setup

Workshop

Development and maintenance of a major suite of Windows-based applications for the configuration of SBE brand routers. This software uses SNMP over IP and MAC-layer comms, including a custom-written driver.

• Java
• SNMP
• Device Driver

Design

A contract in the USA doing research and preparing specifications for a comms-related software program.

• Software Design

Windows PPP Driver

A Windows PPP driver supporting IP and IPX.

• C++
• Device Driver

Reverse Engineering

Reverse engineering and fixing bugs in an X25 to SITA proprietary gateway for TIAS.

• C
• Assembler

Air NZ Hardware Audit

Review of NFS/NIS setup for Air New Zealand.

• Hardware Audit

Air NZ OS/2 gateway

An OS/2 gateway to transmit files between a file server and an AS400 using X25 on top of OS/2 Communications Manager/2 for Air New Zealand.

• C
• X.25

Botany Chromosome Analysis Application

A Macintosh application for chromosome measurement and analysis for the University of Auckland Botany Department.

• C

Serial Port Daemon

Unix serial port buffering daemon.

• C
• Serial Comms
• Device Driver

DOS to Windows Conversion

Porting a suite of DOS retail software packages to Windows.

• C++
• Porting

Obfuscator

A source code shrouder.

• C

HL7 API

Designing and implementing a portable (DOS/Windows/Unix) HL7 stack for the Department of Health.

• C
• HL7

Flowerscape

A major dual-platform (Macintosh and Windows) graphical interactive software application, being sold as a retail product in the USA.

• Pascal
• C

Tamper Checker

A PC device driver checking for software tampering to conform to German standards.

• C

Pasgate

A gateway between Unix (sockets) and an ICL 39 series SX mainframe (IDE interface).

• C

Network Interface

A PC common front end interface to disparate networks across a CASE/Cray/Dowty network stack (Novell, Sequent Unix & AS400).

• C
• Assembler

Serial Data Logger

A PC PABX serial data logger.

• C++

VT220 Terminal Emulator

A PC VT220 multi-session terminal emulator.

• C
• Assembler