SharePoint Customization Examples

This SharePoint 2010 tutorial, we will discuss few SharePoint customization examples. We will discuss below things:

  • How to customize and edit SharePoint pages
  • Change ribbon background color in SharePoint 2010
  • Site menus are hidden behind content editor web part in SharePoint 2010
  • Site Actions Menu in SharePoint 2010
  • Cannot start service DCLoadBalancer14 on computer error in sharepoint 2010
  • Feature Stapling in SharePoint 2010
  • SharePoint 2010 web part pages do not show the left navigation
  • How to Change SharePoint 2010 Site Icon on Web Part Page
  • Custom web parts not getting displayed after deployment in sharepoint 2010
  • Change Site Theme in SharePoint 2010
  • How to rename SharePoint 2010/2013 Theme?
  • Upload Custom Theme in SharePoint 2010
  • Web Front End server (WFE) in SharePoint 2010
  • Application Pools in SharePoint 2010
  • Databases created at the time of installing SharePoint 2010
  • Cannot connect to database master at sql server SharePoint 2010
  • How to change the DocIcons in SharePoint 2010 Sites?
  • LayoutsPageBase and UnsecuredLayoutsPageBase in SharePoint 2010
  • Change name of All site content under Site in SharePoint 2010
  • Hide Personalize this page option in SharePoint 2010
  • The default term store for this site cannot be identified error in SharePoint 2010
  • Open documents in a web browser in SharePoint 2010
  • New Page option missing in SharePoint 2010
  • Cannot Run Microsoft SharePoint Foundation on this Page
  • The trial period for this product has expired error in SharePoint Server 2010
  • Configure site quota in SharePoint Server 2010
  • Hide attach file option from SharePoint custom list form
  • Hide column header in a SharePoint list web part
  • msoidcliL.dll file is missing error in SharePoint Online
  • Web Part Categories missing in SharePoint
  • Filter SharePoint list item without code and Open hyperlinks in new window
  • SharePoint 2013 MySite Not Provisioning
  • My Site document libraries improvements in SharePoint 2013
  • Add attachment field to Post list in SharePoint 2013 blog site
  • Display SharePoint Blogs posts from Blog site on Home page
  • Filtering blog site home page using custom column in post list for SharePoint
  • Sort and Group blog post in blog site home page using custom column in post list for SharePoint

SharePoint 2016 Tutorial Contents

How to customize and edit SharePoint pages

Now, we will see how to customize and edit SharePoint pages?

The new SharePoint ribbon experience enables you to quickly customize and edit SharePoint pages.Below are the steps to edit a SharePoint page.

Open your SharePoint site. Navigate to the home page of your site, and click All Site Content.

Click Create, On the Create Gallery page, click Page -> Web Part Page,and click Create.

Provide a name for the new Web part page (for example,Rajper), Leave the default options and click Create.

By default, SharePoint should open the page in Edit mode. If it doesn’t, click Site Actions -> Edit Page, which will open the page in Edit mode.

Click the top Web part Zone, and click “Add a webpart.” Select the “Media and Content” category, and then select Content Editor. SharePoint adds a Content Editor Web part for you in the top zone, and you can now add and edit text and images using the contextual ribbon.

Add some text and format it. When you have finished, click the Page tab on the ribbon and click Stop Editing to save your changes to the Web part.

Change ribbon background color in SharePoint 2010

Now, we will see how to change ribbon background color in SharePoint 2010.

We have to modify the s4-ribbon row CSS class to change the background color of the ribbon.

Basically, we have to overwrite the above CSS class.

#s4-ribbon row
{
background-color:#F5F90A !important;
}

In the SharePoint 2010 site master page, there will be a div with id with the name as “s4-ribbon row”. Once you deploy the CSS file then ribbon color will change.

Site menus are hidden behind content editor web part in SharePoint 2010

Issue: Site menus are hidden behind content editor web part.

Background: User added .swf file into content editor web part using iframe.

Code: Client had used the following code in the CEWP.

Site menus are hidden behind content editor web part sharepoint 2010

Troubleshooting: We tried with different parameters like visibility, position, z-index but none of them working but no success.

Resolution: You have to add the wmode attribute.

Site menus are hidden behind content editor web part sharepoint

Site Actions Menu in SharePoint 2010

Now, we will see the Site Actions menu in SharePoint 2010.

Site Actions menu is a very useful menu for navigation in SharePoint 2010. The navigation links will be visible according to the permission of the user who is logged in.

Site Actions menu is available to users who are members of the Site Members group in SharePoint Server 2010, But Site Visitors group and other groups that are restricted to Read Only permissions can’t see the Site Actions menu.

The navigation links are basically the administrative settings for the site and you can easily go to the Site Settings page with a single click.

You can view that from the left side of the page before the Edit icon of the page.

Some of the Navigation links are:

New Page: You can create a New Page through this link.

Edit Page: Through this link, you can edit the page. If you will click on Edit Page the page will open in Edit mode.

New Document Library: Through this page, you can create a new document library to store documents.

More Options: This option is used to create site objects like List, Library etc.

View All Site Content: These links open the View all site content page will open where you can able to see all the list, libraries, etc.

