R J E S H

Invoke WebService from PowerShell

2012-04-27T23:50:00.001-07:00

Use the below to create the web service proxy

Invoke the web method and pass parameter, here I have used the stock quote web service which responds with stock details for the supplied symbol.

Satyamev Jayate

2012-04-14T19:34:00.000-07:00

I'm very eagerly waiting for this day May 6th, to watch this.

Promo 1

Promo 2

Promo 3

Promo 4

Datasheet view not available in Office 365 (SharePoint online)

2012-02-08T14:05:00.001-08:00

Some anonymous reader posted the below question on one of the blog post.

I'm using the trial version of the SharePoint online in Office 365. I'm not able to see the data sheet view for the custom list I created. Any idea how to achieve this

There should be no issues with the data sheet view of the list in SharePoint online, please make sure that you are using the level one browsers listed by MS for viewing the site. Use IE browser then you will be able to see the datasheet view.

Happy New year 2012 !!

2011-12-30T11:49:00.003-08:00

Wish you and your family Happy new year. May this new year bring peace and prosperity to you life.

பாரதத்தில் தர்மம் - மனசோர்வு !!

2011-09-28T07:15:00.002-07:00

Nice and classic thoughts on how to overcome depression and ways to avoid it.

Thanks TechSatish.net.

Hide column in SharePoint custom list based on values

2011-09-09T16:54:00.001-07:00

There are certain requirements when creating new item in the SharePoint custom list user has to hide certain columns based on other value. There are two different ways to achieve it.

Server side
Client side

In Server side, we need to write our WebPart and add the webpart to the new form of the list and close the default one. In this you have full control of the controls and life cycle. But the pain will in the deployment and maintaining the code. Advantage is we have full control and the webpart and flexibility to achieve any kind of validations.

In Client side, it can be achieved using Javascript, especially using the Jquery. I'm big fan of JQuery and I'll be using the second option to achieve it in this blog.

Edit the new form and add CEWP to the form
Change the chrome state to none, we don't want to see the webpart title it's meant to invisible to the end users.
In the HTML view of the CEWP, add the below code snippet.
Change the HideColumn funtion parameters based on your columns in the custom list.

That's it try to add new item to the list, and based on the column values the other column will get hidden in the code I have used check box and text field. Based on check box I'm deciding here whether to show or hide the column.

Please have a demo on the below video.

Demo - SharePoint and Microsoft Commerce Server Integrated

2011-07-23T06:40:00.002-07:00

Nice demo to showcase SharePoint and Microsoft Commerce Server integration.

Use Blogger Page links as label filter

2011-07-12T11:23:00.004-07:00

In blogger, when user desires to add the link of posts specific to label in the page navigation.
Use the below code in the page html, enclosed with the script tag.

Change the URL as per requirements. Whenever user clicks on the page link it will redirect to the specific label filter page specified in the script. It also handles mobile layouts too.

function getQuerystring(key, default_)
{
  if (default_==null) default_="";
  key = key.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
  var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
  var qs = regex.exec(window.location.href);
  if(qs == null)
    return default_;
  else
    return qs[1];
}
if(getQuerystring('m'))
window.location="http://www.YourBlog.com/search/label/DESIREDLABEL/?m=1";
else
window.location="http://www.YourBlog.com/search/label/DESIREDLABEL";

My favorite Aamir’s all time hits

2011-03-14T10:40:00.001-07:00

I have listed my favorite numbers from Aamir’s movie. The list goes on and on, here are very few to list down.
Happy Birthday Aamir Khan, wish you many more happy returns.

Papa Kehtay Hain (Qayamat se qayamat tak)
Pehla Nasha (Joh jeeta wahi sikandar)
Chand Sifarish (Fanaa)
Tu meri adhuri (Ghazini)
Aati ka khandala (Ghulaam)
Tanhayee (Dil chahta hai)
Is Deewane Ladke ko (Sarfarosh)
Dil hai Ki Manta nahi (Dil hai ki Manta nahi)
Radha kaise na jale (Lagaan)
Raja ko Rani Se (Akhele hum Akhele tum)
Pardesi pardesi (Raja Hindustani)
Koi kahe kehte rahe (Dil chahta hai)

