how to choose a tm database
- Make sure you have created at least one TM database.
- Do one of the following, depending on the part of the user interface you are using:
Ribbon Select the Resources ribbon. In the Translation Memory section select Choose TM.
- Menu Select Resources>Choose TM.
Translate Toolbar Click
.To open the Translate toolbar from the menu view, you can select View>Toolbars>Translate.
The Manage Translation Memory dialog opens.
-
Next to each TM in the grid that you want to associate with the project, click Use.
You can also use the dialog to do any of the following:
add/remove tm databases to/from grid
If you have additional TM databases that are not shown in the grid, you can add them. Click Add and from the drop-down select one of the following:
- Local Select this option if you want to use SQLite for a local TM database. This option opens a simple dialog that lets you give the new database a name and choose where to store it. By default, the location for SQLite databases is in Documents\Lingo Translation Memories on your computer. However, you can choose a different location if you like.
-
Server Select this option if you want to use SQL Server Express for a TM database to be stored on a server. This opens a dialog with fields for the name, server, and security information related to the database.
Note: If you do not already have SQL Server Express installed and you try to install a server
In addition, you can remove TM databases from the grid if you do not want to see them. This does not delete the databases altogether; it simply removes them from the interface. To remove a TM database, select the row in the grid and click Remove.
example
The following shows how you might add or remove TM databases:
create new tm databases
You can also create new TM databases. This is different from the option to add databases. Adding a database simply makes sure a TM that already exists is shown in the grid so you can select it. On the other hand, creating a database builds a brand new database, adds it to the grid, and automatically selects the Use check box so that it will be associated with the project. To create a new TM database, click Create and select Local or Server, depending on whether you want to create a SQLite or SQL Express database, respectively. Then complete the fields in the appropriate dialog.
example
Let's say you are creating a new Lingo project and you already have one local TM database that you plan to use.
However, you want to create an additional local database to use in the project. So you select Create and select Local.
The New Local Translation Memory Database dialog opens. You give the database a name and keep the default location where it will be stored.
When you are finished, the new database is shown in the grid and the Use check box is automatically selected.
edit tm database
You can open any TM database in the grid to edit it in the Translation Memory Editor. To do this, select the row in the grid and click Edit TM. See Editing the Translation Memory Database.
delete tm database
You can delete a TM database by selecting the row and clicking Delete. This not only removes the TM from the grid, but it deletes it entirely.
import tmx files
If you already have a Translation Memory eXchange (TMX) file containing translations, you can import it into any of the TM databases shown in the grid. To do this, select the database in the grid, then click Import. Complete the fields in the dialog and click Start Import.
example
Let's say you are creating a new project and you have created a new TM database. The new database is obviously empty. However, you have a TMX file with lots of translations, and you want the new database to have these translations. So with the database selected in the grid, you click Import.
Finally, you would use the dialog that opens to find and select the TMX file to import.
Export tmx files
If you have a termbase file in Lingo, you can export it into a Translation Memory eXchange (TMX) file to share with others or to save for later. To do this, select the database in the grid, then click Export. Complete the fields in the dialog and click Start Export.
specify access—read & write versus read only
In the grid listing TM databases, there is a drop-down field to specify the access rights for each database. There are options for Read & Write, as well as for Read Only. By default all databases are set to Read & Write, which means they can be altered once they are loaded into the Lingo project. However, you can change any of the databases to Read Only access if you want. In order to switch to Read Only access, the Use check box must first be selected for that database.
example
Let's say you are connecting your new Lingo project to four different TM databases, like this:
You want to receive translation suggestions from all of the databases. However, when you confirm new translations and upload them to TM, let's say you only want to upload them to the database called "Local1." Therefore, even though the Lingo project will be connected to all four databases, three of them should be set as Read Only, and Local1 should be set to Read & Write.
- Click OK.
