You can export term bases from both memoQ and QTerm into Excel files. Hand them out for review, and import the reviewed XLSX files back into memoQ or QTerm.
To export a term base from memoQ to XLSX:
1.Open a project. In Project home, choose Term bases. From the Resource console: Open the Resource console. Choose Term bases.
From an online project: As a project manager, you can open an online project for management. In the memoQ online project window, choose Term bases.
2.Right-click the name of the term base you need to export. From the menu, choose Export Terminology.
3.Under the File field, select the Export as XLSX radio button. Choose fields one by one: Normally, memoQ exports the Entry ID, Term text (with wildcards), and Example of use fields from the term base. If you're preparing the term base for human reading, this is the simplest option - but you can add any other field as needed. If the other end is memoQ or QTerm, you may want to add all other fields. To add a field, check its check box. Watch the preview: As you set the options, memoQ shows how your file will look like under Preview.
4.When you are done, click Export.
To import a reviewed XLSX file back into a memoQ term base:
1.Open a project. In Project home, choose Term bases. From the Resource console: Open the Resource console. Choose Term bases.
From an online project: As a project manager, you can open an online project for management. In the memoQ online project window, choose Term bases.
2.Right-click the name of the term base you need to import the terms into. From the menu, choose Import Terminology. 3.An Open window appears. Find the file you need to import. Click Open. The Term base Excel import settings window opens.
4.Check the Update existing entries based on ID check box. memoQ recognizes the data fields if they were not removed from the Excel sheet. 5.Click OK.
To export a term base from QTerm to XLSX:
1.Open memoQWeb in a web browser. Log in as an administrator, project manager, terminologist, or external user. 2.Click the QTerm tab. The QTerm - Home page appears. 3.In the list, find the term base you want to export. 4.In the term base's row, in the Operations column on the left, click the Export icon. 5.The Term base export wizard opens. Select the XLSX option and click Next. 6.On the Type page, choose the one entry per line or the multiline entries option. Click Next. 7.The Select term base languages to be exported page appears. By default, all languages in the term base are selected. Click the languages you want to leave out. Note: You need to select at least 2 languages.
8.Click Next. 9.The Select metadata to be exported page appears. By default, no metadata fields in the term base are selected. Click the fields you want to include. 10.Click Export. 11.On the last page, click the link to download the exported file, then click Close.
To import a reviewed XLSX file back into a QTerm term base:
1.Open memoQWeb in a web browser. Log in as an administrator, project manager, terminologist, or external user. 2.Click the QTerm tab. The QTerm - Home page appears. 3.In the list, find the term base you want to import the XLSX back into. 4.In the term base's row, in the Operations column on the left, click the Import icon. The Import term base wizard opens. 5.On the Select file(s) to be imported page, on the Excel data tab, click Choose file and browse to the XLSX file you want to import. Click Next. 6.On the Set file properties page, choose a Layout. The Preview appears. In the header, check the First line contains field names check box. Click Next. 7.On the Define mappings between file columns and term base metadata page, the mappings are automatically set because QTerm recognized the field names on the previous page. Click Next. 8.On the Import options (updating based on entry ID; default values) page, check the Update based on entry ID check box. Click Next. 9.After the import analysis finished running, on the Import summary page, review the analysis results. If everything is OK, click Import. |