We are in the process of migrating several documents from multiple document libraries into one central document library. I need to copy all of the files located in one document library on our SharePoint 2010 Foundation site to another document library. Both document libraries have the same content type but one document library is in a different subsite than the other.
I am easily able to copy the files from one document library using the Open with Explorer command under the Library tab in Library Tools. Obviously this opens windows explorer view of the files located in this document library, and I copied and pasted them into the location of the document library I want to copy them to. This works great with documents in other document libraries in the same subsite. When I do this however with a document library in a different subsite, the files come over and I can view them and everything works, only the meta data is not coming over (Title, and a few custom column values). It is important for our case to get the metadata coming over, and there are hundreds of documents so it would be a major pain to have to manually add them in one by one.
Any help will greatly be appreciated.