Monday, 26 October 2009

Combining SharePoint and Web Content Management to manage web publishing, data capture and collaboration

We’re finding many organisations are adopting Microsoft SharePoint 2007 as their platform for managing documents, collaboration and processes.

As this adoption continues we’re seeing a growing requirement to ensure that other online services can integrate successfully with SharePoint.

We’ve recently been working with several clients to integrate web content management systems with SharePoint, enabling documents and list data to be viewed and manipulated within their wider website and extranet environments – The big payback here being the centralised management of extranet and website communication from within SharePoint.

It’s an interesting technology because it lets you combine the powerful document and list management capabilities of SharePoint with the excellent web publishing, standards compliance, site optimisation and interactive services provided by a good CMS – Useful if you don’t want to go to the development, infrastructure and license expense of delivering a full SharePoint environment to clients (or a particular group of employees).

We thought we’d share some of our experiences of how the SharePoint Connector for Alterian CMC (previously called Immediacy CMS) is being used and the value it can deliver, which you'll find interesting if you're currently using Alterian CMC and reviewing SharePoint, or are a SharePoint user interested extending SharePoint's reach out to your web and extranet sites.

Features overview

The main functionality provided by the SharePoint Connector for Alterian CMC is the ability to display and collect SharePoint lists data within your website, intranet or extranet environment.

The connector works in either live or disconnected mode to:
  • Export list data and documents from SharePoint and transfer them to your web environment
  • Transfer updated information from your web environment back to your SharePoint server and import it

Scenarios

Here are a few scenarios showing how we’ve used the technology:

1. Client extranet: Publishing, receiving and collaborating on documents

If you regularly collaborate or share documents with clients / partners outside your organisation you can manage this via a SharePoint document list exported to your extranet.

Thumbnail: SharePoint Document library extranet screenshot
Screenshot: An exported SharePoint document list within an extranet environment.

Document lists can be displayed on your website or extranet and, if you let them, clients can also upload new documents or download, amend and return documents to you.

You can then use the notification and workflow features within SharePoint to be informed of items needing attention and manage any workflows or processes associated with a document.

You can also associate comments or other information with a document by adding custom fields to the SharePoint document list.

2. Form data management

Submitted website forms can be placed directly into SharePoint making the information easier to manage, process and audit.

Thumbnail: SharePoint custom list extranet screenshot (registration form)
Screenshot: An example event registration form based on a SharePoint list.

Thumbnail: SharePoint custom list showing information from the website
Screenshot: Results come directly into SharePoint and can be filtered by their status and contain additional fields to allow for internal processing.

Completed forms often have internal processes associated with them which can be managed within SharePoint, e.g.
  • Lead processing: you can use SharePoint to manage the contact process for new leads coming in from the website.
  • Event registration: you can export a view of a registration list from SharePoint to your website for completion by web visitors. You then use additional internal fields in the list and SharePoint Workflow to manage your internal processes on the completed registration forms, such as tracking follow ups, sending confirmation letters and printing attendee badges.

Thumbnail: Example email merge using exported SharePoint data
Screenshot of an exported SharePoint list being used as the basis of an email merge in word

3. Client extranet / intranet: Providing information and status updates

If you work with clients in situations where you need to provide regular status or performance updates these can be exported directly from a SharePoint list.

For example: project status updates can be delivered to clients by exporting a custom view from a SharePoint task list across to your extranet.

4. Custom development: Extranet user management

The SharePoint Connector for Alterian CMC provides a development interface that enables us to develop additional functionality and integrate it with SharePoint.

Example: extranet user management – One of our clients operates a range of extranets for several different user groups. New groups are added on a regular basis. Approving access requests from new applicants was a complicated process because each extranet is managed by a different person.

Solution: We developed a .Net role provider for the extranet that utilised the SharePoint Connector to enable extranet user accounts to be managed via SharePoint.

Access requests from new users are automatically added to a custom SharePoint list, enabling SharePoint workflows to route approval requests depending on the specific group access requested by the registrant.

Thumbnail: SharePoint custom list storing extranet account information
Screenshot: Extranet user requests now come in to SharePoint for approval.

