Duplication in SharePoint

모든 응답

• 2008년 10월 3일 금요일 오후 2:32Michael Nemtsev [MVP]MVP

   
  

  0

  로그인하여 투표
  Could you explain in more details what are you doing and what's wrong?!

  ---

  Visual C# MVP | My SharePoint blog
  • 응답
  • 인용

   
• 2008년 10월 5일 일요일 오전 10:09Jamil Haddadin

   
  

  0

  로그인하여 투표
  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.
  
  • 응답
  • 인용

   
• 2008년 10월 6일 월요일 오전 2:20burlo

   
  

  0

  로그인하여 투표
  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.
  • 응답
  • 인용

   
• 2008년 10월 7일 화요일 오전 7:07Jamil Haddadin

   
  

  0

  로그인하여 투표
   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
   

  • 답변으로 표시됨Manoj Kumar P 2008년 10월 7일 화요일 오전 11:22
  •  
  • 응답
  • 인용

   
• 2008년 10월 7일 화요일 오전 9:12Manoj Kumar P

   
  

  0

  로그인하여 투표
  Thank you Jamil
  
  I am going to try this tool.
  

  ---

  Sharepoint
  • 응답
  • 인용

   
• 2008년 10월 7일 화요일 오전 11:24Manoj Kumar P

   
  

  0

  로그인하여 투표
  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
  • 응답
  • 인용

   
• 2009년 6월 15일 월요일 오후 2:04ptrive

   
  

  0

  로그인하여 투표

   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
  • 응답
  • 인용