SharePoint 2010 Service Pack 2 Released

Access 2010 Runtime SP2	KB2687444	32-bit	64-bit
Duet Enterprise for Microsoft SharePoint and SAP SP2	KB2687445		64-bit
FAST Search Server 2010 for SharePoint SP2	KB2687446		64-bit
Groove Server 2010 SP2	KB2687448		64-bit
Office 2010 Filter Pack SP2	KB2687447	32-bit	64-bit
Office 2010 Language Pack SP2	KB2687449	32-bit	64-bit
Office 2010 SP2	KB2687455	32-bit	64-bit
Office Language Interface Pack 2010 SP2	KB2687450
Office Proofing Tools 2010 SP2	KB2687458	32-bit	64-bit
Office Web Apps 2010 SP2	KB2687470		64-bit
PowerPoint Viewer SP2	KB2687456	32-bit
Project 2010 SP2	KB2687457	32-bit	64-bit
Project Server 2010 SP2	KB2687452		64-bit
Search Server 2010 SP2	KB2687461		64-bit
Server Language Pack SP2	KB2687462		64-bit
SharePoint 2010 Indexing Connector for Documentum SP2	KB2687459		64-bit
SharePoint Designer 2010 SP2	KB2687463	32-bit	64-bit
SharePoint Foundation 2010 Client Object Model Redistributable SP2	KB2687467	32-bit	64-bit
SharePoint Foundation 2010 Language Pack SP2	KB2687466		64-bit
SharePoint Foundation 2010 SP2	KB2687464		64-bit
SharePoint Server 2010 SP2	KB2687453		64-bit
SharePoint and Project Server 2010 SP2	KB2687452		64-bit
Visio 2010 SP2	KB2687468	32-bit	64-bit
Visio Viewer 2010 SP2	KB2687469	32-bit	64-bit

Change Regional settings in Central administration as well as at the site collection level- SP2010

Regional settings plays a very vital role as the SharePoint has been extensively used all over the world with different languages.

So many requirements can arise such as:

-How can we set the default regional settings for the new site collections?

-How can we change the default regional settings once the site collection created?

-How can we change the default time zone?

-How can we change the default calendar?

-How can we set the alternate calendar?

-How can we change the time format? 12 hour/24 hour?

Primarily we are going to focus as how we can change the regional settings in central administration as well as at the site level.

Change Time Zone settings in Central Administration:

-Open the central administration

-Application management

-Manage web applications

-Select the appropriate web application on which you need to change the default regional settings

-General settings from the top dropdown

-Default time zone

-change it as per your requirement.

Change Regional settings at the site collection level:

-Open the site collection

-site actions

-site settings

-site administration

-Regional settings

-change any settings as per your requirements.

If you have any queries / questions regarding the above mentioned information then please let me know, I would be more than happy to help you as well as resolves your issues, Thank you.

import Spreadsheet failed into SharePoint as a list - SharePoint 2010

Problem Description:

I had one user who was not able to Import an excel spreadsheet into SharePoint as a list.

Error Message:

You are not authorized to view this page.  

You might not have permissions to view this directory or page using the credentials you supplied.

HTTP Error 403 - Forbidden

Troubleshooting Done:

-User is a site collection administrator.

-We got the file at our end and checked it worked fine.

-We also checked with the proxy settings but even after changing it to the same as we had it did not work.

-Asked the user to check from a different machine with his login it worked fine

-As it was related to excel tried checking on Microsoft office Diagnostics available in Office 2007.

And to my amaze it worked. We were able to import the spreadsheet without any issues.

Where is Microsoft office Diagnostics?

Start => all programs => Microsoft Office => Microsoft Office tools => Microsoft Office Diagnostics

If at all we have office 2010. We may have to run the Repair available under control panel.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

Product Applies To:

-SharePoint Server 2010

-SharePoint Foundation 2010

Move subsites into separate site collections in SP2010

Recently one of our customer created a ticket and requested to move some of his subsites to separate site collections. I think this will be genuine requirement for everybody as rather than keeping the subsite, it’s better to keep a separate site collection.  

I worked on this request and thought of sharing with everybody so that it would be beneficial for the complete community.

Let me explain in basic manner so that there would be no confusion:

Let’s assume here are my subsites:

http://sharepointknowledgebase/sites/amolsplanet/amolshistory

http://sharepointknowledgebase/sites/amolsplanet/amolsbiography

I wanted to convert / move the above subsites into separate site collections so that they would looks like:

http://sharepointknowledgebase/sites/amolshistory

http://sharepointknowledgebase/sites/amolsbiography

Resolution:

Steps are pretty simple so nothing to worry about and we can easily achieve this requirement without any issues.

Note: If you have a requirement like the mentioned above and don’t have sufficient rights to do the operation on your own then request you to forward the requirement to your SharePoint Administrators so that they can complete this task based on your requirements.

Please refer the following commands which are very helpful in accomplishing the requirements:

Export command:

Export-SPWeb -Identity <URL of the subsite> -Path <Filename> -IncludeUserSecurity

By using the above command we can take the backup of the subsite.

Import command:

Import-SPWeb http://site -Path D:\export.cmp -UpdateVersions –Overwrite

By using the above command you can restore the subsite backup to the site collection that you want as per your requirements.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

How to create a subsite in SP2010

Subsite is an integral part of site collection. There are several uses of subsite for which you can deal with as well as manage almost the same set of operations that you can do from the top level site.

Many organisations have some security policies and they don’t permit complete leverage to the owners to manage the complete site collection but one thing is very good that at list they can create multiple subsites as per their requirements.

Today’s topic is based on the same and would like to share this basic information with all of you so that there would not be any confusion in creation the subsite.

Here are the details:

-Open the website on which you are dealing with

-site actions

-site settings

-site administration

-sites and workspaces

-Create

-Enter the title, URL, select the appropriate template and click OK.

By this way you can create a subsite in an easy without being dependent on others / without referring any article or document/ without asking for help from anybody/ without taking any training.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.