Is it possible to have duplicate columns from source List to target List while copying data items by Site Content and Structure Tool in SharePoint 2010

Hi everyone,

Recently ,I have one publishing site template that has a lot of sub sites which  contain a large amount of  content. 

On root publishing site, I have created custom list including many custom fields  and saved it as  template  in order that  any sub sites will be able to reuse it later on .  My scenario describe as follows.

  • I need to apply Site Content and Structure Tool to copy   a lot of items  from  one list to another. Both lists were created from same template
  • I  use Site Content and Structure Tool to copy data from source list  to target list  as figure below.

  • Once copied  ,  all items are completed.  But many columns in target list have been duplicated from source list such as  PublishDate ,NumOrder, Detail  as   figure below  .


     

What is the huge impact from this duplication?


  • User  can input data into this list successfully   but several values of some columns like  Link column  won't  display on AllItems.aspx page  .  despite that they show on edit item form page and view item form page.
  • In addition ,user  can input data into this list  as above but  any newly added item  won't appear on  on AllItems.aspx page at all  despite that actually, these  item are existing on  database(I try querying by power shell).

Please recommend how to resolve this column duplication problem.


April 20th, 2015 1:21pm

Hi,

According to your description, my understanding is that it displayed many repeated columns after you copy items from one list to another list in Site Content and Structure Tool.

I have tested in my environment and it worked fine. I created a listA and created several columns in it. Then I saved it as template and created a listB from this template. Then I copied items from listA to listB in Site Content and Structure Tool and it worked fine.

Please create a new list and save it as template. Then create a list from this template and test whether this issue occurs.

Please operate in other site collections and test whether this issue occurs.

As a workaround, you could copy items from one list to another list by coding using SharePoint Object Model.

More information about SharePoint Object Model:

http://msdn.microsoft.com/en-us/library/ms473633.ASPX

A demo about copying list items using SharePoint Object Model:

http://www.c-sharpcorner.com/UploadFile/40e97e/sharepoint-copy-list-items-in-a-generic-way/

Best Regards,

Dean Wang

Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 1:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics