Solved

SharePoint 2010 Document Library

Posted on 2013-10-24
5
553 Views
Last Modified: 2013-10-26
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
Comment
Question by:Lord_Dragon
  • 2
5 Comments
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
ID: 39599466
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
 
LVL 15

Expert Comment

by:colly92002
ID: 39600020
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
 

Author Closing Comment

by:Lord_Dragon
ID: 39600174
Thats a very thoughtful and creative resolution and more imporantly, it worked!! Thanks Teylyn, that was very nice indeed.
0
 
LVL 50

Expert Comment

by:teylyn
ID: 39603501
Glad it worked for you, Lord_Dragon. Thanks for the grade.

- teylyn
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now