Jean Paul's Blog

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

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

Archive for August, 2012

SharePoint 2010 – Create SSL enabled Site

Posted by Paul on August 15, 2012

As part of development activities we might need to create SSL enabled site inside SharePoint 2010. These sites will be accessed using https instead of http.

For example:

clip_image001

HTTPS is the secured way of communication between server and client. Here the message is encrypted between client and server. An encryption mechanism is needed protect the message from being manipulated by unwanted parties.

HTTPS works by installing a certificate in the server side web application. This certificate is used to encrypt the messages between client and server. The encryption is based on a public key and private key usage. The public key will be shared with client for encrypting the message and the decryption is performed on the server side using the private key.

Note: Stealing the public key does not do any favour in decrypting the message using Man In the Middle attack as Public key can only be used for encryption.

Please following the steps given below to create a new SSL enabled SharePoint site.

Step 1: Create New Web Application

Go to Central Administration and open the Manage Web Applications link. Create a new Web Application with the following properties:

1. Name as My Secured Site

2. Use Secured Sockets Layer (SSL) Yes

clip_image003

clip_image004

Click the OK button to create the new web application.

Now add a new site collection inside the newly created web application.

Central Administration > Create Sitecollection > Choose current web application

Step 2: Set the Certificate

For SSL enabling you need to specify a Certificate in the Server which contains the public and private keys. Go to Internet Information Services (IIS / inetmgr.exe) and select the newly created site. Click on the Bindings link from the right side.

clip_image006

In the appearing dialog select the https item and click the Edit button.

clip_image007

In the appearing dialog select the Certificate from drop down list.

clip_image008

Click the OK button to continue.


Step 3: Test the url

Now you are ready to test the HTTPS url. Open a browser and enter the url of the web site. You can also you the Browse link from IIS.

You will get the page as shown below. It says the certificate is not trusted one. You can use the Continue link to proceed with.

clip_image010

Now you should be prompted with the site credentials. Enter the credentials to continue and you should get the site collection which you have created.

clip_image012

Wow! If you can see the above site then you are done with your SSL enabled site. Please note that the url now starts with https

Adding SSL (https) support to an existing web application

You can add SSL support to an existing web application by performing the following:

1. Open IIS manager

2. Select the web application

3. Choose Bindings dialog

4. Add new binding of type https

5. Select the Certificate

6. Click the OK button

References

MSDN on SharePoint SSL

SSL, Public Key, Private Key

Summary

In this article we have seen how to enable SSL on a SharePoint site. I hope you were able to create a successful SSL enable SharePoint site.

Advertisements

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

ERROR: ‘New Document’ requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the ‘Upload Document’ button.

Posted by Paul on August 15, 2012

Server: SharePoint 2010

Client: Windows 7 64 bit, Internet Explorer 8 32 bit, Microsoft Office 2010 64 bit

image

If you face the above error please following the solutions below:

Client Side Solution

Ensure the following as per the link given below:

http://jeanpaulva.com/2012/08/14/sharepoint-2010-document-library-enable-new-document-feature/

Server Side Solution

Ensure you have valid entries inside DOCICON.XML

Folder: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML\DOCICON.XML

image

This file handles the icon, open ActiveX command for the file extensions like .dotx, .docx etc.

more info: http://msdn.microsoft.com/en-us/library/ms463701.aspx

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

SharePoint 2010 Document Library – Enable New Document feature

Posted by Paul on August 14, 2012

In this article we can explore what are the underlying aspects involved for enabling the New Document feature in a Document Library.

clip_image002

The expected case on clicking the above button is to create a new document inside MS Office client in the local machine. The template of the particular document is fetched from the configured one for Document Library.

We are using the following environment:

§ SharePoint 2010

§ Windows 7 64 bit

§ Office 2010

§ Internet Explorer 8

While using the command some of you might have faced the problem with this dialog box:

clip_image004

