|
memoQ can import tabular text files – tab-separated or CSV files – into term bases. In the Resource console, choose a term base to import the CSV file contents into, click the Import from CSV/TMX link, and then browse for a CSV or a tab-separated file to import. memoQ will attempt to set the options automatically. However, you might need to check the preview before proceeding with the import. If it does not appear correctly, you need to manipulate the settings manually.
Invoking Navigate to the Term bases pane of the Resource console. Or, in an open project, click the Term bases icon in Project home. In both cases, a list of term bases appears. You will also see a list of term bases in the fourth page of the New memoQ project wizard. Select the term base you want to import the CSV file into, click the Import from CSV/TMX link, then, in the Open dialog, locate and select the CSV file to import.
Structure The Term base CSV import settings dialog consists of the following areas:
| · | General: Specifies the file encoding, the delimiter character, whether or not the field names are written into the first row of the CSV file, and other general properties.
|
| · | Fields: Assigns fields in the CSV file to fields of a term base entry
|
| · | Preview: Displays how the first 256 lines of the CSV file would be imported as per the present settings, and a series of buttons.
|
Use General area:
| · | File encoding: Use this drop-down list to select the encoding of the CSV file. CSV is a text file, and therefore encoding information is not stored in it.
|
| · | First row contains field names: Check this check box if the first row of the CSV file contains the names of the fields. Uncheck it if the first row already contains data to be imported. If you uncheck it, the field names in the Preview area will be F1, F2, F3 and so on.
|
| o | Tab: Select this radio button to use tab as delimiter that separates one column from the other in the CSV file.
|
| o | Comma: Select this radio button to use comma as delimiter that separates one column from the other in the CSV file.
|
| o | Semicolon: Select this radio button to use semicolon as delimiter that separates one column from the other in the CSV file.
|
| o | Other: Select this radio button to use a custom character as delimiter that separates one column from the other in the CSV file.
|
| · | Split alternatives in field by: Check this check box
to specify the delimiter that separates one entry in the same column from another. If memoQ finds the same column name twice, it will automatically import the two entries as alternatives.
|
| · | User name where not specified: Use this field to enter a value that will be automatically attributed to the terms if there is no such column specified, or the corresponding field is empty.
|
| · | Subject where not specified: Use this field to enter a value that will be automatically attributed to the terms if there is no such column specified, or the corresponding field is empty.
|
| · | Domain name where not specified: Use this field to enter a value that will be automatically attributed to the terms if there is no such column specified, or the corresponding field is empty.
|
| · | Update existing entries based on ID: Check this check box to update existing entries with the CSV file entries having the same ID.
|
Fields area:
For each field, you can select how it should be imported. A field is a column in the table. The Fields area allows you to assign or not assign fields in a CSV file to fields of a term base entry.
| · | Fields list: Go through every field name listed, and select how they should be imported. All changes in the controls to the right apply to the field that is currently selected in this list.
|
| · | Import as term: Select this radio button to import the contents of the selected field as terms in the language you specify.
|
| · | Import as definition: Select this radio button to import the contents of the selected field as definitions in the language you specify.
|
| · | Import as other field: Select this radio button 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: Select this radio button if you do not want to import the contents of the selected field.
|
Preview area:
While you are configuring the import, look at the preview that shows you how the first 256 lines of the CSV file will be imported. Pay special attention to the correct display of special characters.
Navigation To start importing the CSV file into the current term base, click OK. If the term base does not contain any of the languages that the CSV file contains, you will be prompted if you want to add the language to the term base or ignore importing entries in the new languages. After clicking OK, memoQ displays the results of the import. Click Cancel to leave the dialog without importing the CSV file.
Term base CSV import settings
|