How to add new site collection in separate content database

http://blogs.msdn.com/b/mcsnoiwb/archive/2007/08/20/how-to-create-site-collection-in-a-specific-content-database.aspx

How can i play multiple media files in moss2007

Am in the situation i need to run different media file(*.flv, *.wma, *.dat etc...) in my Sharepoint portal. Media player web part help me to achieve my goals. I download MediaPlayerWebpart.dll and i make use of it.

Small introduction about 'Media Player Web part'

The Media Player Web Part makes it easier to integrate media into SharePoint.It is a universal Media Player Web Part.It queries a media player HTML template from a SharePoint list located anywhere in your farm.Media-file URL, size, title, description, autoplay options can be set.

Sharepoint UserProfile Sync. links

1) http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/adf1c861-0bd4-436f-9744-f85d229eace5

2) http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/a6e5daf1-fb7d-4e80-93f5-3b0f9218c2a0

3) http://stsadm.blogspot.com/2007/08/stsadm-commands_09.html

4) http://www.marcvalk.net/2010/04/sp2010-user-profile-synchronization-service-will-not-start/

5) http://blog.jussipalo.com/2010/02/sp2010-fimsynchronizationservice-errors.html

6) http://blogs.technet.com/b/tothesharepoint/archive/2010/01/22/3307662.aspx

7) http://sharepoint.mindsharpblogs.com/Kathy/archive/2009/11/20/Configuring-User-Profiles-in-SharePoint-Server-2010.aspx

Programatically copy document from list to library

Using this below code you can copy the document from list to library, with in the same web application. The logic is as below

Source :Kethare.in

Upload the Document Programmatically to SharePoint Library

The below code will Upload the document from server drive to SharePoint Library, using SPDocumentLibrary class

Source: kethare.in

Download the Sharepoint List Attachment

You can download the attachment from the any SharePoint List to your local drive in your Server using the following code. Based on the article from Microsoft "How to Programmatically Download attachment from list items in WSS" i iterate the list item and also i checked for Exist of attachment for each list item.

Inherited Web-part Class and create the button control and attach the click event, in the "CreateChildControls" method as below code

(Click on above image to Enlarge the Image)

Now write the code to download the attachment from the List as below in the Button Click event Method

(Click on above image to Enlarge the Image)

Now you create a custom web-part for download the attachment of the list. Create Strong key and build the class deploy it in your Server and update the Web.Config. Add it in web-part gallery and edit the page select the web-part to download attachment. that it. When you click on the web-part, it will automatically download all attachment to the specified path.

Source :Kethare.in

How to Hide SharePoint Column based on user login in Newform.aspx

For last two days i scratch my head, to hide the required column based on the user login in NewForm.aspx and EditForm.aspx of the list. Initially i tried it by using SharePoint designer without using code and later i tried by using inline code but am unable to achieve it , even though i have an option to achieve.

Finally i achieved hiding of share-point column based on user login in NewForm.aspx and EditForm.aspx by creating custom Webpart.

Create a Class Library in Visual studio and add reference 'System.Web', 'Microsoft.SharePoint'. In the class file include the required namespace specify below.

Add the below code

Create the Strong Name Key in Visual Studio and build the project and deploy the code in Assembly and add the Source Safe tag in web.config under which site you want to enable this web part. Now Activate the web-part under Web-part gallery from the top site.

Now add the custom web part in the NewForm or EditForm page where you want to hide the control. That all

To know about Custom Web part Click here

How to create Custom webpart in sharepoint

To Get Started with creating Custom Web Part for MOSS 2007 in Microsoft Visual Studio 2008, Open the IDE and create a new C# project, Select Class Library as Project Type. Name It.

Add references to System.Web, Microsoft.Sharepoint.dll

Extend the MyNewWebPart Class from the WebPart Class ( System.Web.UI.WebControls.WebParts.WebPart), and add the code as shown below. The CreateChildren Control would create and add controls to current class. In the below coding I have only added a WebControl.Calender Object. The RenderControl Method is an override for the WebPart Base Class and calls the RenderChildren Method, this causes the Children Controls to be rendered on the Particular HtmlTextWriter passed as a parameter to the method.

Now, strongly name it, Build the dll, and use sn-t or reflector to find the public key token.

After that follow the below steps to deploy

1) Now you have to deploy to your website, so locate the Sharepoint WebSite you wish to deploy this webpart in. This can be done via the IIS Manager under administrative tools. The default ones would be virtual directories that look like GUIDs under "C:\INETPUB\WWROOT\WSS\".

2) Place the dll under the bin directory in the virtual directory.

3) Under the same virtual directory, find the web.config, and add the following to the SafeControls section -

