|
Translation memory CSV import settings (dialog) |
memoQ can import most tabular text files – tab-separated and CSV files – into translation memories. Choose a translation memory where you want to import the CSV file, browse for a CSV file to import. Then the Translation memory CSV import settings dialog appears. memoQ attempts to set the values automatically. However, you might need to check the Preview area before importing the file. If the contents do not appear correctly, you need to change the settings manually.
Invoking
Navigate to the Translation memories pane of the Resource console. Or, in an open project, click the Translation memories icon in Project home. In both cases, a list of translation memories appears. You will also see a list of translation memories in the third page of the New memoQ project wizard. Select the translation memory where you want to import the CSV file, click the Import from TMX/CSV link, then, in the Open dialog, locate and select the CSV file to import.
Structure
The Translation memory CSV import settings dialog consists of the following areas:
| · | General: Specifies the file encoding, the delimiter character, and 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 translation memory entry. |
| · | Preview: Displays how the first 256 lines of the CSV file would be imported with 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, so it does not store encoding information.
First row is header: 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.
| · | Delimiter: |
| 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. |
| · | Author name where not specified: Use this box to enter a value that will be automatically attributed to the translation memory entry if there is no such column specified, or the corresponding field is empty. |
| · | Subject where not specified: Use this box to enter a value that will be automatically attributed to the translation memory entry if there is no such column specified, or the co rresponding field is empty. |
| · | Domain where not specified: Use this box to enter a value that will be automatically attributed to the translation memory entry if there is no such column specified, or the corresponding field is empty. |
Fields area:
For each field, you can select how it will be imported. A field corresponds a column in the text file. In the Fields list, you can assign or not assign fields in a CSV file to attributes of a translation memory 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 source segment: Select this radio button to import the contents of the selected field as source segments. |
| · | Import as target segment: Select this radio button to import the contents of the selected field as target segments. |
| · | 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 for not to import the contents of the selected field. |
Preview area:
While you are configuring the import, look at this area that displays 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 translation memory, click OK. After clicking OK, memoQ displays the results of the import. Click Cancel to close the dialog without importing the CSV file.