SPEx Setup

2011-02-28T09:20:00.000-08:00

Scripts and CSS files

Download the SPEx 0.1.1 from here.

Upload the necessary scripts and css to the document library.
In case of extending the Out of box form, you can upload the scripts and css files to the document library, and make sure that necessary access permissions are given to the users. If you trying to use the SPEx on your custom WebPart its better to add them in the layouts and package it as part of the WSP.

Adding the script

Goto list settings and edit New/Edit form
Add content editor webpart to the form
Add below code snippet to content editor webpart’s html
Change the script and CSS links based on your uploaded location

extendLookup

markAsDisabled

markAsReadOnly

Update the parameters accordingly based on your need, for complete list of options for extendLookup function is available on the overview.

Cooking SPL

2011-02-20T08:24:00.002-08:00

Some snaps of Home made Strawberry jelly prepared by me .

Overview on SPEx

2011-02-15T21:42:00.008-08:00

SPEx - SharePoint Javascript library extended
SPEx is a Javascript library, which extends some of the existing out of box functionalities of SharePoint.
It’s in beta stage.
Its current version 0.1.0

It’s tested over SharePoint 2010.

Prerequisites
jQuery v1.4.2
SPServices-0.5.8 or greater

Pgrid

SPEx APIs
extendLookup

Syntax:

extendLookup({
WebURL: "",   // Optional, for future purpose
sourceList: "",  // Source list name
sourceColumn1: "", // Source Column from the source list which will be selected.
sourceColumn2: "", // Source Column from the source list to be used in search.  
CAMLQuery: "",   // Optional, for future purpose    
numChars: 3,   // Minimum number of chars to be entered for search
search: false,   // Turns on/off Search
targetColumn: ""  // Target column name in new or edit form 
});

markasReadOnly
Syntax:

markAsReadOnly("targetColumn"); // Target column name in new or edit form

markasDisabled
Syntax:

markAsDisabled("targetColumn"); // Target column name in new or edit form

Known Issues
Currently, extendLookup works on non-dialog based forms.
markasReadOnly and markasDisabled works on single line of text type of columns

Download
SPEx can be downloaded from http://spex.codeplex.com/

My Cricket World Cup Squad

2010-12-10T06:59:00.001-08:00

The Managed Metadata Service or Connection is currently not available

2010-09-08T09:20:00.001-07:00

Error:
When tried to access the Manage Metadata Service from the central admin, got the below error

The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator.

Fix :
Download KB976462 Hot fix and install.
http://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=23806

Term Store Management not visible in Site settings

2010-09-06T10:34:00.001-07:00

When you are done with your installation, you might have noticed that “Term Store Management” link is not visible in the site settings page. You’ll be not able to find the suitable feature also in the features page.

Since its a hidden feature, which needs to be activated. Use the below PowerShell which uses the feature GUID.

After activation,

Get RSS URL from SPList object

2010-08-11T08:20:00.001-07:00

RSS feeds are generated with the help of listfeed.aspx which resides in the layouts folder. It take list id as parameter through querystring. Will be posting other overloaded methods for variants.

public string GetRSSUrl(SPList list)
{
     string rssurl = string.Empty;
     using (SPWeb web = new SPSite(list.ParentWeb.Url).OpenWeb())
     {
          rssurl = web.Url + "/_layouts/listfeed.aspx?list=" + list.ID;                
     }
      return rssurl;
 }

SharePoint 2010 Social Ratings – Part 2

2010-08-10T06:56:00.003-07:00

In Part 1, we have seen how to use the SharePoint 2010 Social ratings in lists. In this post we will try to change the SharePoint ratings icons to custom icons. In SharePoint 2010 classic five star has been used for the ratings, and these image path are stored in the Site properties.

Below list shows the properties and the image icons.

In order to change the icons, we need to edit these properties with the new image icons. For that we need little help from the graphics team or knowledge of image editing software to create new rating icons. Make sure the images are matching exact size specifications as the original.
Below are the four images which I have created.

We will upload the new images, to site assets or any other site library. Next, we will use SharePoint designer 2010 to edit the site properties to reflect the new image icon path.

Open the site in SharePoint Designer 2010
Click the site options from the ribbon menu

