Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand

Archive for the ‘SharePoint 2010’ Category

Enterprise Keywords

Posted by Jean Paul on July 8, 2014

In this article we can learn about the Enterprise Keywords feature of SharePoint 2013. This feature was available in SharePoint 2010 as well.

What is Enterprise Keyword?

An enterprise keyword is a special site column that allows user terms to be stored in a non-hierarchical list. Typically this gets stored along with the Managed Metadata under pre-defined term set called keywords.

image image

What are the advantages of Enterprise Keywords?

Following are the major advantages of using enterprise keywords:

1. It enables Folksonomy

2. Users can submit new keywords

3. It is reusable across Tags and Notes

How to start using an Enterprise Keyword column?

Please follow the steps below to create an enterprise keyword column:

Step 1: Create a list

Create a list of type contacts.


Step 2: Add column

Choose List Settings & then the option Add column from existing Site Columns. In the appearing page scroll down to select the item Enterprise Keywords.


Save changes to the list.

Step 3: Create keyword

Now we are ready to enter data. Back in the list, choose New Item & enter information.

For the Enterprise Keywords column enter a new keyword like ‘business’.


Save changes.

Step 4: View keyword

You can see that the new keyword is being saved to the Keywords term set of managed metadata.

Open Site Actions > Site Settings > Term store management tool for viewing this.


This makes sure that the new keyword gets stored in the non-hierarchical Keywords term set.

Brining Managed Metadata Terms to Auto-Complete

We can also bring managed metadata terms into the Enterprise Keywords column for auto-completion.

For testing this create a site collection level terms using the term store management tool.


Now try entering an item for our list. Type the beginning character of the term. You can see the auto-completion takes place as shown below.


This ensures that the managed metadata terms are available in the enterprise keywords column. This would enable high reuse of the terms.


If you cannot see auto-completion happening, try re-creating your managed metadata service pointing to the same database.



In this article we have explored Enterprise Keywords column of SharePoint 2013.

Posted in SharePoint, SharePoint 2010, SharePoint 2013 | Tagged: , , | Leave a Comment »

Fiddler 2 is available now!

Posted by Jean Paul on May 8, 2014

Fiddler is a Free HTTP debugging tool.


You can download Fiddler from the following location:


Click on the Download button available there. You will get the following page.


You can download the Right Version according to your .Net installation.


You can run the setup file & after Installation, Fiddler looks like below:


How it works?

Fiddler adds a hook to the Windows WinINET and can interpret all HTTP communications passing through the computer.

Starting with Fiddler

For starting with you can clear the existing sessions.  Choose the Remove All option for it.


Now open a new browser & Enter


You can see that Fiddler automatically updates the requests.

Reading Request and Response

Double click on the first URL and you can see the right hand pane have 2 sections opened.


In cases of response text view is not showing textual data, You can click the yellow-ribbon to transform it.


After transforming the contents.


We can also use the View in Notepad button to open the content in notepad.

Essential Features

Following are the essential features of Fiddler:

  1. HTTP Statistics Observation
  2. Request scanning
  3. Response scanning
  4. Cookie Verification
  5. Multiple View support

More Features

Following are the additional features to explore with:

  1. Combined Instrumentation of Requests

Internet Troubleshooting Tip

In case if you experienced Internet Connectivity Issues while Fiddler have crashed, You can start another instance of Fiddler and Close it.  This will restore the connectivity as Fiddler Proxy will be safely removed only on closing.

Posted in SharePoint, SharePoint 2010, SharePoint 2013 | Tagged: , , | Leave a Comment »

How to Crawl another SharePoint site content?

Posted by Jean Paul on April 28, 2014

In this article I would take you through Crawling another SharePoint site content.  The second SharePoint site can be a 2010 or 2013 version.

When we require this?

We require this once we have distributed systems & Users required a unified location to search for all SharePoint content.


Please follow the steps below.  I am going to bring a SharePoint 2010 content into SharePoint 2013 system.

Step 1: Open Central Administration

