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

This bulk updates user profile properties in SharePoint Online through the use of a CSV file.

I am a big fan of Office 365 Developer Patterns and Practices and this sample is so usefull.


Here is the input format for the CSV fil to update your profiles with hiredate and birthday:





Tags: | Categories: SharePoint Configuration

By installing the KB3114503 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”




Apparently a workaround is this quickfix where you modify the view to display the item title colounm (linked to item) instead of (linked to item with edit menu).

Some reports states that a solution is applying January 2016 CU. And that the KB3114503 update is unable to be removed after installation.

So remember to turn off automatic windows update and test any patch/CU before production!




To learn more about the vulnerabilities the KB3114503 fixes, see Microsoft Security Bulletin MS16-004.
Note To apply this security update, you must have the release version of Service Pack 1 for Microsoft SharePoint Foundation 2013 installed on the computer.


Tags: , , | Categories: Technical

Ran in to a project today where I had to revisit the old LDAP query.

ADUC Advanced Custom Search Results

Here are some useful links:

LDAP Query Basics

· Doing a Search Using Active Directory Users and Computers

Search Filter Syntax

Famous LDAP Filters for Active Directory Environments

How to search and find user accounts in Active Directory

Using Ldp.exe to Find Data in the Active Directory

How to Create Custom Active Directory LDAP Searches



How Can I Get a List of All the Users Whose Passwords Never Expire with PowerShell?

LDAP/AD Claims Provider For SharePoint 2013

Tags: | Categories: Database | Tips and tricks

There is a Nuget library called CredentialManagement that wraps the Windows Credential Management API that supports both the old and the new style of UI


works perfectly

        var cm = new Credential();
        cm.Target = "mycredentialname";

        if (!cm.Exists())
            Console.WriteLine("cm is null");
        Console.WriteLine("Password: " + cm.Password);
        Console.WriteLine("Username: " + cm.Username);


Tags: | Categories: Technical

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

Indeed a caching issue, in my case a flush of the DNS and a reset of the web server was sufficient.

  1. ipconfig -flushdns
  2. iisreset -noforce




Tags: , , , | Categories: SharePoint Configuration | SharePoint

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 roles of the admin account on the content database.

  • db_denydatareader
  • db_denydatawriter

Make sure that db_denydatareader and db_denydatawriter are unchecked on the user. 

Thank you Steve! 


Tags: , , , | Categories:

Get the new Blog App at the windows phone store for free and stay up-to-date with new posts on your favorite windows device!







Tags: | Categories: Windows Phone Development

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[] )
   at System.Management.Automation.DotNetAdapter.AuxiliaryMethodInvoke(Object ta
rget, Object[] arguments, MethodInformation methodInformation, Object[] original


I was using the AvailableContentTypes[$contentTypeName] to get the content type I wanted to change. But content types retrieved from this collection (as oppose to SPWeb.ContentTypes) are read-only.

$field = $web.Fields[$fieldName]
$cType = $web.AvailableContentTypes[$contentTypeName]
$fLink = new-object Microsoft.SharePoint.SPFieldLink $field

The correct way is using the SPWeb.ContentTypes collection as the following code:

$field = $web.Fields[$fieldName]
$cType = $web.ContentTypes[$contentTypeName]
$fLink = new-object Microsoft.SharePoint.SPFieldLink $field


Tags: , | Categories: SharePoint Development

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.
  • If you are an Office 365 subscriber, you are always on the most up-to-date version

Here is an excel sheet of issues Fixed by Service Pack 1 (SP1) in Office and SharePoint 2013


SharePoint Server 2013


Service Pack 1 for Microsoft SharePoint Server 2013 (KB2817429)

Service Pack 1 for Microsoft SharePoint Server 2013 Language Pack (KB2817438)

SharePoint Foundation 2013


Service Pack 1 for Microsoft SharePoint Foundation 2013 (KB2817439)

Service Pack 1 for Microsoft SharePoint Foundation 2013 Language Pack (KB2817442)

SharePoint Designer 2013

Service Pack 1 for Microsoft SharePoint Designer 2013 (KB2817441) 64-Bit Edition

Service Pack 1 for Microsoft SharePoint Designer 2013 (KB2817441) 32-Bit Edition

Project Server 2013


Service Pack 1 for Microsoft Project Server 2013 (KB2817434)

Exchange Server 2013

Exchange Team Blog post on changes with the SP1

Microsoft Exchange Server 2013 Service Pack 1 (SP1)


Tags: , , , , | Categories: SharePoint

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:


This works for both SharePoint 2010 and 2013 and can be set in the user interface.

If you are creating a WSP:

Here is the xml for the field called “CustomSortOrder” is a required field with the deafult value set to “00”:

<Elements xmlns="">
        DisplayName="Sort Order"
    <Validation Message="The value of this field must be between 01 and 99 and with 2 characters.">
</Validation> </Field> </Elements>


In my search for this solution I found some other formulars at The Chris Kent blog:


Happy SharePointing.


Tags: , | Categories: SharePoint Development | SharePoint Configuration