Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a new SP 2007 site which I have been loading about a terabyte of files into. File types include .doc, .docx, .ppt, .pptx, .xls, .xlsx, .xlsm, .jpg, .gif, .pdf.

What I need to do is add custom metadata for each file. Fields include project name and department. Since there are a large number of files, adding the data manually isn't an option.

How could I add it in bulk?

share|improve this question
    
thank you for the answers! I have to put my testing on hold as we are now upgrading to 2010. I will revisit this in a couple of weeks. Sorry for the delay! –  user2404 Feb 23 '11 at 15:58
add comment

4 Answers 4

You could write a simple console application that would do it for you through the SharePoint Object Model. You could also do it with PowerShell.

share|improve this answer
add comment

There are several third party tools that let you do bulk import and bulk metadata setting, with some automation, including DocKIT, RoboMETA, and Classifier.

Since you are adding metadata and importing a very large number of documents, do you really want to put them all in the same document library? There is a limit in 2007. You might look into in the routing capability of the Records Center site template in SharePoint 2007, or move to SharePoint 2010 and use the more flexible Content Organizer or the metadata navigation features.

share|improve this answer
add comment

If you need to use Web Services, you can use UpdateListItem http://msdn.microsoft.com/en-us/library/lists.lists.updatelistitems(v=office.12).aspx

share|improve this answer
    
Console is better for 1 TB –  Nat Feb 28 '11 at 21:19
add comment

you could import the metadata dorectly using a metadata file. Get the sample file from the metadata service application itself.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.