Thursday, 15 November 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 “<@ Assembly Src=” directive is not supported

•SharePoint web controls and some ASP.NET controls are not supported in the SharePoint sandboxed environment; if they are used on a sandboxed visual web part an error message similar to the following will be generated at build time:

• The type or namespace name 'Theme' does not exist in the namespace 'Microsoft.SharePoint.WebControls' (are you missing an assembly reference?)

Wednesday, 29 August 2012

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 ................


Wednesday, 22 August 2012

How to use Jquery in sharepoint 2010

How to integrate jquery with sharepoint in easy Steps

This tutorial will guide you step  by 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 of  Jquery  into 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 how it looks in your SharePoint site ,  follow the below 2 simple step for you to get a feel of it.

Step 1.

Unzip the zip file you got now, copy the folder "jquery-bubble-popup-v3"  into a SharePoint  Document Library.

Step 2.

Open the Folder > Click on the html page you see here , "ClickMe.html" and that's it, it should open up the file where you can hover your mouse on the "mouse over here" text and  you should see a pop-up.. 

What you have done is, you have opened an html file and it is showing up the jquery pop-up, that should give you some happiness. Now the next step is to see how we can get the same pop-up in a SharePoint page and also how to link it to different elements like the image or the links
There is a small tidying up need to be done and put proper reference for this, You Ready ?
Step 1.

Navigate to the SharePoint page where you want to see the pop-up, insert a  Content Editor Webpart on the page. There is a file which you can find in the folder called "SharePoint JQuery Script.txt", this contains the script file which you need to insert to a Content Editor Webpart, so we need to put the right references here

Update the below three lines with appropriate path to the files in reference to your Site
(There is an easier way to find it, if you navigate to these actual files in your site and then hover your mouse over the file and click on the drop-down > Send To > Email a Link will give you the full path including " http://url" you can paste the same complete link here and SharePoint will trim this down for you...easy ya? )

 Step 2.

Once you have updated the above references,  select the Content Editor webpart (CEWP)> Select the "Format Text" tab on the Ribbon Control  > click on the HTML > Edit HTML Source
Copy the whole script code from "SharePoint Jquery Script.txt" updated with your reference and paste it in the CEWP.

Paste the Script in the HTML box  > Click OK >  Save the Page.

Step 3.

Now when ever you paste any scripts in the CEWP, Sharepoint always does some editing to clean it up, so ensure you got the scripts without any spaces or changes else it wont work, double check it with the screen shot below.

Step 4.

If everything is fine then hover your mouse over the "click here" and then you should see a pop-up

Step 5.

You can create or associate this pop-up with any links or images on the page all you need to do is to copy paste the same code segment and create unique id and reference the Class id. 

That's it;  so you have implemented Jquery in SharePoint, you could experiment with more features of Jquery.

Hope this article throws some light on the JQuery front...


This article have used Jquery Pop-Up with open license, refer the below link for more options on parameters

Tuesday, 21 August 2012

Scheduling in SharePoint Calendar

I will outline  on how to Schedule in SharePoint calendar, I have explained an article on how to integrate SharePoint calendars with outlook  which 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 box  view 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 SharePoint Calendar
Step 2.
Click on Actions > View Group Schedules
Step 3.
Click New > Type in a name "My team" >  Add the names yow want to view the schedules  > click on Make meeting > New Meeting  with All

This will create a new meeting on your SharePoint Calendar >, Click on Meeting WorkSpace > if you want a meeting workspace > In the bottom of the mail you can see the event is getting created in the SharePoint Calendar

In this way you can use SharePoint Calendar to create events, meetings and with this workaround you can also view the Schedules of other people.
Happy SharePointing…. Do feed me back..

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 SharePoint  events 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.

Friday, 10 August 2012

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 will be set to a default limit if you have not pre-configured it.

So need to review the quota size limit, and then need to do appropriate actions, follow the below steps:
Actions needs to be taken
1 )  Open Central Admin > Application Management > Under "Site Collections " > Specify quota templates
2) In the Storage Limit Value > Set appropriate Data Limit you want > In my case I have increased this to 5 GB so > 5048 MB > OK
That's it..for now you can be relieved.

Wednesday, 8 August 2012

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

Thursday, 19 July 2012

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...

Monday, 28 May 2012

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?

Tuesday, 22 May 2012

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

  1. You can use to display Excel worksheet as a webpage for the users
  2. You can restrict Access to specific worksheets in an Excel workbook and display only the once needed to the users

  1. 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 filtering and getting external data.

