Server: Win2003 + SharePoint Service 3
需求: 當透過WSS UI的「儲存清單為範本」+「包括內容」選項將清單匯出後，再匯入時，所有清單項目的「建立者」欄位都會變成匯入人的名字。如果資訊人員佛心來的想替使用者改掉... 是可以做的，寫程式囉。
利用Microsoft提供的SharePoint API: Microsoft.SharePoint.dll。這支dll可以在SharePoint server上的\\Computer_Name\Drive$\Program Files\Common Files\Microsoft Shared\web server extensions\12\ISAPI 內找到。
但是，如果你覺得把他複製出來到自己本機開發那就錯了。這麼做應該會遇到「無法載入檔案或組件或其相依性的其中之一」的錯誤，就像這篇SharePoint Forums上的討論，請直接在裝有SharePoint Service的server上做開發.. 如果有測試機器是再好不過的，就可以參考這篇文章(Can we update the values of “Created By”, "Modified By” columns in SharePoint lists?)直接在Visual Studio上參考上述組件做開發。
如果你正好沒有測試環境，而且也無法在production上安裝VisualStudio這麼龐大的怪物的話，就參考這篇文章(Updating the “Created By” and "Modified By” Columns in SharePoint lists using POWERSHELL)。沒錯! 就是用POWERSHELL。這也是我用的方法。
script:
1: # Get the SharePoint Assembly
2: # You will need to run this on the SharePoint Server
3: [Reflection.Assembly]::Load("Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
4: 5: # create a new object called $SPSite
6: # Make sure you have the last “/” in the url on the site
7: # allow $SPWeb to be the OpenWeb from the site
8: $SPSite = New-Object Microsoft.SharePoint.SPSite("http://server-name/")
9: $SPWeb = $SPSite.OpenWeb() 10: 11: # Get the list ModifyCreatedBy
12: $SPList = $SPWeb.Lists["ListName"]
13: 14: # Get the Collection of the List Items
15: $SPListItemCollection = $SPList.Items 16: 17: # iterate the Collection
18: foreach ($ListItem in $SPListItemCollection)
19: { 20: 21: # The user in this case was UserA with id of 8 from the SPWeb users
22: $SPFieldUserValue = New-Object Microsoft.SharePoint.SPFieldUserValue($SPWeb,8,"UserA")
23: 24: $ListItem["Author"] = $SPFieldUserValue
25: 26: # Note: Editor will be the account that you are running the Powershell under unless you update Editor as well
27: # ListItem["Editor"] = $SPFieldUserValue
28: 29: $ListItem.Update() 30: } 31: 32: $SPWeb.Update() 33: 34: # Still TODO Disposes, Error Checking, Change to take Parameters, etc
35:
上面的script是改了整個指定清單的建立者欄位，如果你還需要先判斷是那些文件，可以參考一下MSDN Library看看SPListItem還有哪些properities可以用。若是powershell語法不熟的話(尤其他又喜歡跟一般語法同.... 特別是比較運算子...)，請參考reference#4, #5，或自行google。
嗯.. 大概就以上資訊，即可作業!!
Ref:
- [SharePoint Forums] Could not find Microsoft.SharePoint.Library.dll
- [MSDN Blog] Can we update the values of “Created By”, "Modified By” columns in SharePoint lists?
- [MSDN Blog] Updating the “Created By” and "Modified By” Columns in SharePoint lists using POWERSHELL
- [TechNet 技術文件庫] Running Windows PowerShell Scripts
- [賴榮樞的軟體資訊誌] scripting_PowerShell tag
- [MSDN Library] Microsoft.SharePoint Namespace
Posts