Edit In SharePoint Designer: Through this link, the page will open in SharePoint designer. You do not need to open SharePoint designer to edit a page from this link you can open the page. You can see some SharePoint 2010 designer articles here.

Site Permissions: Through this link, you can give access to people.

Site Settings: Through this navigation link you can visit the Site Settings page of the SharePoint 2010 site. Basically, you can access all settings for the site.

Cannot start service DCLoadBalancer14 on computer error in sharepoint 2010

We will see here, how to fix the issue Cannot start service DCLoadBalancer14 on the computer which comes while running SharePoint 2010 Product Configuration Wizard.

Recently while running the SharePoint 2010 Product Configuration Wizard from SharePoint central administration I got the below error:
“Failed to register SharePoint services. An exception of type
System.InvalidOperationException was thrown. Additional exception
information: Cannot start service DCLoadBalancer14 on the computer.”

I found the solution which works for me is to start the “Document Conversions Load Balancer for Microsoft SharePoint Server 2010” service.

So go to start -> Run and then type services.MSC and it will open the Services. Search for display name “Document Conversions Load Balancer for Microsoft SharePoint Server 2010” service and start the service.

But make sure you have the access rights and also make sure you have full admin rights in the local system.

Now, the error Cannot start service DCLoadBalancer14 on computer will not come in SharePoint 2010.

Feature Stapling in SharePoint 2010

What is Feature Stapling in SharePoint 2010? How can we use Feature Stapling in SharePoint 2010?

Feature Stapling is a very useful thing in SharePoint 2010. It is very useful if the site definition is already in use and some sites have been already created.

For example, suppose you want to a custom list to be created whenever you will create a site from Team site template. Or Suppose you want to a custom theme to all your sites then you can do all these by using Feature Stapling.

Feature Stapling has two features. A “Stapler” feature that staples another feature to the site definition and the “Staplee” feature which will be stapled.

So here, we need to create a feature and then we need to create a feature stapler and then we need to create a feature association xml file.
This feature association file will help us to associate the feature with the site definition.

Then we can deploy the whole solution.

Here one important point to remember is: Feature-stapling won’t affect any sites which have already been created from a site definition, only subsequent sites. The only way to do this is to activate your features individually on the site.

SharePoint 2010 web part pages do not show the left navigation

When you create a new web part page in SharePoint, its left navigation column becomes empty.

The reason for this is that the left side navigation is defined in the Master Page using “PlaceHolderLeftNavBar” content place holder and templates for Web Part Pages shipped with SharePoint overrides this content place holder and deletes its content, thus displaying empty left navigation.

The solution for this is to change the page so it will not override the menu place holder, but inherit it from Master Page.

The place holders we are interested in are:

There is this tag which needs to be deleted or commented (this one hides the left nav).

SharePoint 2010 web part pages do not show the left navigation

Delete only this tag as this is what overrides the default nav coming from the master page.

<asp:Contet ContentPlaceHolderID="PlaceHolderLeftNavBar" runat="server"></asp:Content>

Leave this tag as it is, if this is deleted(as said in other posts) it leaves a blank row on top the left nav which is not what you would want.

<asp:Contet ContentPlaceHolderID="PlaceHolderLeftNavSpacer" runat="server"></asp:Content>

Save the file. You will get a warning saying you are about to customize the page. Just go ahead and open that web part again. It should have that good left navigation.

How to Change SharePoint 2010 Site Icon on Web Part Page

This is a very common issue faced by 9 out of 10 SharePoint developers. The custom site Logo does not get reflected on the Web Part Page and hence the default logo is seen as shown in the screenshot:

SharePoint 2010 change site icon

NewTestPage (WebPartPage)

Steps to Change SharePoint 2010 Site Icon

Go to the Web part (NewTestPage) page, click on the “Page” tab at the top, click on the “Title Bar Properties” at the right (in the ribbon)

how to Change SharePoint 2010 Site Icon

In the Image Link section on the right, paste in the image URL

Change SharePoint 2010 Site Icon

Click OK Out Page: Web part Page:

How to Change SharePoint 2010 Site Icon on Web Part Page

This is how we can change SharePoint 2010 site icon.

Custom web parts not getting displayed after deployment in sharepoint 2010

If you have developed a custom web part using visual studio 2010 in SharePoint 2010, sometimes you will not see those web parts after deployment in the custom web part section. Here we will discuss how to resolve the issue.

If you are not able to see your custom web part under the Custom category then, one of the reasons might be because your web part feature might not be inactivated stage. To check this Go to SharePoint 2010 site, Site Actions -> Site Settings.

Then on the settings page, click on Site collection features under the Site Collection Administration section.

This will open the list of features page, search for your web part feature (custom one which you have created and deployed). If it has not been Activated, please Activate the feature and check now the web part should appear under the Custom category.

Change Site Theme in SharePoint 2010

Now, we will see how to change SharePoint 2010 site theme. Here we will change our SharePoint 2010 site theme.

To change SharePoint 2010 site theme go to Site Actions -> Site Settings as shown in the figure below:

how to change theme in sharepoint 2010 site

Next from the Look and Feel section Choose Site Theme as shown in the figure below:

how to change theme in sharepoint 2010

Then from the Site Theme page, you can select your theme as shown in the figure below and then click on Apply. Also here you can see the preview of your site and also there is an option to customize your theme from the Customize Theme section.

sharepoint 2010 change theme

How to rename SharePoint 2010/2013 Theme?

Now, we will discuss how to rename SharePoint Theme. Microsoft introduced theme in SharePoint 2010 version and by doing a few clicks you can change the font and color of your SharePoint site by just changing the theme of your SharePoint site.

In the same way, you can edit themes for SharePoint 2013, SharePoint 2010 or SharePoint Online.

Themes will help you to change most of the page elements of the SharePoint site like background images, text, and hyperlinks etc.

You can change the theme from the Site Settings -> Themes which comes under Web Designer Galleries if publishing feature is activated or if it is a publishing site.

There are 21 themes present in the Themes folder in SharePoint 2013/2010 site and the names are like: Azure, Berry, Bittersweet, Cay, Classsic etc. But we can be able to rename these names.

To rename Open your SharePoint site then go to Site Actions -> Site Settings.

Then from the Site Settings go to the Galleries section and click on Themes link as shown in the figure below:

how to rename theme in sharepoint 2010

The above link will open the list of Themes and from there click on the edit icon of which you want to rename as shown in the figure below.

sharepoint 2010 rename theme

This will open on Edit dialog box, Now in that dialog box Change the name and Description as shown in the figure below:

how to rename theme in sharepoint 2010

Then click on Save, that will rename the theme.

Upload Custom Theme in SharePoint 2010

I will strongly recommend reading this article on how to create a custom Theme in SharePoint 2010 before reading this article. In this article, we will discuss how we can use a custom theme made by using Microsoft office application in our SharePoint 2010 site.

Step-1:
Open SharePoint 2010 site using the browser.

Step-2:
Click on Site Actions and then Site Settings. This will open the site settings page.

Step-3:
From the Site Settings page Navigate to the Galleries section and click on Themes.

Step-4:
This will open the Theme home page.

Step-5:
From the ribbon, click the Documents tab and then click Upload Document. And browse the .thmx file that we have saved in a physical location as described in this article. Also, you can upload from the Add new item link presented below the list of Themes.

Step-6:
This will open the upload new item dialog box.

Step-7:
After that click on Save and our custom theme is saved and ready to use.

Step-8:
To use the Theme click Site Actions -> Site Settings. Then, under Look and Feel, click Site Theme. From the list of themes you can preview or use our custom theme.

Web Front End server (WFE) in SharePoint 2010

Now let us see, What is a Web Front End Server (WFE) in SharePoint 2010.

A web server handles the web page request from users and processes the request and returns the data. In a SharePoint farm, there can be multiple web front end (WFE) servers and have a Network load balancer that will be responsible to distribute the request between the front web servers.

But as the number of users grows you can add more WFE servers. Check one fig below:

Web Front End server (WFE) in SharePoint 2010

Application Pools in SharePoint 2010

Now, let us discuss various application pools in SharePoint 2010. There are six Application Pools in SharePoint 2010.

  1. SharePoint Web Services Root
    Identity: LocalService
    Status: Stopped
  2. SharePoint Central Administration v4
    Identity: SharePoint Farm Account
    Status: Started
  3. SharePoint Web Services System (which is named with a GUID)
    Identity: SharePoint Farm Account
    Status: Started
  4. SharePoint – 80
    Identity: SharePoint Services Account
    Status: Started
  5. SharePoint Web Services Default (which is named with a GUID)
    Identity: SharePoint Services Account
    Status: Started
  6. SecurityTokenServiceApplicationPool (which is named with a GUID)
    Identity: SharePoint Farm Account
    Status: Started

Databases created at the time of installing SharePoint 2010

Here are the databases created at the time of installing SharePoint 2010.

  • Secure Store database: The Secure Store service application database stores and maps credentials, such as account names and passwords. Prefixed with “Secure_Store_Service_DB_”.
  • State database: The State service application database stores temporary state information for InfoPath Forms Services, the Chart Web Part, and Visio Services. Prefixed with “StateService”.
  • Web Analytics Staging database: The Staging database temporarily stores un-aggregated fact data, asset metadata, and queued batch data for the Web Analytics service application. Prefixed with “WebAnalyticsServiceApplication_StagingDB_”
  • Web Analytics Reporting database: The Reporting database stores aggregated standard report tables, fact data aggregated by groups of sites, date and asset metadata, and diagnostics information for the Web Analytics service application. Prefixed with “WebAnalyticsServiceApplication_ReportingDB_”.
  • Search service application Administration database: The Administration database hosts the Search service application configuration and access control list (ACL), and best bets for the crawl component. This database is accessed for every user and administrative action. Prefixed with “Search_Service_Application_DB_”.
  • Search service application Crawl database: The Crawl database stores the state of the crawled data and the crawl history. Prefixed with “Search_Service_Application_CrawlStoreDB_’.
  • Search service application Property database: The Property database stores information that is associated with the crawled data, including properties, history, and crawl queues. Prefixed with “Search_Service_Application_PropertyStoreDB_”.
  • User Profile service application Profile database: The Profile database stores and manages users and associated information. It also stores information about a user’s social network in addition to memberships in distribution lists and sites. Prefixed with “User Profile Service Application_ProfileDB_”.
  • User Profile service application Synchronization database: The Synchronization database stores configuration and staging data for use when profile data is being synchronized with directory services such as Active Directory Prefixed with “User Profile Service Application_SyncDB_”.
  • User Profile service application Social Tagging database: The Social Tagging database stores social tags and notes created by users, along with their respective URLs. Prefixed with “User Profile Service Application_SocialDB_”.
  • Managed Metadata database: The Managed Metadata service application database stores managed metadata and syndicated content types. Prefixed with ” Managed Metadata Service_”.

