[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Setting file associations with group policy preferences

Published on
31,384 Points
8 Endorsements
Last Modified:
Community Pick
At some point in your work you may run into a need to globally assign a specific file type to open using a specific program. I recently was tasked with completing this objective. In my case it was setting the TSV file association to open with Excel. Below are the steps to follow if you need to do a similar file extension modification using GPP.

I had originally been hesitant to use GPP's because I thought they required a 2008 domain controller. This is not the case. These GPP's can be easily used assuming you meet the prerequesites below.

1. You will need to create the GPP on a Vista, 7, or Server 2008 machine with the Group policy management console available.
2. Your clients will need to have the group policy preferences client side entensions installed on them. These come installed by default on Vista and 7. For XP you will need to download them here. This update can also be pushed to your clients via WSUS.
3. Microsoft reccomends installing XMLlite on the machine as well. http://www.microsoft.com/downloads/en/results.aspx?pocId=&freetext=XMLLite&DisplayLang=en 
I did not have to do install this for the GPP to work on my XP machine.

nce you have the 3 pre-requesites above covered simply open up the GPMC. Right click the group policy object container and select new or open an existing group policy.

In the new policy you created navigate to computer configuration | preferences | control panel settings | folder options
Right click on folder options and select new, file type.

The new file type properties window will appear.

The first option you have to configure is the action you would like to perform. The dropdown has 4 choices Create, Replace, Update, and Delete. For an explanation of each hit F1 and you will be presented with descriptions. In this case I chose to update the extension.

Next enter your file extension without the dot in front (tsv not .tsv) and select the associated class from the dropdown. In this case I am using Excel to open my TSV files.

One important item to note is that the program whose associated class you choose must be installed on the machine where you are creating the GPP. If it is not installed you will receive a "Could not save settings file error 80070003"

  6Once you have the settings entered hit apply to save the GPP. At this point you can close out to the main GPMC window and apply your newly created GPP to your target OU.

Since this is a computer policy you will need to perform a reboot for it to apply. Upon reboot your new file associations should be active.
Author:Joseph Daly
LVL 58

Expert Comment

Thanks for putting this together, xxdcmast! I voted "yes" above.
LVL 37

Expert Comment

by:Carl Webster
Dude, you are my hero.  This also works for Terminal Servers, Remote Desktop Services servers and Citrix MetaFrame/Presentation Server/XenApp servers.

<288 point bold red flashing font>



Expert Comment

This was EPIC! I've been trying to get .tif files associated with MODI on a Server 2008 R2 box and I just couldn't find any good information till I checked here. Your guide was exactly what I needed. THANKS!

Expert Comment

by:Josh Libby
Did you have Office installed on the DC where you edited your policy in order to have the associated class available in your drop down?

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Join & Write a Comment

This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month