Skip to content

Upcoming Webinar – Enterprise Information Management with SharePoint 2010: Secrets to Success

Tuesday, November 15, 2011
8:00 AM Pacific / 11:00 AM Eastern
4:00 PM London / 5:00 PM Paris

Managing records and information in an enterprise environment can be a challenge. Your solution needs to address documents, files, emails, and physical assets. Content must be readily accessible. Retention policies must be identified and met. With operational efficiency and regulatory compliance on the line, choosing the right technologies is critical. But how can you be sure?

Join Dan Vasey, Director of Records & Information Management at Fortune 500 cable operator, Charter Communications, as he shares the strategy, methods, and tools that enabled his organization to successfully deploy the Charter Online Information Network, an enterprise-wide SharePoint 2010 based solution for records and information management.

Dan will be joined by Ben Henderson, Solutions Specialist at Colligo Networks, who will discuss best practices for SharePoint email management and accessing SharePoint content offline.  During this webinar, you’ll learn how to:

  • Simplify information management and streamline systems
  • Automate the compliance process, making it transparent to users
  • Drive enterprise commitment and end-user adoption
  • Integrate SharePoint with standard tools and processes
  • Link Outlook and SharePoint for email management

To learn how you can create a world-class SharePoint-based information management solution and drive efficiencies throughout your organization, register for this webinar today! Even if you can’t make the date (November 15, 8AM Pacific), register now and we’ll send you a link to the on-demand version following the webinar.

SPTechCon 2012: The SharePoint Technology Conference – San Francisco

I just received another e-mail from David Rubinstein, Conference Chairman, reminding me of The SharePoint Technology Conference coming to San Francisco this next February.  I have had the honor of speaking at this conference in the past and it has always been top-notch; the facilities, sessions, speakers and so on.  I won’t be speaking at this conference, but I will be attending; hope to see you there!

If you haven’t signed up yet, I highly recommend doing so; they are offering great deals right now for companies who plan on sending more than one individual…

SPTechCon 2012: The SharePoint Technology Conference

 

Remote Project Collaboration with MindManager

As you may already know, I use Mindjet’s MindManager extensively; for project discovery, assessment, SharePoint design and project management.  All of these document artifacts could be accomplished using Visio, Word and Microsoft Project; but my primary tool is MindManager.  I still use the Microsoft Office suite extensively; but these alone can be somewhat limiting in certain circumstances.

On most projects, I have the opportunity to work remotely (lucky me)!  And, on most projects, there is a decentralized group of individuals I need to collaborate with; specifically discovery, assessment, design and planning documentation.  I use Mindjet’s Catalyst product to aid with this collaboration and love it!  If you are unfamiliar with Catalyst, I highly recommend you take a look at it.  In general, you can collaborate on maps live; on the fly.

If you use different platforms, as I do, you will also find MindManager is supported on Windows, Mac, and even my iPad.

I love this product!

Read It Later: Save Your One Read Wonders

If you constantly read information on the web, you may find this an invaluable little gem!  I monitor, literally hundreds of blogs and news sources and use this tool extensively.  Whether I am on my iPhone, iPad, MacBook Pro or other computer, I use this tool to save articles and web pages for me to read at a later date.  It works great with feed readers; google reader, Feeddler Pro and virtually any browser…

Read It Later: Save Your One Read Wonders

Offline SharePoint – Enterprise Adoption of SharePoint – Part 1

I was asked by Colligo to be a guest blogger and write a series on the topic of Enterprise Adoption of SharePoint.  The first article in this series, Enterprise Adoption of SharePoint – Part 1, is now available on their site.

I would like to thank Colligo for giving me the opportunity to do this with them!

Using sub-sites to manage files instead of library folders – a contract management solution

