SharePoint as a business applications framework

Introduction

We described previously that you should be viewing SharePoint as a ‘business applications’ framework, rather than just a piece of software that ‘handles your documents’ or as I once heard it called ‘it’s just an intranet application’!

Indeed, it provides an underlying application development and ‘hosting’ environment in which to provide a repository to store your organisations information. As the image opposite depicts, the forthcoming latest release of the platform (SharePoint 2010) is much more than a document repository; It’s a powerful framework for building and hosting powerful business applications, building communities and providing a rich repository for your organisations information.

It therefore provides an opportunity for applications to be bought, configured or developed within SharePoint in a way to solve many of your business challenges, improve efficiencies with the way your staff work together collaboratively and potentially reduce costs associated with your IT budgets.

SharePoint’s’ intrinsic strength is that it can provide a data repository (in the form content databases stored inside Microsoft SQL Server) for many of your business applications, (both existing and new ones being considered) reducing the need to invest in separate hardware, licensing and on-going support.

SharePoint applications

Generally speaking along with the usual applications SharePoint is used for, such as an intranet, extranet and internet web facing sites, it can also be considered for the following, to name but a few vertical and horizontal business applications:

• Project and programme management applications
• Marketing campaign applications
• Product catalogues
• Discussion forums
• Research applications
• Reporting workspaces
• Document imaging application (using scanners)
• Training and self-help portals
• *List based application (client contacts and knowledge management applications for example)
• *Workflow based applications
• *Forms based data entry applications.

*Any application that is likely to involve creating or updating ‘multiple or single lists’ of data may also need to have a search or filtering mechanism applied. Many existing Lotus Notes or other so called complex applications are based on these three types in one form or another and hence should be considered for migration across into SharePoint.

Applications being provided by existing bespoke ‘client server’ based architectures may also be hosted within your SharePoint environment. Granted, some level of compromise is often needed, but it’s at the very least worth investigating with your stakeholders as to whether there would be advantages in migrating these applications and making them more accessible and arguably reducing your overall costs in the long run by the use of ‘shared services’ provided by SharePoint.

Which is why when looking for specific or custom applications to fulfil a particular set of business requirements, it’s worth looking to your existing investment in SharePoint to see if this can be extended to provide the functionality you need. Or indeed consider using SharePoint as your unified underlying platform for introducing several applications you may be considering implementing independently of each other.

Real world examples

Example 1:

An example of this can be seen with the combining of existing document imaging solutions within your SharePoint framework. Your existing print & scanner equipment can be used to capture, store their content (typically tiff or pdf files) into your SharePoint environment. These in turn can automatically tagged with metadata, indexed and provisioned via a searchable or filtered interface making it available for a wider audience, using workflow, etc. Such a real world example of integrating the technologies would be the scanning of customer correspondences, incoming mail or other ad-hoc scanning requirements. This reuse of your investment in both scanning and SharePoint is good example of combining complementary technologies”

Example 2:

Another example would be that of porting your Lotus Notes applications into your SharePoint intranet. Many so called ‘Notes applications’ are actually just lists of information stored in Notes. These can be migrated and sit perfectly well within the comparable feature set in SharePoint. That said, don’t underestimate the challenges when it comes to “document migration” from Notes, as it’s notoriously difficult, especially with often complex workflows to migrate. There are 3rd party products available to help here, such as AvePoint, Mainsoft and Quest.

Ideally your original SharePoint architecture should have considered the need to provide additional applications and been built accordingly to handle such change. If it didn’t, then you need to carry out a full review and plan the architectural changes required to accommodate them – Do not under estimate the issues here and research this area thoroughly, as it could lead to additional overarching architectural changes, hardware and or software purchases.

Conclusion

So in summary, SharePoint is much more than a document repository; it’s a powerful framework for building and hosting powerful business applications that will help your staff manage their information better and more efficiently, helping your business to achieve its strategic goals. So whether its 2003, 2007 or even the soon to be launched 2010 version of SharePoint, plan the deployment or changes well in advanced so that it supports your business needs in the future.

Regards,

Andrew Walmsley

Director, WorkShares

---

Keep your SharePoint and IT strategy in sync

SharePoint has matured in recent years to become pretty good at being an ‘all things to all people’ platform, or as I would prefer to refer to it as a ‘business applications’ framework.

The introduction in SharePoint 2003 of ‘Windows SharePoint Services (WSS), licensed as part of the Windows Server 2003 operating system as a ‘free’ download, was also a clear master stroke of licensing by Microsoft.

WSS provides arguably a good, robust and rich set of all be it simple document management services that would serve many small, medium and to some extent large enterprise businesses well on its own. Indeed this is where many businesses started off in the deployment of the earlier versions of the software, without really knowing what they were getting themselves involved with.

“SharePoint 2010 will continue to provide a compelling ‘one size fits all’ approach with its attractive feature set that cuts across both intranet, extranet and internet boundaries”

This ‘all things to all people’ theme is set to continue with the next release, SharePoint 2010. Earmarked for a spring time release, it will continue to provide services and functionality that will meet in my view, a large portion of an organisation’s generic solution application needs very well, though other more specific requirements clearly not so.

Like its predecessor in SharePoint 2007, the next version (called SharePoint 2010) will provide a compelling ‘one size fits all’ approach with its attractive feature set that cuts across both intranet, extranet and internet boundaries. Not forgetting with this release is a persuasive, if immature, Microsoft Online ‘cloud based’ service offering, which is being updated on the back of their initial launch in 2009.

However, the ‘all things to all people’ statement has from time to time been its ‘Achilles heel’ in that it doesn’t do one function as well as customers expect or potentially need; Such as document management, records management, wiki’s, blogs, workflow and web content management, etc. Arguably these and SharePoint’s other core features have a raft of competitor products that if used independently, are far better.

But it’s important to remember that SharePoint was not and will not be able to win in such side by side comparisons. Nor is it designed to compete in respect of ‘vertical’ based business applications or other specialist ‘line of business’ application software. A point often lost in the discussions and selection process undertaken with choosing an IT solution to meet your needs.

“SharePoint is, if it isn’t already, part of those building blocks“

To avoid these scenarios and ensure SharePoint is considered in the correct context, it’s important your strategy for its introduction, adoption and management is agreed and understood not just by those in charge of implementation and support, but by all senior stakeholders responsible for IT service delivery.

Furthermore I would advocate keeping this and overall IT strategy in sync. Why? Because more often than not your organisation will be using a growing mix of IT applications, hardware and software, and accumulated a range of skills and experience that your core staff retain and maintain as part of their role.

Hence your IT function has a vested interest in managing the associated costs with this heterogeneous environment. In addition there is, or rather should be a growing desire to simplify, be more responsive and introduce operational and strategic ‘building blocks’, which can aid the business achieve it strategic goals. SharePoint is if it isn’t already part of those building blocks. Even if it is used tactically now as a ‘point solution’ for a particular function like an intranet, SharePoint’s breadth of capabilities arguably demands for it to be considered in the wider context of your strategic building blocks.

In my next article I will write more on why it is the introduction of SharePoint technologies into your IT strategy is important and how you can further extend the investment you have made in SharePoint 2007 or are about to make perhaps in SharePoint 2010 later this year.

Regards,

Andrew Walmsley

Managing Director

---

Interested in SharePoint 2010?

I have had the privilege (and retain many scars!) of having worked with SharePoint since it’s first launch in 2001 and have seen successive updates to the platform over the years, as well as witness the growing adoption by businesses as one of the key ‘building blocks’ of technology being implemented to deliver both strategic and operational IT goals.

As the following blog posts depict (post 1 and post 1)  this has been in my view mostly ‘evolution’ through the years in terms of product platform functionality and architecture.

It has furthermore seen massive interest and investment year-on-year, not least with the latest planned release of the product called SharePoint 2010. More details on this here of the planned updates: SharePoint Sneak Peak

What has surprised me to some extent, is the level of interest and availability of courses, events and other such materials on ‘how to install’, ‘key design decisions to consider’, etc. And this is even before the product has been release in beta to general public! This certainly was not available for the previous versions to any great depth.

This is a good sign of a healthy supporting community and of Microsoft, whom are providing much more in the way of information and up front guidance on their future roadmap considerations for this and its other technologies.

Lets hope the momentum continues for when it does launch next year. Such a vibrant community and help from Microsoft, helps us all ‘come up to speed’ with the new technology and allows us to be better prepared for the challenges it will no doubt provide. This benefits everyone as it also allows Microsoft partners, like WorkShares, to provide timely advice and guidance around strategic decision making companies are having to make for the future investments in 2010 and beyond.

Regards,

Andrew

Managing Director

 

---

Michael Deller joins WorkShares

We are pleased to announce that Michael Deller has joined WorkShares. He has joined as our Technical Director and will continue in his capacity as a seasoned SharePoint consultant and architect, amongst his other roles for WorkShares.

With over 6 years experience of working with SharePoint technologies with some of the UK’s leading Microsoft partners in this space, Michael brings with him a wealth of experience and knowledge unrivalled in this field.

Michael has worked with some of the most high profile SharePoint projects and has cross industry experience including public sector, not for profit, utilities and education.

Michael’s background prior to the SharePoint and Information Worker arena follows several years within the Microsoft client / server infrastructure field with a strong background in infrastructure, messaging and troubleshooting.

Michael’s appointment will bolster our senior management team and overall delivery capability. His recent attendance to the launch of Microsoft’s latest update to the platform (SharePoint 2010) at the conference in Vegas, will bring much needed ‘heads up’ on the implications, challenges and opportunities for existing or new users of SharePoint technology.

Having worked with Michael for several years on numerous SharePoint projects, I am very pleased to secure his services and look forward to his valuable contributions for WorkShares with our existing and future clients.

Regards,

Andrew

Managing Director, WorkShares.

 

---

Document migration in SharePoint: Considerations

Background

I mentioned in my last post entitled “Document Migration in SharePoint – Your options”, that there are basically 4 main options available to you when deciding whether to migrate content from your file shares and other repositories. To summarise:

• Migrate completely into SharePoint
• *Partial migration of a subset of the content into SharePoint
• **Leave where it is and continue to maintain both repositories independently
• ***Leave where it is and continue to maintain both repositories, but use SharePoint to index your old content, hence providing capability to search it.

One or more of these options may be the route you end up choosing depending on your needs and requirements.

*The older content may well be archived or just deleted.

**Consider the expense and risk here maintaining ageing equipment

***This has limited options, investigate thoroughly and test in particular the search results, hence use with caution.

Next steps and considerations

To help you through this decision process to determine which route is best for your circumstances, I have below written a few pointers for you to consider and debate within your core project team and stakeholders alike. These comments are based on several years of managing a variety of SharePoint projects, so hopefully you will avoid some of the painful lessons learnt that we and our clients went through! It’s probably not everything you need to think of, but a good start with a few thoughts to help you along your way.

“Migration can be expensive especially when you consider the volume of information you are intending to migrate, the true cost of the business and technical resources (internal and external) you intend to schedule in to help with the migration effort”

Question your stakeholders & senior users as to whether or not they really do need to move across all those documents and intranet pages, images, video, etc. Based to some degree on anecdotal and empirical, my experience shows time and time again, 80-90% of content is seldom if at all accessed beyond 12-18 months after it was created. So you could be creating a mountain of work, for very little return in value.

I therefore recommend trying to find supporting evidence to confirm it is (or isn’t) accessed frequently or other statements supporting or otherwise the migration requirement. Find out why it actually ‘needs to be migrated’, almost like putting together a mini business case decision process. Often business units will just say it is, to avoid doing the work of investigation or migration in the first place because they have other (naturally so) priorities. The reality is a good old clear out is often a welcome and good opportunity to freshen the content up, archive older elements of content not longer required.

I also strongly recommend you carry out a review of the content that has been amassed over the years. You may be surprised to find out how much of it really is no longer needed, relevant or appropriate and or actually identify content that needs to be refreshed anyway.

Remember also there is a subtle, but important difference between it being ‘available’ to the business and it being migrated and available in SharePoint. For example, you may keep it away from SharePoint in less available, but still accessible offline media or other perhaps cheaper forms of storage.

If you do determine that you will have a large amount of content to migrate, really do put in place a ‘blueprint’ for the migration team(s) you mobilise, make sure everyone is aware of their roles, their tasks and when they are supposed to be doing them and why. They in short need to be fully on board with what is being done.

You also need to ‘prove the process works in advance of proving the throughput’ for your migration teams. This goes for the manual, automated or mixture of both approaches. Be generous in your estimates for migration based on the results of your findings. This will give your stakeholders confidence in your project teams ability to meet the migration deadlines.

“Impact on overall SharePoint architecture needs to be planned into the overall design”

Hopefully you will have covered some or most of this in your original SharePoint architecture planning…Think about the increase in load on your physical server environment, capacity planning issues, impact on search results, overall navigation and usefulness of your content, to name but a few areas that need thought and evaluation when considering migrating existing content into SharePoint.

For example, if you’re going to move and or index any of the externally stored content into your SharePoint environment, consider the implication for the increase in storage you are about to place on your environment. Not least because the increase in size isn’t just for the raw data storage of content being added in your SQL databases, but also the new storage required to handle the increased index file sizes.

Then consider the additional load you have just placed on your backup & restore processes! You might bring potential pressure on your ability to meet your SLAs for service availability in case of downtime. For example can you still restore your newly increased content databases in the time allowed within the SLAs?

“Evaluate 3rd party tools to help you with the volume of data”

Many 3rd party products do a great job in helping you bulk migrate/upload content into your SharePoint environment. However, many will not meet your requirements fully, so review them carefully and plan their performance (or lack of) with migration and costs into your plans and budgets. It’s important to know their limitations as well as their strengths. You may find they migrate many, but not all of your document types. Also, quite often you will lose some important document properties or other meta data associated with the document or pages you are trying to migrate.

In addition you may lose data integrity for example the timestamp information. This is typically something that may be important from a records management perspective, as it may not be carried across to the new environment.

“Ensure you get the business to take the lead in migration”

By all means provide the blueprint (approach), tools and methods in which ensure content can be migrated. Ultimately however the business users should ‘own’ the actual migration and be fully involved in this part of the project from the beginning. They are best placed to know what content is or isn’t required, how it should look, be accessed, etc. It also happens to be one of the best methods to educate your end users in the use of SharePoint capabilities you are providing to them overall.

“Consider regulatory obligations to retain data”

Several business sectors in particular the government/public sector, finance, health and charities have particular regulatory rules they have to follow for data retention, availability and access (data protection issues as a whole). These will need to be factored into your plans.

“Disinvest and or reuse your old hardware”

The migration from old intranets, file shares or other applications potentially allows you to disinvest your hardware (or at least some of it).Plan for this effort, even if it just find out how are you are going to recycle the kit or have it removed from the server rooms. Do consider charitable organisations or schools that might benefit from the old equipment rather than dumping it in landfill.

“Remember, not all data should or can be stored in SharePoint”

It is true SharePoint can index a variety of content sources. But the painful reality is this rarely achieves the results originally desired, due in part not because of product failures per se, but because the general maintenance of SharePoint based searches take a lot of ongoing effort that is often forgotten or omitted in the design or on-going maintenance.

Quite often it’s the easy route to index your ageing and bulging file shares, but would you really want your search results to contain information from sources that is so old and out of date? Without the careful design at the beginning, fine tuning and regular maintenance required often you end up with a poor experience from a user perspective.

So by all means consider indexing your sources, but really do understand the implications from a design, planning and ongoing maintenance perspective not least the users experience with the search results pages. On the latter note, consider all of the out of the box options that you have with search and also introducing filtering for your search results content (custom or 3rd party route).

“Consider leaving the content where it is”

Try to understand both the tangible and intangible benefits of leaving the content in situ, and perhaps making the content ‘read only’ for a period of time whilst you consider your options and or carry out your migration, so as to not allow the increase, or changing of content stored in this area.

Conclusion

There are lots of things to consider as part of your discussions for deciding the approach to migration and the above are just some of the topics you may have to consider.

It’s often politically the ‘path of least resistance’ to just migrate all content, irrespective of the technical and sometimes the financial rational for doing something different. If you haven’t already, consider introducing archiving, quota and retention policies to manage the no doubt increasing volume of data in your environments.

Do engage with your stakeholders and get their buy-in to owning the migration piece. Often a strategy of making sure the business carries out this migration will make them think differently when it is their resources that are taken off their normal roles to do it.

Finally, in my experience migrating and refreshing a small subset of the original content into SharePoint, plus archiving the rest is the appropriate approach for most circumstances. Turning on SharePoint indexing capabilities for your file shares, but only in small and measured circumstances is also something you should consider.

Regards,

Andrew Walmsley

Director, WorkShares

---

Document migration in SharePoint: Your options

Overview

As I mentioned in my last post there are a number of in-built tools and other options to help you migrate your content into and around your SharePoint environments.

“SharePoint is the natural replacement for your ageing file shares and other data repositories”

The very real and important question arises over what to do with your historical data stored in these repositories such as file and network shares, intranets and other silos. It certainly will not be a total replacement for your file/network shares.

That said, this and the next article I plan to write intends to provide you with the main options open to you, as well as some useful pointers from the experiences we have gained over the years with working with clients large and small to deliver intranet, internet, extranets and other point solutions based on Microsoft SharePoint technologies.

The Options

You basically have the following choices to carefully consider, each one will have implications that will be different depending on your needs and circumstances:

• Migrate completely into SharePoint
• Partial migration of a subset of the content into SharePoint
• Leave where it is and continue to maintain both repositories
• Leave where it is and continue to maintain both repositories AND use SharePoint to index your old content, hence providing capability to search it.

Each one has pro’s and con’s, which you will need to way up in order to make a decision that is right for you. In the end one of more of the above may be appropriate for your needs, but as per previous blog posts ensure you budget and plan accordingly as I will guarantee it will take your longer that you think!

I will write a few more pointers for you to consider in those deliberations with your stakeholders and clients alike in the next post.

Regards,

Andrew Walmsley

Director, WorkShares.

---

Migrate or move content inside SharePoint

Introduction

Migration is always a thorny topic that comes up on a project at the beginning in terms of scoping a project,  towards the end during rollout or adoption phases, or once the project is closed and users are left on their own. The activity of migrating or moving data into or between team sites, mysites, or from network drives and systems like Notes can be considerable.

There is however unfortunately no one answer to meet all types of scenarios and by enlarge I recommend businesses consider strongly the need to migrate in the first place from a bulk migration perspective. Consider if it is practical and possible leave where it is and or use it as an exercise in ‘cleansing’ your data before migrating or indeed moving it into SharePoint or possibly cheaper storage mediums. More on this topic in a future article.

For this article I want to provide some guidance to end users and their options. I frequently come across end users from both former or current clients asking me on how best to approach the moving content from one site to another or how to move a whole team site (sub sites included) from one location to another or even content from network drives during a migration or adoption phase. There are a whole range of scenarios and methods/tools here, but hopefully I will be able to provide you with some options to help educate and set you on the right path.