Enterprise edition installation adds two more databases:

  • Performance Point service application database: The Performance Point service application database stores temporary objects, persisted filter values, and user comments. Name Prefix “PerformancePointServiceApplication_.”
  • Word Automation Services database: The Word Automation Services database stores information about pending and completed document conversions.Name Prefix “WordAutomationServices_…”

Cannot connect to database master at sql server SharePoint 2010

This error comes when you start the configuration wizard after the SharePoint installation. Majorly it comes when you give the database server name as local. The full error message was: “Cannot connect to database master at SQL Server at local. The database might not exist, or the current user does not have permission to connect to it.”

The error looks like below:

Cannot connect to database master at sql server SharePoint

There is a lot of reason behind the error. So you can try different solutions:

  • One reason may be your Firewall settings may block incoming traffic on SQL Server on default Port 1433. You can create a different rule if the firewall was blocking.
  • Check the credentials which you have giving in the wizard, wether that account has sufficient permission or not. This Farm account should be a memeber of SecurityAdmin and dbCreator role on sql server.
  • Or you can check wether SQL Server Browser service is stopped or disabled.
  • Also, you can configure SQL Server Alias Name for both 32 and 64-bit (SQL Native Client 11.0 Configuration).

How to change the DocIcons in SharePoint 2010 Sites?

Now, we will see how to change the DocIcons in SharePoint 2010 sites.

Follow below steps to change the DocIcons in SharePoint 2010.

Save your DocIcon image (.gif image) in the below location:

C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\TEMPLATE\IMAGES.

Then Open DOCICON.xml file from the below location:

C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\TEMPLATE\XML

This is the file where all the DocIcons has been registered for SharePoint sites.

Then add the below tag and save the file

"<Mapping Key="pdf" Value="pdf.gif"/>"

Remember: Changes to DOCICON.XML should be made with extreme caution because they are global to a Windows SharePoint Services deployment and affect all site definitions on the front-end Web server.

And also Changes that you make to this file may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.

LayoutsPageBase and UnsecuredLayoutsPageBase in SharePoint 2010

Now, let us discuss LayoutsPageBase and UnsecuredLayoutsPageBase in SharePoint 2010.

If you are creating an application page (such as a custom sign in page or a custom error page), then it will create a page that inherits from the LayoutsPageBase class.

If a page will be derived from LayoutsPageBase class then it will have restricted access. Pages derived from LayoutsPageBase class should always reside in the _layouts folder.

For pages to which even unauthenticated users should have access, use the parent class UnsecuredLayoutsPageBase.

According to MSDN In general, use LayoutsPageBase as a base class for pages that should only be accessible to authenticated users with certain rights. For pages to which even unauthenticated users should have access, use the parent class UnsecuredLayoutsPageBase.

Change name of All site content under Site in SharePoint 2010

Now, we will see how to change the name of all site content under the site in SharePoint 2010.

Go to the SharePoint 2010 site where you want to change the name of the site content. and see by default name of All Site Content (See in fig).

Change name of All site content sharepoint

In this site add the Content Editor Web Part in page.( See in Fig.)

Change name of All site content sharepoint 2010

Now edit that Web Part and click on Click here to add new content.

After this On Ribbon under Editing tools click on HTML like shown in fig.

sharepoint 2010 Change name of All site content

After this one popup window is open. Under this window add the following code.

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js" type="text/javascript"></script>
 <script>
 $(document).ready(function()
 {
  $('.ms-splinkbutton-text').each(function(i){ $(this).text($(this).text().replace('All Site   Content','My  Custom Content Name'))
  })
  })
  </script>

Click on save and ok. Now see the changes in replace of All site content is My Custom Content Name like see in fig.

sharepoint 2010 Change name of All site content using javascript

This is how we can change the name of All site content under Site in SharePoint 2010 using JavaScript.

Hide Personalize this page option in SharePoint 2010

Now, we will see how to hide “Personalize this Page” option from the right side menu in SharePoint 2010.

SharePoint allows you to create a personalized version of a web part page. This means you can add/remove web parts or modify some web part properties that allow personalization changes.

The “Personalize this Page” option come like below:

Hide Personalize this page option in SharePoint 2010

Follow below steps to hide:

Open SharePoint 2010 central administration -> Web Applications. Then select the web application you want to apply changes. (Here this changes will apply to the full web application) And then from the Ribbon click on User Permissions as shown in the fig below:

Hide Personalize this page option in SharePoint

Scroll to the bottom of the list of options and observe the last two. Clear the options “Add/Remove Personal Web Parts” and “Update Personal Web Parts” to to prevent the user personalizing the web part page as shown in the fig below:

SharePoint 2010 Hide Personalize this page option