Recently I wrote an article about why I don’t like the use of folders in SharePoint Document Libraries.  Some comments left on that article prompted me to describe one approach to using sub-sites instead of folders for managing documents.  The specific comment I am referring to indicated they were managing thousands of clients documents, categorized by client and contact.  And, I must say, in this individuals specific situation, folders may have been the best approach for them; I am not certain of all their business requirements.

I currently have a similar situation where I am building a contract management solution for a customer.  There are literally thousands of contracts and tens of thousands of associated documents.  For example, each contract has an associated RFP or RFQ, addendums, RFP/RFQ response documents, internal meeting notes documents, vendor information documents and so on.  Certainly these documents could be stored and managed in a single library with a folder structure rooted on the contract number; and sub-folders to group the various associated artifacts.  In fact, this is basically how it was done on their file share in the past.

What are the problems associated with using file shares and folders?

I would like to start by mentioning a few of the problems encountered when this information was being managed on the file share.  First and foremost, remember that folders hide content and do not promote findability; more so on file shares.

There is a general problem with file share security management.  File share security and sub-folder-level security is managed by IT and the applied security is hidden.  Non-technical users who don’t have access to the applied security information really never know if the documents they are managing is in fact secure; meaning, who has access to what!  This fundamental problems has plagued the world of file share use for decades.

Another problem with the use of folders is consistent naming conventions.  Meaning, there is no way of enforcing a consistent folder/sub-folder naming convention.  This is a problem from a use and consumers perspective.  When viewing the documents associated with one contract, additional associated artifacts are stored in different sub-directory structures; in some cases no sub-directory structure at all.

Lastly there is a major problem with findability.  There is a ton of important information stored on their file share related to contracts; and very difficult to mine this information to better support day-to-day business operations.  For example, how would a user find all associated vendors who sell a specific widget who have a current and open contract?  This type of slicing and dicing of information is all manually maintained in spreadsheets; and its not accurate because its very difficult to manage and keep fresh.  I know, I know… you’re going to say, but Bob, that’s why we want to use enterprise search services; this will solve all of my findability needs!  My response is, good luck!  Not even enterprise search services will produce relevant results to support all of the contextual needs that will arise; not without deliberately applying information architecture that is!

So why would we take the structure used on the file share and bring the same issues associated with it in to our SharePoint environment?  Many individuals feel that by simply picking up files off a file share and dropping them in to SharePoint, the above problems will go away.  They wont!  You will still have the security management issues and more so the issues around the consistent storage/management of content and findability.  If these aren’t issues for you, then I have to ask – why are you moving the files to SharePoint?  If you think enterprise search will solve all of your problems… which it won’t… but if you still think it will, then simply index the file share.

Another approach using sub-sites

Lets take a look at how using sub-sites might solve all of the issues described above.  Usually, when I mention this approach, individuals become fearful and somewhat defensive when thinking about the use of thousands of sub-sites.  I would like to start by getting you to squash this thought completely, its not an issue.  SharePoint can easily handle thousands and thousands of sub-sites when the need presents itself.  The manner in which SharePoint stores site information is vastly different than what you may be used to from the conventional ASP.NET development days.  I won’t go in to more detail in this article; but in general, a blank site in SharePoint consumes a single database record.  Yes, I know, there is additional references stored and managed by SharePoint but I will save that for another time.  The point I am trying to make here is SharePoint can handle the needs here.

For the rest of this article, I am going to use the same contract management solution need I started with.  We have thousands and thousands of contracts; each with many associated artifacts.

I started approaching this need using a dedicated Site Collection and sub-site structure; a single sub-site to store and manage each contract.  After reading below, I am hoping you will see why this approach is superior to the sometimes desired Document Library/folder/sub-folder approach.

If you take a look at the image below, you will see that I am managing a list of vendors, vendor specific sub-sites, list of contracts, contract specific sub-sites and various workflows to manage those lists and sub-sites.  This all could be managed manually, but that is a pain, and such a good use of workflow.  In this case we used K2 blackpoint workflow tools.

