on the cheap and sleazy side (www.cheapandsleazy.net)

By G.D. Warner

"It's Dead, Jim!"

When a digitalCAT Dictionary Goes Bad


Has this ever happened to you?

You get to a job, fire up your CAT software of choice, and you see a message telling you that your dictionary is bad?

I'm pretty sure you know without experiencing it for yourself that that is something you never wish to experience, EVER!!

Of course, it's easy to say, "Dude -- you should just restore from your backup!"

Not so good to hear if your backup is not with you -- or worse, also corrupted.

One of my Facebook friends experienced this very thing (fairly) recently, and I was able to resurrect her corrupt dictionary for her -- unfortunately, the class she was providing CART services for was over by then, but she was able to retran the notes from the class against the now-working dictionary afterward, so there's that.



(*Cue "The Twilight Zone" theme music*)

Rod Serling

Picture this:

You, on the job. You start your CAT of choice, load your dictionary, and suddenly, you see this:

Dead digitalCAT Dictionary

Uh-oh ....!

... and suddenly, your day is not looking like it's going to be very much fun.

Not to worry -- you have support on speed dial! You call, they log into your computer, look at your dictionary, and give you the news no CART provider wants to hear, ever:

"I'm sorry, there's nothing we can do!"

In other words ...

It's Dead, Jim!

"It's Dead, Jim!"

Undaunted, you go on with your job -- but your client is not able to read all of your strokes, because of that missing corrupt job dictionary.

This actually happened to one of my Facebook friends recently, and (naturally), she posted the issue as her status, and I saw it go by in the sidefeed.

We talked for a bit, and I asked her to send me her dictionary, and I'd see if I could figure out something.

... and I did. This article is intended to help you if you should happen to find yourself in a similar predicament.


"Okay, Wise Guy. What Did You Do?!?"

(For those of you in a hurry, click here.)

Well, first I did some stuff that didn't work ... and then I remembered something I'd seen a few years back, when I first started using digitalCAT -- an error message talking about something called "Microsoft Jet database."

That prompted a Google search:

"MS Jet database" "corrupt" "repair"

After wading through a lot of results, I finally found something I could download that would fix a corrupt database. It was called " Jet Compact Utility."

I read through the instructions and downloaded the file ... but it was a .exe file, and I was on my Mac.

Pish-posh! My Mac is running Wine! It should be able to handle this task!

Turned out that the file I was downloading was an installer with poor window management skills, so I didn't know what was going on at first.

JCU Installer

JCU Installer

That is to say, when I double-clicked the installer and clicked the "Browse" button, it brought up a window with a lot of weird looking lines. Not knowing what to do, I clicked "Okay."

JCU File Navigation Window

JCU File Navigation Window

Turns out those "lines" were a file navigation window, and all I had to do was to slide the little slider bar to the right a bit:

JCU File Navigation Window, Take Two

JCU File Navigation Window, Take Two

I then decided to make a folder for this, so I hit the Cancel button, and made a copy of the damaged dictionary (always a good idea during a fix of this sort) in another folder, which I cleverly named "Jenz Dictionary," seeing as how the woman I was trying to help was named "Jen."

I then moved Jen's damaged dictionary into that folder, along with the installer and ran it again.

When I did that, I ended up with two files -- a Word document with the instructions, and the actual executable file.

JCU Installed

JCU Installed

After a dry run, I discovered that to fix the corrupted dictionary, I needed an empty dictionary for the corrections to be copied to ... so I created the "Fixed" folder seen in the previous picture, and used my copy of digitalCAT's Dictionary Maintenance Program that I have running under Wine and created the empty dictionary, "Jen_Fixed.dct"

Note: My copy of the Dictionary Maintenance program could *NOT* open Jen's dictionary normally (she's running a newer version).

Jen Fixed Folder and Empty Dictionary

Jen Fixed Folder and Empty Dictionary

I then double-clicked the jetcomp.exe file, and got this window:

JetComp.exe running

JetComp.exe Running

It's not exactly obvious, but basically it wants me to select the damaged dictionary in the top field by clicking those little dots there, and select the new empty dictionary in the second field, like so:

Database Compact Utility running

Database Compact Utility Running

Once that was done, I clicked the "Compact" button ... and waited.

Nothing showed ... no progress bar, no clock, nothing ... but after a few moments, there was a blue progress bar down where it says, "Ready" that disappeared too quickly for me to get a screenshot of ... so I checked the "Jen_Fixed.dct" dictionary, and ....

It's Fixed!

It's Fixed!

I then exported the dictionary as an .rtf file --

... because Jen's computer would have had to convert it to the new format.

... But Wait a Minute.

Look at that last picture up there. Do you see the "Tools" menu?

What's THIS?!?!

But Wait ... What's THIS?!?!

Looks like the repair tool is BUILT INTO the Dictionary Maintenance program!

... which merits a test!

I opened my old copy of VMWare Fusion -- which is still running XP Pro -- opened the Dictionary Maintenance program in there, and copied the corrupt dictionary to the desktop.

I then double-clicked the corrupt file, and immediately got an error message:

Bad Dictionary

Bad Dictionary

This, of course, was closely followed by this message:

Dictionary Not Found

Dictionary Not Found

... so now we know the dictionary is still corrupt, which makes it a prime candidate for this test.

The Quick and Easy Fix For Bad Dictionaries

In the Dictionary Maintenance program, click Tools and select Compact and Repair:

Compact and Repair

Compact and Repair

Now for a helpful hint you've seen previously:

Helpful Tip

Helpful Tip

Next, you will be presented with a normal file navigation window, with which you can locate your corrupt dictionary:

Select Your Corrupt Dictionary

Select Your Corrupt Dictionary

Once the dictionary is selected, nothing visibly happens ... and then ...

... you get an empty dictionary window, just like the one you started with.

... at which point, you can do File --> Open and point it at your formerly corrupt dictionary.

If everything went well, you'll see this:

It Worked!

In Summary ...

Clearly the way I went about this at first was a *LOT* more difficult than it needed to be ... but that experience lead me to the more elegant solution.

... which hopefully, you'll never have to use!