To display a workbook in an Excel Web Access Web Part, you must add the Web Part to a page and then connect the workbook to the Web Part by entering the workbook URL or UNC in the Excel Web Access tool pane. As a final step, you can customize the Web Part by selecting properties in the Excel Web Access tool pane for the Web Part. By configuring properties, you can control the size and layout of the Web Part, and control the ways that users can interact with the workbook.

 How to Add an Excel Web Access Web Part to a page
This procedure describes the specific steps that you have to take to add an Excel Web Access Web Part to an existing Web Part page. To add a Web Part to a page, you must belong to the default Members SharePoint group for the site.

If no appropriate page exists, you might have to create a site page.

To add an Excel Web Access Web Part to a Web Part page, take these steps.

  1. In the Quick Launch pane, click All Site Content. Then, on the All Site Content page, click Create.
  2. On the Create page in the Pages and Sites list, click Web Part Page.

  1. The following illustration shows an example of a newly created Web Part page. The page contains a Header zone and one Body zone. Each zone contains the Add a Web Part box. In the zone where you want to add the Excel Web Access Web Part, click Add a Web Part to display the Web Part Picker.

  1. In the Categories pane of the Web Part Picker, click Business Data. In the Web Parts pane, click Excel Web Access. Then, click Add.

Connect a workbook to a Web Part

  1. In the Excel Web Access
    Select a Workbook
    pane, click the link
    Click here to open the tool pane
     The page changes to Edit mode, and displays the Excel Web Access tool pane.

  1. In the Workbook Display section in the
    text box, enter the URL or UNC of the workbook. If you do not know the URL, you can click the browse button, and then select the workbook that you want to use in the
    Select an Asset
    -- Web Page Dialog
  2. In the
    Named Item box, type the name of a named item in the workbook (such as a defined name, the name of a chart, table, PivotTable, or PivotChart) that you want displayed in the web part.
  1. In the Toolbar and Title Bar section and in the
    Navigation and Interactivity section, select one or more properties that you want to enable. If you want to disable a property, clear the associated check box.
To save changes and exit Web Part Edit mode, you can click OK at the bottom of the Web Part tool pane. Or, to stop editing and view the workbook in Display mode, click Stop Editing.
This displays the Web Part that you configured to use its associated workbook on the page.

Now lets see how to Show Specific Work Sheets in an Excel workbook or even just a set of cells, lets do that in easy steps !!

  1. Open the Excel workbook you want to create views
  1. Click on the Excel office button >  Server  > Excel Services Options

  1. In the Show tab you can set, what all worksheets you can show on the workbook , here you can set it to the  appropriate sheets you want.

           4.  Now lets see how we can show specific cells/ranges,
Go to the Excel workbook select the range of cells/cell you want to display > Right click  > "Name a Range" > set the name > I set it to "PublicView"(no space)  and Click OK

             5.   That's it, now you have created a specific named item, now go back to the SharePoint site, edit the Excel WebAccess webpart and this time on the > Named Item  > type in "PublicView" > OK

           6.  The Webpart will start showing the specific table range on the page as below…

Hope this helped you…. Happy SharePointing !

Monday, 30 April 2012

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:

Wednesday, 18 April 2012

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" calendar. Once you fill out TO, Subject , Location , click on "Meeting Workspace" icon on top of the window  and click "Create", this will create a Meeting Workspace for you under the SharePoint site you have, and will insert a link to the new "Meeting workspace".
Step 6.
Clicking on Send will throw you couple of pop-ups

 Popup 1 > Say OK
Popup 2 > Say Yes
Step 7.

That's it, now you have setup a meeting and the below things have happened now:

  1. it will create a Meeting Schedule for you in your Outlook Calendar  and on the SharePoint Calendar.
  1. It will also populate all the members on to the meeting workspace from the "To" field on to the "Attendee's" list in the Meeting workspace.
  1. It will also put a schedule in your SharePoint calendar where you can navigate to the Meeting workspace.

Meeting Workspace:

SharePoint Site Calendar:

It might take 2 or 3 minutes to reflect the meeting in SharePoint calendar as its done by a job service. Double clicking on the event will show you the Meeting workspace and other details (including the attachments if any) where you can navigate to the Meeting workspace.

From the Next time you schedule the Meeting, make sure you follow this step as it will help to create only one "Meeting workspace" and track all your meetings on the same workspace as oppose to create multiple workspaces.

Step 8.
Once you click the "Meeting Workspace" > Click on the "Change Setting and select the second option.

Select the Second option "Select a Workspace" > Click  "Link to an existing workspace" this should show the previous workspace you created, Select it and click on >  OK  >  Link

This will create a new meeting schedule on the Same Meeting workspace and you can track all your meeting schedules, agendas, Meeting minutes on the same Meeting Workspace and Navigate to this from your Team site Calendar.

Hope this steps helped you to configure Meeting workspace from Outlook and how you can make use of SharePoint more in your project or in your day to day activities.

