Monday, March 22, 2010

Free Web cast from Critical Path Training

Andrew Connell [MVP] posted on his blog that Critical Path Training going to provide handful of free one-hour webcasts over the next three months the topic are given below

  • PowerShell Boot Camp for SharePoint Professionals
    Exploring the New Service Application Framework in SharePoint 2010
    Introduction to SharePoint Designer 2010: Top 5 Great Things to Know!
    SharePoint 2010 Introduces Feature Upgrade Enhancements
    Developing with SharePoint 2010 Sandboxed Solutions
    Enterprise Content Management in SharePoint Server 2010
    SharePoint UI Extensibility
    SharePoint Workflow: From Napkin to Business Process
    Creating Workflows with SharePoint Designer 2010, InfoPath 2010 and Visio 2010
    Fun with the ECMAScript Client Object Model

To Register visit

Thursday, March 18, 2010

List Validation

You can only compare column values to one another in a list level validation.

A validation formula at the column level cannot include any other columns besides itself.  For example, [Column1]>[Column2] is an invalid formula and SharePoint will not allow it to be used at the column level.



=AND([Paper 1],[Paper 2],[Paper 3],[Paper 4],[Paper 5]<=100,[Paper 1],[Paper 2],[Paper 3],[Paper 4],[Paper 5]>0)



1. What if you have both column level validation and list level validation?
The column level formulas will be evaluated first, then the list formulas

2. What if the column and list level validations are in conflict?
Example - at the list level, you require that [Text1] = [Text2],
but each column has it's own validation; [Text1]="AAA", and [Text2]="BBB". 
In this case, it will be impossible to actually submit a list item. 

3. The column validations are evaluated first, but if the values validate here, they will of course fail the list validation.

Thursday, March 11, 2010

Unique column

In SharePoint 2007 you couldn't enforce uniqueness on a column in a list or document library to ensure that the column would never have duplicate values.

Supported Column Types
Single line of text
Choice (single value)
Date and Time Lookup (multi-valued)
Person or Group (single value)


Unique column Limitations
1. Remove the index of a unique column.
You must change the column from a unique column to one that allows duplicate values first, and then remove the index

2. Change existing column to unique values.
If existing column contain duplicate values You must remove all the duplicate values to a unique column and then set to unique values.

3. Change the data type of the unique column
Change the column to allow duplicate values, remove the index, change the column to the other supported data type, and then make the column unique

4. You cannot copy a file to a library by using the Open with Explorer command.
5. You cannot break inheritance of permissions from a list to a list item.
6. Item-level permissions for not allowed
7. If list that contains items with unique permissions.
8. List items with content approval enabled
9. Case-insensitive “Product 1” and “product 1”. This is because these two values are considered equivalent.
10. Lookup column supported uniqueness in this case means that more than one list item in the child list cannot look up to the child list cannot look up to the same list item in the parent list

IPL Live on You Tube


Does it mean that in Singapore we view on Live? any idea…. !!!!!

Wednesday, March 10, 2010

Large lists with list throttling



Maximum Limit 2010

Maximum Limit 2007

Number of items in a list or library

50 million per library

5 million per library

Size of an individual file item or item attachment

2 Gigabytes

50 MB (2 Gigabytes)


5,000 per view

2,000 per view

Power Shall script to create Large list

$siteurl = “http://Faizal-PC”
$mysite=new-object Microsoft.SharePoint.SPSite($siteurl)
$spWeb = $mysite.OpenWeb()
$spList = $spWeb.Lists["powershell"]
$i = 1001
do { Write-Host “Item – “$i
         $spitem = $spList.Items.Add()
         $spitem["Title"] = $i.tostring()
while ($i -le 7000)


To Setup Resource throttling go to Central Administration and General Setting and Select Resource throttling


Resource Throttling screen to setup Threshold



Go to List Settings and View the List threshold message. 


Tuesday, March 9, 2010

SharePoint 201o List of List Improvements

For the user group presentation i explored the List of list improvements in SharePoint 2010 the list given below for your reference

  1. Lookups and relationships
    Form web part
    List & Column Validation
    Unique values
    Inline editing
    Info path form editing
    Large lists with list throttling
    External lists
    Managed Metadata as a column
    Metadata navigation
    Index columns
    Item-level Permissions options
    Toggle “New Folder” command is available
    Control Offline Client Availability
    Datasheet toggle

Monday, March 8, 2010

SharePoint 2010 official launch

SharePoint team, officially announced that May 12th, 2010, is the launch date for SharePoint 2010 & Office 2010.

The RTM will intent to release in April 2010.