Please keep in mind, I have intentionally hidden many of the implementation details to I could get the general point across.  If you have any questions about those implementation details, leave me a comment, I will be happy to share my answers with you.

Click on the image above to see an enlarged view.

The vendors list contains a list of all vendors, related metadata and a URL to a vendor sub-site.  The contracts list contains a list of all contracts, related metadata, reference to associated vendors and a URL to a contract sub-site.  These 2 lists are key to aid in findability; they both provide a simple means of navigating vendors and contracts.  Each can be viewed in many different ways using the column filtering abilities built in to SharePoint.  For example its easy to view all contracts associated with a specific vendor or what contracts are active within a date range; many other options are also available.

I used a Vendor and Contract site template to promote the consistent implementation of information, look, feel and user experience.

Each Vendor sub-site is used to store and manage vendor specific documents, links to their public site, related contact information, product and services information and so on.  Each Contract sub-site is used to store and manage the contract document itself, related addendums, the RFP/RFQ, notes and everything else related to the management of that specific contract.

There were a couple of custom Web Parts developed for this solution.  Each Vendor site displayed a list of related contracts in a Web Part and each Contract site displayed a list of associated Vendors, the selected Vendor and so on.  These Web Parts could have also been implemented using the out-of-box Data View Web Part but that would have required some manual tweaking each time a new sub-site was created.

So… how does this approach solve the problems associated with file shares or the use of a Document Library with folders?

If you recall, I indicated security was an issue.  Using this approach, the management of security is at the Vendor and Contract sub-site level; which can be easily managed and viewed in SharePoint.  If you do need to further the level of security to specific lists and libraries within each sub-site, consider displaying that information in the description of those lists and libraries or in a Content Editor Web Part.  If you use the Content Editor Web Part approach, you may want to consider audience targeting the Web Part with the same security as the associated list or library so its not visible to consumers.

I also indicated there is a problem with consistent naming conventions.  This problem is easily solved by using site templates; each Vendor and Contract sub-site is created from a site template.  This enforces the consistent use of lists, libraries, content types, metadata and so on.

Lastly, I indicated there was a general problem with findability.  Most, if not all, of your findability problems will be solved using this approach.  Users who wish to point-n-click their way to information can use the structured Vendor and Contract look-up lists.  And users who are searching for something, as a result of a specific business contextual need, can use search.  Because we used consistent naming conventions, content types and metadata, search scoping and faceted filtering can be applied to significantly improve the relevancy of search results.

Using Folders in SharePoint Document Libraries

06-13-2011 – Updated based on post comments.

I am asked on a regular basis how I feel about the use of Document Library folders.  To be honest, I always tell people “avoid them”.  This response always stirs up controversy so I though I would write this article to help you
better understand my thinking.

Before I dive too deep in to this article, I need to first say; there is no right or wrong way of implementing your document management solution. There are simply better ways of surfacing information and improving the user experience.  If you are concerned about findability and user adoption, then read-on!  Another prerequisite to reading this article is to say, this is not a black and white topic; meaning, its not an all or nothing issue.  I believe document library folders have a place and can be used when done so in the correct ways.  Do I use them in my implementations?  Absolutely… However, I do so in a very limited manner and very specific ways.  With all that said, lets move on…

First, lets take a look at why you would use document library folders.  The only reason that immediately comes to mind is; because that is what we are used to doing!  I personally don’t think this is a great reason, but it does hold truth.

Now lets take a look at why we shouldn’t use document library folders; or ways of improving the users experience.

Navigating document library folders is not the same as what users experienced when storing/managing files on file shares and other drives.  The tree view, with +/- to expand/collapse branches, doesn’t exist in the out-of-box Document Library Web Part. Navigating down a folder branch requires the simple click of a link.  However, navigating back up the branch requires the user to click the browser back button.  This is a cumbersome user experience at best.

Just so you are aware, there are options to help solve some of the navigation issues described above.  You could write a custom Web Part, find publically available code or purchase a 3rd party product (a couple of examples are below).  There is code and products available.  However, I would first recommend you continue reading because these products won’t solve all of the problems you will have.

In addition to the navigation issues described above, folders hide the content contained; especially when you use sub-folders.  For example, when a user arrives at a site and they see a library named Shared Documents (which I also don’t recommend), first off the name of that library doesn’t tell them anything about what it contains.  Also, if the user clicks on the library, all they see is the first layer of folders. This may begin to indicate what files are contained within those folders but doesn’t suggest anything about what might be contained within sub-folders.  Again, hiding content and detail from users; forcing them to traverse folders until they find what they are looking for.  Not very efficient at all.

Remember, if it takes a long time for a user to find an important document, quite often they will make a local copy for future reference; so they don’t have to go through the pains of finding it again on your Intranet. Findability is extremely important.

I also have to make a comment about folder-level security; avoid it at all costs!  The use of it can and will become confusing for your user-base.  I have seen structures become so complex, contributors loose comfort knowing where to store and manage their content.  And what happens when contributors loose comfort and security with the solutions we implement?  They stop using them and go back to what they feel secure and comfortable with…  Something else to remember, security is one of the most complex features to teach a non-technical user.  If you are expecting your non-technical user-base to manage item and folder-level security, it will eventually be done so incorrectly; this brings up a while different set of issues (good topic for another article).  And, if you aren’t expecting the general non-technical user to manage their own security (which is good, I don’t recommend it) then you are placing the burden of that management on Site Collection Administrators, IT or whomever you have it assigned to.

Lastly, lets talk about content duplication.  Content duplication occurs in an organization in many different ways; so many that we don’t want to add to the problem.  Folders hide content.  As such, if it takes a long time for a user to find an important document, they are more likely to make a local copy of that document so they don’t have to find it again in the future.  Another way duplication occurs by using folders, is by simply needing a document to be present in multiple folders.  For example, lets say you have a document that is related to 2 of 3 areas of Human Resources Benefits; related to Medical and Dental Benefits but not Vision Benefits.  If you have benefit documents broken down in folders by benefit type (which is common), you may have to duplicate this common document in 2 places.  Again, we have to avoid the duplication of content on our document management system at all costs.  It’s called single source of truth!

So… what can be done to solve these problems, improving the user experience and overall findability?

First and foremost, consider using metadata!  Whether you choose to continue using a Document Library named Shared Documents or not, I would recommend you start applying Content Types and metadata to your documents.  As a simplified example, move all of your documents in a library to the root folder and apply metadata that can be used to filter the view.  Still not the greatest user experience; however, a user will at least be able to see all of the files contained within a library simply by clicking the library link.  They can then filter the view down using the metadata column filtering abilities built in to SharePoint.

Using more Document Libraries is an even better approach to solving the overuse of folders issue.  Let me demonstrate; a user arrives at a Human Resources site and is presented with a Document Library named Shared Documents, with folders and sub-folders.  Well, you already know how I feel about this user experience.  Now improve the experience for the user by creating multiple Document Libraries; one named Medical Benefit Documents, another named Dental Benefit Documents and another named Vision Benefit Documents.  Using this approach alone will significantly improve the user experience from a findability perspective.  The Medical Benefit Documents library has a Content Type associated with it named Medical Benefit Document; which forces the contributor to store and manage only documents of type Medical Benefit.  This also helps with your overall IA too; but that’s a whole different article series! Just be certain to not have your Document Libraries so generic that you have to manage too many Content Types with it; this can also be confusing for contributors.

Another approach, and one I use all the time, is to build your hierarchy with sub-sites.  Take Human Resources Benefits for example.  You may be better suited having a Benefits sub-site then sub-sites below that, one for each specific type of benefit (Medical, Dental and Vision).  There are many, many advantages to using sub-sites in this manner.  Sub-sites, used in this manner are really nothing more than what is called “a point of aggregation and association”.  Let me provide you with another example.  On a Medical Benefits sub-site you can store and manage related announcements, policies, procedures, forms, FAQ’s, glossary terms, links to external references and so on.  You are basically bringing the user to a new level of experience when you aggregate all information associated with Medical Benefits on a single sub-site.