Open your SharePoint 2013 Central Administration.  Choose Manage Service Applications > Search Service Application.


Step 2: Create Content Source

Click on the Content Sources link.


Choose the New Content Source link.


Enter the information for your new content source:

  • Name
  • Type
  • Address

After entering the details Save changes.

Step 3: Crawl

Choose the Start Full Crawl option.


Wait for the crawl to be completed.  Usually it takes 10 minutes for 100 GB data.  You can check the status of crawl periodically.


Step 4: Set Authentication

You might receive Crawl Errors if there is an Authentication Problem.


We need to create a Crawl Rule to specify credentials.  Click on the Crawl Rules link & Create a new Crawl Rule like below.


You need to specify a valid content crawling account & password.  If your site is Anonyumous, choose Anonymous access option.

After saving changes, start full crawl again.

Step 5: Test

Now you can search from your SharePoint 2013 system.  Try to use a SharePoint 2010 content title.



As SharePoint can understand the Metadata of the underling system, we can configure Managed Properties & Search Refiners on the crawled content.


In this article we have explored how to configure a content source to existing SharePoint system.  I hope this scenario would be useful in real-world scenarios.

Posted in SharePoint, SharePoint 2010, SharePoint 2013 | Tagged: | Leave a Comment »

Print button on InfoPath form

Posted by Jean Paul on March 26, 2014

In this article we can explore a real-life scenario to show a Print button on an InfoPath form in view/edit mode. You can also extend the solution to other list forms.

Why Print button needed on forms?

By default there is no print button on SharePoint forms.



Following are the steps needed to achieve the Print button solution. We are using HTML & JavaScript for the solution.

Step 1: Enable Modeless forms

By default the view/edit forms are opened in dialog forms. We need to change this to edit the page.

Choose List > List Settings > Advanced Settings


Set the last option to No.

Now you can see the View form is opened in full page mode.


Following is the Edit form.


Step 2: Edit Page

Open a list item in View Form, Choose the Site Actions > Edit Page option to bring the page to edit mode. Add a Content Editor Web part & enter the following HTML contents.

<input onclick=”window.print();” type=”button” value=”Print”/>


Click OK to save the changes. Choose Stop Editing from the page tab. The page will look like below.


We added a Print button which will invoke window.print() method on click.

Step 3: Test the page

Refresh the list & open a list item in View Page. Click on the Print button & you can see the Print Dialog appearing like below.


This confirms the print functionality integration. You can also repeat the same for Edit form.

Step 4: Enable back dialog

Now we need to enable back the dialog form. Go to List Settings > Advanced Settings & enable the Dialog option.


You can see the Print button there too.


The print() method prints the contents of the current window.

Custom Action

For having a custom action you can refer the solution below:




In this article we have explored a scenario of showing Print button on InfoPath forms.

Posted in SharePoint, SharePoint 2010, SharePoint 2013 | Tagged: , , , | Leave a Comment »

SharePoint Anti-Virus Configuration

Posted by Jean Paul on March 21, 2014

While working with SharePoint the Administrator may have to deal with Security Threat of virus-infected files.  The files uploaded can be infected & it can cause wide-spread across the network creating a bigger chaos of loss or productivity hours.

To tackle this problem, SharePoint provides Anti-Virus Configuration.

How to configure anti-virus?

Open Central Administration > Security tab.

You can see the Manage antivirus settings link in the appearing page.  Click on it.


On clicking the link, you will get the following page.


By default it will be unchecked.  Following are the options available:

Scan documents on upload will scan the documents on upload/save operation.

Scan documents on download will scan the documents on download operation

Allow users to download infected documents will allow users to download documents even if it is infected.  This is allowable if users have separate infrastructure to deal with infected documents.

Attempt to clean infected documents will try to clean the infected documents.

SharePoint Realtime Scan Job

Microsoft Forefront Security for SharePoint is the underlying component that performs the anti-virus functionality coupling with SharePoint.  The scanning operations will be implemented through Realtime scan jobs installed in the server.

