C# 将列表项从一个列表复制到 sharepoint 中的另一个列表
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1075323/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
copy list items from one list to another in sharepoint
提问by raklos
In Sharepoint how can you copy a list item from one list to another list eg copy from "List A" to "List B" (both are at the root of the site)
在 Sharepoint 中，如何将列表项从一个列表复制到另一个列表，例如从“列表 A”复制到“列表 B”（两者都位于站点的根目录）
I want this copying to occur when a new list item is added to "List A"
我希望在将新列表项添加到“列表 A”时发生这种复制
I tried using the CopyTo() method of an SPListItem inside the ItemAdded event receiver but couldnt figure out the url to copy to.
我尝试在 ItemAdded 事件接收器中使用 SPListItem 的 CopyTo() 方法，但无法找出要复制到的 url。
采纳答案by Johan Leino
Indeed as Lars said, it can be tricky to move items and retain versions and correct userinfo. I have done similar things with that before so if you need some code examples, let me know through a comment and can supply you with some guidance.
事实上，正如 Lars 所说，移动项目并保留版本和更正用户信息可能很棘手。我之前做过类似的事情，所以如果您需要一些代码示例，请通过评论告诉我，并可以为您提供一些指导。
The CopyTomethod (if you decide to go with that) need an absolute Uri like: http://host/site/web/list/filename.doc
该CopyTo从方法（如果你决定去与）需要一个绝对URI，如： HTTP：//host/site/web/list/filename.doc
So, if you are performing this in an event receiver you need to concatinate a string containing the elements needed. Something like (note that this can be done in other ways to):
因此，如果您在事件接收器中执行此操作，则需要连接一个包含所需元素的字符串。类似于（请注意，这可以通过其他方式完成）：
string dest=
siteCollection.Url + "/" + site.Name + list.Name + item.File.Name;
回答by Lars Fastrup
Copying and moving files, items and folders in SharePoint can be tricky if you want to retain all metadata, timestamps, author info and version history. Take a look a CopyMove for SharePoint- it also has a Web Service API.
如果您想保留所有元数据、时间戳、作者信息和版本历史记录，在 SharePoint 中复制和移动文件、项目和文件夹可能会很棘手。看看SharePoint的CopyMove- 它还有一个 Web 服务 API。
回答by UnhipGlint
So, the lists have the exact same or similar columns? Either way, you could create a simple workflow that runs automatically when an item is created in "List A". Since the workflow in question is relatively simple, I'd recommend using SharePoint Designer (which is free) to create it, since you can easily match up the columns from the two lists. The walk through below should be able to help you get started.
那么，列表具有完全相同或相似的列吗？无论哪种方式，您都可以创建一个简单的工作流，该工作流在“列表 A”中创建项目时自动运行。由于所讨论的工作流相对简单，我建议使用 SharePoint Designer（免费）来创建它，因为您可以轻松匹配两个列表中的列。下面的演练应该能够帮助您入门。
回答by Sylvain Perron
Here is the code I use. Pass it a SPlistItem and the name of the destination list as seen in Sharepoint(Not the URL). The only restriction is that both list must be in the same site:
这是我使用的代码。将 SPlistItem 和目标列表的名称传递给它，如 Sharepoint（不是 URL）中所示。唯一的限制是两个列表必须在同一个站点中：
private SPListItem CopyItem(SPListItem sourceItem, string destinationListName) {
//Copy sourceItem to destinationList
SPList destinationList = sourceItem.Web.Lists[destinationListName];
SPListItem targetItem = destinationList.Items.Add();
foreach (SPField f in sourceItem.Fields) {
//Copy all except attachments.
if (!f.ReadOnlyField && f.InternalName != "Attachments"
&& null != sourceItem[f.InternalName])
{
targetItem[f.InternalName] = sourceItem[f.InternalName];
}
}
//Copy attachments
foreach (string fileName in sourceItem.Attachments) {
SPFile file = sourceItem.ParentList.ParentWeb.GetFile(sourceItem.Attachments.UrlPrefix + fileName);
byte[] imageData = file.OpenBinary();
targetItem.Attachments.Add(fileName, imageData);
}
return targetItem;
}
回答by Sebastien
There's many tools on the market for copying a list item to another list (avepoint, metavis, etc.) but they are pretty expensive if you're planning to do this on only one list.
市场上有许多工具可用于将列表项复制到另一个列表（avepoint、metavis 等），但是如果您打算仅在一个列表上执行此操作，则它们非常昂贵。
If you can do this manually once a week for example, look at the following tool : http://en.share-gate.com/sharepoint-tools/copy-move-sharepoint-list-items-with-metadata-and-version-history
例如，如果您可以每周手动执行一次此操作，请查看以下工具：http: //en.share-gate.com/sharepoint-tools/copy-move-sharepoint-list-items-with-metadata-and-版本历史
回答by hrezs
I had the same problem.
我有同样的问题。
After experimenting a bit instead of
经过一番试验而不是
targetItem[f.InternalName] = sourceItem[f.InternalName];
targetItem[f.InternalName] = sourceItem[f.InternalName];
I used:
我用了：
targetItem[childField.Title] = sourceItem[parentField.Title];
targetItem[childField.Title] = sourceItem[parentField.Title];
回答by Daniel
Here is a powershell equivalent of Sylvian's that does allow for cross-site copy. His code could be modified similarly as well...
这是一个相当于 Sylvian 的 powershell，它确实允许跨站点复制。他的代码也可以类似地修改......
param([string]$sourceWebUrl, [string]$sourceListName, [string]$destWebUrl, [string]$destListName)
$sourceWeb = get-spweb $sourceWebUrl;
$sourceList = $sourceWeb.Lists[$sourceListName];
$destWeb = get-spweb $destWebUrl;
$destList = $destWeb.Lists[$destListName];
$sourceList.Items |%{
$destItem = $destList.Items.Add();
$sourceItem = $_;
$sourceItem.Fields |%{
$f = $_;
if($f.ReadOnlyField -eq $false -and $f.InternalName -ne "Attachments" -and $sourceItem[$f.InternalName] -ne $null){
$destItem[$f.InternalName] = $sourceItem[$f.InternalName];
}
}
$destItem.Update();
}
To use, copy and past to a file copy-listitems.ps1 and run using Sharpoint powerhsell commandline...
要使用、复制并粘贴到文件 copy-listitems.ps1 并使用 Sharpoint powerhsell 命令行运行...
回答by Ievgen Naida
How to copy field and save versions:
如何复制字段和保存版本：
public static SPListItem CopyItem(SPListItem sourceItem, SPList destinationList)
{
SPListItem targetItem = destinationList.AddItem();
//loop over the soureitem, restore it
for (int i = sourceItem.Versions.Count - 1; i >= 0; i--)
{
//set the values into the archive
foreach (SPField sourceField in sourceItem.Fields)
{
SPListItemVersion version = sourceItem.Versions[i];
if ((!sourceField.ReadOnlyField) && (sourceField.InternalName != "Attachments"))
{
SetFields(targetItem, sourceField, version);
}
}
//update the archive item and
//loop over the the next version
targetItem.Update();
}
foreach (string fileName in sourceItem.Attachments)
{
SPFile file = sourceItem.ParentList.ParentWeb.GetFile(sourceItem.Attachments.UrlPrefix + fileName);
targetItem.Attachments.Add(fileName, file.OpenBinary());
}
targetItem.SystemUpdate();
return targetItem;
}
private static bool SetFields(SPListItem targetItem, SPField sourceField, SPListItemVersion version)
{
try
{
targetItem[sourceField.InternalName] = version.ListItem[sourceField.InternalName];
return true;
}
catch (System.ArgumentException)//field not filled
{
return false;
}
catch (SPException)//field not filled
{
return false;
}
}
回答by Petr ?pa?ek
Make sure you call CopyTo(url) method on SPFile, not on SPListItem. for example:
确保在 SPFile 上调用 CopyTo(url) 方法，而不是在 SPListItem 上。例如：
ItemUpdated(SPItemEventProperties properties)
{
//...
string url = properties.Web.Site.Url + "/" + properties.Web.Name + "Lists/ListName/" + properties.ListItem.File.Name;
//properties.ListItem.File.MoveTo(url);
properties.ListItem.File.CopyTo(url);
//...
}
回答by Sunny Sinha
private void CopyAttachmentsToList(SPListItem srcItem, SPListItem tgtItem)
{
try
{
//get source item attachments from the folder
SPFolder srcAttachmentsFolder =
srcItem.Web.Folders["Lists"].SubFolders[srcItem.ParentList.Title].SubFolders["Attachments"].SubFolders[srcItem.ID.ToString()];
//Add items to the target item
foreach (SPFile file in srcAttachmentsFolder.Files)
{
byte[] binFile = file.OpenBinary();
tgtItem.Update();
tgtItem.Attachments.AddNow(file.Name, binFile);
tgtItem.Update();
}
}
catch
{
//exception message goes here
}
finally
{
srcItem.Web.Dispose();
}
}
Don't forget to add this line, tgtItem.Update();, else you will get an err.
不要忘记添加这一行tgtItem.Update();，否则你会得到一个错误。
