Don't see Save as Site Template

I wanted to migrate my site from one SharePoint Site Collection to another. And I thought to save the site as a template and upload the template to the new Site Collection and Activate it. But when I navigated to the Site Settings page of the site I wanted to save as template, I din't find the link.
Under Site Actions

This post is limited to making Save as site template available here and not how to Export and Import the template.

Steps to enable Save as site template

• Click on Manage Site features under Site Actions.
• Click Deactivate on SharePoint Server Publishing feature.
• Click Deactivate this feature on the page that opens.
• Navigate back to Site Settings page for that site and under Site Actions you will now see Save as site template.

Picture speaks a thousand words: I should have done this before the write up :)

Excel VBA script to open a file system folder

Issue Resolution Journey during SharePoint 2010 Installation on Windows 7

While Installing SharePoint Foundation 2010, I encountered a failed installation error and it pointed me out to go through the log files.

While having a look at the log files, I landed on a file at this location C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt

When I scrolled towards the end of the file, the below InnerException was displayed.

Inner exception type: Microsoft.SqlServer.Configuration.SqlEngine.ValidationException
        Message: 
                The system database file master.mdf already exists in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Data\MSSQL10.SHAREPOINT\MSSQL\DATA.

Towards resolving the issue, I renamed this file -> un-installed SharePoint Foundation 2010 and tried installing again. This time I hit another error quite similar to the above but with one exception, "the file name this time was master.ldf"

Inner exception type: Microsoft.SqlServer.Configuration.SqlEngine.ValidationException
        Message: 
                The system database file master.ldf already exists in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Data\MSSQL10.SHAREPOINT\MSSQL\DATA.

By this I understood that it would do this for all the other system databases available in this folder.

I went one folder up to ..\MSSQL and renamed the folder DATA -> un-installed SharePoint Foundation 2010 and re-installed again. Guess what ....... I was in smiles.

SharePoint created another folder called DATA and created the database and log files a-fresh again.

Quite straight forward, but worth taking a space on my blog. Hope it helps!!

Excel VB commands to Convert Numbers into Currency

In the below example we are converting a Number to Currency and we are using '$' symbol for display.


We can achieve this using alternate commands like the ones in the below example. However, the above command is a short-hand. Quite handy, ain't it?

Output after converting to INR

We can also change the currency. Suppose we were to display INR (Indian Rupees)




To learn about formatting numbers in Office Excel (the ones like #.##, #,###.00 etc. that you see in the above examples), I would recommend you to refer Excel Help and search for the topic "Create or delete a custom number format"

SharePoint 2010 Products and Configuration Wizard Error

Operating System : Windows Server 2008 R2 (all important updates installed)
Installing : SharePoint Foundation 2010 Standalone (with SQL Server 2008 Express SP1) in one box.

Steps successfully performed:

• I installed all pre-requisites using SharePointFoundation.exe
• I restarted the Server
• While running SharePoint 2010 Products and Configuration Wizard, I received the following errors

After resolving the above error I received

Here is the right approach

• Before running ShaerPoint 2010 Products and Configuration Wizard, Right-click on the folder %commonprogramfiles%\Microsoft Shared\Web Server Extensions\14 click Properties from the context menu and then select the Security tab > select Edit
• On the Permissions for 14 dialog click Add… and enter Network Service in the Enter the object names to select and then click OK.
• On the Permissions for 14 dialog select Full Control under Permissions for NETWORK SERVICE and click OK twice.

The second screenshot above is faced when you don't have the Cumulative Update 2 installed for SQL Server 2008 Express. Download and Install SQL Server 2008 KB 970315 x64

Site Collection Features Not Visible - SharePoint 2010

Trying to spot "Site Collection Features" in your SharePoint Site and unable to find it? Here is how you approach it:

• Open Central Administration
• Select Application Management
• Click Change Site Collection Administrators
• Add yourself as the Administrator (Primary or Secondary)
• Get back to your Site and refresh the page.

I am sure you are good to go :)

Find out why are you not able to create a New Site using Enterprise Search Center template?

Cannot find Enterprise Search Center when creating a New Site

There could be two reasons for this:

• SharePoint Server Standard Site Collection Features is deactivated.
• Enterprise Search Center is not available under Sub sites can only use the following site templates in Page Layouts and Site Templates under Look and Feel.

Activating SharePoint Server Standard Site Collection Features

• Click Site Actions > Site Settings > Site Collection Administration > Site Collection Features (Can't find Site Collection Administration? Look here)
• Activate - SharePoint Server Standard Site Collection Features

Enterprise Search Center should be visible under Site Action > New Site. If not, keep reading :)

Provide Privilege to use Enterprise Search Center

• Click Site Actions > Site Settings > Look and Feel > Page Layouts and Site Templates and add Enterprise Search Center (All) to the right (as shown below)
• Click Ok.