Microsoft Access auto-reading DOS program Take5

Microsoft Access auto-reading DOS program Take5

This project involved working around a DOS accounting program called Take5. While this simple package does the day-to-day tasks extremely well, it’s very rigid when it comes to reporting. Simplify I.T. learned how the DBF tables interacted and set them up to automatically extract to a server overnight, automatically convert and import themselves into a Microsoft Access database. Combined with pre-written forms and reports, this allowed for a whole new level of sales reporting that could be developed and changed rapidly. The couple of days previously spent typing VAT data (every 2 months) has now been replaced by a one-click report.

Workflow system completed for multinational company

Workflow system completed for multinational company

Simplify I.T. has just completed an internal SQL Server and PHP driven workflow system for a multinational company. This is to replace Lotus Notes. This complex new system, which runs on an internal server, is an authorisation system that sends emails to the relevant worldwide users asking them to review a request and accept or reject it. It contains a suite of reports and has different security levels.

Simplify I.T. creates an internal new product system

Simplify I.T. creates an internal new product system

Simplify I.T. has just completed an internal SQL Server and PHP driven product development system for a multinational company, to replace a Microsoft Access database which was a decade old. This complex new system, which runs on an internal server, facilitates the structured collection of product data from 30 users worldwide and combines it into one fixed format. This data is then entered onto the company’s ERP system. It contains a suite of reports, is multi-lingual, multi-timezone and has different security levels.

Bespoke system for Kavanagh Electrical

Bespoke system for Kavanagh Electrical

This project involved building a bespoke PHP system that could be accessed in the back office or by iPhone on the road. Its implementation resulted in huge time savings. The system itself allows new job sheets to be created by the electrician as soon as he finishes a callout. This appears in real-time in the back office allowing the owner to convert it to a PDF invoice and email it. It also provides job and invoice tracking and integrates into the existing and longstanding accounting software package (Big Red Book).

Simplify I.T. build a CRM for Orafol (Reflexite)

Simplify I.T. build a CRM for Orafol (Reflexite)

This project involved building Simplify I.T.’s first customer relationship management system (CRM) that allowed the Orafol staff, based throughout Europe, to input, manage and report on all their leads and customers (in real time) via a user-friendly CRM that we custom-designed. It also contains Microsoft Outlook calendar integration, allows newsletters to be built and analysed with open/click-through statistics and can be accessed on-the-road using a Smartphone.

Hardware & System for Waterford Crystal Sports & Leisure Centre

Hardware & System for Waterford Crystal Sports & Leisure Centre

The Waterford Crystal Sports & Leisure Centre project had numerous phases and demonstrates Simplify I.T.’s full variety of skills. Phase one involved setting up all the hardware in a client/server configuration as well as email. Phase two involved building a point-of-sale/membership system with barcode scanning, receipt printing and cash drawer functionality. Phase three required a clocking system while phase four involved the creation of the website with Facebook integration.