Showing posts from January, 2012

Ajaxifying Sharepoint 2010

Just a quick note on how to ajaxify Sharepoint 2010:-
1. Download the code files from
2. Update the location of stsadm to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\stsadm in deploy.cmd and upgrade.cmd files respectively.
3. Open command prompt in admin mode and run the following command:
STSADM.EXE -o addajax -url http://UNLT239/MOSS
to ajaxify the site. In my case it is the above url, however you would need to specify STSADM.EXE -o addajax -url <sitename_to_be_ajaxified>

Once this is done, navigate to the web.config file and ensure that you replace the version of your system.web.extension to 3.5.

Also the following changes are extremely vital:-

<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
<add verb=&…

Creating a simple expense spreadsheet

Now many a time it becomes a necessity to track daily expenditure (or weekly expenditure) and try and figure out your spending trend over the year. I created a quick solution for anyone out there who requires something like this. It should not take you more than 3-5 minutes unless you are blogging about it. (Thought of implementing it in SSRS earlier but an excel sheet is good enough to do the trick)
1. Open Excel and type in the Location, Date and Expense made... something similar to the following image:-

2. Now in case you want to just check the trends of your expenditure using databars, create another column or insert a column called trend and then click on conditional formatting on the Home Ribbon (Keeping the Trend Column Selected) and choose the Databar along with the required color formatting --> the image is as shown below:

3. Next Step Ensure that for every cell in the Trend column you point it to the respective cost which in my case are the values present in the B column so …