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 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:

UserName,SPS-HireDate,SPS-Birthday

i:0#.f|membership|atestusr03@unclouded.onmicrosoft.com,01/05/1971,12/04/1971

i:0#.f|membership|atestusr01@unclouded.onmicrosoft.com,11/08/1975,11/22/1975

i:0#.f|membership|atestusr02@unclouded.onmicrosoft.com,12/21/2012,07/03/2012

E-mail | Post RSS Permalink | Comments(0)

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 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!

More

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.

Sources

• http://answers.flyppdevportal.com/MVC/Post/Thread/14788a0e-5acd-4d1f-8de4-a9250f149fe6?category=sharepointgeneral
• https://blogs.technet.microsoft.com/stefan_gossner/2016/01/12/january-2016-cu-for-sharepoint-2013-product-family-is-available-for-download/
• http://wp.secretnest.info/archives/5187
• https://www.reddit.com/r/sysadmin/comments/40tvqn/quickfix_patch_kb3114503_causes_sharepoint_to/
• http://www.andreamonguzzi.it/sharepoint-2013-errore-typeerror-cannot-read-property-undefined/

E-mail | Post RSS Permalink | Comments(0)

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

Here are some useful links:

LDAP Query Basics

https://technet.microsoft.com/en-us/library/aa996205%28EXCHG.65%29.aspx

· Doing a Search Using Active Directory Users and Computers

• Doing a Search Using LDP
• Doing a Search Using LDIFDE
• Using LDAP Queries in ADModify

Search Filter Syntax
http://msdn2.microsoft.com/en-us/library/aa746475.aspx

Famous LDAP Filters for Active Directory Environments

http://www.ldapexplorer.com/en/manual/109050000-famous-filters.htm

How to search and find user accounts in Active Directory

http://www.selfadsi.org/extended-ad/search-user-accounts.htm

Using Ldp.exe to Find Data in the Active Directory

https://support.microsoft.com/en-us/kb/224543

How to Create Custom Active Directory LDAP Searches

http://blogs.msdn.com/b/muaddib/archive/2011/10/24/active-directory-ldap-searches.aspx

More…

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

http://blogs.technet.com/b/heyscriptingguy/archive/2005/08/29/how-can-i-get-a-list-of-all-the-users-whose-passwords-never-expire.aspx

LDAP/AD Claims Provider For SharePoint 2013

http://ldapcp.codeplex.com/

E-mail | Post RSS Permalink | Comments(0)

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 http://nuget.org/packages/CredentialManagement/

works perfectly

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

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

E-mail | Post RSS Permalink | Comments(0)

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 and a reset of the web server was sufficient.

1. ipconfig -flushdns

2. iisreset -noforce

E-mail | Post RSS Permalink | Comments(0)

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! http://stevemannspath.blogspot.dk/2013/03/sharepoint-permission-error-when.html 

E-mail | Post RSS Permalink | Comments(0)

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

E-mail | Post RSS Permalink | Comments(0)

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 
 Arguments)

AvailableContentTypes

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
$cType.FieldLinks.Add($fLink)
$cType.Update($true)

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
$cType.FieldLinks.Add($fLink)
$cType.Update($true)

E-mail | Post RSS Permalink | Comments(0)

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

KB2817429

Service Pack 1 for Microsoft SharePoint Server 2013 (KB2817429)

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

SharePoint Foundation 2013

KB2817439

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

KB2817434

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)

E-mail | Post RSS Permalink | Comments(0)

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 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="http://schemas.microsoft.com/sharepoint/">
  <Field
        ID="{[id]}"
        Name="CustomSortOrder"
        DisplayName="Sort Order"
        Type="Text"
        Required="TRUE"
        EnforceUniqueValues="FALSE"
        Indexed="FALSE"
        MaxLength="2"
        Group="CustomField">
    <Default>00</Default>
    <Validation Message="The value of this field must be between 01 and 99 and with 2 characters.">

      =IF(LEN(CustomSortOrder)=2,ISNUMBER(CustomSortOrder+0),FALSE)

    </Validation>
  </Field>
</Elements>

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

• http://thechriskent.com/2012/08/15/validate-phone-number-columns-in-sharepoint/
• http://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/

Happy SharePointing.

E-mail | Post RSS Permalink | Comments(0)