Current Projects

Database systems

We have created FileMaker database systems for a wide range of clients and industries. To help you get an overview of what we do let us share with you a few of the systems we have created.

 

Winch Design

 

We started work with Andrew Winch, the founder of Winch Designs, in 1995 and have worked with his company as it grew from 10 staff to now over 70.

 

Winch Design create some of the largest and most fabulous mega yachts on the planet. They create the interiors for large private airplanes and the interiors of castles and mansions all over the world.

 

The systems we created for his company have helped with time management, project quoting and monitoring and more recently with the specification, budgeting and procurement of the all the products needed for the fit out of all of these projects.

 

The projects require a lot of reports and schedules which could take hours to produce and format. The staff are able to generate reports with a few clicks and in minutes have the printers whirring or emails flying.

Coexistence

 

We started work with Coexistence in 2001. Coexistence assemble furniture packages for office contracts and for residential schemes. With orders ranging from a few thousand to several million pounds the skilled staff are able to select and propose coordinated designs for major UK corporations.

 

Over the years we have produced together a system that manages quotes, order confirmations, suppliers orders, shipping management, client invoicing, staff commission calculations and stock control.

 

A great deal of coordination of dates and data is required to ensure that the staff are able to deliver the furniture packages to the client on time. The system assists in the collection of the data, the reformatting and restructuring of it to create the multiple documents needed to purchase the items, have them delivered, installed and paid for. The system also needed to allow external access so that the storage warehouses could keep stock records up to date.

David Collins Studio

 

We have taken on the ongoing development of the David Collins Studio FileMaker System.

 

The system that exists assists in the collection of data to help with the interior fit out of the prestigious projects that the studio is commissioned to work on.

 

This is a great example of where two clients, David Collins Studio and Winch Designs appear to be in the same industry with the same requirements. But each has a unique niche in the market and so whilst the systems are similar, one could not copy one system and insert it into the other office and expect it to work. The needs are different, the time scales are different and the method of working is different. Having a system that is specific to each clients' requirements helps them be as efficient as they can be without the need to ignore features that irrelevant.

L C Energy

 

We were very keen to work with a company that was involved in renewable energy. L C Energy are one of the largest suppliers of Bio Fuels in the UK. They supply fuel to some of the largest boiler installations in the England and also to the domestic market.

 

The system we produced for L C Energy manages the quoting, delivery run management, the recording of deliveries using iPads and the return of that data to the office for invoicing.

 

This system needed a main office element and a remote element. Data is prepared in the office and then uploaded to the truck driver's iPads where delivered quantities and client signatures are collected. The resulting data is returned to the office for invoicing. This process used to take up to a month to process and is now completed within hours, dramatically improving cash flow.

RAL

 

RAL required a system to record the delivery of waste material to a landfill site. The partner trucking company finds and organises the collection and delivery of the waste material and RAL provides and manages the site where the waste is being used as landfill.

 

The issue here was the management of the strict environmental compliance standards demanded by the Department of the Environment.

 

The system needs to collect four types of data coming in from four parties, all by email. The emails are sent to the system which then identifies the type of data being received and inserts it as needed. The data relates to the initial waste inspection, a number of deliveries of the waste to the site, photographs of the waste material and chemical analyses taken of the waste. Each data type arrives from different sources and needs to be checked for completeness and accuracy. The system then assists with reporting on the deliveries made each week and invoicing to the trucking company.

 

A second aspect was to work with the trucking company - Axtell Ltd - to link the system to their PDAs to further reduce the need for data entry.

Previous Work

 

We have worked with FileMaker since 1995. The first system we produced was designed to manage Architectural practices. The idea being to generate a single solution that would fit all. We soon discovered that there was far more benefit to the clients if the system was written to their specific requirements. No two companies work in the same way.

 

There are some great off the shelf products that work well when there are well established industry standards or compliance constraints. But where these do not exist or where they are still under development we have found that having a bespoke solution greatly benefits the client. They are able to request system changes to meet new requirements or working methods and see these changes implemented within hours or days rather than having them languish on wish lists.

 

Since those early years we have produced over 24 major systems.

Previous systems include:

Company

Industry

System

Neals Yard Dairy

Neals Yard Dairy - Wholesale, Mail order and online cheese sale

Order processing, Shipment management, Customs paperwork, invoicing, delivery route planning.

The Conran Shop

Retail/product development

Management of product development, selection and production.

Conran Weddings

Wedding lists

Client relationship management, List management, reporting and invoicing.

Conran Contracts

Contract furniture supply

Quoting, order processing, client invoicing.

Techniker

Structural Engineers

Staff Timehseets

Meno Yearbooks

Online specialist publications

On line book purchase, data gathering, automated conversion to publication layouts and order taking.

Jasper Conran

Haute Couture

Design development, sample management, client order taking, component ordering and client invoicing.

The Picture Canning Company

Television Broadcast and filming equipment hire

Quoting, job processing, stock management, packing lists, shipping documentation, client invoices, management reports.

Education Extra

Childrens Education Charity

Membership management and correspondence.

The Diana Award

Childrens Anti -Bullying charity

Membership management and correspondence

LandroverSuperstore

Online parts sales website

Stock offering, back office management system for multiple suppliers, client accounts. order taking and shipping cart system, multiple currency management, suppliers orders and invoice management.

Capital Sound

Sound Equipment hire for large events.

Quoting, order processing, packing lists, stock management.

First Subscriber

Online specialist magazine subscriptions

On line product list, order taking and processing, multiple currency management, back office order fulfilment. New supplier telesales operation and commission system. SEO tools and on line marketing system.

KR2

Lighting Suppliers

Import industry client lists and current projects lists from Barbour Index, Mass targeted and personalised marketing tool. Management feedback reports, quoting and suppliers orders.

BD3

Printers

Quoting, job bag and client invoicing.

Spectrum Environmental

Air and Water quality testing and monitoring

Quoting, job scheduling, client invoices, large contract management.

Maharishi

High Street fashion

Seasonal Product range, client ordering module and invoicing, stock management. Catalogue booklet production.

Ecohomes

Solar Panel Installers - In House Call Centre

Prospect list management, campaign management, targeted concentration of calls, tiers call managers, call back management. Reporting on caller performance. Appointment booking management.

t. 01428 717 611

© Copyright 2016. All Rights Reserved.