Now the user cannot personalize the page.

SharePoint Hide Personalize this page option

This is how we can hide Personalize this page option in SharePoint 2010.

The default termstore for this site cannot be identified error in SharePoint 2010

I got this error while trying to create a local term set in SharePoint 2010. The full error message is “The default term store for this site cannot be identified error”.

Follow the below steps to fix error The default termstore for this site cannot be identified:

Open SharePoint 2010 central administration. Then navigate to Manage Service Applications under Application Management section.

After that select the Managed Metadata Service Application that you have created. Then click on the Service connection. And then select Properties from the Ribbon.

There in the Edit Managed Metadata Service Connection dialog box. Enable the This service application is the default storage location for column specific term sets option checkbox. And then click on Ok.

Open documents in a web browser in SharePoint 2010

Now, we will see how to open pdf documents in a web browser in SharePoint 2010.

By default when you open a pdf document it will ask a dialog box to save or cancel the document. But if you want to open the document in the browser directly then we need to do some change in the central administration and also you can do this by using PowerShell.

Open SharePoint 2010 Central Administration, then from the Application Management section click on Manage web applications.

Then from the Web Applications page, Select the particular web application and from the Ribbon select General Settings as shown in the fig below:

Open pdf documents in web browser in SharePoint 2010

Then from the General Settings page, Navigate to the Browser File Handling section. Here there are 2 options:

  • Permissive: Permissive Specifies no headers are added, which provides a more compatible user experience.
  • Strict: Strict adds headers that force the browser to download certain types of files. The forced download improves security for the server by disallowing the automatic execution of Web content that contributors upload.

By default Strict option is enabled, Change to Permissive as shown in the fig below.

Open pdf documents in web browser in SharePoint

Now it should work. Now the pdf file should open in the browser.

We can also enable settings to open PDF file through browser through PowerShell:

$webApp = Get-SPWebApplication http://WebAppURL
$webApp.BrowserFileHandling = “permissive”
$webApp.update()

This is how we can open any documents in web browser in SharePoint 2010.

New Page option missing in SharePoint 2010

In this SharePoint 2010 tutorial, we will discuss how to solve “New Page” option missing under Site Actions in SharePoint 2010.

Suppose you have created a site using the Blank Site template, then you will not find the Create New Page option under site settings in SharePoint 2010 site. In this post, we will discuss this solution.

Check the fig below, the Create New Page is not coming under the Site Actions menu because we have created the site using Blank Template.

SharePoint 2010 New Page option missing

To bring the New Page option under Site Actions menu we need to activate 2 features:

  • SharePoint Server Enterprise Site features
  • SharePoint Server Publishing

To activate the above 2 features follow the below steps:

Open SharePoint 2010 site and Go to Site Actions -> Site Settings

This will open the Site Settings page. From the Site Settings page go to the Site Actions section and click on Manage Site Features.

This will open the list of features, Search for both the features and then click on Activate like below:

New Page option missing in SharePoint

Once both the features activated, the New Page option will appear below in the SharePoint 2010 site.

New Page option missing in SharePoint 2010

This is how New Page option will appear in SharePoint 2010 site.

Cannot Run Microsoft SharePoint Foundation on this Page

While uploading multiple documents in a document library, there is an issue comes as “Cannot run Microsoft SharePoint Foundation on this page”.

Follow below steps to fix error: Cannot Run Microsoft SharePoint Foundation on this Page:

Take a copy of upload.aspx in layouts folder.

Look out for the following tag

<input TYPE="hidden" NAME="_charset_" VALUE="utf-8">

Update the following string as follows

<input TYPE="hidden" NAME="Cmd" VALUE="Save">

Save your file and do an IISReset.

The trial period for this product has expired error in SharePoint Server 2010

Now, we will see how to fix error: The trial period for this product has expired which comes in SharePoint server 2010.

You can check the fig below for the full error message:

The trial period for this product has expired SharePoint Server 2010

In this case there is following three things happened

  • My SharePoint is trailed one and it was expired.
  • Problem with my Central Administrator Application pool Account.
  • Problem with my registry.

Following the step for solving the issue:

My SharePoint is trailed one and it was expired

In this case no any solution. There is only one way to solve that problem and the way is get licensed version of SharePoint.

Problem with my Central Administrator Application pool Account Go to iis manager. Check the central administration site application pool account. It was running with Network Credentials. Account that are running application pool need to be in the local administrator group. So I just changed the application pool account to Administrator.

For this follow these steps:

  • Go to Run and type inetmgr.
  • After this select your Application Pools like SharePoint Central Administrator
  • Now in right side click on Advance Settings
  • See Identity and change the account.
  • You can also add the current application pool identity account to local Administrator group
  • Run “iisreset” from Command prompt.

Problem with my registry

Still you have same issue, there might be some share point secure sources not configured correctly. You need to run “SharePoint Configuration wizard” or run “psconfig.exe -cmd secureresources” command from the path “c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\bin\ psconfig.exe -cmd secureresources”

Configure site quota in SharePoint Server 2010

Now we will see, how to configure site quotas in SharePoint Server 2010.

Quotas and locks are two methods of controlling access to site collections. By employing the use of locks, site administrators can manually prevent user access.

