Advertisement
PtiTom

SharePoint List Sync

Mar 6th, 2013 (edited)
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Fill parameters here
  2. $sourceWebUrl = "http://vm-tme-w2k8/sites/DEV/Child1/Child2"
  3. $sourceListName = "SourceList"
  4. $sourceKeyField = "Title"
  5. $sourceDataField = "Body"
  6.  
  7. $targetWebUrl = "http://vm-tme-w2k8/sites/DEV/Child1/Child2"
  8. $targetListName = "TargetList"
  9. $targetKeyField = "Title"
  10. $targetDataField = "Body"
  11.  
  12. # Script code.
  13. $sourceWeb = Get-SPWeb $sourceWebUrl
  14. Write-Host $sourceWeb
  15. $sourceList = $sourceWeb.Lists[$sourceListName];
  16. Write-Host $sourceList.DefaultViewUrl
  17.  
  18. $SPAssignment = Start-SPAssignment
  19. $targetWeb = Get-SPWeb $targetWebUrl -AssignmentCollection $SPAssignment
  20. Write-Host $targetWeb
  21. $targetList = $targetWeb.Lists[$targetListName];
  22. Write-Host $targetList.DefaultViewUrl
  23.  
  24. for ($sourceItemIndex = 0 ; $sourceItemIndex -lt $sourceList.ItemCount ; $sourceItemIndex++)
  25. {
  26.     for ($targetItemIndex = 0 ; $targetItemIndex -lt $targetList.ItemCount ; $targetItemIndex++)
  27.     {
  28. #$SPItem = $SPList.Items | Where { $_["Title"] -eq "New Announcement" }
  29.         if ($sourceList.Items[$sourceItemIndex][$sourceKeyField] -eq $targetList.Items[$targetItemIndex][$targetKeyField])
  30.         {
  31.             $targetItem = $targetList.Items[$targetItemIndex];
  32.            
  33.             Write-Host -ForegroundColor Green "Found matching Title : "$targetItem[$targetKeyField]
  34.             Write-Host -ForegroundColor Cyan "REPORT : Change for item '"$targetItem[$targetKeyField]"' : Value '"$targetItem[$targetDataField]"' became '"$sourceList.Items[$sourceItemIndex][$sourceDataField]"' END_REPORT"
  35.             $targetItem[$targetDataField] = $sourceList.Items[$sourceItemIndex][$sourceDataField];
  36.             $targetItem.SystemUpdate();
  37.         }
  38.     }
  39. }
  40.  
  41. Stop-SPAssignment $SPAssignment
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement