Resources > Term bases > (TB) > Import

Check the character encoding (CSV files only)

Nowadays, characters are almost always encoded in Unicode - which can encode practically any character or symbol.

Plain-text files may use simpler, older encodings. If the file you import is not Unicode, memoQWeb shows a warning.

If this happens, choose the correct encoding from the Encoding dropdown. You may need to experiment until the characters appear correctly.

Check the delimiter character (CSV files only)

memoQ will choose a delimiter character from the file. In a tabular text file, the delimiter character separates the columns (cells) from each other.

At the bottom, click Show Preview, then check if the columns appear correctly.

If they do not, you may need to choose another delimiter.

Click Tab, or Comma, or Semicolon, or Other. If you click Other, type exactly one character in the box next to it: the delimiter character that you expect in the file.

After you choose the other delimiter character, check the preview again.

Choose what fields memoQWeb imports and where (both CSV and XLSX files)

memoQWeb imports each row from the table in a new entry in the term base.

Each column is imported in a field in the term base.

If the file has column headers, memoQWeb will try to find the right field for every column.

To make this work, check the First row contains field names check box.

Two or more terms in one cell? If a column contains not one term but several alternatives, memoQWeb can still import them if it knows how they are separated. This must be a different delimiter character (not the one that separates the columns). If you have alternatives like this: Check the Split alternatives in field by check box, and type this character in the box next to it.

To choose the fields memoQWeb should import: At the bottom of the CSV settings section, click the Customize fields link. In the Fields section, check or clear the fields' check boxes as needed.

To match the columns and the fields to each other: In the preview area, memoQWeb shows the field mapping:

For each field, you can select how it should be imported. A field is a column in the table. Under Fields, you can match (or not match) fields in a CSV file to fields of a term base entry. (You can omit fields from the CSV file.)

Click a blue as "(field name)" link in the preview area. A small window appears:

• Import as term: Choose this option to import the contents of the selected field as terms, then choose a language from the dropdown.
• Import as definition: Choose this option to import the contents of the selected field as definitions, then choose a language from the dropdown.
• Import as other field: Choose this option to import the contents of the selected field as Subject, Domain, Note, Creation Date, Creator, Last Modification Date, or Last Modified By.
• Do not import: Click this if you do not want to import the contents of the selected field.

To make the changes: click the Change button under the dropdowns.

In the columns and the fields, a term is not called 'Term': It is called by the language it is in. When memoQWeb imports terms, it looks for the English name of the language at the column header, not for the word 'Term'.

If some entries need to be updated, not added: You can do this if the text file comes from memoQ originally, and it still has the identifiers of the entries. If the same entry is still there, but it was edited, memoQWeb can update it. To do this, check the Update existing entries based on ID check box.

Specify user, subject, and domain where the file does not have them (both CSV and XLS files)

If these metadata are missing from the text file, you can still add them to the new entries.

Type the details in the User name where not specified, Subject where not specified, and Domain name where not specified boxes.

If these details are there in the text file: memoQWeb will use those, not the ones you type here.