SharePoint Guru

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

noreply@blogger.com (Sumit Kumar Domyan) — Mon, 02 May 2011 07:57:00 +0000

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

noreply@blogger.com (Sumit Kumar Domyan) — Tue, 09 Nov 2010 17:52:00 +0000

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

noreply@blogger.com (Sumit Kumar Domyan) — Fri, 31 Jul 2009 01:32:00 +0000

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

noreply@blogger.com (Sumit Kumar Domyan) — Thu, 13 Nov 2008 02:58:00 +0000

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

noreply@blogger.com (Sumit Kumar Domyan) — Sun, 01 Jun 2008 23:03:00 +0000

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

noreply@blogger.com (Sumit Kumar Domyan) — Tue, 11 Mar 2008 01:00:00 +0000

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?

noreply@blogger.com (Sumit Kumar Domyan) — Thu, 29 Nov 2007 10:54:00 +0000

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

10 signs that you aren’t cut out to be a developer

noreply@blogger.com (Sumit Kumar Domyan) — Mon, 29 Oct 2007 01:33:00 +0000

Justin James looks at 10 indications that you might not be well suited for a developer career. Check out this article.

Study recommendations for Sharepoint Exam (70-542)

noreply@blogger.com (Sumit Kumar Domyan) — Tue, 25 Sep 2007 08:53:00 +0000

Here is the link everybody was waiting for. Paul Galvin has prepared a nice list of links which is quite useful in preparing for Sharepoint certification exam (70-542 Microsoft Office SharePoint Server 2007 - Application Development).

How To Share Authentication Cookies across ASP.NET V1.1 and ASP.NET V2.0 Applications?

noreply@blogger.com (Sumit Kumar Domyan) — Mon, 17 Sep 2007 03:55:00 +0000

A nice article by Scott Guthrie on how you can share same session in ASP.NET 1.x and 2.0

Adding table headers and/or footers to a Content Query Web Part Layout

noreply@blogger.com (Sumit Kumar Domyan) — Tue, 21 Aug 2007 01:31:00 +0000

I have found a very easy way to add headers and footers to Content Query Web Part.

We can symply use preceding-sibling and following-sibling in our xslt template.

<xsl:if test="count(preceding-sibling::*)=0">

</xsl:if>

<xsl:if test="count(following-sibling::*)!=0">

</xsl:if>

Here is another article for adding Headers and Footers to a Content Query Web Part. It provides you a very good step to step demonstration of how you can add headers and footers to content query web part.

Ultimate Sharepoint 2007 Links

noreply@blogger.com (Sumit Kumar Domyan) — Wed, 11 Jul 2007 10:16:00 +0000

Just found this article, very useful links of sharepoint 2007 links. Check out guys, they are really useful.

Sharepoint and Popfly Integration

noreply@blogger.com (Sumit Kumar Domyan) — Sun, 08 Jul 2007 04:18:00 +0000

Checkout this nice article from Mike Gannotti where he tells about Popfly integration with Sharepoint.

Here is the link for video.

How to programmatically check whether a user has responded to a Survey or not?

noreply@blogger.com (Sumit Kumar Domyan) — Fri, 06 Jul 2007 08:31:00 +0000

We have a requirement in one of ongoing projects, where client is looking for Forced Survey. Users will have to necessarily take a survey before entering into the website. The real challenge in this requirement was to identify whether the user has responded to the survey or not. It is possible to find the responses to the survey by querying the survey list when the survey is created using the default options. The problem arises when the survey creator checks the option to hide the username from the responses in the survey. After lot of research, I came to the conclusion that we can not get response for a survey using object model in this scenario (Please leave a comment here you disagree with this conclusion and have already done this before!).

Then I started digging into content database. I would like to thank my fellow colleague, Kushagra, for finding this solution. We created a Stored Procedure in the Content DB of the Portal to check whether a particular user has responded to a survey or not. Sharepoint stores all this information in a table called AllUserData. Here is the code for the SQl Query I created to find out whether a particular user has responded to the survey or not:

select count(*) from AllUserData
where tp_ListId = 'Survey-List-Guid'
and tp_Author = Numeric_UserId
and tp_DeleteTransactionId not in (SELECT RecycleBin.DeleteTransactionId
FROM RecycleBin
WHERE (RecycleBin.ListId = 'Survey-List-Guid'))

The Query takes two parameters:

Survey list guid
Userid

This query returns count of responses from a particular user based on the Userid passed. I hope this will be helpful. I’m open for suggestions and comments.

"Best Damn SharePoint Books" List

noreply@blogger.com (Sumit Kumar Domyan) — Sun, 01 Jul 2007 04:56:00 +0000

Interesting article by Andrew Connel. List of books on sharepoint.

Adding metadata to a folder

noreply@blogger.com (Sumit Kumar Domyan) — Tue, 26 Jun 2007 04:12:00 +0000

Last month, I got a requirement; my client wanted to add some metadata with folders in document library. After some research, I found that we can not attach Meta data to folders. To resolve this problem we can create a new content type based on Folder content type. Below are the steps you can follow…

1. Under Site Actions menu, go to Site Settings

2. Click on Site Content Types under Galleries section

3. Click on “Create”
4. Give it a name “Ordered Folder”
5. Select “Folder Content Types” as the parent content type group.
6. From the Parent Content Type drop down select the “Folder” option.
7. Click “Ok”.

8. You will be redirected to Content Type Settings page. You can add columns to your Content Type here. Click on the “Add from new site column” link under the column section.

9. Select a name and data type for your column.

10. Click “Ok”. Now navigate to Document Library where you want to add this content type.

11. We need to enable management of content type for document library. On Document Library menu click on “Settings” and then “Document Library Settings”.

12. Select “Advanced Settings” under "General Settings”

13. Set “Allow management of content types” to “Yes”.

14. Click “Ok”. You will be redirected to Document Library Settings page.
15. Now under “Content Types” section, click on “Add from existing site content types”.

16. Select “Ordered Folder” from the list of “Available Site Content Types”.

17. Click “Ok”. You will be redirected to Document Library Settings page. Go to Document Library.

18. Select “New” on menu bar.

19. You can create your new folders using this content type. And at anytime you can add new columns to this content type.

20. If you have some existing folders, you can change the content type from “Folder” to “Ordered Folder”. Cool isn’t it.

I hope this will be helpful. I’m open for suggestions and comments.

Here i am...

noreply@blogger.com (Sumit Kumar Domyan) — Mon, 25 Jun 2007 08:14:00 +0000

So here i am...

I've been thinking of starting a blog for some time. And today I'm feeling great while writing this post. I have read lot of blogs and decided that I might add my own experience here.

I'm a developer from heart. I will mostly blog about things related to Sharepoint (one of my horrible addictions).

I hope you’ll enjoy your stay!