You are here: Home / Archives for Projects / Application Development

Cardiovascular Research Data Collection System

April 9, 2011 By

2and7 Limited have been asked to support a new medical research project which is looking to improve the lifestyles and health of patients with cardiovascular disease (CVD). The system will support the electronic collection of data directly within the clinical consultation and the subsequent presentation of this discrete data in a longitudinal view thereby allowing the investigation of the individual patient disease pathway and wider condition development.

The system also provides a patient portal through which clinicians and patients recruited onto the study can share information and patients can keep an online exercise and dietary diary which will feed into the clinical information system.

There is also the potential to publish data back to the patient portal from the clinical information system to encourage self management and to allow patients to view the study data currently held about them.

The system will be delivered via a combination of Microsoft InfoPath, Microsoft SharePoint Server 2010, SQL Server 2008 and bespoke web site/web service development.

Share
Filed Under: Application Development, Projects, SharePoint, Web Site Development Tagged With: , ,

Stadium Entry System

April 9, 2011 By

2and7 Limited have recently completed a project to make amendments to an existing gate admissions system developed using Microsoft Visual Basic for the user interface and Microsoft Access as the database engine.

The system was no longer fit for purpose, as it was not possible to co-ordinate and share information across all entry gates, raising the possibility of using the same card to enter the ground on multiple occasions. The system was also unable to support any flexibility in season ticket subscriptions.

The first stage of the process was therefore to migrate the backend database onto Microsoft SQL Server Express, removing unnecessary fields and improving the performance of the database. The improved capabilities of SQL Server also provided a more robust database engine through which to co-ordinate all entry gates.

The next stage was to increase the functionality of the system to allow a number of credits to be associated with a particular season ticket record, thereby enabling special offers to be introduced and partial season tickets to be sold throughout the year thereby increasing revenue. There are plans to further enhance this aspect of the system by also allowing the system to differentiate between league and cup games to allow for league only season tickets to be sold.

The final improvements were to the administration and reporting systems. The administration console was improved to allow the management of credits plus the application used on the gates was also extended to show the number of credits left on the card. Finally, ODBC links were created to expose the underlying data to Microsoft Excel for analysis whilst formal reports were requested via SQL Server Reporting Services.

Further improvements in the pipeline include the aggregation of data into a formal customer relationship management application which will be provided under our SPLA licencing model, allowing the business to control their expenditure by only committing to licences on a monthly basis rather than having to purchase server and client access licences for all users.

Share
Filed Under: Application Development, Projects Tagged With: , ,

Bespoke application development

March 10, 2011 By

2and7 Limited have recently agreed a contract to re-develop an existing bespoke application to bring it back into line with current business needs. The existing application, written in Visual Basic, allowed season tickets to be scanned at the gates to ensure that they were still current and to ensure that each card could not be used twice for the same match.

Whilst this system has done stirling service, it could not support the new flexible season tickets which a particular sports club were looking to implement, nor did it integrate with existing business systems.

2and7 Limited have ported the application from Microsoft Access into the more robust Microsoft SQL Server 2008 and provided additional networking functionality to allow the main office and all entry gates to share data in real time. The system also introduces the notion of credits, whereby season tickets can be purchased for a number of games as well as for the season.

Future planned developments include advanced querying and integration with the customer management systems.

Share
Filed Under: Application Development, Press Releases, Projects Tagged With: , ,