Home
About>
Services>
Case Studies
Talk to us
Company Info
Extranet
Site Search:

Case Studies

As technology evolves, we adapt and evolve to meet the opportunities and challenges.

Here are examples of the solutions we can design and develop. Simply click to expand the details.

  • Pestfree Environmental

    • Bespoke Site Visit Scheduling and Reporting System

      We have been working with the management team at Pestfree since 2006. The first project was an extranet solution to enable their customers to review their site's pest and hygiene status from a secure web-based resource.

      Recently we enhanced their extranet and designed and developed a bespoke Windows™ based scheduling and reporting system.

      The scheduling system ensures that operatives are allocated to site visits and automates the visit reminders and visit status via text messaging from our custom-built SMS Handler. It also enables the operatives to:

      • Inform the office staff of their location
      • Close down visits
      • Schedule follow-on visits and more from their mobile phones.

      The scheduling and reporting system also allows in-office staff to:

      • Securely manage users and admin roles
      • Allocate operatives
      • Schedule visits from a familiar calendar-based interface
      • Define visits for a contract
      • Manage all aspects of the system
      • Produce printed, PDF and Excel™ reports directly from the system with selectable parameters and in a specified format.

      As it is a bespoke system, new features can be added in a way that the management team want to work.

       

      Note:
      Example screen shots deliberately do not include live data. This prevents full functionality being shown.

       

      For the Technically Minded

      The scheduler and SMS handler are Microsoft.NET 3.5 WinForms applications with third-party controls and royalty-free reporting and Excel™ import/export tools. This means that there are no additional licenses to pay for reporting and the solution is licensed to the company.

      Option selection is dependent on user permissions and is provided through a ribbon-bar control.

      Pop-up alerting has been built into the scheduler to warn if the SMS handler has not logged a process run in a given time, and if there are any overdue visits.

      Pop-up help is provided on each form.

      The scheduler and SMS handler are supplied in installer packages for easy instalation and update management.

      Both the scheduler and SMS handler share the same back-end database which is Microsoft SQL Server™.

  • Cystic Fibrosis Trust

    • Specialised Database Conversion Tool

      This solution was not designed to be visually pleasing. It was designed to do a job fast, simply and reliably within a very short project timeframe, which it achieved with flying colours.

      All the client needed to do was select the source database, set the target database and click 'start import'.

      The application performed all the clever conversion and migration stuff, and reported progress with just a few mouse clicks. They could go and have a cup of coffee whilst it got on with it, safe in the knowledge that it would do its job as expected. It even allowed them to migrate data to an existing MS SQL database by individual tables.

      This simplicity enabled them to run many test migrations before migrating the live data to their new system.

      Cystic Fibrosis Trust were so happy that they recommended it to the charity CLIC Sargent, who also purchased a license for their data migration.

       

      For the Technically Minded

      This is a Microsoft.NET 3.5 WinForms application that converts data from Visual FoxPro™ to MS SQL Server™. It uses third-party database providers and visual components. In addition to working in both 32 bit and 64 bit Windows™ server environments, it has been tested in production in VMware™.

      The application is supplied in an installer package for easy instalation and management.

  • Butterfield Private Bank

    • Corporate Intranet

      We have been working with Butterfield Private Bank for over ten years and developed their first intranet in 2000. The original brief was to design and develop a solution that allowed them to add, manage, search and authorise group documents simply from an intranet.

      The latest version has been migrated to newer technologies and has been greatly expanded to include:

      • Who's who information for employees
      • Group Notice Board
      • Social Notice Board
      • Enhanced group document management
      • Group files management
      • FX rates import from Excel™ and authorisation
      • Deposit interest rates import from Excel™ and authorisation
      • Secure user and user role management.

      Note:
      Example screenshots deliberately do not include live data. This prevents full functionality being shown.

       

      For the Technically Minded

      The original solution was based on 'Classic' ASP technology which was migrated to ASP.NET 2.0 then ASP.NET 3.5.

      The new solution uses third-party ASP.NET controls for the UI and Excel™ import functionality, with AJAX on most forms for an enhanced user experience.

      The back-end database is Microsoft SQL Server™, however we have developed intranets using most other common database engines.

A significant competitive advantage

Many of the projects we undertake are under non-disclosure, so we cannot show you how the technology works as it is a significant competitive advantage for them. That's a shame because we think you would be impressed - our clients were.

For example, we recently developed the functionality for a regional based community magazine portal for a client and what makes that work is hush-hush too.

More examples of what we can achieve can be found in our testimonials on this web site.