Category: SharePoint


  • Since the new User Profile Batch Update API is not available on all tenants yet I have been using the “User Profile Bulk Property Updater” from the OfficeDevPnP samples at https://github.com/OfficeDev/PnP/tree/master/Samples/Core.BulkUserProfileUpdater This bulk updates user profile properties in SharePoint Online through the use of a CSV file. I am a big fan of Office 365…

  • By installing the KB3114503 https://support.microsoft.com/en-us/kb/3114503 all the listview webparts on your SharePoint 2013 server displays this error repeatedly. “TypeError: Cannot read property ‘replace’ of undefined” With danish localization it looks like this: “TypeError: Værdien af egenskaben ‘replace’ kan ikke hentes: Objektet er null eller ikke defineret” Workaround Apparently a workaround is this quickfix https://www.reddit.com/r/sysadmin/comments/40tvqn/quickfix_patch_kb3114503_causes_sharepoint_to/ where…

  • All of the available out-of-the-box content types and their related columns in SharePoint Server 2013 are listed here in a post @JKevinParker http://www.jkevinparker.com/2014/02/sharepoint-2013-content-types-and.html You can also find the xml for most of the built in content types at your SharePoint server under the 15 hive folder TEMPLATE\FEATURES\ctypes\   Here is the PowerShell to fetch all content…

  • Following up on a change of default URL for a WebAppllication on SharePoint 2013, the site did not respond correctly. Finding the a Unexpected SPAudienceValidator Audience URI ‘[OLDURL]’ is not valid for context in the ULS led me to this blog post https://gavinmckay.wordpress.com/2014/11/28/fixing-sharepoint-2013-unexpected-spaudiencevalidator-audience-uri-is-not-valid-for-context/ Indeed a caching issue, in my case a flush of the DNS…

  • When using the PowerShell command Mount-SPContentDatabase or adding content database through the Central Admin you will receive this error message: The SELECT permission was denied on the object ‘sysobjects’, database ‘mssqlsystemresource’, schema ‘sys’. if the SharePoint Admin account has the deny permissions checked. The easy fix was to open SQL Server Management Studio and modify the…

  • Got the error while scripting content type modifications with PowerShell and SharePoint 2010.     Error System.Management.Automation.MethodInvocationException: Exception calling “Update” with “1” argument(s): “The collection cannot be modified.” —> Microso ft.SharePoint.SPException: The collection cannot be modified.    at Microsoft.SharePoint.SPContentType.Update(Boolean updateChildren, Boolean ignoreSealedOrReadOnly, Boolean throwOnSealedOrReadOnly, IList`1 exceptions)    at Microsoft.SharePoint.SPContentType.Update(Boolean updateChildren)    at Update(Object , Object[]…

  • Microsoft released the Service Pack 1 (SP1) for the 2013 set of Office products including Office 2013, SharePoint 2013 and Exchange Server 2013. Office 2013 customers will begin to get notifications of SP1 availability through Windows Update within the next 30 days. For Exchange Server 2013 and SharePoint 2013 you can use the links below.…

  • Here is how to set column validation formula for SharePoint field to contain only numbers and only two symbols (fixed length). You have to use a “single line of text” field because the number field won’t work this way. Here is the formula: =IF(LEN(CustomSortOrder)=2,ISNUMBER(CustomSortOrder+0),FALSE) This works for both SharePoint 2010 and 2013 and can be…

  • Todd Klindt has made a very useful SumUp on how to create different SharePoint Admin Permissions. For more information, take a look at Todds post Demystifying SharePoint Admin Permissions at Todd Klindt’s SharePoint Admin Blog Web Application Policy How Do You Give It? In Central Admin > Manage Web Applications > Policy for Users Farm…

  • Trying to filter a list on its workflow status is pretty non-intuitive. You need the special status codes. Theese will work with all workflows in ShaePoint even Nintex workflows. Status Code Status Description 0 Not Started 1 Failed on Start 2 In Progress 3 Error Occurred 4 Cancelled (i.e. Stopped by User) 5 Completed 6…