Showing posts from 2012

Visual Webpart for SandBox Solution in SharePoint 2010

Quick Tip

Can you use Visual Webpart for a sandbox solution in SharePoint 2010?

The answer is NO; you cannot since this is basically .ascx controls which needs to be stored in the "controlTemplate" folder and hence it should be a "Farm Solution".

Not to worry much..... MSDN has an answers to this, YES you can have Visual Webpart in a sandbox solution, all you need to do is to install the Visual Studio 2010 Power Tools and you will get a Visual Webpart for Sandbox Solution.

Here is the Link :

There are certain limitations however you still can use it.... Happy developing !

Known Limitations

There are a few known limitations when using a sandboxed visual web part. These include:
•JavaScript debugging is not supported in Visual Studio, although client JavaScript debugging does work

•Debugging of inline ASP.NET code must be done in the generated code file rather the markup file

•Use of “<@ …

Visual Studio 2012 and .Net 4.5 Release

Microsoft announced the release dates for Visual Studio 2012 and .Net 4.5

The Release for Visual Studio 2012 is on September 12, 2012 , you can find more related to this event here :

Also try download and install VS 2012 you can find the downloads here :

.Net 4.5 is also released you can find it here :

Also if you don't want to spend money on Visual Studio 2012 you can also get a free version of Visual Studio 2012 called Visual Studio Express 2012

Try it and be more Knowledgeable ................

How to use Jquery in sharepoint 2010

How to integrate jquery with sharepoint in easy Steps

This tutorial will guide you stepby step on how to integrate Jquery into SharePoint, and the best part is being an end-user with no special administrative privilege you should be able to do the integration ofJqueryinto SharePoint... Guess that should have given you some happiness !!
Have you ever felt of having a nice pop-up on your SharePoint page when you hover your mouse over a link or an image? Yes that's what I would be showing you today. You can download all the necessary script and the files from this link :

So let's download the zip file first. Download
Now let me take you through the steps, you don’t need to edit any SharePoint Master Pages or get the SharePoint Designer / Visual Studio all you need to do is just a "Content Editor Webpart" and a document library to store the "Jquery" Files.
Do you want to see the pop-up working on your site straight away ? If So lets do it, so that you can see…

Scheduling in SharePoint Calendar

I will outlineon how to Schedule in SharePoint calendar, I have explained an article on how to integrate SharePoint calendars with outlookwhich you can find here :
If you have started working in SharePoint calendars you would have noticed that it is a bit difficult to find the schedules of other people in SharePoint calendar , you have to check that in outlook and then come to SharePoint to add an event it will add up the hassle if it's a meeting workspace. If you want to know more on how to configure SharePoint meeting workspace look on this article : OK so back to Scheduling, follow the below steps, this is basically a workaround as SharePoint does not support out of the boxview of Schedules of other people.
Step 1.
Open up Outlook > Go to the SharePoint Calendar > Click on the day which you wish to Schedule in Share…

How to integrate SharePoint Calendar with Outlook

To integrate your SharePoint Calendar with Outlook follow the below 3 easy steps , by doing this you should be able to start to see and schedule the SharePointevents from within Outlook itself.
Step 1 .
 Click the Calendar > Select the Calendar tab

Step 2.
 Click the "Connect to Outlook" icon on the Ribbon

Step 3.

Click Allow and this should connect your SharePoint Calendar to outlook.

If you open up Outlook and if you select your Outlook calendar and the SharePoint calendar you can see both of them side by side.

You could also right click on the SharePoint calendar to select different options like the "Overlay " mode where you can see both the calendars and schedules overlaid.

Tweak around play with it, drop me feedback if you have issues or what article you wish to see and I shall try to help.

Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit.


"Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit. You must save your work to another location.  Contact your administrator to change the quota limits for the Web site"

Monday morning....the teams started getting error saying " Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit.
You must save your work to another location.Contact your administrator to change the quota limits for the Web site. " and received calls and emails from different teams saying there are some issues with SharePoint and need help, emergency, 911..... what not... Had a look and found that this error is happening because of the storage quota limit which is set in SharePoint Central Admin.
SharePoint sets appropriate quota size for the site template and for the site collection. As part of the architecture usually disk and space assessment will be done and appropriate quota will be decided…

SharePoint 2013 Trial Product Key

In case if you are stuck up and need to have a quick try with the SharePoint 2013 Trial Product Key, here is it :

Available in these languages: English, Japanese, Spanish

Installation requires the following product key : 6RNT8-XV26M-GWH36-VMGQH-94MMH
Enterprise trial key :  NQTMW-K63MQ-39G6H-B2CH9-FRDWJ

SharePoint Next Version Released

Microsoft announced SharePoint 2013, which is the newest release to the SharePoint product.

Have a look on this link to see, what's new for developers :

You can also download SharePoint Server 2013 Platform preview from :

You can also try this link to get all the products at one go...
What i believe is this version is, this is a great upgrade from SharePoint 2010, tidied up and loaded with more functionality, need to check if there is any fundamental changes...

