I wanted to setup a new SDL Multiterm 2009 Termbase to organize our Terminology. Since we have lots of stuff already in existing Excel spreadsheets, importing them would make sense. This is a post about how to do this.

First, to get a little order into the whole thing, I figured adding a Category setting to every Term would help later on.

In the picture above, you can see the Category. It’s built into Multiterm and is of the type Picklist. But that Picklist does not contain the categories that I wanted yet, so you have to add them manually.

Add a entry into the Category Picklist

First, you need to have a Termbase open. I used the predefined termbase template “Multilingual termbase”.

Extending the Category itself is actually pretty simple:

1. Go to the  Catalog of your Termbase
2. Right-click on Definition and then Edit
3. Go through the Wizard until Step 4
4. Select Category and then Properties below
5. Now you can add new Entries (see in the pictures below)

Get the Excel ready

Now that we prepared our Termbase, we can get the Excel ready. Besides the two obvious columns with the terms, we need 2 more  columns with the Category. The title needs to be exactly the same as in Multiterm. In this case “Category”. The same is true for the entries, I’ve added an entry “amount” to the termbase, which is exactly the same as in the Excel spreadsheet. Upper and Lowercase matters too. Otherwise there will be no match.

Make sure the titles are on the first line, otherwise Trados will not recognize them.

Now we have to start SDL MultiTerm Convert 2009. You cannot import an Excel directly into MultiTerm unfortunately.

The Excel import wizard is pretty straight forward. There are only two points that need a little attention. On Step 5 make sure that you set the 2 Term columns to be Index fields with the right language and the Category column to be a Descriptive field of type Picklist. Don’t worry if you only see the Category column once.

In the next step we have to add the two Category fields to the structure, as you can see in the picture below, I’ve added Category #1 to the Term below CH-DE and Category #2 to EN-US.

This all we have to do in MultiTerm Convert. Finish the wizard and go back to the SDL MultiTerm 2009 main application.

Import into MultiTerm

Go to the Catalog of your termbase, click on Import and then I would use the “default import” definition. Right-click and choose Process. You should have an *.mtf.xml file from the Excel converting process. Choose that and just follow the Wizard.

That’s about it.

Please post comments below if you run into issues.

You just lost your ASP.NET session object and your app restarted? Check the Event Log for the following message:

A worker process with process id of ’23232′ serving application pool ‘ASP.NET v4.0′ has requested a recycle because the worker process reached its allowed processing time limit.

I’ve already posted the solution for this for IIS6. It’s basically the same for IIS 7.

Go to the Application Pools section of your IIS. Right-click on the right pool and choose Recycling.

Here you can adjust when you want you Application Pool to recycle. No recycling is not really recommended. So either out put in a very high number of requests or you choose fixed time when you assume there are no users on your site.

We decided to just recycle during the night.

What would be nice is to get some kind of notification, so one could save all ASP.NET sessions and then restore them afterwards.