April 19, 2024

SamTech 365

PowerPlatform, Power Apps, Power Automate, PVA, SharePoint, C#, .Net, SQL, Azure News, Tips ….etc

TOP 10 best practices for document libraries in SharePoint

These are the things you really must do for every document library:

  1. Require Check Out on any document library where multiple users might make changes.
    • Check out is supported by, but not enforced on, document libraries unless you make it that way!
  2. Add the Checked Out By column to the default view of the library.
    • That way users can see easily who has a document checked out. If you hover over the Checked Out icon, it tells you in a tip, but that’s not exactly a “discoverable” little gem.
  3. Train users how to check out, check in, and discard check out.
    • Be sure they understand that the changes they make can’t be seen by other usersuntil checked in.
    • Do they understand the purpose of Keep document checked out after checking in? They check in the document to make their changes visible, but maintain an editorial lock to make more changes.
    • If there is a required column (property/attribute/metadata) that’s blank, the document can’t be checked in. Train users how to deal with this. This is particularly challenging if you’re using Internet Explorer (IE) to upload documents. You can upload them, but they won’t be visible to others until checked in, and they can’t be checked in until required columns are complete. So after uploading, open the SharePoint document library in IE and fill in those columns! What solutions have YOU found in your organization to this problem? I’ve yet to uncover a really great answer. DO YOU HAVE ONE?
  4. Create a permission level that gives someone the Override Checkout permission.
    • Take the burden off of yourself and your IT team to check documents in when users forget to do so before going on vacation.
    • Train your “check in managers” and your users so that they know what it means when a document has been checked in “on behalf” of someone else. If that someone else was using Microsoft Office 2007’s SharePoint Drafts folder, there are likely to be changes in the local copy of the document that were not included when the document was checked in. At some point, the two versions (the server’s copy and the user’s local copy) will need to be reconciled.
  5. Decide whether to use versioning.
    • If you want to restrict who can see drafts, use minor versions. Most of the time your processes will require that. If not, there’s no real point in using minor versions.
  6. If you’re using versioning, set retention limits.
    • By default, SharePoint keeps all versions, and these aren’t bitwise differential versions—they’re the full version. With large documents, even a small but active library can eat up your database in a hurry!
  7. Configure views that will help users navigate libraries effectively and find the documents they require.
    • Use folders only if you need to scope unique permissions on documents or if you need to make a subset of documents easily offline-able by Microsoft Outlook.
    • If your library has more than 2,000 items, be sure you remove the out-of-the-box default view, which shows all items. Add views with filters so that no view returns more than 2,000 items. Paging and grouping doesn’t count. You must use a filter. (BTW, in its sneak peek of SharePoint 2010, Microsoft announced that SharePoint 2010 will have large-list support, so this won’t need to be done much longer.)

    Then there are things that take a bit more time and configuration but really pay off:

  8. Create content types for documents that belong in a library, and upload a template for that document into the content type. Users can then click the NEW button on the library, choose the document type, and a new document with the right template appears.
  9. Push navigation aids to users: Add Favorites to users’ Internet Explorer (Group Policy Shortcut Preferences) and Network Places (XP) or Network Locations (Vista), which can be created by an administrator (separately for XP and Vista), uploaded to file shares, then distributed by copying into users’ systems (%userprofile%\nethood in XP and %appdata%\Microsoft\Windows\Network Shortcuts in Vista).
  10. Integrate custom columns (metadata) into Microsoft Word 2007 documents using Quick Parts. You can “link” content in your document with SharePoint metadata.

These are the things you really must do for every document library:

  1. Require Check Out on any document library where multiple users might make changes.
    • Check out is supported by, but not enforced on, document libraries unless you make it that way!
  2. Add the Checked Out By column to the default view of the library.
    • That way users can see easily who has a document checked out. If you hover over the Checked Out icon, it tells you in a tip, but that’s not exactly a “discoverable” little gem.
  3. Train users how to check out, check in, and discard check out.
    • Be sure they understand that the changes they make can’t be seen by other usersuntil checked in.
    • Do they understand the purpose of Keep document checked out after checking in? They check in the document to make their changes visible, but maintain an editorial lock to make more changes.
    • If there is a required column (property/attribute/metadata) that’s blank, the document can’t be checked in. Train users how to deal with this. This is particularly challenging if you’re using Internet Explorer (IE) to upload documents. You can upload them, but they won’t be visible to others until checked in, and they can’t be checked in until required columns are complete. So after uploading, open the SharePoint document library in IE and fill in those columns! What solutions have YOU found in your organization to this problem? I’ve yet to uncover a really great answer. DO YOU HAVE ONE?
  4. Create a permission level that gives someone the Override Checkout permission.
    • Take the burden off of yourself and your IT team to check documents in when users forget to do so before going on vacation.
    • Train your “check in managers” and your users so that they know what it means when a document has been checked in “on behalf” of someone else. If that someone else was using Microsoft Office 2007’s SharePoint Drafts folder, there are likely to be changes in the local copy of the document that were not included when the document was checked in. At some point, the two versions (the server’s copy and the user’s local copy) will need to be reconciled.
  5. Decide whether to use versioning.
    • If you want to restrict who can see drafts, use minor versions. Most of the time your processes will require that. If not, there’s no real point in using minor versions.
  6. If you’re using versioning, set retention limits.
    • By default, SharePoint keeps all versions, and these aren’t bitwise differential versions—they’re the full version. With large documents, even a small but active library can eat up your database in a hurry!
  7. Configure views that will help users navigate libraries effectively and find the documents they require.
    • Use folders only if you need to scope unique permissions on documents or if you need to make a subset of documents easily offline-able by Microsoft Outlook.
    • If your library has more than 2,000 items, be sure you remove the out-of-the-box default view, which shows all items. Add views with filters so that no view returns more than 2,000 items. Paging and grouping doesn’t count. You must use a filter. (BTW, in its sneak peek of SharePoint 2010, Microsoft announced that SharePoint 2010 will have large-list support, so this won’t need to be done much longer.)

    Then there are things that take a bit more time and configuration but really pay off:

  8. Create content types for documents that belong in a library, and upload a template for that document into the content type. Users can then click the NEW button on the library, choose the document type, and a new document with the right template appears.
  9. Push navigation aids to users: Add Favorites to users’ Internet Explorer (Group Policy Shortcut Preferences) and Network Places (XP) or Network Locations (Vista), which can be created by an administrator (separately for XP and Vista), uploaded to file shares, then distributed by copying into users’ systems (%userprofile%\nethood in XP and %appdata%\Microsoft\Windows\Network Shortcuts in Vista).
  10. Integrate custom columns (metadata) into Microsoft Word 2007 documents using Quick Parts. You can “link” content in your document with SharePoint metadata.