<SafeControl Assembly="ClassLibrary2, Version=1.0.0.0, Culture=neutral, PublicKeyToken=77dfsdf234933833"Namespace="ClassLibrary2" TypeName="*" Safe="True" AllowRemoteDesigner="True" />

Insted of above step you can also directly deploy it in the Assembly if you are an Administrator, and add the SafeControl in webconfig file.

4) Then browse to the WebSite, and go to Site Actions -> Site Settings.

5) On the site settings page under Galleries column click on the Web Parts

6) Click on "New" in the toolbar,as shown below -

7) Find the ClassLibrary2.MyNewWebPart

8) Now switch to 'Edit Mode' of the page where you want to add the calender control,then click on Add a webpart, you should see it in the list that pops up. Add the MyNewWebPart, and under Miscellaneous.

9) Click 'Exit Edit Mode' you will find the output as below.

Source :kethare.in

Sharepoint 2010 links for beginners

1) http://channel9.msdn.com/learn/courses/SharePoint2010Developer/

2) http://www.microsoft.com/downloads/en/details.aspx?familyid=CFFB14E8-88A9-43BD-87AA-4792AB60D320&displaylang=en

3) http://msdn.microsoft.com/en-us/sharepoint/default.aspx

4) http://www.microsoft.com/downloads/en/details.aspx?FamilyID=83A80A0F-0906-4D7D-98E1-3DD6F58FF059

5) http://blogs.msdn.com/b/pstubbs/

6) http://msdn.microsoft.com/en-us/sharepoint/ff405669.aspx

7) http://blogs.msdn.com/b/sharepoint/

8) http://blogs.msdn.com/b/sharepointdesigner/

9) http://blogs.msdn.com/b/ericwhite/

10) http://blogs.technet.com/b/sharepointexperts/

11) http://blogs.msdn.com/b/ecm/

12) http://blogs.msdn.com/b/erikaehrli/

13) http://blogs.msdn.com/b/pandrew/

14) http://blogs.technet.com/b/speschka/

15) http://blogs.msdn.com/b/sharepointdeveloperdocs/

16) http://blogs.msdn.com/b/bcs/

17) http://technet.microsoft.com/en-us/library/cc263199.aspx

18)

Links for sharepoint blogs

Some of sharepoint Blog links

1) http://community.zevenseas.com/Blogs/Robin/default.aspx

2) http://glorix.blogspot.com/

3) http://www.vyapin.com/blogs/

4) http://www.andrewconnell.com/blog/

5) http://www.bluedoglimited.com/SharePointThoughts/ViewPost.aspx?ID=90

6) http://weblogs.asp.net/jan/

7) http://thedailyreviewer.com/top/sharepoint

8) http://weblogs.asp.net/bsimser/

9) http://blogs.msdn.com/b/mikefitz/

10) http://blogs.msdn.com/b/danielmcpherson/

11) http://weblogs.asp.net/bsimser/archive/2005/10/26/428538.aspx

12) http://blogs.technet.com/b/corybu/

Sharepoint 2010 Tutorials for Developers.

Part 1 - Developing a Visual Web Part in Visual Studio 2010
Part 2 - Developing a List Definition and Event Receiver in Visual Studio 2010
Part 3 - Developing Advanced Web Parts for SharePoint 2010 with Visual Studio 2010
Part 4 - Developing with LINQ to SharePoint in Visual Studio 2010
Part 5 - Developing for SharePoint 2010 with the Client OM and REST in Visual Studio 2010
Part 6 - Developing a BCS External Content Type with Visual Studio 2010
Part 7 - Developing a SharePoint 2010 Workflow with Initiation Form in Visual Studio 2010
Part 8 - Developing SharePoint 2010 User Interface with Silverlight in Visual Studio 2010
Part 9 - Developing SharePoint 2010 Sandboxed Solutions in Visual Studio 2010
Part 10 - Developing SharePoint 2010 User Interface Ribbon and Dialog Customizations

Other Links
Getting Started with Development on SharePoint 2010
Developing SharePoint 2010 User Interface Ribbon and Dialog Customizations
Developing SharePoint 2010 Sandboxed Solutions in Visual Studio 2010
Developing SharePoint 2010 User Interface with Silverlight in Visual Studio 2010
Developing a SharePoint 2010 Workflow with Initiation Form in Visual Studio 2010
Developing a BCS External Content Type with Visual Studio 2010
Developing for SharePoint 2010 with the Client OM and REST in Visual Studio 2010
Developing with LINQ to SharePoint in Visual Studio 2010
Developing Advanced Web Parts for SharePoint 2010 with Visual Studio 2010
Developing a List Definition and Event Receiver in Visual Studio 2010
Developing a Visual Web Part in Visual Studio 2010

Create a Featured News Section with jQuery

