Versions Compared

Old Version 18

changes.mady.by.user Former user

Saved on

compared with

New Version 19

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

You can import external terminology into Wordbee provided that it is stored in one of the following file formats: Align Assist file (*.ftm), CSV file (*.csv), Excel (*.xls, *.xlsx), Open Office Calc (*.ods), TBX file (*.tbx), TMX file (*.tmx).

How to import a termbase

  • Go to Resources > Terminology.

  • Click on Add new to launch the Create new database wizard.

  • Select Import new Terminology Database from file.

  • Select the file format you want to import.

  • Select languages and name your new database.

  • Browse to the file you need to import.

  • If you import an Excel or CSV file, you will be prompted to select additional import settings:

    • Map each column to the content.

    • Apply import filters, if necessary.

    • Preview whether the content is displayed properly.

  • Click Finish to start the import.

If the import is successful, you can view the total number of imported terms in the Resource details window. Open the termbase in Terminology Manager to view or edit the terminological entries.

See specific import cases in Examples.

Examples

Learn specific cases.

Expand

How to import an Excel glossary

If you have an Excel glossary with the source language and target language terms listed in separate columns, you can import it into Wordbee as follows:

  • Go to Resources > Terminology and click on Add new. The Create new database wizard opens.

  • Select Import new Terminology Database from file.

  • Select Excel from the available file formats.

  • In the next window Select languages and name your new database.

  • Browse to your Excel or Open Office spreadsheet and upload it.

  • Choose sheets, columns and contents (see screenshot):

    1. Import sheet:

      1. Select the sheets that you want to import.

    2. Header line

      1. Check box First line contains column headers or titles.

    3. Choose columns

      1. Map the content to the columns. You need to indicate what kind of content you have in which column.

    4. Select filters and other:

      1. Missing translations

        1. Skip monolingual (not translated) records.

      2. Merge with existing:

        1. Merge new and existing data - Replace existing translations.

        2. Merge new and existing data - Do not import if translation already exists.

        3. Do not merge but skip doubles.

        4. Do not merge and do not look for doubles (fastest!).

      3. Content formatting:

        1. Content is HTML or XML formatted (import tags as markup).

      4. Optional import label:

        1. Wordbee automatically identifies the name of the spreadsheetyour spreadsheet; hence, you can import the label.

    5. Verify how data will be imported: Click to preview. Wordbee will produce an HTML preview of your Excel file.

    6. If the text is properly extracted and displayed in the HTML preview, click Finish to start the import.

If the import is successful, you will see the details of your new terminology database in Resource details. Open the termbase in Terminology manager to view the imported terms and complete the entries.

You might need to prepare the Excel file before importing it into Wordbee, for exampleTo ensure a successful import, we recommend you to keep the Excel file as simple as possible.:

  • List the terms for each language in separate columns.

  • Clearly specify the headers and the language codes.

  • Eliminate any strange characters.Enter synonyms…???

How to import a TBX file

The next example shows how to import a subset of the IATE database that has been extracted from the IATE website.

  1. Go to Resources > Terminology and click on Add new. The Create new database wizard opens.

  2. Select Import new Terminology Database from file

  3. Select TBX file from the available file formats.

  4. In the next window browse to your TBX file and upload it. It should not exceed 250 MB.

5. The next window shows the total number of records and the languages .6. Adjust the import filter settingsWordbee has identified in your file. From here, you can also adjust the filters import settings, for example indicate how the system should treat the inline tags and the comments:

  • Inline tags: import inline tags, rempoveremove, replace with blancs.

  • Comments: import notes and descriptions.

7. Select the optional import label, i.e. the name of the file.

8. Click Finish to start the import. If the import is successful, Wordbee will display the Resource details where you can see the number of total records and languages. Open the termbase in Terminology manager to view or edit the terms.

Note

If a TBX concept contains multiple terms per language, the system will create multiple bi-lingual segments with all possible combinations!

Notes

Related pages