Archive for the 'SQL' Category

SARMA – Secure Australasia Returns Management Application

Thursday, June 5th, 2014

A comprehensive application to manage generation of RMAs (Returned Materials Authority), the receiving of damaged/failed meters into the warehouse, repairs and refurbishment in the workshop and despatching meters back to customers.  The client had a very basic in-house developed application to record the repairs and refurbishment aspect using TCL running on PostgreSQL.  The project covered […]

Property Management

Thursday, June 14th, 2012

This was a project more about data manipulation than software development. A local real estate agent was using a commercial application for tracking rental lease payments and had a separate home brewed Access database for managing late payers, task checklists and history of maintenance performed on a property.  They also had a few other spreadsheets around the […]

Transport Directions Database

Monday, April 16th, 2012

Fraser’s Livestock Transport operate in the remote regions of western Queensland where there are no maps.  Each customer might have several pick-up or delivery locations on a property.  They had an Excel spreadsheet with customer name, property/location name, and text directions of how to get there.  Built up over the years it was getting a […]

MOHS

Sunday, May 14th, 2006

Mallet’s Occupational Health and Safety forms was an ambitious project for a small company of heavy machinery operators. They wanted to automate all their paper work.  Each machine needed daily inspection with a couple of pages of checklists to be filled in.  While that wasn’t too difficult, collecting and filing them before they got lost […]

Estimating And Tracking System

Monday, July 13th, 1998

E.A.T.S. was initially developed for a steel fabrication company to streamline their job estimating process and produce quotations ready to send to the customer.  The costs of resources used in the manufacturing process are recorded so that the accuracy of estimations can be tracked.  It also interfaces with the Mind Your Own Business (M.Y.O.B.) accounting […]

Computer Network Hardware/Software/User Register

Friday, January 13th, 1995

This was a low-cost development for a very budget conscious, computer literate client.  Digressoft did the initial database design in Access and discussed the user interface design with the client who then did most of the work to put together the system.  We then came back and did the tidy up work and the tricky […]

Commercial Applications on the “New IBM PC”

Monday, January 1st, 1990

After 5 years working as an Analyst/C Programmer for Pancom Systems Pty Ltd.  I have decided it is time to move onto something more physical. In that time projects included: Development of a cashbook accounting system to run under both CPM and PC-DOS. Modification of an existing client/product management application and underlying database management system […]

bespoke software