This isn't an exhaustive list of all the systems that we have written and installed but it will give you a good idea or the range of services we can offer...
The publicity department of the Foreign and Commonwealth Office needed to replace a non-Millennium compliant Unix system. The new system is required to keep the email address of all UK embassies and legations around the world. Whenever public domain documents become available or when ministers make statements, copies, summaries or details are fed into the system via a Word document. From within Word, the document is catalogued and put on a mailing list. Each mailing list can be a simple list or a list-of-lists. The system is written to ensure that only one copy of the document is sent to an email address even if the address appears more than once. After cataloguing, the document is dispatched to the far-flung corners of the Empire using Microsoft Outlook. About 20,000 emails are sent each month.
Database to distribute to agencies in order to track and process contracts. Teams of advisers around the country were cold calling on homes and flats and thousands of contracts were being signed. A coordinated approach was needed to ensure quality data, smooth data capture and transmission. An Access 97 database was written that enforced data integrity. At the end of the working day the database produced an Excel spreadsheet which was zipped and emailed to the data processing department. A bar code reader was used to scan the contract numbers, this produced remarkable accuracy in data input.
Database to hold details of employees, training history and their needs. It was important to ensure that classrooms, trainers and employees were not double booked. The booking procedure was interfaced with Lotus Notes to allow joining instructions to be sent by email to employees giving details and directions. A bespoke checklist was included for each course as well as the facility to book multi-day and multi-site courses.
Database to speed up the handling service calls and the associated paperwork. An Access 2000 database was written to interface with an existing system and to relay jobs to engineers who were equipped with a touch-screen laptop computer fitted with a Nokia card phone. After each job the engineer printed an invoice for the customer and then sent details of the job, spares, mileage and time spent back to base using the Vodafone short message service. The base-station then passed the details back to the main system. A team of 5 engineers have used it for six months. It was well received and has now entered the second phase of development [July 2001] plans are in hand to equip two more teams for further evaluation in areas with limited SMS cover.