Rename the existing properties as below, to be used to when the default icons has to be reverted.
Create new properties as mentioned below, with the path where the new icons were uploaded.

We need to perform an IISRESET or app pool recycle, after completing the above items to the new icons to get in effect. It will look like below after the changes are made. I was not able to capture the hover effect on the screen grab. Need to capture it on the screen cast I think. Anyways Isn’t it cool?

Could not load type 'System.Data.Services.Providers.IDataServiceUpdateProvider'

2010-08-06T20:13:00.001-07:00

I was trying to access SharePoint 2010 REST services in a Windows 7 machine, and face the below error message.

After some binging was able to get a Service update, which solved the issue.

ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 7 and Windows Server 2008 R2

Now, I’m able to proceed with the REST.

SharePoint 2010 Social Ratings – Part 1

2010-08-06T10:16:00.001-07:00

SharePoint 2010 provides new feature to users to rate the site content list items like documents, blogs, tasks, discussion items etc. It’s available only with SharePoint 2010 and not with the Windows Foundation Services.

Lets see how to use the rating feature. I will use social rating on the discussion board list in this article, but the procedure remains same for the rest of the lists.

Follow the below steps to enable rating.

1. Enable Ratings Feature, It’s a hidden site feature, make sure it’s activated.

To activate using PowerShell : Open SharePoint 2010 Management Shell and type the below

2. Enable Ratings on the list by using the List Settings >> Rating Settings

3. Select “Yes” on the, Allow items in the list to be rated option.

4. Rating (0-5), Rating Average columns gets added to the list, and in corresponding views.

5. Start rating on the discussion board item. The same procedure applies for other lists also.

Why my ratings are not getting reflected instantly?

Ratings works with the help of the two timer jobs listed below

User Profile Service - Social Data Maintenance Job
User Profile Service - Social Rating Synchronization Job

These two timer jobs are responsible for synchronizing rating values between the Social Database and the Content Database. By default it’s configured on default interval. Change the interval to desired minutes will allow the timer job run more frequently and synchronize the rating data quickly.

My PC RIG

2010-08-05T09:56:00.000-07:00

Finally, My PC RIG is ready.

I7 - 860 Processor
Gigabyte H57 mother board
Corsair 2Gb * 2 DDR 3 RAM (marked for upgrade)
Cooler Master Elite 360 case
Cooler Master 500W PSU
Seagate 1 TB HDD
ATI Radeon 4350 1 GB Graphics card

Document Library “Open with Explorer” from custom WebPart

2010-07-23T11:11:00.004-07:00

Today, some one posted in MSDN forums a question regarding, opening the pre defined document library in an Explorer mode from the custom WebPart.

Option, which is available with the ribbon menu of the library.
This can be achieved using below, by using the NavigateHttpFolder function in the core.js

NavigateHttpFolder('http:\u002f\u002fServerName:portno\u002fsitename\u002fdoclibraryname','_blank');

This method takes hex encoded URL and frameTarget as the parameters.
It worked for SharePoint 2010 and MOSS 2007 in IE8 and Firefox browsers.

MVP Award

2010-07-10T10:16:00.001-07:00

I’m glad to say that, I have been awarded Microsoft Most Valuable Professional award for SharePoint Server. I take this moment to thank all my friends, readers of my blog, moderators and members of TechNet and MSDN forums.

Finally, thanks Microsoft for this recognition.

The referenced assembly "Microsoft.SharePoint.Client.Runtime" could not be resolved..

2010-07-05T09:20:00.002-07:00

Error:
The referenced assembly "Microsoft.SharePoint.Client.Runtime" could not be resolved because it has a dependency on "System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project.

Fix:
When you get the above error, it means that in your project your pointing to .net framework 4.0 and its not installed in your machine. Now, change the project properties to point out available framework in your machine.

This is what you call motivation !!!

2010-07-01T08:50:00.001-07:00

Folks!, don’t be stereotypic come out of your boundaries. Think beyond, apply science in management.

Custom Tag Cloud for Rjesh.com

2010-04-11T10:47:00.001-07:00

A Silver light based tag cloud generation tool available with Tagxedo. Which allows to change the shape, color, font and theme of Tag Cloud.