Another advantage to using sub-sites as a point of aggregation and association, is realized when you begin to aggregate content to a higher level on your Intranet.  For example, if you choose to aggregate all Policy Document (documents of type Policy) to an aggregate view using the Content Query Web Part, those policies can be grouped by site/sub-site.  This is a very useful view and cannot be produced automatically using folders.

So how do you handle the folder-level security confusion issue described above Bob?  Great question, and I’m glad you asked!  Remember, my implementations utilize sub-sites and multiple document libraries.  I simply place a Content Editor Web Part above the Document Library Web Part and use it to describe the libraries intended use and security.  I target this Web Part to the contributor audience so it is only displayed for those who are contributors on that specific site or page.

The document management/Intranet solutions I have implemented, contain a wide rage of the techniques described above.  The actual implementation techniques used all depends on the size of organization, amount of content, contributors, consumers, security and a myriad of other requirements.  It is my hope that some of these techniques help with your next implementation or give you ideas of how to improve your current implementation.

If you have any questions or comments about this article, please leave them below!

Until next time…

06-13-2011 – UPDATE

A few great comments on this post prompted me to make the following updates to this post.

As Paul indicated in his comment, there are situations where folders can be used to manage content; just because of the sheer amount of content being managed.  I don’t necessarily feel that thousands of clients and contacts should drive this, but I am not completely familiar with his requirements.  I am going to write an article about how this type of situation may be better solved using sub-sites instead of folders.

None the less, there are some situations where folders may help.  In the past there have been limited occasions where using folders made sense.  In these situations, the implemented used was driven by workflow.  This was done to manage the security and consistency of that implementation.  As I look back at those implementations, I would most likely do them differently today and use sub-sites.

I also want to note that Chris Poteet also has a nice video on this topic.  It can be found on his site here.

 

SharePoint 2010 Lists – Simple Form Validation

I was going to provide a post about this topic; however, I noticed Mattias Karlsson has already done so on Secrets of SharePoint.  Take a look at his post Validate the form data when items are created.

SharePoint 2010 Calendar – Resources

SharePoint 2010 calendar resources.  If you have any suggestions, please leave me a comment!
Updated on 6/3/2011

Articles (How-to’s)

Path to SharePoint Blog – Tutorial: add color coding to your SharePoint 2007 calendar in 15 minutes
SharePoint 2007 specific

3rd-Party Products

Bamboo Solutions – Calendar Plus Web Part
Visually communicate date-based list data through several useful views: Day, Week, Work Week, Month, Quarter, Year and Gantt. Show events, tasks, milestones, project initiatives, legacy data, or employee vacation plans, to name a few.

Bamboo Solutions – SharePoint Team Calendar
The SharePoint Team Calendar Web Part provides a centralized group calendar that can interact with a SharePoint calendar list, multiple Microsoft Exchange calendars, or do both side-by-side. Users can add and edit items in a SharePoint list directly from the Team Calendar, or they can create and update Exchange meetings and appointments through an Outlook style resource scheduling assistant. The Team Calendar can even display events for multiple Exchange accounts in a single calendar, complete with customizable color coding for different calendars and event types.

Bamboo Solutions – Calendaring & Scheduling Toolkit
Bamboo’s Calendaring & Scheduling Toolkit for SharePoint provides a broad array of extended calendaring functionality, well beyond SharePoint’s “out-of-the-box” capabilities. With seven extensible components that can be deployed and configured by end users anywhere across your SharePoint environment, it’s a complete solution to your organization’s calendaring needs.

 

SharePoint Intranet Implementation – CSF – Simplify the Contribution and Management of Content