The error message says: ‘New Document’ requires a Microsoft SharePoint Foundation-compatible application and web browser.

Now let us go some levels deep to see what is happening in the hood. Following are the infrastructure elements required to make it work as expected.

Element 1: Compatible Browser Version

You have to ensure that the right version and bit of Browser is being used. The 32 bit version of Internet Explorer is compatible with this feature.

You can check the version from Browser > Help Button > About Internet Explorer menu item.

clip_image006

Note: The default iexplore command executed from Run window opens the IE 32 bit version.


 

Element 2: Compatible Office Version

– SharePoint 2010 is best compatible with Office 2010

– SharePoint 2007 is best compatible with Office 2007

Ensure that the client machine is having a compatible Microsoft Office version installed.

clip_image008


 

Element 3: Microsoft SharePoint Foundation Support in Office

You have to ensure the Microsoft Office installed has the following feature:

Microsoft Office > Office Tools > Microsoft SharePoint Foundation Support

clip_image010

If the above feature is not installed (Run from My Computer) you need to fix this.

Following are the steps to fix this:

1. Go to Control Panel

2. Choose Programs and Features

3. Select Microsoft Office 2010

4. Choose Change option and Add / Remove features

5. Ensure the above option is selected as Run from My computer

6. Execute the installation


 

Element 4: Internet Explorer ActiveX Control

Additionally the ‘New Document’ feature inside Internet Explorer works by launching a 64-bit Active X control. You can verify this control is enabled inside Internet Explorer. Please follow the following steps to verify it.

Open Internet Explorer and choose Tools > Internet Options window. Go to the tab Programs and click on the Manage add-ons button as shown below:

clip_image012

In the appearing window choose All add-ons as shown below:

clip_image014

Once the list on the right hand side is refreshed, sort the list based on Publisher column and locate the item named SharePoint OpenDocuments Class as shown below.

clip_image016

Ensure the version is 14.0 and it is enabled (If you can see the Disable button it shows it is enabled)

Testing the New Document feature

Now everything is ensured we can test the above feature. Open the SharePoint site, go to a library, select the Documents tab and click on the New Document button.

clip_image002[1]

You will be getting a dialog similar to this:

clip_image018

The warning is happening because the template.dotx will be opened by Microsoft Word application locally. This may induce any security threats if the source of the document is not valid. Click the OK button to continue.

You can see the new document is created inside Microsoft Word as shown below:

clip_image020

This concludes our research with New Document feature enabling and usage with compatible browser and Office application. The same aspects are to be ensured while working with Edit document feature from the client side.

Advanced Settings

Inside the Library Settings you can change the following:

– Default Template

– Add multiple content type templates

– Change the document open behaviour in client side

References

Fiddler and User Agent

Summary

In this article we have explored the underlying aspects to make New Document feature work in client side.

 

If the above solutions did not worked for you you can switch to the server side solutions using following link:

http://jeanpaulva.com/2012/08/15/error-new-document-requires-a-microsoft-sharepoint-foundation-compatible-application-and-web-browser-to-add-a-document-to-this-document-library-click-the-upload-document-button/

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

SharePoint 2013 Installation on Windows Server 2012

Posted by Paul on August 14, 2012

You might have already known that Microsoft announced the preview version of SharePoint 2013 (aka SharePoint 15) last month. In this article I would like to give an overview of the Installation of the same on a Windows Server 2012 machine.

clip_image002

Download

Please note that there are 2 versions to download:

· SharePoint Foundation 2013

· SharePoint Server 2013

Choose the version which you required:

· SharePoint Foundation 2013 (1 GB) Download

clip_image004

· SharePoint Server 2013 (2 GB) Download

clip_image006

