Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

SharePoint 2010 Document Library

I have a document library in SharePoint that houses over 400 documents.

Within this document library is a column titled "Status".

All of the documents fall under 1 of 2 Statuses, "Active" and "Archive"

Is there a way I can change the status of all of the "Active" documents to "Archive" without having to edit each document one at a time?
0
Lord_Dragon
Asked:
Lord_Dragon
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

not out of the box, no. One thing you can try is to create a view that shows the column, sort by the column. Then use the Datasheet view, change the first item, then copy down like in an Excel spreadsheet (Select first cell to last cell, use Ctrl-D).

This will not work if the library requires checking out of documents before they are edited. You may try to change that setting to allow changes with no check out, then do the above, then revert back to require check out.

If that is not an option, there are third party tools (not free), like MetaVis Information Manager that can update metadata in bulk.

cheers, teylyn
0
 
colly92002Commented:
You can use Powershell to do this.

Here is the simplest way of updating all documents in a library:
http://blogs.msdn.com/b/paulking/archive/2011/10/04/using-powershell-scripts-to-modify-document-properties-in-sharepoint-2010.aspx

You need to change the update command to something like this:

 # Updates the title for each item in the list with Name
$docs.items | ForEach { $_["Status"] = "Archive"; $_.Update() }

Open in new window


If you have never done this before be very very careful and make sure you have backups available.  I would revommend you trying this on a test site before doing anythign on the live site.
0
 
Lord_DragonAuthor Commented:
Thats a very thoughtful and creative resolution and more imporantly, it worked!! Thanks Teylyn, that was very nice indeed.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Glad it worked for you, Lord_Dragon. Thanks for the grade.

- teylyn
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now