Exporting terminology (CSV, MultiTerm XML)
memoQ is able to export term base contents into tabular text files called CSV files. Choose a term base to export its contents into a CSV file, invoke the Term base export settings dialog, and configure the CSV file. memoQ tries to set the values automatically, but please check Preview before exporting the term base. If it does not appear correctly, you need to manipulate the settings manually.
How to begin
You can invoke the Term base export settings dialog from the Term bases pane of the Project home or the Resource console, by selecting the term base you wish to export, and clicking Export terminology on the Term Bases ribbon tab or the Export terminology link below the term base list in the Resource console.
The Term base export settings dialog consists of the File section for specifying the file type of the CSV file, the General section for specifying the file encoding, the delimiter character, whether or not the field names should be written into the first row of the CSV file and other general properties, the Fields section for selecting fields of a term base to be exported into the CSV file, the CSV preview window for displaying how the first 256 lines of the CSV file would be exported as per the present settings, and a series of buttons.
•: Click this button to browse for the target folder structure. The path of the CSV file will appear in the CSV path field.
•Export as CSV: Click this radio button if you want the selected term base to be imported later into another CAT or terminology tool.
•Export as MultiTerm XML: Click this radio button if you want the selected term base to be imported later into MultiTerm, the terminology application of SDL. There are no further export options. memoQ exports an XML file.
Note: If a memoQ term base contains wildcard characters (asterisk or pipe) and it is exported to MultiTerm XML format then the wildcard characters are not retained in the exported file. As the MultiTerm XML file is generated by memoQ, it does not include the wildcard characters. These characters will not show up when the XML file is imported into qTerm. The mentioned characters are memoQ specific and are not exported by design because other tools, that are capable of importing MultiTerm XML files, have their own special characters to indicate matching.
CSV settings section:
•Encoding: Choose the encoding of the CSV file from this drop-down list. CSV is a text file, and therefore encoding information is not stored in it.
•Write field headers in first row: Check this check box if the first row of the CSV file should contain the names of the fields. The field names will appear in the CSV file as in the Preview window. Uncheck it if you don't want to export the names of the fields into the first row. If you uncheck it, the field names in the Preview window will disappear.
•Delimiter radio buttons: Select the character memoQ should use to separate table cells from each other within a row:
oTab: Select this radio button to use tab as delimiter that separates one column from the other in the CSV file.
oComma: Select this radio button to use comma as delimiter that separates one column from the other in the CSV file.
oSemicolon: Select this radio button to use semicolon as delimiter that separates one column from the other in the CSV file.
oOther: Select this radio button to use a custom character as delimiter that separates one column from the other in the CSV file.
Go through every field name listed, and select whether or not they should be exported into the CSV file. By default the check box of each field name is checked. The checked field names will appear in the CSV file as in the Preview window. If you uncheck a check box, the related column will disappear from the Preview pane.
CSV preview section:
While configuring the export, you can look at the preview that shows how the first 256 lines of the exported CSV file will look.
To start exporting the term base contents into the CSV file, click the Export button. After clicking Export, memoQ will display the results of the export. Click Cancel to close the dialog without exporting the term base contents.