Please note that the file is in Image (.img) format. You need an Image File Extractor to extract and run the setup. Following is the link for an Image File Extractor. (http://www.winimage.com/)

No Client Operating System Installation

The Client Operating Systems like Windows 7 / Vista etc. are not supported in the SharePoint 2013 version. So you might require one of the following for installing:

· Windows Server 2012 R2

· Windows Server 2008

· Windows 8 Hyper V virtual machine

Pre-Requisites

Following are the prerequisites for SharePoint Foundation 2013

• Microsoft .NET Framework 4.5

• Windows Management Framework 3.0 (CTP2)

• Application Server Role, Web Server (IIS) Role

• Microsoft SQL Server 2008 R2 SP1 Native Client

• Windows Identity Foundation (KB974405)

• Microsoft Sync Framework Runtime v1.0 SP1 (x64)

• Windows Server AppFabric

• Microsoft Identity Extensions

• Microsoft Information Protection and Control Client

• Microsoft WCF Data Services 5.0

• Cumulative Update Package 1 for Microsoft AppFabric 1.1 for Windows Server (KB2671763)

You can install the pre-requisites using the Install software prerequisites option from the main screen. In case of internet connection unavailable, then download & install would be possible.

Windows Server 2012

For the installation I have used Windows Server 2012 R2 trial version. If you already have a server operating system installed you can skip this step and proceed directly with SharePoint 2013 Installation.

Download Windows Server 2012 Image

You can download the image file from following location:

http://technet.microsoft.com/en-us/evalcenter/hh670538.aspx

The image file is 3.37 GB in size and you can extract or burn the image file to proceed with the installation. (ImgBurn is a tool to burn .img files to DVD)

On running the bootable DVD you should be prompted with the setup.exe as shown below:

clip_image008

Use the GUI option in the further step:

clip_image010

Please note that this operating system installation step can be skipped if you already have Windows Server in place. Ensure your Operating System has a valid domain integration.

Tips

1. Inside Windows 2012, Use Ctrl + Alt + Delete to view the Power Options screen and you can choose Shut Down, Restart etc.

2. To access your Start Menu (Screen) use your Windows button or move mouse to the left bottom end of toolbar.

SQL Server 2012

SharePoint 2013 requires SQL Server 2012. You can download a trial version from the following link:

http://www.microsoft.com/betaexperience/pd/SQL2012EvalCTA/enus/default.aspx

clip_image011

Download the highlighted version and install it. Before installation you need to create a domain account to specify it during the SQL Server installation.

Note: The SQL Server Installation should take around 20 minutes.


SharePoint 2013 Installation

After installing the operating system & database server we can continue with the actual SharePoint 2013 Installation. Run the setup.bat from the extracted files root folder.

clip_image013

Install software pre-requisites

Click on the Install software prerequisites link to automatically install all the pre required software.

clip_image015

After the above step you can proceed with the actual installation.

clip_image017

Choose the installation as Standalone and click the Intall Now button as shown below.

clip_image019

Wait for a few minutes for the installation to be completed.

clip_image021

Once the installation is completed you will be launched with the Products Configuration Wizard.

clip_image023

Specify your database name and credentials in the following page:

clip_image025

Enter the Farm Security Phrase of your own:

clip_image027

Wait for the configuration activities to be completed. This should take around 10 minutes.

clip_image029

Once the Configuration is done you will get the following message. The textboxes shows your appropriate machine parameters.

clip_image031

Central Administration

Following is the screen shot of Central Administration in SharePoint 2013. You can open this from the Start Menu.

clip_image032

Click on the Start the Wizard button as shown above to configure your farm settings. Once the farm configuration is done you should be able to see the following screen.

clip_image034

Default Site

Now you can try opening the default site installed. It should be accessible by the machine name itself as shown below:

· http://localhost

· http://machinename

Following is the blank site template of default site.

clip_image036

Corrupted Default Site

If you get a time out error or a Connection Close message then probably the default site collection is corrupted. You can do the following activities to fix it:

1. Delete the port 80 site from Central Administration

2. Create a new web application with port 80

3. Add a new site collection to the new web application

4. Try accessing the site using above urls

Ensure that you have valid entries in the system32\drivers\etc\hosts file.



Virtual Machine Links

Following are some virtual machine links.

Link 1

Link 2

References

http://msdn.microsoft.com/en-us/library/jj162979(v=office.15).aspx

Summary

In this article we have seen the installation of SharePoint 2013 on Windows Server 2012. Summarizing the activities we have performed the following:

1. Windows Server 2012

2. SQL Server 2012

3. SharePoint 2013

4. Internet Information Services 8.0

Please let me know any problems you face so that I may be able to guide you. In the upcoming article I will come up with the new features of SharePoint 2013.

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

Disabled New Document button

Posted by Paul on August 11, 2012

Have you ever faced that ‘New Document’ button in any library is disabled?

image

Wondering how to enable it?

Solution

Go to the Central Administration > Choose Web Application > Authentication Settings > Select Authentication > Select Enable Client Integration > Click OK

image

 

image

image

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

SharePoint 2010 – Workflows

Posted by Paul on August 8, 2012

In this article we can explore the Workflow feature of SharePoint 2010.  It adds much power and flexibility to SharePoint and is a must have skill for advanced SharePoint users or administrators.

What is Workflow?

Workflow started as a component of .Net framework 3.0 named Windows Workflow Foundation.  Workflow represents a sequence of activities as in a Flow Chart and a runtime that executes these activities.  

The Workflow activities get executed inside a:

·         Windows Application

·         SharePoint Server

·         ASP.NET Application

Workflow is integrated in SharePoint 2010.  We can create Workflows using SharePoint Designer, Viso and Visual Studio.

Why we need Workflow?

Workflow provides a convenient way to automate manual business processes.

The activities in the Workflow can be represented in a graphical manner and adds great flexibility to a developer and non-developer.  Using Workflow we can easily achieve the branching, cases and executions in an easier manner.

Inside SharePoint, the Workflow feature enables an easier way of associating activities Approvals, Rejections, Copying, Moving, Email Notifications with Document Libraries and Lists.

Scenario to reveal the advantage of Workflow:

Create a Task List of Id, Name, and Status.

When Status is Completed,

Move the item to Completed Task List

Time Required

Using ASP.NET

8 Hours

Using SharePoint and Workflow

5 Minutes

 

From the above scenario We can understand the cost and time savage using Workflows.  It allows dragging and dropping the common programming scenarios.  We can also do advanced activities by programming extension of Workflows.

Common Workflow Scenario

We can apply Workflow for the following scenarios.

Scenario 1: A task list allows creation of task for users.  Whenever a new task is created in the list, we need to notify the user associated with it.   We can use Workflow to accomplish this easily.

Scenario 2: A company consists of developers with various skill sets.  There is a set of Training Items.  Each developer can apply for the training.  The application will be notified to the Training Manager.  He can check the skill set and approve or reject the applicant.  If selected, the applicant can attend the training.  On completion of training there is a verification exam to be undergone by the attendee.  If he passes then Certificate is issued else the notification through email is done. We can use Workflow to accomplish this easily.

Scenario 3: People upload their expense reports into a Document Library.  The library captures the expense as a separate field.  Every week manager has to change status to Approved for the expenses with less than $ 500.  The list contains hundreds of entries.  The status updation can be done using Workflow in just 1 minute.

Scenario 4: Client can create a bug and it should be notified to Developer through email.  Developer on completion of the bug fix changes the status and the Client gets notified.  This whole process can be done through Workflow in an easier manner.

The above scenarios shows that a good amount of programming effort is needed to provide a solution.  Using Workflow with SharePoint we can reduce the effort considerably.

When the activities are getting complicated in the business world, Workflow provides a graphical and modular approach in addressing them simply.

Reusable and Non-Reusable Workflows

In the case of SharePoint 2007 the workflow created for one list cannot be used for another list.  But in SharePoint 2010 the same workflow can be applied for multiple lists and thus making it Reusable.  We can create reusable workflows using SharePoint Designer 2010. 

There is a similar term called Globally Reusable Workflow which requires conversion of existing Reusable Workflow.  Once it is converted the Workflow can be used with the whole site collection.

We can export the workflow as a template to be used with another site collection.  We can also import the WSP (Windows SharePoint Solution) file inside Visual Studio using the Import Reusable Workflow wizard.

Manual and Automatic Invocation of Workflow

We need to mention that there are 2 ways of starting a Workflow:

·         Manual

·         Automatic

In the case of manual start, the user / administrator has to click some buttons for the workflow to start.

In the case of automatic start the workflow executes automatically.  This can be configured along with a list/library like:

·         Start on Creation of Item

·         Start on Updation of Item

etc.

Typical Workflow Usage in SharePoint

·         Developer creates the Workflow

·         Administrator deploys the Workflow

·         Site Users use the Workflow

Designer, Visio and Visual Studio

The SharePoint Designer provides an easier way for Administrators and Developers to create Workflows.  Along with Microsoft Visio, Designer provides much more flexibility and features in Workflow creation.

Using Visual Studio developers can write more complex programming tasks with Workflow.  Using the SharePoint extensions for Visual Studio, the inbuilt templates provides easier Workflow creation and deployment.

References

http://msdn.microsoft.com/En-US/library/aa480215.aspx

http://sergeluca.wordpress.com/2011/01/06/step-by-step-tutorial-creating-workflows-for-sharepoint-2010-step-115/

http://www.codeproject.com/Articles/70867/Reusable-and-Globally-Reusable-Workflows-in-ShareP

Summary

In this article we have explored the Workflow feature of SharePoint 2010.  In the next article we can experiment with creating workflows.

 

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

SharePoint 2010 – Workflows

Posted by Paul on August 8, 2012

In this article we can explore the Workflow feature of SharePoint 2010.  It adds much power and flexibility to SharePoint and is a must have skill for advanced SharePoint users or administrators.

What is Workflow?

Workflow started as a component of .Net framework 3.0 named Windows Workflow Foundation.  Workflow represents a sequence of activities as in a Flow Chart and a runtime that executes these activities.  

The Workflow activities get executed inside a:

·         Windows Application

·         SharePoint Server

·         ASP.NET Application

Workflow is integrated in SharePoint 2010.  We can create Workflows using SharePoint Designer, Viso and Visual Studio.

Why we need Workflow?

Workflow provides a convenient way to automate manual business processes.

The activities in the Workflow can be represented in a graphical manner and adds great flexibility to a developer and non-developer.  Using Workflow we can easily achieve the branching, cases and executions in an easier manner.

Inside SharePoint, the Workflow feature enables an easier way of associating activities Approvals, Rejections, Copying, Moving, Email Notifications with Document Libraries and Lists.

Scenario to reveal the advantage of Workflow:

Create a Task List of Id, Name, and Status.

When Status is Completed,

Move the item to Completed Task List

Time Required

Using ASP.NET

8 Hours

Using SharePoint and Workflow

5 Minutes

 

From the above scenario We can understand the cost and time savage using Workflows.  It allows dragging and dropping the common programming scenarios.  We can also do advanced activities by programming extension of Workflows.

Common Workflow Scenario

We can apply Workflow for the following scenarios.

Scenario 1: A task list allows creation of task for users.  Whenever a new task is created in the list, we need to notify the user associated with it.   We can use Workflow to accomplish this easily.

Scenario 2: A company consists of developers with various skill sets.  There is a set of Training Items.  Each developer can apply for the training.  The application will be notified to the Training Manager.  He can check the skill set and approve or reject the applicant.  If selected, the applicant can attend the training.  On completion of training there is a verification exam to be undergone by the attendee.  If he passes then Certificate is issued else the notification through email is done. We can use Workflow to accomplish this easily.

Scenario 3: People upload their expense reports into a Document Library.  The library captures the expense as a separate field.  Every week manager has to change status to Approved for the expenses with less than $ 500.  The list contains hundreds of entries.  The status updation can be done using Workflow in just 1 minute.

Scenario 4: Client can create a bug and it should be notified to Developer through email.  Developer on completion of the bug fix changes the status and the Client gets notified.  This whole process can be done through Workflow in an easier manner.

The above scenarios shows that a good amount of programming effort is needed to provide a solution.  Using Workflow with SharePoint we can reduce the effort considerably.

When the activities are getting complicated in the business world, Workflow provides a graphical and modular approach in addressing them simply.

Reusable and Non-Reusable Workflows

In the case of SharePoint 2007 the workflow created for one list cannot be used for another list.  But in SharePoint 2010 the same workflow can be applied for multiple lists and thus making it Reusable.  We can create reusable workflows using SharePoint Designer 2010. 

There is a similar term called Globally Reusable Workflow which requires conversion of existing Reusable Workflow.  Once it is converted the Workflow can be used with the whole site collection.

We can export the workflow as a template to be used with another site collection.  We can also import the WSP (Windows SharePoint Solution) file inside Visual Studio using the Import Reusable Workflow wizard.

Manual and Automatic Invocation of Workflow

We need to mention that there are 2 ways of starting a Workflow:

·         Manual

·         Automatic

In the case of manual start, the user / administrator has to click some buttons for the workflow to start.

In the case of automatic start the workflow executes automatically.  This can be configured along with a list/library like:

·         Start on Creation of Item

·         Start on Updation of Item

etc.

Typical Workflow Usage in SharePoint

·         Developer creates the Workflow

·         Administrator deploys the Workflow

·         Site Users use the Workflow

Designer, Visio and Visual Studio

The SharePoint Designer provides an easier way for Administrators and Developers to create Workflows.  Along with Microsoft Visio, Designer provides much more flexibility and features in Workflow creation.

Using Visual Studio developers can write more complex programming tasks with Workflow.  Using the SharePoint extensions for Visual Studio, the inbuilt templates provides easier Workflow creation and deployment.

References

http://msdn.microsoft.com/En-US/library/aa480215.aspx

http://sergeluca.wordpress.com/2011/01/06/step-by-step-tutorial-creating-workflows-for-sharepoint-2010-step-115/

http://www.codeproject.com/Articles/70867/Reusable-and-Globally-Reusable-Workflows-in-ShareP

Summary

In this article we have explored the Workflow feature of SharePoint 2010.  In the next article we can experiment with creating workflows.

 

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

Review of uCertify online platform for 70-573 CSHARP PrepKit:

Posted by Paul on August 2, 2012

I had a chance to review the Certification Preparation Kit for SharePoint 2010 Development by uCertify.

I would recommend this as a good tool for attaining the certification:

  • Practise Questions
  • Explanatory Solutions
  • Interactive Topics

Again I have approached to write something about their PrepKit but this time it is for online PrepKits which is launched recently. The feature which distinguish online Platform from old one is you can use PrepKits from anywhere on any device, including Mac, Android, iPad, etc. You need to have internet connection only. You may access online platform from this link: http://learn.ucertify.com/

The PrepKit has many more features like:

• Practice test

• Quizzes

• Flash card

• E-book

• Analytics, Progress report

• Study Planner

The cover page of the PrepKit looks like this:

clip_image002[4]

User can take multiple type of test. The test helper helps to define number of question in the test, time allowed, passing score, etc.

clip_image004[4]

You may study from eBook chapter by chapter and can take tests too

clip_image006[4]

A report is generated after taking the test

clip_image008[4]

In short, the online platform is quite friendly and easy to use. It is recommendable to use uCertify PrepKit if you want to be fully prepared for any IT certification exam.

Posted in C#, SharePoint | Tagged: | Leave a Comment »