One of the fine article that helped me to develop Recent Update in my Sharepoint site using JQuery. The Article is as below
http://wssdevelopment.blogspot.com/2010/04/create-featured-news-section-with.html

Unable to edit the page with error in web part

Have you ever had a web-part that started creating errors that wouldn't allow you to get to your page for editing it? Here's a cool little tip that might get you up and going with much less frustration. Append ?contents=1 to the end of your URL for the page that contains your problematic web part. This will take you to the web-parts management page that will allow you to remove the troublesome web-part from the page. https:////?contents=1

How to move the all database associated with Microsoft SharePoint Server 2010

This article describes how to move all of the databases associated with Microsoft SharePoint Server 2010 from one database server to another database server. If your databases are hosted on different servers, this procedure applies to the database server that hosts the configuration database. For moving content databases only, see Move content databases (SharePoint Server 2010). For moving service application databases only, see Rename or move service application databases (SharePoint Server 2010).

For more Click here

What happen when you create Web application

When SharePoint creates a Web application the following actions happening behind the scene:

Web Ste:

• Creates a unique entry in SharePoint configuration DB for the Web App and assign GUID to that entry;
• Create and configures a Web application in IIS;
• Creates a root folder to store the Web application pages and associated resources;
• Creates and configures an IIS application pool;
• Configures authentication protocol and encryption settings;
• Assign a Default alternate access mapping for the Web app;
• Creates the first content database for the Web application;
• Associate a search service with the Web application;
• Assign a name to the Web application that appears in the Web application list in SharePoint Central Administration;
• Assign general settings to the Web application, such as maximum file upload size and default time zone;

Site Collection:

• Creates the top-level site based on a site definition;
• Sets general properties for the site, such as the site title and site owner;

Source from:http://sharepoint-sandbox.com

Sharepoint Cascading Drop Down

In sharepoint 2007 Custom List while adding new listitem, i want to populate the Customer Name in the dropdown based on the selection of Customer Category. The selection category column contain radio buttons, for each category.

Problem:

I have different lists,base on the selection of radio button i want to bind all the listitem from a particular list. Now the problem is how to access various List base on the selection. I tried it with work flow but it did not helped me, i decide to achieve using custom code, as it is in Newpage.aspx of the List, i have to deploy as custom web-part and i have to add functionality to it, that also not help me due to time constrain.

Solution:

After considering different type of solution i choose two option

1) Using javascript & CSS to hide the required control, (i.e) Based on my selection of the radio buttons field from the list will show up.

2) Develop custom Web part.

3) Using Cascading Drop Down instead of using radio button.

I feel using Javascript & CSS is not a good approch, so i decide to go with web-part at that time i got Cascading Drop Down article." Thanks to DataCogs."

CoolStuff

Source: http://kethare.in

Content Types in Windows SharePoint Services 3.0

Click on the below links to view the video tutorials

1) Building Custom Content Types in Windows SharePoint Services 3.0
In Windows SharePoint Services, a content type is a reusable collection of settings that are applied to a certain category of content. Learn how to build a custom content type by using Microsoft Visual Studio 2005 Extensions for Windows SharePoint Services 3.0.

2) Creating and Using Content Types in Windows SharePoint Services 3.0
Windows SharePoint Services 3.0 introduces a new innovation named Content Types that allows users and developers to create reusable definitions for an item in a list or a document within a document library. This tutorial demonstrates how to create user-defined content types using inheritance and how to configure a document library to use these content types.

3) SharePoint Site Columns and Content Types via a Feature
This video demonstrates how to use Visual Studio to build a SharePoint Feature that creates Site Columns and Content Types.

4) Using Content Types
Content types are designed to help users organize their SharePoint content in a more meaningful way. A content type is a reusable collection of settings you want to apply to a certain category of content. In this video, Rob Windsor will demonstrate how to use content types to define reusable list schemas, how to use content type inheritance, and how to associate multiple content types with a list or library

InfoPath video links

Convert a Word document into an InfoPath 2007 form template
We can import the Word document and excel document into infopath form. The following link has the video for importing Word document Expense report to Infopath form expense repots.

http://office.microsoft.com/home/video.aspx?assetid=ES102063321033&width=884&height=540&startindex=0&CTT=11&Origin=HA102063221033
and also refer introduction of form template and forms

http://office.microsoft.com/en-us/infopath/HA100626851033.aspx


View the business logic in a form template
Watch the demo to see how the Logic Inspector makes it easy to see what fields and groups have business logic associated with them and how this logic is related to other fields and groups in the form template.
http://office.microsoft.com/home/video.aspx?assetid=ES102063511033&width=884&height=540&startindex=0&CTT=11&Origin=HA102063491033
And also refer the same without video

