Blogs

Is there a sustainable and scaleable records management model in SharePoint 2010?

By James Lappin posted 07-28-2010 12:11

  

In June I saw Peter King, Office Server Group Manager  of Microsoft UK,  give a keynote speech to the AIIM roadshow in London.  One of Peter’s slides contrasted functions that SharePoint 2010 could fulfill on its own, with functions that SharePoint needs the help of third party applications to fulfil.   Records management was listed as being one of the things that SharePoint 2010 could do on its own.  

However Microsoft say that they have no intention of submitting SharePoint 2010 for certification against one of the recognised standards for records management systems, for example DoD 5015.2  in the US or MoReq 2 in the European Union.  They advise customers wanting that level of records management functionality to look to third party products.

 
SharePoint 2010 can do a form of records management, but it is records management as defined by Microsoft, not as defined by the international records management community.  The fact that Microsoft are using their own definition of records management is not in itself a bad thing - we need innovation in this space, and vendors slavishly following worthy specifications drawn up by committee isn't going to do anyone any favours.   But it does mean that we need to closely scrutinise, and debate, the records management functionality contained in SharePoint 2010.
 
The lack of a clear records management model in SharePoint 2010
 
With SharePoint 2007 Microsoft had attempted to make two innovations in records management:
  • They wanted people to use 'content types', rather than folders as the primary means of organising and managing documents and other content
  • They wanted documents to be moved into a records centre to be treated as records, rather than treated as records inside the team sites that people worked in
 
In SharePoint 2007 there was a clear records management model -  the only problem was it didn't work.  Microsoft had given all the power to the content type and none to the folder, but the content type on its own proved unequal and unsuited to the task of managing records.
 
In SharePoint 2010 Microsoft are hedging their bets:
  • Content types have been adapted to make them more suited to managing records (through the addition of a new kind of content type called a  'document set').  But at the same time folders have been given more functionality 
  • Record centres have been improved, but Microsoft are also providing an 'in place' records management facility to enable people to protect records from deletion or amendment without moving them to the records centre
 
In SharePoint 2010 there is no single records management model.  Instead there are different choices and options.   SharePoint 2010 shows some improvements in records management functionality when compared with SharePoint 2007.  But the lack of a clear records management model in SharePoint 2010 means it will not be easy for implementers to decide upon and to sustain a coherent approach to records management.
 
For example lets imagine you intend to deploy a fileplan in SharePoint. I am defining a fileplan as a hierachical classification of the work an organisation carries out.  There are three different ways you could deploy that fileplan.  You could deploy it as:
  • the site collection/ site/ sub-site hierarchy
  • a hierarchical structure within a records centre (or spread across several records centres)
  • a taxonomy in the managed metadata service
Each of these options has its pros and cons.
 
Using the site collection/site/ sub site hierarchy to house your fileplan (‘In place’ records management)
 
Whereas in SharePoint 2007 you had to send a document to the records centre if you wanted it protected from unauthorised deletion or amendment, in SharePoint 2010 you can have it protected within the team site.
 
There is a ‘Declare Record’ button on the SharePoint document library ribbon that enables colleagues to save a document as a record.  Once a document is declared as a record it is protected from amendment or deletion.
 
In theory this option means we can dispense with the records centre(s).
 
However having content protected as a record is only one aspect of how records managers want content needed as a record to be treated.    We also want to to ensure that content is organised within a managed structure.  A structure that persists, and continues to make sense, over time.
 
The problem with managing records 'in-place' is that it is very difficult to control the structure within which content resides.
 
Take a typical piece of content in SharePoint - a document, sitting in a folder within a document library.  The library sits within a sub-site, which sits within a site, which sits within a site collection.
 
The structure that a document resides in is the breadcrumb trail encapsulated in the URL of the site, the library and the document itself .  The breadcrumb trail starts with the name of the site collection and carries on with the name of the site, sub-site, document library and folder.
 
