Problem with uploading multiple documents. Cannot run Microsoft SharePoint Foundation on this page: http://sitename/documents/Forms/Upload.aspx

The cause of multiple documents upload problem is permissions. The person uploading the documents must have following permission level assigned:

We had a custom permission level "Editor" where these permissions were not assigned. Adding them to Editor permission level solved the issue for us.

Export / Import / Migrate document libraries across sites in SharePoint 2010

One of the biggest pain in SharePoint 2007 can now be handled easily in SharePoint 2010. Migrating large document libraries across sites can be achieved with following power shell commands.

Export-SPWeb -Identity http://sp2010vmsk -Path "C:\Temp.dat" -ItemUrl /SharedDocuments -IncludeUserSecurity -IncludeVersions All -Force

Import-SPWeb -Identity http://sp2010vmsk/site1 -Path "C:\Temp.dat"

SPListItemVersion.CreatedDate does not follow locale settings

While working on a requirement in one of ongoing projects, I noticed that CreatedDate is stored according to GMT in database for version items. A simple fix to convert it to local time is:

SPListItemVersion.Created.ToLocalTime()

Search error after upgrading to MOSS SP1 - System.IndexOutOfRangeException: DisplayInAdminUI

After upgrading to MOSS SP1, we started getting the following error on search results screen.

System.IndexOutOfRangeException: DisplayInAdminUI

After doing some research on internet and going through log file, we din't find any solution.

And then we decided to rebuild the SSP. That solved this problem.

Installing SharePoint on Vista

I was really excited when I heard this. Then I tried installing MOSS 2007 on Vista and it works perfectly. Thanks to Bamboo Solutions. Check out this post for all the instructions from Jonas.

Group A List by Week Number

To group a list by week number, follow this post by Paul. I just wanted to make a small change to the formula which read as:

Add a Calculated column to the list called 'WeekNumber' that uses the following
formula: =INT(([Start Time]-DATE(2007,1,1))/7)

To avoid the hardcoding of year, we can use the following formula

=INT(([Start Time]-DATE(YEAR([Start Time]),1,1))/7)

How to programmatically check who has posted last message in to a discussion?

I was working on a ‘Latest Updates’ web part for site. That site has Tasks List, Document Library, Wiki and a Discussion Forum. Everything was fine other than displaying data from discussion board. Here are some of the findings:

Objective:
-> To display no of replies to a discussion – Very easy. Just use “ItemChildCount” field of discussion board.
-> To display when was last message posted in the discussion – Again, just use “DiscussionLastUpdated” field.
-> To display who has posted last message into a particular discussion – Now this one is a bit tricky. But as we know Sharepoint treats each discussion as Folder, so we can query that particular folder (or we can say Discussion) to get the child items. Here is the sample code:

private string GetLastPostCreator(int nItemID)
{
string strAuthor = string.Empty;
SPWeb webCurr = SPControl.GetContextWeb(Context);
SPList lstDF = webCurr.Lists["Discussion Forum Name"];
SPListItem itemDiscussion = lstDF.GetItemById(nItemID);
SPFolder folder = itemDiscussion.Folder;
SPQuery query = new SPQuery();
query.Query = "";
query.Folder = folder;
query.RowLimit = 1;
SPListItemCollection items = lstDF.GetItems(query);

foreach (SPListItem _item in items)
{
strAuthor = new SPFieldUserValue(webCurr, _item["Author"].ToString()).LookupValue;
}

return strAuthor;
}

Happy Coding J