Friday, 23 March 2012

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 look and feel to display data appropriately.
It can also be used in many scenarios, some examples below:

+ If you have a site collection with a root site and you want to bring in and display the most recent blog posts from all blog sites within its own site collection…. Yes you can use CQWP for this

+ If you want to bring in and show all the events in a group calendar on the root site from the sub-sites created below….. CQWP will do

+ You can also bring in data views from a document library or lists and filter it and show it dynamically.

So here I will guide you through on how to configure a CQWP and to bring in data with two examples :
Example 1
Imagine that you want show a Group-Events calendar which will show  all the events from the calendars which are added in site and sub-sites within a Site-collection. It would be really nice if we could do this easily ….without any custom coding; yes you can do that with CQWP  or to aggregate data from all the "Announcement " list  which exist in sites and sub- sites of a site collection and to show that on the root site of the site collection.

Now lets crack on with the Group-Events calendar…. You can achieve this in less than 5 minutes !!!!!

Step 1.
Open up your SharePoint team site or a publishing site .

Step 2.

Insert  a CQWP webpart from the webparts list, you can find it in the "Content Rollup" category ( If you cannot find the webpart it means you have not enabled "SharePoint Publishing Infrastructure " feature . Search in internet or review this link to resolve
Step 3.
Once the webpart is added on to the site,  Click on the "Edit Webpart" and this will open up the CQWP tool part pane.
Step 4.

Basically the key useful sections of this tool webpart are below:

  1. Query Section : In this section you will be able to mention the source of data which you can bring in, you can also mention about the filters you can apply on the data source.
  1. Presentation Section : In this section you will be able to mention about the "Grouping, Sorting" , Styles and most importantly "the fields to display" on the CQWP.

Step 5.
In the Query section, Select the first option  "Show items from all sites in this site collection". In the List type select "calendar" . In the "Grouping and Sorting" select "Group Items by" - Title
 Leave all the other fields as in the Query section as it is.
Step 6.
In the Presentation section select  Group Style > Banded, if you are looking for a bit of styling.
In the Fields to display leave as it is, this is one of the key things ; the fields you see are the default values which are going to be in the  CQWP, you can add more values to it however it needs XSLT editing.
Step 7.
That’s it ……….all done, now you can see your CQWP showing all the events in the site collection grouped and styled.
Now play around  change the grouping fields or filter there are many things you can do with it…..
Example 2

Now If you want to show contents from a specific list can you do something similar ?.... Yes
I will take you through the steps quickly…..

Step 1.
Create a custom list with site columns on it, I have quickly created a list with 2 columns on it "Name" and "Description".

Note: DO NOT create new columns from a list if you want to display your own fields. There is an MSDN article says about it but always remember to create Site columns for this.

Step 2.
Once your list is created, Click on the "Edit Webpart" and this will open up the CQWP tool part pane.

Step 3.
Expand "Query" section and select the source list from the browse button
Step 4.
Expand the "Presentation" section and go to the "Field to Display" section. By default SharePoint provides 4 fields to display  Link, Image, Title and Description.  Put "TitleDescription" in Title and "EmpName" in Description.

Step 5.

That's all the Content Query webpart will start displaying the values from these fields.

Note : Even though  the help on the "Fields to display" says [Depending on the scope of your query, select one or more site or list columns whose values you want to show in the following display slots for this style, separating entries with a semicolon. To specify a column from a particular group, type the name of the group in square brackets after the column name. Ex: Column[Group]] you can display multiple fields by semi columns on these fields, this is NOT QUITE TRUE.

If you want to add more custom columns then you have to edit the XSLT style sheet file on the style library.
Hope this article helped you to get some insight on CQWP

CQWP is quite powerful, you can use this for many things -

If you like to format Content Query Webpart and give it a great look, check this Article :

Here is another one, How to use CQWP for a News Scroller , Scrolling Announcement -

Here are some links and site you can use to have a look :

Here is an Example of CQWP usage, the widget you see on the site is CQWP
Eric: Swenson

Friday, 16 March 2012

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.... 

Thursday, 15 March 2012

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

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 the formula based on the columns you are having)
Step 4.
Select the datatype returned from the formula (the values returned as results, in this case "single line of text" as i have given text values ("Not Applicable", "Yes")
Step 5.
Click OK and add the column

The page will throw validation errors if there are any problems with the formula you input.

You can use "CountA" parameter to check and count on non-blank columns, you can use this formulat in differnt variance to achieve the specific need you have.

Also Refer to the microsoft site for other formula parameters :

SharePoint Template Sites

  SharePoint look book Get inspired Discover the modern experiences you can build with SharePoint in Microsoft 365 https://lookbook.microsof...