The biggest payback: streamlining website and extranet management

If your organisation has taken the strategic decision to use SharePoint internally then we're finding the biggest payback from a CMS based SharePoint Connector is coming in the form of streamlined site management. Managing your extranet becomes integrated into the flow of daily work processes, making it more straightforward to maintain larger extranets.

It will be interesting to see how the capabilities of SharePoint Connectors evolve, especially with the iminent arrival of SharePoint 2010.

Atlassian Mini Confluence for iPhone Review - Hands-on

I've just installed and set up Atlassian's Mini Confluence for iPhone, linking it up to our Confluence wiki install. It's available now in the Apple App Store for £2.99.

On first-run Mini Confluence prompts for a username and password, and the web address of your Confluence installation. You need to enable the Confluence Remote API in your confluence install before the app can connect, and I needed to set up a VPN connection on my iPhone before I could connect to our company Confluence install.

Once you've logged in you're taken to your dashboard which, in Mini-terms, means a list of the latest content changes. Don't think of this as a copy of your web-dashboard that you may have heavily customised; here Mini Confluence give you a simpler window onto the latest content updates.
Along the bottom of the app you have quick links to Dashboard, Spaces, People, and (most importantly) Search. 

Dashboard: List of latest content updates 

Spaces: A list of the spaces to which you have access 

People: A neat cork-board display with people's photos and names, along with a "Search people" box 

Search: A very familiar search interface.

If you've ever searched and typed something on an iPhone, you can't go wrong here!

The first thing to appreciate is that this is not a fully featured Confluence editing and management application; it is a window onto your wiki giving you access to information you need when you're on the move. It seems quite acceptable to not want to administer your Confluence installation through an iPhone, but some may question the omission of the ability to edit content. However when you consider that you are getting quick, easy access to all your wiki content whenever you have your phone in your pocket the issue of editing becomes less important. In the future it would be good to see even a wiki-markup-only editor for those determined enough to write significant amounts of content on an iPhone which, in itself, would not be a pleasant experience no matter how good the interface.

You can, however, view and post comments on any articles in the iPhone's portrait mode which is a welcome feature.

Search

This is the important bit! The big question is: can I find content quickly and read it easily? The pleasing answer to this question is yes. The search facility is implemented simply, works perfectly, and is easy to use. It appears that Atlassian has concentrated on the most important aspects of why someone would want to access their corporate wiki which are finding colleagues and finding content fast and without fuss. This being the first version of Mini Confluence, any other criticisms aimed at the new app have to be balanced against the fundamentally simple search and viewing functions.

Currently the search box is very static, requiring the user to submit the search before seeing results. A future improvement would be to have a more dynamic search which filters the search results as you type in the same way that the full version of Confluence shows you relevant pages before you've finished typing. The Wikipanion app is a good example of this search method in action which works well even when restricted by a standard phone network connection.


Navigating around content

As I've said above, the main method of navigating around content you'll use is the Search option. In many ways you're forced to use this option as the structural element of Confluence is a bit hit-and-miss inside Mini Confluence. For instance, you can browse to a space and see the list of all content within that space sorted alphabetically. If you have the {children} macro on a page to display it's child pages you can navigate using that. However there is no breadcrumb, or indication of where you are within the wiki's structure, and the {pagetree} macro does not appear to render at all. An odd choice given that it is such a commonly used macro.

The lack of a breadcrumb looks like a space issue: an iPhone just isn't big enough to display where you are within the app, as well as where you are within the wiki, especially given how long some of the page names can be within a Confluence installation. It's a shame that the Pagetree macro is not supported though.

Overall you'll be searching for content rather than navigating around content, and you'll be consuming content rather than editing it. Mini Confluence handles searching and consuming of content very well indeed and I've already been using it to check information while off-site.


Wish list

In the future I'd like to see multiple log-ins for those users who have more than one Confluence installation and, given that search is the fundamental way in which users are required to navigate content, a more interactive search system that offers suggestions as you type.

As it is, Mini Confluence is well worth the price of admission if you need to review and comment on your content while out of the office.

You can find out more about Mini Confluence here. Or purchase Mini Confluence in the Apple Store here.