Quotas are used to prevent users from adding content to a site collection or provide e-mail warning notification to the site collection administrator when specified limits on disk space are passed.

It is also possible to create and edit site quota templates that you can use during site creation

To configure SharePoint site quotas, follow these steps:

From the Application Management page of the Central Administration site, click Configure quotas and locks under the Site Collections section.

Choose the site collection to configure from the drop-down list in the Site Collection section.

In the Site Lock Information section, choose the desired level of access to the chosen site collection, as shown in Figure.

Configure site quota in SharePoint Server 2010

In the Site Quota Information section, choose the quota template you want to modify, and then select one or both of the following:

  • Check the Limit site storage to a maximum of the box, and then enter the amount of disk space in megabytes (MB).
  • Check the Send warning e-mail when site storage reaches the box, and then enter the amount of disk space in megabytes (MB).
  • Enter the amount of usage points per day for sandboxed solutions.

How to hide column header in a SharePoint list web part?

Now, we will see how to hide column header in a SharePoint 2010 list web part using a stylesheet.

Add Content editor web part in the page where you want to hide the column header in list web part.

Edit the content editor web part and add the following code under the Ribbon menu insert and click on HTML.

<style>
.ms-viewheadertr { display: none;}
</style>

Save and check it

Hide attach file from SharePoint custom list form

Now, we will see how to hide attach file option from SharePoint 2010/2013 custom list.

Suppose we are developing a SharePoint custom list, and there are certain cases where we do not need the attachment option. Usually that comes as a button while Adding a list item or updating a list item in the form.

But we can disable that button from list settings page.

First Open the Custom list in browser and from the ribbon from List Tools tab click on List and then go to the List Settings from the right-hand side of the Ribbon. This will open the list settings page.

From the List Settings page go to the General Settings section and click on Advanced settings. This will open the Advanced settings page for the custom list.

From this page see the Attachments section and select the Disabled Radio button.

This will disable the Attach file button. Now you can add or edit one list item, you will not get the Attach file button in the input form.

This is how we can hide attach file from SharePoint custom list form.

msoidcliL.dll file is missing error in SharePoint Online

This tutorial, we will discuss how to fix error msoidcliL.dll file is missing which sometimes you will get while working in SharePoint online office 365.

If you are working in SharePoint online (Office 365) and trying to authenticate SharePoint using SharePointOnlineCredentials, sometimes you may get the error saying the soidcliL.dll file is missing.

We have to use SharePointOnlineCredentials object if we are trying to authenticate in Office 365 (SharePoint Online) using ClientContext.

Here if you got the above error then first check whether the msoidcliL.dll exists in the directory C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\Client.

If it is not presented then download the SharePoint Server 2013 Client Components SDK from this MSDN URL and install it.

Now it should work fine.

Here, we learned how to fix error msoidcliL.dll file is missing which comes in SharePoint 2013/2016 or SharePoint Online.

Web Part Categories missing in SharePoint

Sometimes if you will click on Add a web part link then you may not see web part categories even if you have full control to the site where you want to add a web part.

When you edit the page and try to add by clicking on the Add a web part link, you may not see the web part categories even if you have full control.

If you are working in SharePoint 2010, then you may see only lists and libraries. And if you are working in SharePoint 2013, then you may see only the Apps category.

There might be a possibility is that You are probably working in a subsite and do not have read access to the top-level site in the site collection. You will need at least read access to the top-level site’s web part gallery.

If you grant Read rights to the Web Parts Gallery of the top-level site to the subsite owners then all of the web parts in the gallery can be seen in the Add Web Part popup of the subsite.

So if due to some restrictions you will not be able to give access to the parent site, then grant rights to the Web Part Gallery only. After this when the user will click on Add a web part, the user will be able to see all the web part categories.

Filter SharePoint list item without code and Open hyperlinks in new window

Hi Friends In this post we will discuss how to filter SharePoint list item without code and Open hyperlinks in a new window.

1. To Display hyperlink in a new window on click

Step-1: Go to Site Settings -> Site Columns and click Create

Step-2: Insert a name and choose “Hyperlink with formatting and constraints for publishing” as type.

Step-3: Go to your list and add a column (existing column)

Step-4: Go to your list and add a new Item.

Then click on “Click to add a new hyperlink” and add your favorite link:
Now you see the options:

  • Open the link in a New Window
  • Display an icon next to the link
  • Choose a display text
  • Choose a tooltip

2. Filter data without code in SharePoint list view web part

To filter list items using a specific field name and field value.

Step-1: Place SharePoint list view webpart in a page

Step-2: Pass query string in the page with field name and field values

Step-3: Form URL like this: http://sharepointsite.com/lists/Allitems.aspx?FilterField1=CountryName&FilterValue1=india
Automatically list item filter with giving values passed in the query string

SharePoint 2013 MySite Not Provisioning

We will discuss one of the wired issue happened to me during SharePoint migration (from 2010 to 2013). On SharePoint portal, some users (mainly users that don’t have MySite) are not able to follow sites.

For instance, when a user, e.g. Test1 clicks on “Follow” link on any SharePoint site, he/she will be redirected to the Newsfeed page of the user with page content “We’re almost ready!”.

