Tuesday, May 22, 2012

Moving List Items from one list to another list in SharePoint 2010

If we want to move the list items from one list to another  Here is the simple way

1.Lets be on the existing list, click List tab on the ribbon bar and click List Settings icon.

2.Click “Save list as template” link that exists under Permission and Management section which will bring up another page where you need to provide template File Name, Template name and Template Description. Make sure you didn’t check “Include Content” checkbox. Then, click the OK button.
This step is to move the structure of the list to another .Surely there are other ways to do so like creating a list and then opening the list in access view and then copying the columns . but I am trying to make it simple

3.Go to Site Actions => More options => Click List under Filter By section. You can see the template which has been created in the previous step as part of other templates on the right pane. Choose the template and provide list name.

4.If there are any workflows associated with the existing list that may still persist on the newly created destination list.
Usually when lists are saved as template, all workflows associated to the original list will be saved as part of template except currently running workflows.
Make sure all workflows associated with the original list have been removed if it’s not required. To remove workflows associated to list, go to List Settings Click on Workflow Settings Click “Remove a workflow” link, choose Remove option and click OK button.

5.Open the New List,
Go to Site Actions => Manage Content and Structure, choose the Original List on the left pane.

6.You can increase the currently showing items up to 1000
 sort list items by clicking column header and choose all items by clicking Select All option (displyaed top-left corner on the header) or individual items can be selected by clicking the checkbox displayed on each individual item.

7.Click “Actions” =>  Move Or copy and choose the target list the newly created list
I would suggest you Copy the items instead of moving which is always safe and then delete the list after checking if everything is working fine on the new list.

8.Finally click the OK button and wait until the list items are moved or copied to destination list.
You can redo the above steps till all the items are copied or moved to the new list
 You need to be a site collection admin or should have full control on both the root site and the destination site .

No comments:

Post a Comment

Users cannot see the checked out files in the folder/ library

I Came across a Issue today wherein the user opened a ticket for the below issue Issue : Users cannot see the checked out files in the fo...