I have searched for a ssolution to copy a list item in a top site to a list in a subsite. Unfortunately are there no workable solution. This is the configuration
SharePoint 2013 Standard server
In the top site  an Issue tracking list with customized columns for projectnumber. I want to copy a list item to a subsite with the projectnumber as the last part of the url being the projectnumber. The list in the subsite should be an issue tracking list with the same columns as the list in the topsite.
Is the best solution a workflow or a coded solution? Anyone have an example of such a solution?
Best regards,
Ove Bristrand NetIntegrate Sweden AB
(Visited 217 times, 1 visits today)
Hi,
We can achieve by using the server object model.Please find the below code:
namespace CopyListItems { class Program { static void Main(string[] args) { try { SPSite mySourceSite = new SPSite("http://fivenumber:5/"); SPWeb mySourceWeb = mySourceSite.OpenWeb(); SPList mySourceList = mySourceWeb.Lists["Source List"]; SPQuery mySourceListQuery = new SPQuery(); mySourceListQuery.Query = "" + "" + "" + "" + ""; SPListItemCollection mySourceItemColl = mySourceList.GetItems(mySourceListQuery); int count = 0; foreach (SPListItem mySourceListItem in mySourceItemColl) { string SourceEmpId = mySourceListItem["Employee Id"].ToString(); string SourceEmpName = mySourceListItem["Employee Name"].ToString(); string SourceDesig = mySourceListItem["Designation"].ToString(); string SourceAge = mySourceListItem["Age"].ToString(); SPSite myDestinationSite = new SPSite("http://fivenumber:50"); SPWeb myDestinationWeb = myDestinationSite.OpenWeb(); SPList myDestinationList = myDestinationWeb.Lists["Destination List"]; SPListItem myDestinationListItem = myDestinationList.Items.Add(); myDestinationListItem["Employee Id"] = SourceEmpId; myDestinationListItem["Employee Name"] = SourceEmpName; myDestinationListItem["Designation"] = SourceDesig; myDestinationListItem["Age"] = SourceAge; myDestinationWeb.AllowUnsafeUpdates = true; myDestinationListItem.Update(); myDestinationWeb.AllowUnsafeUpdates = false; count++; Console.WriteLine(count+" item(s) copied"); } Console.WriteLine("Press enter to continue"); Console.ReadLine(); } catch (Exception ex) { Console.Write(ex); Console.WriteLine("Press enter to continue"); Console.ReadLine(); } } } }
Thanks,
ManjunathaReddy
(Visited 1 times, 1 visits today)