Firstly, to set your expectations right from the start…any migration into or around SharePoint is not easily achieved, especially using out of the box methods and requires quite a few manual steps. This is mainly because of how we typically store our team site content (in lots of what are called site collections – top level sites typically), which are in turn stored inside SQL databases. But also as a result of lack of support in general in the user interface within SharePoint to provide the necessary control and mechanisms to allow the copying or moving of content. This is probably why there are lots of 3rd party tools out there to help you.

In any case, make sure you plan carefully your site design and naming conventions to avoid such a need to move your content later!

Glossary of Terms

A few pointers firstly on terminology before we continue:

• Site Collection – Top most repository and security boundary for the storage and management of content. SharePoint can contain many hundreds or even thousands of these in a deployment. Top level team sites are often site collections.

• Team site – A top level site that is created at the very beginning to store and or share content. Typically a site collection can contain many tens of thousands of team sites and or sub-team sites in one site collection each containing many hundreds of thousands of documents or greater if structure properly.

• Sub-site – Are basically team sites that sit under the top level site in a site collection and have been created by users to store further content away from the top level site. They have more or less the same functionality, but are/can be considered ‘children’ of the top site and will likely but may not necessarily inherit permissions and can link between each other, etc

• Content – Any Office documents, PDFs, images, discussion lists, calendars, contact lists, or text that you have stored in your site.

• List – Calendars, contacts lists, document libraries, discussion boards are all examples of ‘SharePoint lists’ and can contain a mixture of content items.

Methods & Tools

The following are some real world end user driven methods and tools in which to consider for your content migration into and of team sites in the main, but also will work for mysites, and publishing content.

1. Creation of site ‘templates’

For any team site that you have content in, there is an ability to save the entire site, its document libraries, meta data and content (up to a size of 1O megabyte only) as a re-usable template. This now becomes a portable site template to re-use on other sites. With this you can now create repeatable sites that contain the same structure and or content.

To do this, under the Site Setting you will find a feature called ‘Save Site as Template’. This will allow you to save just the structure AND OR the content as well – Though because its limited to a maximum of 10 megabytes in size. It’s not ideal and will depend on the size of your content as to its relevance or not as a tool for you to use.

Once you have saved the site as a template, (give it a familiar name) you can go under Site Settings to your ‘Site template gallery’. Your newly saved site template will be there. Now, this can be downloaded to your desktop, (“sitetemplatename.stp”) and basically uploaded in to your new site into the destination ‘site template gallery’.

What happens now is that when you go to your new site and attempt to create a new site,  the template will appear an ‘Custom’ tab option on the ‘select a template page. Hence its important to call it something familiar on the previous steps! Once this is chosen, your new sub-site (and content if you ticked this option) will be there in the new site!

Pro’s

• Quick and easy method to get small sub-sites migrate from one location to another
• Useful for creating different site templates for different audiences/needs
• Maintains branding/look and feel
• No admin or code deployment required
• End user friendly.

Con’s

• Cannot be used for creating top level sites (unless uploaded to centrally ‘master gallery’.
• Loses security permissions
• Loses item level security
• Limited to 10M in size
• Does not save sub-sites as part of the site, only that one site

2. Creation of list ‘templates’

Basically for each list or library you have created on your site (this means any calendar, document library, contacts list, or other generic list) you can actually save each individual list including any additional columns you have created inside AND documents/content inside them, as a reusable ‘list template’. As with ‘Save as a site template’ mentioned previously, this now becomes a portable list template to re-use on other sites.

To do this, under the list or document library settings, you will find a feature called ‘Save as template’. This will allow you to save just the structure AND OR the content as well – Though again it’s limited I to a maximum of 10 megabytes in size, so not ideal and will depend on the size of your content as to its relevance or not as a tool for you to use. At the very least you can get the list structure, then maybe use Option 3 below to bulk move your content.

Once you have saved the list/content as a template, (give it a familiar name) you can go under Site Settings to your ‘List template gallery’. Your newly saved list template will be there. Now, this can be downloaded to your desktop, (“listtemplatename.stp”) and basically uploaded in to your new site into the destination ‘list template gallery’.

When you go to your new site and attempt to create a new list or library,  the template will appear an option in which to create from – hence as before, call it something familiar. Once this is done, your new structure (and or content if you ticked this option) will be there in the new site!

Basically repeat this process for all your other libraries or lists until you have copied your content across to your new site.

Pro’s

• Quick and easy way to move/copy list based content and structure including meta data
• No admin or code deployment required
• End user friendly

Con’s

• Resource intensive
• Loses security permissions
• Lose item level security
• Limited to 10M in size

3. Explorer view ‘quick and dirty -  copy, cut and paste’

This method only works for document libraries or picture libraries. Basically if you open up your picture or document library using ‘explorer view’, (Choose Actions, Open in Windows Explorer) then do the same in your destination library, you end up with two explorer windows. Make sure you can see these side by side. You can manually select all your documents, copy/paste from one location to another or drag and drop in the same manner.

This is particularly useful for moving data from network drives (but is very very slow!) or other areas that support a protocol called Webdav.

Note: Any meta data won’t be copied and you lose time stamp and other original owner details. DO NOT move or copy the ‘Forms’ folder! This is a systems folder needed by SharePoint.

Pro’s

• Quick and easy way to move/copy content between libraries
• No admin or code deployment required
• End user friendly

Con’s

• Resource intensive
• Slow moving lots of content
• Need to setup security permissions again on destination library
• Ignores any metadata you have setup!

4. Export to Excel

As you might expect, this is only useful for lists (not document libraries).

On any given list you have the option to ‘export to excel’ or ‘export and link to excel’. This can be used to provide an export into excel, then save/re-import back into another list.

Note: This can be quite painful as your origin/destination lists need to have the EXACT columns and metadata setup. Otherwise it will through up lots, (read huge!) amounts of data integrity errors that you will need to work through. Not recommended for the faint hearted, but does work, with limitations.

Pro’s

• Quick and easy way to move/copy content between lists
• Good for limited offline working
• Good for large lists (Better use Access for lists with thousands of entries)
• No admin or code deployment required
• End user friendly

Con’s

• Limited to one list at a time
• Not very robust
• Potentially resource intensive when uploading new data
• Need to setup security permissions again on destination library

5. Third party tools and server side tools

There are a mass of third party tools out there and too many to mention specifically on here. Ultimately many do however require a level of access (read server level permissions or server side code updates) you might not be allowed to have, so be aware of this ‘show stopper’ before you go out and buy something from Bamboo, Quest, Metalogix, Kwizcom or some other freeware on the internet! And before you go ahead and install a 3rd party product, read this article I wrote a while back.

For large migrations of data, the above methods 1-4 are simply not scalable and hence such products will be needed to make migration that much easier to manage.

Be aware however that some products may sound cheap, easy to install but can wreak havoc on your precious data and platform. I have come across many 3rd party web parts (free and chargeable) that have caused the project more problems, so caution should be taken. Areas such as not respecting origin and destination metadata, preserving file time/author stamp details and in general just overall robustness and performance issues are the main areas I have found to be areas in most need of improvement.

There are in addition some server side tools (basically command line tools) which are available to copy/move content between site collections (and different databases which the site collections are often stored within if need be). These are only for use by your system admins however, but can/should be consulted if you have a particularly large amount of content that you need to move from one site to another.

Conclusion

If your site has relatively very little content, its often quicker/easier to manually re-create the data or site you need to move, rather than actually move it using the above methods

For individual migrations its worth try the above options to gain an understanding of what you can do without purchasing 3rd party products or deploying server side code. Though the above examples are not ‘bullet’ proof or without limitations so do experiment and try before you settle on the one that will work for you.

There are a lot of 3rd party tools out there that can and do help. But as with any software purchase don’t load it on our production environment without first demonstrating it is fit for purpose. I’ll write some more soon on the topic of migration in general, so watch this space!

Regards,

Andrew Walmsley

---

Did you achieve your SharePoint ROI (Return on Investment)?

The ‘solid’ business case for SharePoint

When was the last time you read a business case which contained tangible (specifically financial) cost savings for recommending Microsoft SharePoint to be deployed into your organisation?

If you’re one of the few that I have come across, I often wonder just how well the numbers ‘stack up’ both when they were written in terms of the criteria used and how they have fared since it was deployed?

I am sure many were ‘successful’, even if the financial statistics were not available to support this statement, as often its not just about the financials and can be more about introducing a change a way of working, i.e. collaboratively as opposed to in ‘working in silos’.

Even so, over the last couple of years of working with the latest version of SharePoint with our existing (and new) customers, whereby we have returned to carry out additional work or for new consultancy pieces of some kind, I often enquire how the original business case was first of all agreed and secondly, (if one was produced!) how the deployment has lived up to it’s original goals.

Predictably, it’s a mixed response but overall business cases are increasingly being used, (which is a good thing) but rarely do they in my opinion, consider the long term financial savings nor are they revisited to confirm expected financial savings were achieved.

How well did the deployment go?

So did the deployment meet or exceed original financial savings?

Are the executive, steering group or IT dept. who signed off on the project happy with the financial cost savings or delivery in general? I suspect quite a few responses would be not so positive, decisive or along the lines of ‘could have gone better’.

Depending on whom you spoke to in the business the reasons for this would typically fall into the following statements:

• ‘No estimate of financial cost savings were produced in the beginning, so I can’t say whether it saved us money or not’
• ‘Bad advice from our SharePoint partner led us into a ‘square peg, round hole’ scenario, i.e. They decided to force (read bespoke code!) the hell out of the platform into something it just wasn’t meant or designed to do and hence costs more than we budgeted for’
• ‘It was deployed but it did not have stakeholder support, proper governance or adoption plans and hence wasn’t really used by the business and so stagnated’
• ‘The project was managed poorly by IT, ran over budget, took a lot longer than they said it would. Any identified cost savings has been lost getting it delivered’
• ‘The new intranet was deployed, but I was offered no training or support and I can’t find anything I need so rarely use it. There was nothing wrong with the previous application…’

Etc, etc…

As I posted a couple of years ago with my “Microsoft ROI Calculator for Windows SharePoint Services”, there are some useful resources out there to help, but these tend to be a bit of a ‘black art’ and should in my view be used with caution. There’s one also from HP and others, but my thoughts on these are that it’s a bit overkill in its recommendations, (perhaps to sell more hardware…?!) though useful I think for the wider awareness you need when carrying out such capacity and performance planning activity.

Why some SharePoint business cases often miss a trick

Most business cases I have read consider typical issues such as costs of maintaining existing application that are ‘not fit for purpose, together with potential replacement application costs for licensing and hardware costs. Fine.

But rarely do they consider the financial savings of delivering additional applications on top of SharePoint beyond what they were originally introduced for (typically your intranet/extranet scenarios).

Not so easy to put down on paper in terms of financial savings, as such applications may not even be known about or requirements scoped in enough detail to make an informed decision. But nevertheless such a statement should be in your business case as a strong ‘intangible’ business benefit and support your strategic reasons for using SharePoint.

SharePoint 2010 is just around the corner…

The simple fact is SharePoint 2007 is already a good platform for delivering  applications upon. SharePoint 2010 isn’t so far away and first signs are that it will build upon its success with the current version and become a great platform in which to host applications upon.

Whilst SharePoint may not be optimised for heavy transactional based applications, very few of your line of business applications (small, medium and large) will be of this kind anyway. Think about your existing applications (or planned) that provide your users with product catalogues, knowledge base applications, record management, document imaging repositories and consider them for inclusion into your SharePoint environment. Such additions will bring yet more value to the original (or new) business case.

Organisations must not miss this opportunity to bolster their business cases for SharePoint 2010 adoption, by looking at their ‘line of business applications’ they were considering introducing or replacing legacy applications, to see if they can realistically be ‘consumed’ by the SharePoint environment. I think you will be pleasantly surprised just how many can.

Important Note: Its imperative those doing so now with SharePoint 2007 or in future with SharePoint 2010 factor such things into their high level architecture designs. Most architecture designs I have come across fail to consider such requirements or plan for their inclusion. Introducing such things later will potentially cost you in redesign of your design in particular capacity or performance related areas.

With SharePoint 2007 available now and the soon to be released SharePoint 2010, it’s even more critical to  increasingly view the strategic nature of your decisions and how operationally you can derive more value out of your investment in SharePoint platform.

Regards,

Andrew Walmsley

Director, WorkShares

Update June 15th 2010

A report commissioned by Microsoft from Forrester provides useful insight into the potential value in deploying Microsoft SharePoint 2010. The report can be found here and highlights several supporting statements others will find useful when putting together your business case for deploying the latest version of Microsoft SharePoint.

---

Microsoft BPOS – Business Productivity Online Standard – First Thoughts.

Background

We were experiencing some issues with our hosted email provider through 2008 and were looking to move away from them at some point this year.

Together with our own business strategy of providing hosted solutions we were keen to continue ‘consuming our own food’ so to speak. Hence we were on the look out for a smaller number of service providers for our core service of email, conferencing, collaboration and instant messenger/presence.

Having signed up as a partner of Microsoft Online late last year, we also felt we needed to experience first hand what some of our future clients would go through and decided to move to Microsoft Online service when it became more widely available.

Microsoft Online – http://www.microsoft.com/online/solutions

We moved our organisations email services to the recently launched Online Services offering. There are several services available including:

• Dynamics CRM – Customer relationship management

• Office Live Meeting –Conferencing/live online meetings

• Exchange Hosted Services – Virus software protection, encryption and filtering for Exchange

• Exchange Online – Exchange email, calendars and contacts

• SharePoint Online – SharePoint (Windows SharePoint Services v3)

• IM & Presence – Office communication for instant messaging and presence

• Business Productivity Online Standard Suite (BPOS) – encompasses Exchange Online, SharePoint Online, IM & Presence and Office Live Meeting services ‘all in one’ package.

All of the above have been available predominantly in the US during last year and are now in UK and other parts of the world. There are also dedicated offerings for the larger customers available whom wish to move perhaps their ‘on premise’ solutions into the cloud.

We opted for the “Business Productivity Online Standard Suite” over a month ago now and though we didn’t replace all our services in one go, it nevertheless provided us with a useful insight into the challenges presented to businesses when moving from either ‘on premise’ or existing hosted service.

At this stage we have only moved our email and live meeting services over – though arguably our most critical application and service, (email) we felt comfortable with doing so based upon research with other beta users, demo’s I had seen plus existing experience in general with hosted exchange providers.

In addition to email and live meeting we were was also provided with these additional services as part of the package.

• Exchange Storage of 100gb (for all mailboxes)

• SharePoint – 5GB of Windows SharePoint Services

• Live Meeting Office Communications. 

Migration and Setup

So far so good. As you can see from the screenshots below, once you have the service up and running, the administration console is a clean intuitive interface with various options presented in tab like format.

The migrating and setup of the Outlook 2007 client was fairly straight forward, though migration from hosted email provider isn’t particularly well catered for in terms of migration tools. This is to be expected I guess as there are so many configuration options here and many would need the server level access, ISP’s wouldn’t be willing to provide.

Not the same however for your ‘on premise’ based solutions it has to be noted, as Microsoft has provided several options in this arena for you to consider as part of your migration planning. As you can see from the image below, we have several options to consider and plan for.

Once you’re email has been migrated you have access to your email either from your Outlook 2007 client. In addition you can access to your mail via the web browser in ‘Outlook Web Access’ shown below, which is great way to access your emails on customer or client sites.

Single Sign On

The Single Sign On application provided is a neat piece of software and very easy to use giving the user a single console like interface in which to launch their applications.

 

 

 

 

 

 

 

User Portal

The single sign on application will take you to your personal user portal. You get a number of different screens within your administration center, but the user portal is specifically personalised for your users and importantly has a lot of help already built into the site.

 

 

 

 

 

 

 

 

 

 

 

 

Live Meeting

We have not done much here other than to see ‘it just works’ and provides usual features to allow for live meeting to take place.

Office Communicator

Not something we have played around with much either, but again it just seems to work as expected. We’ve only just loaded this up, but will consider migrating to it once things have bedded down a bit. It’s basically an instant messaging application which will evolve into a ‘unified comms’ platform by 2010 supposedly.

 

 

 

 

 

 

 

 

 

SharePoint Online Features Table

Here is a table with the features provided by the SharePoint Online service, which is part of the BPOS offering. Again, we haven’t done much in this arena as we have other providers for this at the moment, but it pretty much does what you would expect. Note: It’s based on Windows SharePoint Services not MOSS for those interested.

Support during migration

Responses in general to queries being raised were provided to us in a timely manner, either by way of updates to the support area and or by way of telephone during office hours.

Our planning was thorough having gained experience in upgrades/migrations of Microsoft products with our day jobs, but we still came up with a few issues/challenges around email.

We particularly like the online support area, which is much improved from our old provider and keeps you easily up to date as to progress with your support requests.

Conclusion

The Good

• Setup was ok as we mentioned, though not really for the ‘none techie’ or individual whom isn’t used to migration issues with Microsoft based technology. You do need to plan your migration carefully as there are many permutations to consider, especially for your ‘on premise’ existing email providers and or SharePoint content migrations – more on this for a later post.

• SharePoint Online support changes made by SharePoint Designer and forms introduced by Infopath

• Mobile access to email via Windows Mobile devices is simple to setup

• Fantastic value for money with email, SharePoint, live meeting and instant messenger applications all neatly tied into one cloud based platform

• Highly resilient platform 99.9% plus secure https (only) traffic for all users

• Support via email and telephone was excellent.

Not so good

• It’s basically Windows SharePoint Services functionality, not MOSS

• Migration tools from hosted Exchange providers are none existent. Which we guess is ok, as you have the option to migrate/import your old PST files – but you do need to plan in time for this. For large scale migrations, you need time to do this and plan in appropriate with the user as they may well be without their mail during this time. Though with the migration tools available, you won’t lose any email

• Unfriendly URLs with all services – Apparently plans to improve on this area, but expect very long URLs and no way to change them

• Doesn’t support bespoke code within SharePoint Online (that requires server side additions or changes) but will allow SharePoint Designer based changes

• Arguably the lack of ability to support custom modifications is a ‘Bad’ but feel we have a good compromise here. Besides which, the dedicated offering from Microsoft will allow this. This position will probably changed for the better with SharePoint 2010….

Bad, needs improving

It’s early days yet, and perhaps we will post back after a month or so of using it in anger! Otherwise, it just works from our experience to date.

Regards,

Andrew Walmsley

WorkShares Team.

---

Accessing Office 2007 formatted documents in SharePoint with older versions of Microsoft Office

An ongoing challenge for some of our customers and no doubt many others out there is the inability of older versions Microsoft Office  (Namely Office 2000, 2002 (Known as OfficeXP) & 2003) to open/edit the newer formats created in Office 2007.

The Office 2007 applications by default have document extensions typically found with an ‘X’ on the end – .DOCX, .XLSX and .PPTX, etc. Though it should be noted that this can be changed to default back to the original formats, if you need too.

In any case, Microsoft have recently release a free download called “Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats”.

This downloadable installation will update your existing Office installation and allow it to open/view/edit/save the documents in the newer formats. Great!

Link to software download found here.

With further information found here relating to the knowledge base article.

Regards,

Andrew Walmsley

www.workshares.co.uk

Technorati Tags: Office,sharepoint

---