Monday, October 20, 2008

Remove "Open in Windows Explorer"

Sharepoint is designed to be a resource for people to easily access the information they need. End users are given many options on how to access the info on Sharepoint. One powerful way is to use the tool "Open in Windows Explorer". This is found under Actions in the form/document library you are using. The big advantage of using "Open in Windows Explorer" is it enables you to easily view, copy, delete documents in an environment most are familiar with. This can be a big advantage.

Recently I ran into a possible drawback to "Open in Windows Explorer". Here was my issue:

I created a form libary that will be used for Performance Appraisals. The forms are created in InfoPath. Mangers connect to the form library, click New, fill out the Performance Appraisal on the employee. I have created a submit button on the form that automatically saves the form to the form libary and saves it using the "employee name" and "review date" fields in the form. All is well up to this point.

The real issue that I ran into was, Performance Appraisals are very confidential. Management made the decision that the only person that could see the Performance Appraisal in the form library was the person who created it. That sounded easy enough, I would remove the All Documents view and create a single view that would only display documents created by [Me]. I also changed rights on the form library so nobody could create new views after all, if they could create a view, they could create one that could show all fields in the form libary.

Unfortunately, when you select "Open in Windows Explorer" you can see all documents in the form libary. The only way I have found around this issue is to Remove the "Open in Windows Explorer" options under Actions. There is one huge drawback with this. When you remove "Open in Windows" is must be at the Site Collection level. You lose it for all of your sites. On the positive side, you can set it up so a Site Owner can still see "Open in Windows Explorer".

Here is how I disabled "Open in Windows Explorer" for everyone except site Owners.

  • On your SharePoint server go to the following folder and make a copy of the DefaultTemplates.ascx file. \Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\CONTROLTEMPLATES
  • Rename the copy of DefaultTemplates.ascx to CustomDefalutTemplates.ascx
  • Open CustomDefaultTemplates.ascx in Notepad and change the following line:
  • ID="OpenInExplorer" Change PermissionString="UseClientIntegration" to PermissionString="MangeWeb"
  • Save the file
  • Reset IIS

I do not take credit for coming up with this solution. After searching many ways of diabling "Open Windows Explorer" this solution was found on the following blog: http://sharepoint-uk.blogspot.com/2008/03/in-order-to-remove-open-in-windows.html This was by far the easiest way I found to perform the task.

No comments: