Posts

Showing posts from March, 2010

Total Count of Items in a List in Sharepoint

Image
I had a recent assignment to test the performance of a List. The list was behaving really slow and I need to determine the total number of items in the list.
Aaaah ………… there starts the problem. I wanted the total number of items in the list and I could only do that by navigating through the List Item pages which was around 20,000 + Items, So need to click through every single pages and it would take couple of months to figure out the exact numbers. Then I thought about the "Calculated Columns" in Sharepoint.
Finally I figured out to get the total count of the Items in a Sharepoint List. Here are the steps -


Step 1.Create a "Calculated (calculation based on other columns) " column in the List
Step 2.Column Name - "Total"
The Type of Information in this column - "Calculated"
In the Formula Column put - "=SUM(ID)" (without apostrophise)
Select "The data type returned from this formula is: " as Number
Step 3.Select "OK" -…

Sharepoint Service Pack 2 Release

Image
Sharepoint 2007 Service Pack 2 Release(MOSS SP2)I got a new task assigned to upgrade my MOSS Farm from SP1 to SP2.
Here are the steps which I done
Step 1
Installed Service Pack 2 for Windows SharePoint Services 3.0, x86 & x64
http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B&displaylang=enStep 2
Installed Service Pack 2 for Office SharePoint Server 2007, x86 & x64
http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90
Once after the upgrade checkpoints -
Check 1
Go to the Control Panel>Add remove programs > Select "Microsoft Office Sharepoint Server 2007" > Click here for Support Information. This would be updated to 12.0.6425.1000










Check 2
Go to Central Admin > Operations > Servers In Farm > The Version would be upgrade to 12.0.0.6421 from 12.0.0.6219








Possible Errors
Strangely I was getting the below error while installing "Service Pack 2 for Office SharePoint Server 2007" Installer -










The err…

Creating SharePoint 2007 Timer Jobs

I was searching for some articles on how to Create Sharepoint 2007 Timer Jobs - and i found some nice ones, Andrew is describing it very well on his articles - Check out.
http://www.andrewconnell.com/blog/archive/2007/01/10/5704.aspx
http://www.andrewconnell.com/blog/archive/2008/04/15/More-help-on-creating-custom-timer-jobs-and-a-useful.aspx