However, the user will never see his Newsfeed page with the sites that he/she is following.

The error was coming because Self-Service Site Creation was not enabled on the MySite host web application.

My Site document libraries improvements in SharePoint 2013

Now, we will see My Site document libraries improvements in SharePoint 2013.

  • In SharePoint 2010, My Site has 2 document libraries- Personal and Shared. Items stored in the personal document library were restricted to the My Site owner, and items in the shared document library were shared with everyone.
  • But in SharePoint 2013, My Sites include several improvements to saving, synchronization, sharing, and moving of content. These improvements make My Sites a more robust solution for users to store and work with files in the SharePoint environment.
  • In SharePoint 2013, When deployed, a user’s My Site document library is the default save location for files saved from Office 2013 client applications. A discovery service identifies the user’s My Site URL and offers it as the default location in addition to other locations available for saving files. This promotes the workflow of storing files in the user’s My Site document library where items can be managed, governed, shared, and moved. This helps reduce the amount of content that is stored in other systems, such as in email or on personal drives.
  • Also, Users have the option to synchronize their My Site document library content with a local drive to enable offline access to documents.
  • SharePoint Server 2013 introduces the concept of sharing for all document libraries. By default, all content that is stored in a user’s My Site document library is restricted to the user, and other users cannot see content unless it is shared with them. If the user wants others to collaborate on a piece of content in that library, the user can share the content with specific users or groups and select the permission those users or groups have to the content.
  • My Sites include a sharing hint, which displays all the users and the permissions for a specific piece of content. This makes it easier for users to see at a glance what they are sharing and with whom.

Add attachment field to Post list in SharePoint 2013 blog site

Now, we will discuss how we can add an attachment field to the Post list in SharePoint 2013 blog site. Before proceeding you can check out this article to know more about how to create a blog site in SharePoint 2013.

Open your site and Click on manage post from the right side from home page.

Add attachment field to Post list in SharePoint 2013 blog site

Click on List tab from ribbon and then expand form web part, Now click on the default new form as shown in the fig below.

Add attachment field to Post list in SharePoint 2010 blog site

It shows the page in add mode. Here click on the Add web part, then it will show the page to add the web part. From the categories, choose media content and then choose content editor web part and click add as shown in the fig below:

Add attachment field to Post list in SharePoint blog site

Now your content editor web part is added. Click inside the web part and from the ribbon choose edit source. Then add the following code to the edit source dialog box and click ok.

<div>
  <a title="Attach File" class="ms-toolbar" accesskey="I" onclick="javascript:UploadAttachment();" href="javascript:UploadAttachment()">
     <img width="16″ height="16″ align="absMiddle" alt="Attach File" src="/_layouts/images/attachtb.gif" style="border-width: 0px;"/> </a>
  <a id="ctl00_m_g_7df5d998_1390_4e67_8fc4_2da066cbcf7d_ctl00_ctl01_ctl00_toolBarTbl_RptControls_diidIOAttach{generate-id()}" href="javascript:UploadAttachment()" style="visibility: hidden;"> </a>
  <a class="ms-toolbar" id="ctl00_m_g_7df5d998_1390_4e67_8fc4_2da066cbcf7d_ctl00_ctl01_ctl00_toolBarTbl_RptControls_diidIOAttach_LinkText" accesskey="I" onclick="javascript:UploadAttachment();" href="javascript:UploadAttachment()">Attach File</a> </div>

Now click on the page tab and click on stop editing page from the ribbon. Now see the effect as one attachment control is added to the new form as shown in the fig below:

how to add attachment field to Post list in SharePoint blog site

Display SharePoint Blogs posts from Blog site on Home page

Now, we will discuss how to display SharePoint blogs posts from the Blog site on a SharePoint Online 2013 homepage using the content query web part.

First, we create the blog site in your site collection. Now we want to show this blog on our SharePoint Online 2013 homepage. For this, we add the Content Query Web Part to my home page. See in fig

 Display SharePoint Blogs posts from Blog site on a SharePoint Online 2013 Homepage
Display SharePoint Blogs posts from Blog site on a SharePoint Online 2013 Homepage

Now we edit this web part. See in fig

 Display SharePoint Blogs posts from Blog site on a SharePoint Online 2016 Homepage
Display SharePoint Blogs posts from Blog site on a SharePoint Online 2016 Homepage

Now we expand the Query from edit web part properties. See in fig

 Display SharePoint Blogs posts from Blog site on a SharePoint Online 2010 Homepage
Display SharePoint Blogs posts from Blog site on a SharePoint Online 2010 Homepage

Here three option is available:

  • Show items from all sites in this site collection
  • Show items from the following site and all subsites
  • Show items from the following list

As our requirement, we want to show a blog post from a blog site. So for this, we choose the third option, Show item from the following list and click on Browse…. See in fig

 Display SharePoint Blogs posts from Blog site on a SharePoint Online 2013 Homepage
Display SharePoint Blogs posts from Blog site on a SharePoint Online 2013 Homepage

After clicking on Browse… there is one wizard come, here I select my blog site, under this, I selected the Posts list. See fig. Click OK

sharepoint blog site examples
SharePoint blog site examples

Here filter option is also there If we want to filter then click on additional Filter. See in fig

