You are here: Home / Archives for Projects / SharePoint

UK Aspirin Survey supported by 2and7 Limited

January 23, 2012 By

Members of 2and7 Limited have recently delivered a form for testing for a UK wide census on the use of aspirin and clopidogrel in orthopedic surgery. The form was coded in Microsoft InfoPath 2010 and is implemented using the latest version of Microsoft’s SharePoint cloud solution, Office 365.

Although relatively simple, the form required the development of a number of bespoke rules to ensure that all required fields were completed and to hide/show form elements depending upon previous answers. 2and7 Limited also developed specialised workflows to undertake a number of post processing tasks once the forms were submitted and notifying the census leaders of the existence of new forms.

The final part of the equation will be collating the form results into a single Microsoft Excel 2010 spreadsheet for subsequent analysis as well as feeding the data into a back end Microsoft SQL Server database to provide the potential for a longitudinal study.

2and7 Limited are experts at the delivery of electronic data collection, records management and document management systems for all sizes of business.  Specialising in medical research and healthcare, our systems are scaleable to cope with any size of business using a mixture of hosted, on site and cloud hosted systems.

Share
Filed Under: Data Collection, SharePoint Tagged With: , , , ,

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: , ,

LMBRU launch new Extranet site using SharePoint 2007

December 21, 2009 By

We have been working closely with the Leeds Musculoskeletal Biomedical Research Unit (LMBRU) to create a number of internal and external facing web sites to support the implementation of their IS/IT strategy and to subsequently support their bid to become a biomedical research centre.

Based around Microsoft Office SharePoint Server 2007, the newly created Extranet site provides the facility to securely upload and share documents and information between collaborative partners; facilitating closer working relations and building a foundation upon which to build more complex data capture programmes.

The Extranet system provides dedicated sub sites for individual projects with the ability to upload documents via email, Windows Explorer as well as the typical Upload features of SharePoint 2007.  The system also makes use of SharePoint’s security trimming functionality to ensure that only authorised users are able to view a particular sub site by hiding any information, functions and documents to which the user does not have access.

In this way, users must know the exact URL of the collaboration site and have an authorised username and password before gaining entry.  Once successfully logged in, system auditing ensures that any unusual access is identified at an early stage and ensures the administrators can fine tune the security permissions where appropriate.

The system also allows anonymous access to the home page providing visitors with background information on the mission of the LMBRU along with links to a support wiki and various online training courses.

More information is available from the LMBRU Senior Business Systems Analyst.

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