In theory you could impose the rigidity of a hierarchical records fileplan onto this structure.  It is possible to:
 
  • set up a SharePoint site collection for each of the top level headings in your fileplan
  • set up a site within those site collections to represent the 2nd level of your fileplan, and sub-sites beneath that for the third level of the fileplan.  If you needed another level of hierarchy you would add another level of sub-sites
  • ask each team to create a new document library for each new piece of work that they start, within a lowest level sub-site
 
However in practice such rigidity may become too much of straitjacket for a SharePoint implementation.   If SharePoint becomes popular in your organisation then sub-sites and document libraries will be created for all sorts of reasons,  some with the intention of holding records, but others for ephemeral collaboration.  It isn't necessarily going to be meaningful to shoe-horn them all underneath a fileplan hierarchy.
 
On the other hand if you do not think through the hierarchy of site collections/sites/sub-sites, and allow a free for all in site and sub-site creation, then you end up with a haphazardly evolving structure, a sprawl.  When that happens the in-place records management feature is of little use, because your declared records are randomly dotted around the massive SharePoint sprawl like tiny islands in the Pacific Ocean.
 
Housing your fileplan in a SharePoint records centre
 
The way the records centre works in SharePoint 2010 is broadly similar to the way that it worked in SharePoint 2007 (although to say that the records centre worked at all in SharePoint 2007 is in my view something of an exaggeration).
 
  • In SharePoint 2007 the idea was that knowledge workers would click on a document in a SharePoint document library, and would select the option ‘send to the records centre’.  In the records centre the ‘records routing table’ would route the document to the appropriate records library, providing the document belonged to a SharePoint content type, and provided that a records routing rule had been set for that content type.
  • In SharePoint 2010 the records routing table is replaced by the content organiser and the drop off library.  When someone selects the option ‘send to records centre’ documents are received by the drop off library, and then processed by the content organiser. The content organiser sends the document to the appropriate records centre library, or the appropriate folder within a records centre library, providing that the document belongs to a content type or a document set, and providing that a routing rule has been set for the content type or document set that the document belongs to
 
In terms of configuration in SharePoint 2010 you can have a drop off library and content organiser within the records centre itself (like the records routing table in SharePoint 2007).  You can also have content organisers and drop off libraries inside each collaborative site,  that route documents to the records centre or to particular places within the records centre.
 
The improvements made to the records centre between SharePoint 2007 and SharePoint 2010 are incremental rather than revolutionary, but they are worth listing:
 
  • Routing to a specific folder - In SharePoint 2007 the fact that you could have a folder structure within a records centre library was rendered useless by the fact that the records routing table could only route a document to a records library, it could not route a document to a specific folder within a records library.  In SharePoint 2010 the content organiser can route a document to a specific folder within a records library in the records centre
  • Inheritance from folders- Folders have more functionality in SharePoint 2010 (they had none in 2007).   You can set retention rules on high level folders, and you can allow all the sub-folders and documents saved within it to inherit the retention rule. This means you can get a folder structure in a records centre library to function like a fileplan
  • Routing on the basis of metadata properties In SharePoint 2007 the routing table could only apply a rule to a content type.  In 2010 rules can be set rules at a more granular level.  You can base a rule  on a value in a metadata column field of a content type.  For example you could define a column entitled 'project'  for a content type/document set.  You could set up a controlled vocabulary for the 'project' metadata column.  You could get the content organiser to look at the value in that column for any incoming document, and route it to the folder in the records centre for that particular project
  • Multiple records centres - In SharePoint 2007 organisations were only able to have one records centre. In SharePoint 2010 you can have as many records centres as you wish.  Rather than having one records centre with one huge fileplan, an organisation could choose to spread its fileplan over several records centres in SharePoint 2010
