February 23, 2017
Companies that have adopted SharePoint as a platform for their document management solution often face common issues with their document libraries, particularly in cases where the solution was not implemented based on best practices. The common issues that are faced are:
Often, we find companies request to migrate their content from their network file shares across to SharePoint, effectively wanting to replace their network file share systems with SharePoint being the document management solution.
To fully take advantage of SharePoint, it is always recommended to convert the file share system into a solution architected based on best practices in the SharePoint platform. This is to get the most out of the software and also to provide the business with a return on investment. If the file share is merely replicated in SharePoint, the return on investment is limited, as it is merely a like for like set up just on a different platform.
Some of the best practices for SharePoint Document Management address these common issues and aim to solve them.
Enable document library versioning to ensure a complete version history is kept and maintained. This allows document changes to be tracked, and provides a mechanism to allow users to restore from previous versions if required and view details on past changes made.
Major and minor versions are able to be maintained, and there is the option to specify how many major and minor versions are to be retained. It is recommended to set a figure of versions to retain to ensure storage consumed does not grow exponentially due to versions. If major versions are required to be created, we recommend as a rule of thumb retaining 10 major versions. If major and minor versions are required to be created, we recommend as a rule of thumb retaining 10 major and 10 minor (draft) versions.
When a list or library has a large number of items, you must carefully plan its organisation and how users need to access the data. By planning and using a few key list and library features, you can ensure that users can find information without adversely affecting the performance of the rest of your site.
To improve the performance of a large list or library, you can index a column. An index on a column enables SharePoint to quickly analyse the data in that column, even when working with thousands or millions of items. For a view to quickly filter through a large number of items, the filter must be applied to a column that is indexed.
Consider the following:
Document libraries must have a logical name to make the document management solution intuitive to use and ensure content is uploaded into the correct location. This would improve user adoption and collaboration.
It is also important to ensure no spaces are included in document library internal names. On the Internet, spaces are encoded as ‘%20’ in the URL. Spaces are acceptable to be included in the display name for document libraries. Without spaces, the URL is constructed in a more user friendly manner.
File naming conventions are recommended to be named in a logical manner and short to ensure URL length limits are adhered to. It is highly recommended to not use any special characters in folder names, file names and also in document library names. Special characters such as ampersand, are not to be used. Always use alpha and numeric characters only.
To avoid hours of adding tags to bulk uploads, using one type of content per library can save time. This means organising content distributed across different libraries can aid in reducing time required to tag documents in their corresponding libraries.
What are the benefits of implementing this best practice?
Do not use folders to store content in document libraries because this can cause issues such as users misfiling documents, documents getting lost in nested folders, and it’s more time consuming to navigate around document libraries to locate content.
Tagging is preferable because it is more flexible. It also means you can view items by different classifications, which enriches the functionality of your library. Metadata provides the ability to view the list of files in the document library in different ways that allows you to find content quicker and also produces quality reports that is virtually impossible using folder structures.
As a rule of thumb, document libraries are to have no more than 5 columns for metadata. Site columns and site content types are definitions that can be re-used across a site or its subsites. This saves set up time and helps minimise admin overhead.
Site content types help structure a document library’s content by defining the metadata required to be captured in the content type, and associating the content type to files in the library.
If the organisation requires the ability to co-author on Microsoft Office documents in the library, it is recommended not to turn on the ‘Require Check Out’ setting.
The function of this feature is to prevent alteration of a document by multiple individuals. This is a good feature to have when there is more than one person working on a specific project or to prevent another from making changes to completed work without consulting you about it first.
In document libraries, the permissions recommended to be set up is to adhere to using SharePoint groups rather than granting users access directly to the library. This minimises admin overhead from a permissions management perspective.
With this security model, users can be added/removed from the SharePoint group(s), which subsequently controls their access levels to the library, depending on the group’s assigned permission levels on the library. Without the need for folders, permissions can be set up directly on the document library (if the library is to have unique permissions different to the site level permissions), otherwise the library’s permissions can inherit from the defined permissions at the site level.
When document libraries include metadata and files are tagged appropriately, document library views can be set up to present the content in different ways that will help users find content quicker and easier. Content such as the most recently modified files can be presented at the top of the default view, saving the user time in finding the document that was last updated in the library.
Views can also provide a great reporting feature on the content in the library.
The All Documents document library view is the default view that typically always has all the metadata properties in the library visible. This view is to be used for doing bulk tagging on the documents in the library, post the bulk upload of files. It can also be considered as the administrative view of the library.
Alerts can be set up in a document library. They will inform you if someone is trying to change or delete your documents in some form or fashion. It will also keep you up to date on what has been added / changed in the document library through email notifications. The following are the available options to configure for the alert:
The next step that can be taken in SharePoint for further enhancements, utilising the document library features such as metadata is: customising search with search refiners and result sources.
This can aid in improving content find-ability and filtering through large result sets. Search refiners and result sources can improve search performance, as they are targeted to returning a subset of results from the entire search index.