Unable to see SharePoint 2010 Filter Webparts

Where you trying to Add SharePoint 2010 Filter Webpart and it says it is added however not visible on the page? Did you feel like .... Well what is happening?

I felt the same and i thought this was some issues with the features which needs to be activated however No..... this is a Bug !!

So can't i use it ? Yes you can and there is a workaround - Don't worry it is straight forward this time :

Follow the below 1 simple step :

To see the filter web part you'll need to select “Edit Web Part" for any of the existing web parts you already have on the page. You can then see the newly added filter web parts you have added to the page and also configure them.
Well...that was easy ? Is'nt it?

Excel Service in SharePoint 2010

How to add and use Excel Service and Excel web access webparts in SharePoint 2010?

Excel Service is a very useful feature in SharePoint 2010 you can do the below things and many more by using this
You can use to display Excel worksheet as a webpage for the usersYou can restrict Access to specific worksheets in an Excel workbook and display only the once needed to the users
You can even show a specific named item in a worksheet, so lets say you want to show only one table you created in the worksheet or a set of cells you can do that even !!!
Doesn't this sound exciting ? Lets crack on…...
         Lets first see how to Display a workbook in an Excel Web Access Web Part

You can display an Excel workbook on a dashboard or other site page by connecting the workbook to an Excel Web Access Web Part. You can customize the appearance and functionality of Excel Web Access Web Parts, and you can connect them to other Web Parts for data analysis tasks such as filter…

SharePoint 2010 SP2 Release

I believe, It has not announced so far - as of (April 2012) on SharePoint 2010 SP2,  however you can always go for cummulative updates :

Scroll through this page it gives a detailed list :

Also Keep an eye on this thread:

How to use and Configure Meeting WorkSpace in SharePoint 2010 using Outlook

The below easy 8 steps will guide you on how to use SharePoint meeting workspace in SharePoint 2010 and how to configure it using OutLook, I have used Outlook 2007 version and in Outlook 2010 it is more or less the same steps I guess, Step 1. Go to the SharePoint 2010 site you are having and then navigate to the Calendar Step 2. Navigate to the tab Calendar > Click on Connect to Outlook

Step 3.
Click Allow, and this will link your SharePoint calendar on to Outlook, Now you can see your Outlook Calendar and SharePoint Calendar Side by Side

Step 4.
Click on the SharePoint Calendar and select the appropriate Schedule date and time, right click > select New Meeting Request, this brings up the outlook "Meeting Request Mail" screen
Step 5.
Fill in to "To:" with appropriate recipients, always remember to add "YOUR OWN" name aswell,  as this will make outlook to throw a pop-up box in the end asking you if you want to synchronise this with your "Outlook&quo…

How to use Content Query Webpart in SharePoint

In this article I would detail more on how to use Content query webpart in SharePoint 2010, it has got a bit more enhanced and advanced than the CQWP (content query webpart) you found in SharePoint 2007; however you can easily get wrong on understanding how this works because of several reasons.
I had spent time looking around  and wasting a lot of time to find articles on this, so I thought better to put together all these in a single place for you all...

If you search for CQWP mostly you would hit the MSDN site however you still might need to find other articles to understand it and  get a grip. The primary question is …..

      Q. Where do you use a CQWP, and basically When will you use this webpart?

Ans.      Content Query Web Part could be used to create custom views of data that is queried from many sources, and present that data all in one place. After you add the Content By Query Web Part to a Web page, you can customize the Web Part's querying behaviours  and also the lo…

Unable to Display List in SharePoint Page

You would have got an error something similar to this, at least once in your sharepoint journey ...

"The page you selected contains a list that does not exist. It may have been deleted by another user"
This is primarily happening because of a reference missing or corrupted webpart, So quick tip to get out of this situation first:

Step 1. Try and find which list is causing the issue, so get to the SharePoint maintanence page
if you append "?contents=1" to your site URL you will get into the maintanence page
Eg. ?contents=1

Step 2. Once the webpart is removed try and scope where the problem is, you can use SharePoint logs for this.

I thought of jotting this out, as a quick pointer in panic mode....

How to show a column value based on other columns in a SharePoint Custom List

In one of the SharePoint list i was asked to provide a custom value based on the values inputed on the other columns. You might have faced a similar situation sometimes, this was thought to be a customisation, but i found that this could easily be acheived by using formula column in SharePoint.

I would run through the steps here : Column 1 Column 2 Column 3 (Formula Column) Value 1 Value 2 If Value in both Columns =”OK” If  No Values in both columns =”Not Applicable”  Value 1  Value

So if Column1 and 2 has both values then Column 3 value = "OK" else "Not Applicable"
I tried couple of variations and was able to find a solution for this using the formula below : =IF(COUNTA([Column 1],[Column 2])=0, "Not Applicable", "OK")
Step 1. Create a new column in a list Step 2. Select the "Type of Information as" : Calculated (calculation based on other columns)
Step 3.
In the Formula column insert the appropriate columns and add the formula (you may have to edit t…