CSF – Simplify the Contribution and Management of Content

Many Intranets I have seen over the years have been implemented with the focus being on a single consumer audience.  This model may work well for an Internet (public facing) site; however, I contest it is a model that doesn’t work well for Intranet implementations.  First and foremost, we have to implement a consistent model that makes the contribution and management easy for those who are performing updates and managing content on a day-by-day basis.  This requires us to separate the content contribution model from the visual representation of that content.

Common Mistakes

If you focus on the visual representation model first and use it as the basis for your contribution model, you will most likely have the following difficulties:

  1. Your visual representation will most likely only solve a single contextual need; meaning, it is quite common we have to re-purpose content to aid with different contextual business needs to support aggregation, search, dashboards and so on.
  2. Targeting content to be stored in a single location will require addition security, governance and maintenance.  I will explain more below.
  3. Content contributors will have to remember, or bookmark, all the various locations on your Intranet needed to get their jobs done.

Let’s first take a look at the single location for storing, managing and visualizing content of a specific type.  This is the common implementation model I see most often and the one I rarely use on Intranet implementations.  Corporate policies are common throughout most Intranet implementations, so I will use this as a basis for the following examples.

In the example above, all contributors and consumers visit a single site where corporate policies are managed.  This is, by far, the easiest implementation approach in SharePoint; however, not the easiest to manage.  The biggest problems you will encounter with this approach are forcing the contributor to go to this site to manage their documents and the management of policy document security.

First, an employee who works in the Human Resources department should be able to go to a single Intranet destination to perform all of their day-to-day duties.  Approaching the contribution and management of content using this type of model will make the contributors and owners of that content much happier.  Secondly, if you store all corporate policy documents in a single document library on a Corporate Policies site, you will need to manage item level security.  If you don’t do this, every contributor will have the ability to modify other departmental policies; and it will happen, I guarantee it.

I know, you can overcome the item level security maintenance nightmare in a few different ways; use folders (doesn’t promote findability, ugly navigation), use a document library for each department (doesn’t solve the problem with simplifying the contribution and management of the content).  Also, don’t forget about the different contextual needs you will encounter with regards to content consumption.

How can you avoid these mistakes?

Now, let me introduce you to a couple of alternative implementation models that will solve all of the problems described above!

The alternate approach displayed above uses a model where corporate policy documents are stored and managed at the department level.  Meaning each department is responsible for managing their own corporate policy documents.  This in itself solves the security model problem; you only need to manage the contributors for each department at their specific site level.  In addition, each departmental employee goes to their specific departmental destination to manage their corporate policies; thus simplifying the contribution and management of their content.  Another note; this also aids with solving that age-old question “where do I store and manage my content?”

This approach also provides you with the “All Corporate Policy” document view found on most Intranets.

The key to this approach is to uniquely identify documents of type Corporate Policy.  We accomplish this by using SharePoint Content Types.  Most Intranets I implement have a Content Type named “Corporate Policy Document”.  I assign this Content Type to each of the departmental specific document libraries where corporate policies are to be stored and managed; the difficult work is done!

You now have corporate policy documents positioned in a manner that allows you to aggregate them in many different ways too.  For example, it’s quite easy to create a search scope on all documents of type Corporate Policy Document, located in the Operations department or Finance Department.

The second alternative approach displayed above has the same basic site structure, contribution model and use of the “Corporate Policy Document” Content Type.  The only difference in this model is the documents being published to the Corporate Policy aggregate site in a PDF format.  Again, this is only an alternate approach and will cost additional budget to implement.  However, some companies would prefer published corporate documents be delivered on an Intranet in PDF format; thus reducing the read/view tools required by the consumer.

Conclusion

The suggested models I have provided above are not difficult to implement or complex in any way.  My goal is to change the way you think about separating the storage, management and visual representation of content.

If you have any questions or comments about the implementation approach suggestions above, drop a comment below and I will respond!