Friday, 26 March 2010

Total Count of Items in a List in Sharepoint

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" - a new column will be added to the List and then you could see the Column "Total" which would display values from 1 to End number in ascending order. If you click the header "Total" the list would be displayed in descending order displaying the Total number of the Items in the list.

Now.... however this is not an optimal solution considering that if you delete an item sharepoint still retains the ID and hence it still shows the total count (including the deleted item). So you can use this solution with a variation and use it appropriately.

To fix the total count issue,  there is another solution; You can follow the below steps:

Step 1.
Go to the list, click on the list tab, Click on "Modify View"

Step 2.
Scroll to the bottom of the page, there will be an option called "Totals"
Step 3.
Click on the column which you want to show the count, select count option here it is the "Name column"
Step 4.
Now if you go back to the list, you can see a new column "Count" with the total count of items on it.

Hope this  helps....... Do let me know your feedback .

Also If you are looking to filter a list based on user/Group permission, this post says it

Tuesday, 9 March 2010

Sharepoint Service Pack 2 Release

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

Step 2
Installed Service Pack 2 for Office SharePoint Server 2007, x86 & x64
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 from

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

    The error was saying something pertaining to Registry and Microsoft Search Front End which was a bit confusing, but later I found this was happening because of Disk Space on my C Drive.

    Event Type: Error
    Event Source: MsiInstaller
    Event Category: None
    Event ID: 1023
    Date: 08/03/2010
    Time: 18:27:26
    User: *****\Administrator
    Computer: ******
    The description for Event ID ( 1023 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Microsoft Search Front End, 2007 Microsoft Office System Servers Service Pack 2 (SP2), 1603, C:\DOCUME~1\ADMINI~1.APP\LOCALS~1\Temp\coreserverwwsp2_MSPLOG.LOG, (NULL), , .

    Creating a bit more space (1 GB) and rerunning the Installer fixed the issue, So a quick check would be on your C: drive space before you install the Service packs.

    Known Error Lists Once after SP2 Release

    SharePoint Template Sites

      SharePoint look book Get inspired Discover the modern experiences you can build with SharePoint in Microsoft 365 https://lookbook.microsof...