Tag: SharePoint 2010


  • 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…

  • 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…

  • When you throw claims authentication in the mix of AD users and SharePoint user profiles there is some things you should be aware of: Use your Identity Provider to make the user profile sync connection to the domain There’s no built in mapping between the user profile identifier and claim (or forms) users identity provider;…

  • The User profile synchronization with AD comes with a build in property mapping. The following page from The TechNet Library describes the profile properties and link to their corresponding directory service attributes: Default user profile property mappings (SharePoint Server 2010) User profile property AD DS attribute SPS-DistinguishedName dn SID objectSid Manager manager PreferredName displayName FirstName…

  • Problems with disabled accounts from former employees in your SharePoint User Profile Store ? This will help you set up Exclusion Filters in the User Profile Synchronization   1) Browse to Central Administration Site > Manage Service Applications > User Profile Service Application. 2) On the Manage Profile Service: User Profile Service Application page, click the…

  • Got the message: >>The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document. << This is a challange and there is several possibilities: You are using the 64 bit version of Internet Explorer and choosing “edit in Microsoft Word” The SharePoint support component that…

  • Using the in the the wrong parameter with the SPWeb.GetList method you will receive a FileNotFoundException with the following very SharePoint-ish error message: System.IO.FileNotFoundException: <nativehr>0x80070002</nativehr><nativestack></nativestack><nativehr>0x80070002</nativehr><nativestack></nativestack> The stacktrace will often give more information but the ULS log it wil simply show: <nativehr>0x80070002</nativehr><nativestack></nativestack> So the parameter is incorrect; Either the URL does not specify a valid path…

  • The SharePoint Config log DB can grow quite large! The following way can help you shrink the config databases. But do only use these in test or development enviroments! SharePoint 2010 on SQL 2008 R2 Right click on you DB -> Properties Select Options Change the Recovery Model to SIMPLE and Click Ok Once that…

  • Problems when trying to open a SharePoint Document Library in explorer view from Windows? With errors like: “Your client does not support opening this list with Windows Explorer.” or in danish ”Klienten understøtter ikke åbning af denne liste med Windows Stifinder.” Explorer view uses the WebDav protocol to connect to SharePoint from the client. In…

  • If you get the following error when trying to run a search on a WSS site: Your search cannot be completed because this site is not assigned to an indexer. Contact your administrator for more information. or in danish Din søgning kan ikke fuldføres, da dette websted ikke er tildelt et indekseringsprogram. Kontakt administratoren for…