This SharePoint feature allows you to quickly import data from a CSV file or a SQL stored procedure to any custom SharePoint list.

Once you have added the solution to your farm and activated it on your site collection an additional menu option will be available on the Action menu of each custom list that will take you to the import CSV or SQL page.

Simply select which option you want – either import from a CSV file or import from a SQL stored procedure. Next, browse to the CSV file or enter the SQL connection and name of the stored procedure and hit the Import button.

There is a check box option to delete all items from the list before doing the import which is not selected by default.

Click Here

This guidance helps healthcare organisations apply a chosen information architecture or taxonomy within a 2007 Office system environment. Microsoft Office SharePoint 2007 Information Architecture describes how to plan and design an information architecture and provides step-by-step instructions showing how to configure Microsoft® Office SharePoint® Server 2007 with these settings.

This guidance is suitable for use by healthcare organisations that currently:

- Have content stored in local drives and file shares
- Archive records manually
- Have a basic Web server with Web master-controlled publishing
- Have not yet deployed Office SharePoint Server 2007, or have recently deployed Office SharePoint Server 2007 and wish to plan a portal structure and information architecture

Solution Accelerator – Scorecards

This solution accelerator acts as a template for configuring a management dashboard to track organisational metrics. It contains four example dashboards ranging from a primary care practice to a healthcare organisation’s CEO dashboard with metrics based on the healthcare targets for 2008. The solution accelerator also includes online guidance explaining how to customise a dashboard for a healthcare organisation’s needs.

This solution accelerator is suitable for use by healthcare organisations that currently use :

- Static paper-based documents to track performance with manually-entered performance metrics

- Static, decentralized, and highly-IT dependent reports

- Standalone spreadsheet-based analysis

A recent study conducted by ioko for a typical NHS Trust indicated that over half the respondents found it difficult to find information and could not be sure they were using the latest version of the document. 32% indicated that they spent between 2 to 5 hours or more per week searching for information.

You do the maths !!