Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Collaboration > Duplication in SharePoint
Ask a questionAsk a question
Search Forums:
 

AnswerDuplication in SharePoint

  • Friday, October 03, 2008 2:14 PMManoj Kumar P Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    I Have to restrict user to enter Item If Title Already Exist. By Default SharePoint only restrict Only The Row Duplication. Any one Help me on this?

     

    Thanks in Advance

     
    Sharepoint
     

Answers

  • Tuesday, October 07, 2008 7:07 AMJamil Haddadin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
     There is a tool on http://www.codeplex.com/features/Release/ProjectReleases.aspx?ReleaseId=2502  called "Uniuq Column policy Feature", download it  (*.wsp file) then install it on your server using the following command:


    C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o addsolution -filename "C:\Documents and Settings\Administrator\Desktop\UniqueColumnPolicy.wsp"

    then go to Central Administration>Operations> Solution management, you will find a solution called uniquecolumnpolicy.wsp, go and deploy it.

    Then go to your document library or list> Settings> docuemnt library settings>Information management policy settings > Select Define a Policy, you will find "Unique Column Policy" then check the "Unique Column Policy" box  next to it, then you will have the list of columns in your document library, select the column you want to apply a unique constrains on.


    Cheers
     
     

All Replies

  • Friday, October 03, 2008 2:32 PMMichael Nemtsev [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Could you explain in more details what are you doing and what's wrong?!
    Visual C# MVP | My SharePoint blog
     
  • Sunday, October 05, 2008 10:09 AMJamil Haddadin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    sharepoint doesnt take care of duplications out of the box, you can easily do it by object model where you can cancel all the new / Editted items that contains a title used in on of the old items.
     
  • Monday, October 06, 2008 2:20 AMburlo Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Write an list item event handler (http://www.wrox.com/WileyCDA/Section/Programming-Event-Handling-in-Windows-SharePoint-Services.id-306329.html) that overrides the ItemAdding method. In this method you want to check if the title exists (i.e use a CAML query not a foreach loop, its more efficient) if it does not exist then add it, other wise cancel the action and display a message to the user.
     
  • Tuesday, October 07, 2008 7:07 AMJamil Haddadin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
     There is a tool on http://www.codeplex.com/features/Release/ProjectReleases.aspx?ReleaseId=2502  called "Uniuq Column policy Feature", download it  (*.wsp file) then install it on your server using the following command:


    C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o addsolution -filename "C:\Documents and Settings\Administrator\Desktop\UniqueColumnPolicy.wsp"

    then go to Central Administration>Operations> Solution management, you will find a solution called uniquecolumnpolicy.wsp, go and deploy it.

    Then go to your document library or list> Settings> docuemnt library settings>Information management policy settings > Select Define a Policy, you will find "Unique Column Policy" then check the "Unique Column Policy" box  next to it, then you will have the list of columns in your document library, select the column you want to apply a unique constrains on.


    Cheers
     
     
  • Tuesday, October 07, 2008 9:12 AMManoj Kumar P Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Thank you Jamil

    I am going to try this tool.
    Sharepoint
     
  • Tuesday, October 07, 2008 11:24 AMManoj Kumar P Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Thank you Jamil,

    That Solution Works for Me

    How ever it is For Single Column Constrains

    Is there any option for Multiple columns constraints

    Thanks in advance

    Manojkumar P

    Sharepoint
     
  • Monday, June 15, 2009 2:04 PMptrive Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
     There is a tool on http://www.codeplex.com/features/Release/ProjectReleases.aspx?ReleaseId=2502  called "Uniuq Column policy Feature", download it  (*.wsp file) then install it on your server using the following command:


    C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o addsolution -filename "C:\Documents and Settings\Administrator\Desktop\UniqueColumnPolicy.wsp"

    then go to Central Administration>Operations> Solution management, you will find a solution called uniquecolumnpolicy.wsp, go and deploy it.

    Then go to your document library or list> Settings> docuemnt library settings>Information management policy settings > Select Define a Policy, you will find "Unique Column Policy" then check the "Unique Column Policy" box  next to it, then you will have the list of columns in your document library, select the column you want to apply a unique constrains on.


    Cheers
     

    Thank you Jamil,

    Is there any option available to avoid duplicate entried in column (multilines)?
    Do we need to srite any event handler for work breaker or something like that ?

    Regards
    Pramod