Monday, September 27, 2021
Technology Claims Management System

MySQL, MSSQL, Filemaker, .NET & compact framework

MySQL Icon

Acorn Assessors in house IT team leverage several advanced technologies to deliver their IT solutions infrastructure.

Our claims management system is built on a MySQL Core with a custom built Filemaker reporting and data access solution. This system has had over 10 years of development from its humble beginnings, to one of the most advanced solutions of its kind in the industry.

Using the .NET platform and the .NET Compact framework, along with Widnows 7 Tablet PC functionality we have developed our OnSite reporting system which allows our road based engineers to inspect from site using handheld PDA's, smartphones and more recently a much more efficient tablet PC system.

Each morning the system downloads the engineers allocated jobs to the device. The system integrates with their TomTom GPS devices adding the vehicle location's to the GPS device so that the engineer can take the most efficient route to the next destination. The devices both offer job allocation and two way communication, where engineers update head office immediately to inform us that they are on site at the vehicle location.

"Our booking staff can allocate new jobs directly to the engineers mobile devices based on their location in comparison to the vehicle location of newly receved inspection requests."

Microsoft.NETEngineers then inspect the vehicle and using their mobile device they add the vehicle inspection details. Once complete they sign off the inspection and the data is instantly transmitted to our head office claims management system for processing.

Our work providers can access live claims information 24/7 via our website. Once logged in work providers can generate copy reports, view images, get current status and add notes to the file. Our website also allows support requests to be logged.

We are currently developing a system whereby we show our road based engineer locations on our website so clients can see when the engineer will be arriving.

Technology in use

MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout it's history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.

Filemaker 11Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, and packaged software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and

FileMaker Pro is powerful database software platform that helps you and your team get any task done faster. Millions of people in business, government and education use FileMaker Pro to effortlessly manage all their information on Windows and Mac. The built in reporting functionality makes visualisation of data instant and effortless, reducing the need for lengthy development cycles.


Mysql Logo
Tomtom Logo

Client Login

Click to login

If for you have forgotten your details, please e-mail: