How to fix a messed GP file association ?

Even since I’ve worked with Dynamics GP I came across from time to time with systems where the extension association with Dynamics GP files is messed, more frequently this was happening on x64-bits systems (Windows 7-10, Server 2012 & up).


MVP fellow Mariano Gomez had posted about this back in 2009, and this would bug me because you couldn’t check quickly anymore what the version & build of a particular dictionary was when hovering over with the mouse or when opening the file properties, as there would an important tab gone missing (Dictionary).

My good friend David Musgrave had posted something about how to fix that many years ago in 2009 and I bumped into a 2011 community thread about the very same topic, but to me both posts where either incomplete or confusing in their instructions. Sure, David provided a file to fix the problem with one mouse click (or so he though), but it’s an incomplete solution.

How does it start ?

When you’re open the Dynamics GP folder on your computer or server, you’d see something like the capture below, where the .DIC files would look like they would be a notepad text file.. More than often that’s the association the happens to various GP files, including the .SET launch file because in Windows 10 for example if you double-click on the file and the system doesn’t know what to do with, a user would pick the notepad to peek into the file and then eventually by accident the extension would get associated permanently with Notepad or Wordpad text files..

Invalid file association

What it should look like !

After a regular pristine GP client deployment, this is how the dictionary association would look like below. Notice the file type in Windows Explorer shows “DIC File” and when you hover the mouse over the file name, it would provide you details about the Dictionary builder (ISV) and version / build numbers.

Proper file association

Also, when right-clicking on the file to open properties, you should see an additional tab that isn’t there for regular files (Dictionary) that provides you details about the relationship with GP. The advanced detail pane would provide information about the GP main build and allows you to see its relationship in the DYNAMICS.SET launch file, as sometimes the names are hard to identify when searching the Forms & Reports dictionaries.

File Properties / Dictionary Tab
Advanced properties

How do I fix it ?

This Microsoft article explains how to use a registry file (.reg) to make changes to the Windows registry which holds all the information for the file associations (and much more), so be very careful when using this. This other MS KB explains how to do a quick full backup of your Registry before doing any changes. Like with SQL databases, it’s always a good idea to make a backup before doing any changes that could modify your system’s behaviour

Basically a .REG file is a set of labels & values which represents the branches and fields in the registry. I’ve always thought of the .REG files to add values to the Registry, but it turns out you can also delete entries with it. Based on my findings and experience, as most of the corrupt entries have to deal with Notepad or Wordpad association, I’ve tweaked a registry file that will take care of removing the invalid entries and fix the proper values for the .DIC, .CNK & .SET file extensions. The file can be downloaded from this link (as the free WordPress blog does’t allow for file embedding).

If you’re curious to see what’s currently in your own registry, open the Registry Editor in Windows : WIN-key + R and then type “regedit.exe” (whiteout the quotes). Navigate to the following branch or simply press F3 to open the search box to look for “.DIC” : [HKEY_CLASSES_ROOT > .dic]

If you keep searching with F3 or move to this other branch, you’d see the other .DIC extension entry : [HKEY_CURRENT_USER > Software > Microsoft > Windows > CurrentVersion > Explorer > FileExts > .dic], There are at least 2 or 3 entries under that branch, in which you can see the association with Notepad or Wordpad.

The 2nd branch will be the link back to the first .dic extension entry you saw in the registry under HKEY_CLASSES_ROOT :

In order to run properly the registry fix file that is linked in the blog post, you have to open a command prompt with elevated privilege (Admin mode), otherwise the changes may not be applied if you lack proper permissions. Press the WIN key on your keyboard and type CMD in the search box, windows should show you the icon for cmd.exe on which you’d right-click with the mouse and then click on “Run as Administrator”.

in Windows 7
or in Windows 10 / 2012

When the command prompt is open, navigate yourself to the folder where you saved the “Fix DynGP Dictionary Association.reg” file and type : regedit Fix_DynGP_Extensions_Association.reg

Press Enter and you’ll be prompted by Windows to merge the content of the .reg file with your system registry :

Click on Yes and you should get a confirmation pop-up that the content was successfully merged. If you get an error message, then it’s likely that you don’t have the proper permissions. Ask your IT staff to help you with fixing this extension issue in GP.
Until next time.
@GP_Beat

Advertisements

One thought on “How to fix a messed GP file association ?

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by WordPress.com.

Up ↑

JenKuntz.ca

Dynamics GP & other thoughts!

SergesPoint

Tricks and trips about SharePoint

Salim Adamon - Dynamics CRM Blog

Everything Dynamics CRM from a technical, architectural and business perspective

The Official Blog for Training Dynamo LLC

Microsoft Dynamics GP - Tips, Tricks, News and Thoughts

Dynamics GP Tips and Traps For Users and Developers

Talking about Great Plains, Dexterity, SQL, and some C#

smay772

A fine WordPress.com site

Tom Roush's Blog

Musings on Life, Lessons, and Laughter...

Belinda Allen, Microsoft MVP Business Solutions

Things I've learned from years of working with Microsoft Dynamics GP.

David Musgrave's Winthrop Development Consultants Blog

This blog will keep you up to date with Winthrop Development Consultants and David’s experiences, tips and tricks as a developer and consultant in the Microsoft Dynamics GP community.

%d bloggers like this: