Sharepoint 2010 - Archiving the files from one document library to another document library in sharepoint site

I have a requirement to move the documents from one document library to another document library.
Source Library - DocumentLib
Destination Library - Archive
Archive document library will have folders by fiscal year.
Source documentlibrary has files from year 2012 till date.
Archive folder will have folders by fiscal year -(fiscal year starts from July1st -June 30th )
If the document is created date  between 1st  July 2012 -June 2013 then move the document to Archive document library and in  folder Fiscal Year 2013.
If the document is created date  between 1st  July 2013 -June 2014 then move the document to Archive document library and in  folder Fiscal Year 2014.
Please find attached the screenshot of the requirement.
Structure of destination document library folder should be same as source document library.(The columns). Files Type - Excel,pdf,microsoft outlook item
Could we use Sharepoint designer workflow to achive this task?
Any help on this will be appreaciated.
MovingItemsYrwise.png
DocLibStructure.png
asrithapAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Justin SmithSr. System EngineerCommented:
A retention policy MAY be the thing for you.  Not sure if you can point to a folder though.

http://blogs.askcts.com/2013/05/14/creating-a-timed-workflow-in-sharepoint-2010/
0
asrithapAuthor Commented:
I have tried this but does not help it.I  am able to move the items from library by associating the retention policy workflow to a library. But creating folders in workflow is the challaenge. Any idea how to create sub folders in sharepoint designer workflow and move the items into this folders by fiscal year.
0
Justin SmithSr. System EngineerCommented:
Not that I'm aware of.  Designer workflows can only move to libraries and cannot specify a folder.  You would likely need to do a Visual Studio workflow for that, or possibly find a custom designer workflow action out on the web.


http://social.msdn.microsoft.com/Forums/en-US/2a3c5e5b-4fb2-4d8a-8e1b-0d56d032fece/copy-list-item-into-a-document-library-folder
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

asrithapAuthor Commented:
Thank you for your response.Will the concept of Content Organizer help me in achieving the task?
0
Justin SmithSr. System EngineerCommented:
I don't believe that works based on a date.
0
asrithapAuthor Commented:
If we want to use Content Oraganizer concept, then for already created files how to add the content type (Date) information?
 
I am moving files to Drop off library from another source library using workflow. These files are old and does not contain content type information.I have tried adding the content type information to already uploaded file using Datasheet view. But those files that are updated with content type information are not being moved to destination folder in doc library. But the new files that I have uploaded directly to Drop off library with content type information re moved to Destination Document library folder. Could suggest me any ideas to overcome this issue. Am I missing something?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.