http://office.microsoft.com/en-us/infopath/HA101663011033.aspx


Use InfoPath e-mail forms to view data in Outlook 2007

http://office.microsoft.com/home/video.aspx?assetid=ES102068991033&width=884&height=540&startindex=0&CTT=11&Origin=HA102068981033

Create reusable template parts in InfoPath 2007

http://office.microsoft.com/home/video.aspx?assetid=ES102379651033&width=884&height=540&startindex=0&CTT=11&Origin=HA102374171033

Publish a form template as an e-mail message

http://office.microsoft.com/home/video.aspx?assetid=ES102390201033&width=884&height=540&startindex=0&CTT=11&Origin=HA102383151033

Help users prevent mistakes by using data validation

http://office.microsoft.com/home/video.aspx?assetid=ES102631131033&width=884&height=540&startindex=0&CTT=11&Origin=HA102549111033

Populate a drop-down list box from a SharePoint list

http://office.microsoft.com/home/video.aspx?assetid=ES102811451033&width=884&height=540&startindex=0&CTT=11&Origin=HA102549121033

Find what you need faster with the redesigned Office Online

http://office.microsoft.com/home/video.aspx?assetid=ES102114031033&width=884&height=540&startindex=0&CTT=11&Origin=HA102114011033


Windows Vista and the 2007 Office system — better together

http://office.microsoft.com/home/video.aspx?assetid=ES102154241033&width=800&height=600&startindex=0&CTT=11&Origin=HA102120011033


Store InfoPath forms in a document library on a SharePoint site
http://office.microsoft.com/home/video.aspx?assetid=ES102811461033&width=884&height=540&startindex=0&CTT=11&Origin=HA102636741033

Anonymous user in sharepoint

Today I worked with anonymous user in sharepoint. I want to share links which is useful to me.

1) http://www.learnitfirst.com/Course/225/Video/845/Access-the-SharePoint-Site-as-an-Anonymous-User.aspx
2) http://www.iotap.com/Blogs/tabid/277/EntryId/86/Blocking-Anonymous-Users-from-Sharepoint-List-Pages.aspx
3)https://blogs.msdn.com/pavankumar/archive/2009/02/18/hide-the-sign-in-link-for-the-anonymous-user-sharepoint-moss.aspx
4) http://nirma.org/_layouts/help.aspx?lcid=1033&cid0=MS.WSS.manifest&tid=MS.WSS.HA10113018

User Profiles in Sharepoint

User profile is one of the most important concepts of Sharepoint. It is nothing but adding users to the Sharepoint site and assigns them different kinds of rights to access the resources.

We can add user to the SharePoint from Active directory, LDAP and also from local system user account. There is different types of default users group as below

1) Approvers :
Members of this group can edit and approve pages, list items, and documents.

2) Designers :
Members of this group can edit lists, document libraries, and pages in the site. Designers can create Master Pages and Page Layouts in the Master Page Gallery and can change the behavior and appearance of each site in the site collection by using master pages and CSS files.

3) Hierarchy Managers :
Members of this group can create sites, lists, list items, and documents.

4) NT AUTHORITY\authenticated users :
Use this group to give people contribute permissions to the SharePoint site:

5) Members :
Use this group to give people full control permissions to the SharePoint site:


6) Owners :
Use this group to give people read permissions to the SharePoint site:


7) Visitors :
Use this group to give people read permissions to the SharePoint site:


8) Quick Deploy Users :
Members of this group can schedule Quick Deploy jobs.

9) Records Center Web Service Submitters for Record :
Members of this group can submit records to this Records Center using Web Services.

10) Restricted Readers :
Members of this group can view pages and documents, but cannot view historical versions or review user rights information.

11) Style Resource Readers :
Members of this group are given read permission to the master page gallery and the Restricted read permission to the Style Library. By default, all authenticated users are a member of this group. To further secure this site, you can remove all authenticated users from this group or add users to this group.


12) Viewers :
Members of this group can view pages, list items, and documents. If the document has a server rendering available, they can only view the document using the server rendering.



Individually adding user Permissions
1) Full Control - Has full control.
2) Design - Can view, add, update, delete, approve, and customize.
3) Manage Hierarchy - Can create sites and edit pages, list items, and documents
4) Approve - Can edit and approve pages, list items, and documents
5) Contribute - Can view, add, update, and delete
6) Read - Can view only
7) Restricted Read - Can view pages and documents, but cannot view historical versions or review user rights information
8) View Only - Members of this group can view pages, list items, and documents. If the document has a server-side file handler available, they can only view the document using the server-side file handler
9) Records Center Submission Completion - This role is required to fill in missing properties on records submitted to the Records Center. It is automatically granted to users for each record submitted that is missing properties.