Here are some of the projects we have worked on...

 Commercial Business to Business Energy Supplier. Two major projects were undertaken; a data warehousing system supporting in excess of 200 million records and a data migration project. This was in addition to ad hoc support and maintenance on the customer’s Visual FoxPro v9 application. Between Mar 2008 and Aug 2011.

Data Warehousing Case Study... Initially taking over a Finance Data warehousing and reporting project designed to store data on an Oracle database, we re-factored the processing to do more processing on the Oracle server and significantly reduce the daily update processing time. On taking on the project, the batch update process was taking more than 5 hours on it’s daily run and expected to increase as record volumes increased. We learnt and wrote Oracle stored procedures to move processing to the server and reduced the batch process time to 3 hours which was not expected to increase with record volumes. We also worked with the client to produce data views to assist in their reporting requirements and consulted with them on the design of Crystal reports formats for extracting data. Using this system the client covered the cost of development in the first 3 months. Data Migration Case study... This data migration task of significant size moved data from DBF files and Oracle to SQL server. Foxclever undertook the role of producing a set of central controlling data tables from which many other processes sourced data. The project was essentially one of batch processing with an emphasis on speed; a tenth of a second saved on one record iteration could mean several hours saved in the overall migration process. The majority of coding was done in Visual FoxPro v9 accessing DBF or Oracle tables and creating intermediary, consolidated DBF tables which were then used to produce CSV files for bulk loading to SQL server. Some coding for migrating accounting data (from Sage) was done in SQL server stored procedures.

 Leading international antiquarian booksellers. Foxclever rewrote their FoxPro for Windows system in Visual FoxPro (VFP) v9.0 and using SQL server based data. Systems include; Customer Relationship management, stock recording & cataloguing and management reporting.

FoxPro for Windows Rewrite Case Study... Taking a well loved, well used, but ageing system originally written in 1993 using FoxPro for Windows 2.6, Foxclever rewrote the system using Visual FoxPro v9.0. At the same time the decision was taken to move the data from DBF files to SQL server. The aim of the rewrite was to produce a system that had a more modern look and feel, was easier to use with an improved flow of work and most importantly included new functions requested by the business. Importantly the data would be migrated from DBF files to Microsoft SQL Server to achieve greater data integrity, stability and to cater for an increasing data volume. A system specification was created for the new system outlining the requirements and design for each functional area. It was possible to keep the specification relatively brief as the existing system acted as a functional guide where the new system was not changing significantly. The specification was reviewed in detail with the customer and version 2 of the specification was produced, reviewed and approved a short time later. The first step taken was to analyse the existing data and produce a new structure in SQL server. Improvements were implemented in relational data form and additional fields included as required. Once this was complete, data migration programs were written to move the data from their old DBF home to the new SQL server database. Actual development progressed in functional business areas; customer management, stock management, ... Each area was developed and released in small working sections, demonstrated and given to the users for initial testing. Final development was followed by system testing in a number of scenarios. Data migration routines developed at the beginning was used many times through the development cycle and  allowed users to test using “real” data.

 Major provider of spray painting equipment, spare parts and training. Rewrote their FoxPro for DOS system in Visual FoxPro v9.0, using DBF data. System handles Sales Order processing, Customers, Purchase ordering, Stock control and Reporting.

 International provider of Library Management software & systems. FoxPro for DOS system rewritten in Visual FoxPro v9.0, using DBF data. System handles all aspects of a lending library, including managing members, items, loans, reservations and reporting. The new Visual FoxPro system is multi-lingual, multi-product (varying levels of features controlled by licence key) and includes an advanced ranked result search facility. Foxclever also provide consultancy on web site advertising campaigns.

 Specialist provider of term life insurance for private & business customers. Foxclever was subcontracted to provide specific support & additional management information utilities on systems in VFP 6 and using DBF & SQL server data.

 Large independent advertising and communications firm. Foxclever is subcontracted to provide support & development on a key VFP v5.0 application using DBF data.

 One of the leading Specialist insurance Adjusters in the UK. Extensive FoxPro for DOS system rewritten in VFP 7.0 and later upgraded to VFP 8.0. Foxclever played a major role in this multi-phased rewrite project, together with in-house IT staff. The system is used to manage all aspects of their business; tracking cases, time management and reporting. Also developed a web based management information system for use by staff and customers using West Wind Web Connection, SQL server data and VFP 8.

 UK based horse racing tipster. Foxclever provides support and minor development for FoxPro for DOS & VFP 9.0 systems. Also maintain their web site

 National wholesalers of field nursery supplies. System upgraded from VFP v3.0 to v7.0.

 International company providing underwater transducer services & technology. Provided consultancy on completion of VFP 9.0 production control and administration system.

 Commercial secure storage provider serving mainly the airline industry. Upgraded and provided modifications to VFP v5.0 system to VFP v9.0.

 Leading promotional gifts supplier for the Medical, Advertising and Travel industries. Foxclever is contracted to provide support services for their extensive VFP v8.0 systems.

 International supplier of parts & service for cranes, fork lift trucks & tractors. Foxclever provided support & development on FoxPro for Windows 2.6 system, used for sales & purchase ordering.