We can configure the number of Threads  in the text box shown above.


Forefront Protection is discontinued after 2015, Please find the ant-virus alternatives for SharePoint using References section.



In this post we have gone through an overview of Antivirus Settings in SharePoint. 

Posted in SharePoint, SharePoint 2010, SharePoint 2013 | Tagged: , | Leave a Comment »

SPCOP – Another Need Tool

Posted by Jean Paul on March 17, 2014

SPCOP CE is a Visual Studio extension to analyze SharePoint code.

SharePoint Code Check Community Edition


We can analyze different SharePoint versions using it:

  1. MOSS 2007
  2. SharePoint 2010
  3. SharePoint 2013

It analyzes the following:

  1. Memory Dispose Check
  2. Features, Content Types, List Templates
  3. XML files
  4. ASPX, ASCX files

It also provides continuous integration facilities.


You can download the tool from:



Download & Install the tool. 


I am using Visual Studio 2012.  After installations restart Visual Studio.

We can do a simple testing to ensure it is working.


Create a new console SharePoint project & add a web part into it.

Inside the web part, please add the following code.

(Please note that we are not disposing the explicitly created SharePoint object)


Build the project & run SharePoint Code Check from the Solution Menu.


If successfully installed, you can see the Dispose error being caught.


This confirms you have SPCOP CE successfully installed.



In this post we have explored another need tool for SharePoint application development.  For advanced needs like verifying WSPs, there is a client tool available with higher editions.

Posted in SharePoint, SharePoint 2010, SharePoint 2013 | Tagged: , , , | Leave a Comment »

Activate Solution is Disabled (greyed out)

Posted by Jean Paul on March 17, 2014



Following are the solutions that we can try one-by-one:

  1. Restart Internet Explorer in Administrator Mode
  2. Ensure SharePoint User Code Host is running in Windows Services
  3. Ensure Microsoft SharePoint Foundation Sandboxed Code Service is started in Central Administration > Manage Services

Once applying the solution(s) the Activate button turned to be Enabled now. Great!!


Posted in SharePoint, SharePoint 2010 | Tagged: , , , , , , | 2 Comments »

Migration Template

Posted by Jean Paul on March 11, 2014

In the world of SharePoint, occasionally we need to work with other worlds too.

For example: Migration is such an area of work.


What is Migration?

Migration is the process of moving from one computing system to another.

For example Migration can be:

1. SharePoint older-version to SharePoint newer-version

2. Another CMS to SharePoint

3. SharePoint to Another CMS

4. SharePoint On Premise to SharePoint Online

What will be the Migration Steps?

Migration requires the following aspects:

1. Analyzing existing environment

2. Capturing migration elements

3. Creating a migration plan

4. Creating a target staging environment

5. Performing migration against staging environment

6. Analyze the readings

7. Optimize strategies

8. Declare migration dates to stake holders

9. Take production to offline

10. Perform final migration

11. Validate migration

12. Take production to online


Migration Template

Following are the screen shots of a Migration Template to capture information about source system. You are free to download it.


Screen shots from the template.





Please note that in a typical scenario, automated/manual migration happen from source to staging & then automated migration to production.

A good automation tool I can recommend is Sharegate. Spending for automation tool is worth if the no-tool cost is higher than tool-cost.



In this article we have explored migration overview and a shareable template.

Posted in SharePoint, SharePoint 2010 | Tagged: , , , | Leave a Comment »

Load Testing SharePoint 2013 Site

Posted by Jean Paul on March 4, 2014

In this article we can explore the offering of Visual Studio 2012 Ultimate for Load Testing a SharePoint 2013 site.

What is Load Testing?

Load testing is the process of putting demand on a system or device and measuring its response. 

For example, we can test a SharePoint Site by simulating a load of 100 users at the same time. We can measure the response, possible-errors to validate the load-capacity of the servers(s) and measure Performance, Scalability, Endurance and Volume.


Who Performs Load Testing?

