Friday, April 2, 2010

Change Create By / Modified By fields display

Recently one of our customer ask me how to change Create By and Modified By names that appears on Display form, New form and Views.  Out of the box SharePoint systems only display Created at <time> by <username>. Our Customer request to change Display Photo with Name and other details?.  Can we do it without customization?

The answer is “YES”. SharePoint list setting has options to change.

image

Go Settings > To List / Document Settings and Click Created By / Modified By fields.

image

Select Show fields type to Name (with picture and details) and click Ok.

image

SharePoint All document view display modified fields with picture and name.

image

When you visit Display form or New form will display created by and modified fields with picture, name and other details.

image

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

http://www.criticalpathtraining.com/Schedule/Webcasts/Pages/default.aspx

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.

image

image

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

image

Limitations

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)
Currency
Number
Date and Time Lookup (multi-valued)
Person or Group (single value)

image

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

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

image
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

ALL IPL 2010 MATCHES WILL BE WEBCAST ON YOUTUBE.COM/IPL WITH A FIVE MINUTE DELAY IN INDIA

http://www.youtube.com/ipl 

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

Wednesday, March 10, 2010

Large lists with list throttling

 

Feature

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)

Item

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()
         $spitem.Update()
         $i++
}
while ($i -le 7000)

image

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

image

Resource Throttling screen to setup Threshold

image

image

Go to List Settings and View the List threshold message. 

image