Solved

How to make files marked "edited" shown as checked out

Posted on 2011-02-17
8
387 Views
Last Modified: 2012-06-27
I have a large group of users they want to have files that are "edited" to be marked in the same way as "checked out"

Files that are "checked out" can be seen via the "Checked Out To" column in document views, while those documents that users have selected "edit" do not display who has the file open for editing.

Is there a way to fix this?
0
Comment
Question by:InfoZenHQ
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 8

Expert Comment

by:nsyyoung
ID: 34918435
If a file is checked out, it would be edited by that person, so the column would be the same.  It sounds like an extra step, but you could create a calculated column to mirror the Checked Out column and call it Being Edited By, then show that column in views, right next to Modified By, so you can see who had it last and who has it now.

It sounds like a semantics matter, or did I miss the point?

Oh, but that would only apply if the doc library has Check Out/Check In enabled.  Is that not the case and they want a separate field to warn them that someone has it out?  Same thing: create a Being Edited By column, maybe a people picker populated by a SharePoint Group, that you could show in views.  You'd have to stress the importance of manually updating that field when a file is being edited or not.  

I would recommend enabling CO/CI and using the default Checked Out To column, or a mirrored column with a prettier name.
0
 

Author Comment

by:InfoZenHQ
ID: 34918662
The proposal team doesn't want to go through the "extra steps" the check in and out all the time. They want to use edit. In addition to CO/CI and while the CO/CI works fine on the site now and so does the column "Checked out to" I need help with the files in "edit" rather than CO

I've been looking for a "Being edited by" but it does not seem to exist. I guess then my next question is where and how would I go about creating that column. I just don't have that as an option at this time.

0
 
LVL 8

Accepted Solution

by:
nsyyoung earned 500 total points
ID: 34918844
You have to create it.  Make sure there is a sharepoint group to choose from, then go to site columns > Create > (call it whatever you want) Person or Group.   Choose your SharePoint Group from the availabe groups list toward the bottom > OK.

Then add your column to your library (and content type, if you're using them) and add it to views as needed.

If they don't want to check out, though, I don't have high hopes for the extra step of making sure this new field is current.

You can tell them that enabling CO/CI and choosing the "Edit in <office application>" choice from the file's context menu will either automatically check it out or prompt them to do so, and that just closing the file and being automatically prompted to check it in are WAY less effort than redoing a file because person A didn't keep the column updated and person B wrote over it.

Be wary of setting wag-the-dog precedents like this.  It could make your site administration nightmarish.  I speak from experience.  :)

0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:InfoZenHQ
ID: 34919061
I guess I meant more how do I create a column that automatically updates in the same way "Checked Out To" function except with Edit. That's really want I need. I don't want a field they have to enter in data.

Imagine that Bob starts to edit a document thinking "I'll be done in 5 minutes no one will ever know". Bob suddenly has to run home and take care of a sick kitten and forgets to release the document. We need to know who to yell at to release the document when it's in edit mode.

I tried creating the column in the following way (and I really apologize but I'm barely familiar with sharepoint at a user level and now I have to admin the site so please bear with me).

I put the name:                          test
for the type:                              person or group
Description:                              <blank>
Require column contain data:   No
Allow multiple selections:         No
Allow Selection of:                   People only
Choose from:                           All users
Show field                               name with presence

I added it to the document library
When "Evil Eve" CO a file the "Checked Out By" column says "Evil Eve"
When "Evil Eve" edits a file the "test" column is blank

I really need "test" to say "Evil Eve" without manually setting the data
0
 
LVL 8

Expert Comment

by:nsyyoung
ID: 34919257
I'm sorry, I'm helping to mix you up.  The people-picker column that you created above would have to be manually updated, which you said you don't want to do.  The mirrored column that I spoke about above is separate and would get its data from the checked out to column, which wouldn't be in effect, since CO/CI is not enabled.

So, where would "test" get its data from?  It needs to be either manually updated, which is not okay, or it needs to automatically get information from somewhere, but there's no checked out column to reference, since it's not enabled, and no other way in SharePoint that I know of to indicate that a file is being edited.  That lack of way to see if a file is being edited is why, I believe, CO/CI was developed.

So now we're back where we started.  CO/CI does exactly what you want, so I strongly recommend using it.  Perhaps there is a way that developer experts know to force what you want programmatically, but then again, since the file is opened and SP doesn't care that it's opened if CO/CI isn't enabled, how would it know to advertise that?
0
 

Author Comment

by:InfoZenHQ
ID: 34919966
Let me try again

How would I create (since it doesn't exist yet) a column that broadcast which user has a file out for edit in theb same way co/ci work (ie that it is updated completely automatically) and displays the username of the person (just like ci/co) does but without using the ci/co mechanism.

The system has to know this because when a second person select edit on a file it gives an error message that the file is being editted. So how do I get that info and put it into a column  
0
 
LVL 8

Expert Comment

by:nsyyoung
ID: 34920233
I understand what you're asking, but I don't think you can translate that to SharePoint, although I would be happy to learn that I'm wrong.  

It would probably involve a developer programatically taking the 'locked for editing by <user>' status and displaying it in a custom column if the file is being edited, or not displaying it if no one has it open.  The question is how to get at that status for a file...  I'm sorry I'm not more help for you.  
0
 

Author Closing Comment

by:InfoZenHQ
ID: 34921706
Really appreciate you taking the time to go through all the permutations and giving a strong recommendation on best practices. Absolute lifesafer.

I did finally go with the "force edit to Check Out File" option. Accomplishes exactly what the proposal team wanted without requiring any SharePoint coding exerpience
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Launching a report from a Sharepoint webpage is slow. 2 54
Masterpage unexpected error 7 47
Sharepoint doesn't work wirth Mozilla Firefox 1 46
MS SharePoint Services 2 37
Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

739 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