Utility to extract documents/metadata from document libraries to Excel/folders

Question

Hi,

Do we have any utility/tool created for any of our customers where it extracts documents/metadata from document libraries in a given site and puts the metadata into Excel, files (along with versions) to folders?

Please let me know if you have any info?

Thanks & Regards,

Sudheer

---

Thanks & Regards, Sudheer

Answer 1

Hi,

As far as I know, you can get the metadata properties of the items in a document library through code. For example, first, you can access a document library through managed object model, then export each item’s metadata into a file.

For more information about how to use managed Client Object Mode, check out the following article:

http://www.aboutsharepoint2010.com/2012/03/29/how-to-get-files-from-document-library-silverlight-client-object-model/

Thanks,

Rock Wang

---

Rock Wang TechNet Community Support

Answer 2

Hi Rock,

Thanks for the info.

With the posted article i am able to get the document library name but not able to get version info.

Thanks & Regards,

Sudheer

---

Thanks & Regards, Sudheer

Answer 3

This tool helps you to manage managed metadata in SharePoint 2010. It can create and delete terms and term sets, import term sets, EXPORT term sets in a .csv file, ...
This solution also shows how to access Managed Metadata by the web service TaxonomyClientService

SolidQ Managed Metadata Exporter for SharePoint 2010

http://metadataexportsps.codeplex.com/

hope so this helps you

---

Pious P P | Enthusiastic about SharePoint

Answer 4

Hi,

Check out the below code snippet to get version history of a document using .net managed client object model

public void GetVersions()

{

ClientContext clientContext = new ClientContext(“http://SPSite”);

Web site = clientContext.Web;

clientContext.Load(site);

clientContext.ExecuteQuery();

File file = site.GetFileByServerRelativeUrl(“/Shared Documents/mydocument.doc”);

clientContext.Load(file);

clientContext.ExecuteQuery();

ListItem currentItem = file.ListItemAllFields;

clientContext.Load(currentItem);

clientContext.ExecuteQuery();

FileVersionCollection versions = file.Versions;

clientContext.Load(versions);

clientContext.ExecuteQuery();

if (versions != null)

{

foreach(FileVersion _version in versions)

{

Console.WriteLine(“Version : {0}”,_version.VersionLabel);

}

}}

http://www.aboutsharepoint2010.com/2012/03/30/sharepoint-2010-get-document-version-history-using-client-object-model/

Thanks,

Rock Wang

---

Rock Wang TechNet Community Support