Solved

How to archive list items on SharePoint 2010?

Posted on 2013-01-15
4
2,357 Views
Last Modified: 2013-02-04
I have a very large list on SP 2010 Ent. What would be the best way to automate archiving: items older than 1 year are moved to another list (same site) and items older than 5 years are deleted from that second list.
0
Comment
Question by:MisUszatek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
Mohit Nair earned 200 total points
ID: 38780975
A custom workflow is required pointing to the created by and modified by column and then initiate the workflow

Reference article:
http://referpages.com/wp/2012/04/101/
0
 
LVL 29

Expert Comment

by:QPR
ID: 38781239
If you go to your list settings tab and then to Information management policy settings, you can set up a retention schedule for that folder which will move items to a different location. This retention schedule can be set to be X number of years after the list item created date.

This is discussed here:
http://blogs.msdn.com/b/ecm/archive/2011/10/12/policy-and-retention-in-sharepoint-server-2010.aspx
0
 

Author Comment

by:MisUszatek
ID: 38794325
I used the option from the link suggested by mohitnair87. It works very well but unfortunately Created and Modified dates are not preserved. Is there a way to preserve those dates?
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 150 total points
ID: 38794353
Given that you are creating a new record you may need to get the values from the original items and put them into your own columns in the destination list
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question