The whole concept of the record centre in SharePoint brings with it three big disadvantages
 
  • It requires you to use content types - If you are using the records centre, you are going to have to use content types or document sets.  This is because the content organiser works by applying rules to content types/document sets, not to folders.  Content types and document sets are more powerful than folders, but they are also more complex for you as an administrator to set up and maintain, and for your colleagues to understand and use
  • You have the administrative overhead of maintaining all the routing rules- Most organizations are used to having some rules to automatically route some documents (particularly where they have workflows set up to automate some important business processes, or within some line of business systems).  However I don’t know any organisation that is used to setting rules for the routing of documents across all its business processes.  This reliance on pre-defined routing rules for the basic records management process is new to SharePoint – none of the established electronic records management system worked that way.   I am yet to be convinced that it is feasible to set up and maintain routing rules covering a large organisation’s  entire range of activities
  • there is no guarantee that the records in the records centre will be useful- Microsoft envisages collaboration sites as being the sphere of the knowledge worker, and records centre sites as being the sphere of the records manager.   But if knowledge workers have little or no interaction with the records centre, then in what sense can we regard the accumulation of documents that build up there as an authentic record of the work that those knowledge workers carry out?
 
Installing your fileplan as a taxonomy in the Managed Metadata service
 
The third option for your fileplan in SharePoint 2010 is to have it as a controlled vocabulary, a three level taxonomy that sits in the Managed Metadata Service, and that can be used to:
 
  • populate metadata columns in document libraries
and/or
  • populate columns of metadata for content types and/ document sets
 
Support for hierarchical taxonomies is a new feature in SharePoint 2010.  SharePoint 2007 only supported flat controlled vocabularies (akin to a drop-down list of headings).
 
A taxonomy in SharePoint's managed metadata service can only go three levels deep (the three levels are called: groups, term stores and terms).  This is a significant constraint - in my experience those organisations of around 800 people that have corporate fileplans tend to have a four level classification (which they use to organise folders that are created when a piece of work starts).
 
The weakness of having your filepelan as a taxonomy in the managed metatdata service is that you cannot link retention rules to SharePoint taxonomy terms.  You can only link retention rules to content types, document sets, libraries and folders.  You would still need to decide with this option whether to move records to the records centre, or whether to manage records in-place in the collaborative team sites.
 
If you are using the in-place records management option, then the advantage of having the fileplan as a taxonomy is that it removes the need to warp the site collection/site/sub-site structure into the form of a fileplan.
 
It is not easy to enforce a fileplan set up as a SharePoint taxonomy,  particularly with the in-place records management option. This is because SharePoint gives teams a lot of options on what type of object to use when collaborating on work.  It is hard to predict whether any particular team will want a sub-site, a document library, or a folder for their piece of work.  This makes it harder to issue a blanket policy rule such as ‘every document library must be classified against the fileplan in the managed metadata service’
 
One option might be to use content types, and specifically to use the SharePoint document set content type.   In theory it is possible for an organisation to use 'document set content types' as a fourth level fileplan classification, with each 'document set content type' linked to a specific pathway in the three level fileplan in the managed metadata service.  The downside of this approach is that it would force people to use document sets to manage documents of their work.   Document sets are a new feature in SharePoint 2010, and at the time of writing I have not seen any case studies from organizations using them in practice.
 
Conclusion
 
SharePoint is now a mature collaboration system, having gone through several iterations of the product.   But the records management in SharePoint is not yet mature. The records centre in SharePoint 2007 could not be made to work to any scale without extensive custom coding.  Many of the concepts on which records management is based in SharePoint (content types, document sets, routing rules, and the records centre) are unique to SharePoint.  Records management in SharePoint is still unproven, and will remain unproven until we know of a reasonably sized organisation who have successfully used it for records management across their full range of activities without extensive customisation.
 
For these reasons I think it is important that we as a records management community look on SharePoint 2010 with a sceptical, questioning eye.


#SharePoint #ElectronicRecordsManagement
0 comments
42 views