Often load testing is performed by Automation Testers on a pre-configured test environment with same-topology of the production system.

What is the Configuration needed?

Often load testing is performed by Automation Testers on a pre-configured test environment with same-topology of the production system.

What we can infer from the results?

We can use the results for Capacity Validation for coming up with better Capacity Planning.

For example, if the expected response time is 3 seconds for 500 users / minute scenario, and the test result is showing 5 seconds, surely we need to optimize server (s) or change topology based on the bottle necks.

Load Testing helps us validating & improving performance yielding maximum-productivity from the system.

What is the version of Visual Studio 2012 required for Load Testing?

Visual Studio 2012 Ultimate is required for doing Load Testing.


You can get a trial download from here.

Simple Load Testing

To perform a simple load testing, please follow the steps below:

Step 1: Create new project

Create a new project of type Web Performance and Load Test Project


You will get the following screen.


Step 2: Start Recording

Recording is the process of teaching Visual Studio about our activity. The browser will be launched & the URL entry, mouse clicks, keyboard entries will be recorded. The recording will be used for play back later.

Click on the Start Recording button as highlighted above. You will get the following browser window.


Type the URL and enter credential information.

Step 3: Stop Recording

You can see the left pane logs all the requests for pages & scripts. Click the Stop button to stop recording. We are just testing a simple home page load scenario.


Visual Studio will try to find the dynamic parameters like text box entries. The dynamic parameters should be replaced with on-the-fly unique values to avoid duplication.


Time being we do not have any dynamic parameters. You should be getting similar results below in Visual Studio.


Step 4: Stop Recording

You can delete all the URLs except one.


Step 5: Add Loop

We are now adding a loop of 10 counts to the above test. Right click on the url node and choose the Add Loop option.


In the appearing dialog box choose Counting Loop and enter property as 10.


Click the OK button to save changes & you will see the new loop item as shown below.


We are going to try a loop of 10 times to ensure proper page response within 3 seconds.


Please note that 3 seconds is one standard-measure of page response time.

Step 6: Play Recording

Choose the Run Test option from the menu.


You can see the test will get executed 10 times & the result will be similar to below.


You can see that the average response time is less than 3 seconds. This concludes our simple test scenario.


The above is a simple test scenario. Once you gain confidence, you can go for higher levels like:

1. Opening list pages, clicking new item, entering data, clicking save, changing dynamic parameters

2. Testing against production-topology simulated environments

3. Testing with simulated user-volume

4. Passing Credentials

5. Using various load-testing options available in Visual Studio



In this article we have explored an overview of Simple Load Testing of SharePoint sites. I hope this will help you gain the grounds for advanced real world scenarios.

Posted in SharePoint, SharePoint 2010, SharePoint 2013 | Tagged: , , | Leave a Comment »

What is AlwaysOn in SQL Server?

Posted by Jean Paul on March 3, 2014

SQL Server 2012 introduced the new feature called AlwaysOn.

AlwaysOn provides High Availability & Disaster Recovery alternative to Database Mirroring.

What is Database Mirroring?

Database Mirroring is a technique to increase High Availability of database.  The topology consists of three server roles.

  1. Witness Server
  2. Principal Server
  3. Mirror Server 

Transaction Logs will be synchronized from Principal Server to Mirror Server.


The Witness Server determines whether to contact Principal or Mirror based on activity, thus increasing the availability.

Advantages of AlwaysOn over Database Mirroring

AlwaysOn provides the following advantages over Database Mirroring:

  1. More effective server utilization
  2. Less configuration hassles
  3. Better manageability
  4. Better failover situation
  5. Works best with multiple-database scenarios of SharePoint

More and More people are switching to AlwaysOn Availability Group technique.


AlwaysOn Experiment


Clustering, Mirroring, Log Shipping, AlwaysOn are different technologies to attain High Availability in database servers.

Posted in SharePoint, SharePoint 2010, SharePoint 2013, SQL Server | Tagged: , | Leave a Comment »