I came across a scenario where I want to copy large amount of content from one sharepoint list to another. I have done this by creating custom view on lists and copied contents using datasheet view.
Please follow these steps to achieve this.
- Create one list view for both lists which should contain all the columns that you want to copy, also make sure that columns are not read only and they are not system generated columns like “Created by, Created”.
- Open both lists in different browsers
- Select newly created view for both list
- Open this view in datasheet view on both lists
- Select all the items in the source list and click copy
- Select the first cell of the available row in the destination list and click paste
- All your items should be copied successfully, now you can open the list in standard view and see that all data is copied.
This works as long as you don’t need to copy any of the system generated content like (created by filed). You need to use list view web parts or write custom code to achieve that.
Niyaz
Aziz
Nice to see this, but is there any automate process for archiving the list items i Sharepoint 2010?
Aziz
Hi
Build a workflow and have it activated by the expiration Information Management Policy in the list. Take a look at the following article:
http://technet.microsoft.com/en-us/library/cc262490.aspx
Regards
Aziz
long distance movers
This is a great inspiring article. I am pretty much pleased with your good work. You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post.