sharepoint 2013 blog site
SharePoint 2013 blog site

Now click on Apply and OK in Edit web part properties. Save the page and see our blog post in our SharePoint online 2013 homepage. See in fig

sharepoint 2016 blog template
SharePoint 2016 blog template

Filtering blog site home page using custom column in post list for SharePoint

Now, we will discuss how to filter blog site home page using a custom column in the Post list in SharePoint 2010. Here I created many blogs. Now I want to filter that blog using a custom column.

For achieving this follow these steps:

Create the custom column in post list, I gave the name is Order by. See in fig

Filtering sharepoint blog site home page

Now open your blog site in SharePoint designer 2010. Edit the home page of your blog site. See in fig

Filtering sharepoint blog site home page

Now click on dispel mode. See in fig

Filtering blog site home page using custom column in post list for SharePoint 2010

Now, you able to see List view Tools in Ribbon. Click on Filter. See in fig

Filtering blog site home page using custom column in post list for SharePoint

Now add the filter criteria, for this Click here to add a new clause. See in fig

Filtering blog site home page using custom column in post list for SharePoint 2010

Here select your column name and give the value, you want to filter. See in fig

Filtering blog site home page using custom column in post list for SharePoint 2013

Now save and refresh your site in a browser. You are able to see as your filter post.

Sort and Group blog post in blog site home page using custom column in post list for SharePoint

Now, we will discuss how to sort and group the blog post in blog site home page using a custom column in post list for SharePoint.

Here I created the many blogs. Now I want to Sort my blog post using a custom column. For achieving this follow these steps:

Create the custom column in post list, I gave the name is Order by. See in fig

Sort and Group blog post in sharepoint 2010 blog site home

Now open your blog site in SharePoint designer 2010. Edit homepage of your blog site. See in fig

how to Sort and Group blog post in sharepoint blog site home

Now click on display mode. See in fig

sharepoint blog site home page sort and group blog post

Now, you able to see List view Tools in Ribbon. Click on Sort & Group. See in fig

sharepoint 2010 blog site home page sort and group blog post

Here select your column name and Add for Sort order, you also choose Sort Properties like Ascending or Descending. See in fig I selected my custom column Order by

sharepoint 2013 blog site home page sort and group blog post

Now save and refresh your site in the browser. You able to see on Sort post.

Here, we learned how to sort blog posts in SharePoint 2010 blog site home page using a custom column.

Change the default language in SharePoint 2010

Now, let us see how to change the default language in SharePoint 2010.

Just to let you once you will finish installing language packs then you will get the option to choose the default language for your SharePoint 2010 site. If you do not have the language pack installed then the only language will be selected.

Once your language pack successfully installed, Click on the Select Display Language from the Top welcome menu. And according to your language packs, it will show you the list of all languages to change.

Once you will select your default language then you can go to Site Actions and the Site Settings and from the Site Settings page go to the Site Administration section choose Language Settings.

In the Language Settings page, you will be able to see the default language that you have selected and the optional languages.

You may like following SharePoint tutorials:

We learned below SharePoint customization things:

  • How to customize and edit SharePoint pages
  • Change ribbon background color in SharePoint 2010
  • Site menus are hidden behind content editor web part in SharePoint 2010
  • Site Actions Menu in SharePoint 2010
  • Cannot start service DCLoadBalancer14 on computer error in sharepoint 2010
  • Feature Stapling in SharePoint 2010
  • SharePoint 2010 web part pages do not show the left navigation
  • How to Change SharePoint 2010 Site Icon on Web Part Page
  • Custom web parts not getting displayed after deployment in sharepoint 2010
  • Change Site Theme in SharePoint 2010
  • How to rename SharePoint 2010/2013 Theme?
  • Upload Custom Theme in SharePoint 2010
  • Web Front End server (WFE) in SharePoint 2010
  • Application Pools in SharePoint 2010
  • Databases created at the time of installing SharePoint 2010
  • Cannot connect to database master at sql server SharePoint 2010
  • How to change the DocIcons in SharePoint 2010 Sites?
  • LayoutsPageBase and UnsecuredLayoutsPageBase in SharePoint 2010
  • Change name of All site content under Site in SharePoint 2010
  • Hide Personalize this page option in SharePoint 2010
  • The default termstore for this site cannot be identified error in SharePoint 2010
  • Open documents in a web browser in SharePoint 2010
  • New Page option missing in SharePoint 2010
  • Cannot Run Microsoft SharePoint Foundation on this Page
  • The trial period for this product has expired error in SharePoint Server 2010
  • Configure site quota in SharePoint Server 2010
  • Hide column header in a SharePoint list web part
  • Hide attach file option from SharePoint custom list form
  • msoidcliL.dll file is missing error in SharePoint Online
  • Web Part Categories missing in SharePoint
  • Filter SharePoint list item without code and Open hyperlinks in new window
  • SharePoint 2013 MySite Not Provisioning
  • My Site document libraries improvements in SharePoint 2013
  • Add attachment field to Post list in SharePoint 2013 blog site
  • Display SharePoint Blogs posts from Blog site on Home page
  • Filtering blog site home page using custom column in post list for SharePoint
  • Sort and Group blog post in blog site home page using custom column in post list for SharePoint
Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

>