Export term bases on server

When there is a change in the project - in most cases, when the project ends -, memoQ TMS can automatically export the project's term bases into a folder on the server. This works in projects that you create from project templates.

memoQ TMS exports the term bases in CSV files. Each term base is exported in a separate CSV file. You can open a CSV file in Excel, or you can import it into another copy of memoQ - or into a different translation tool.

How to get here

1. Open Resource console. Choose Project templates.

   Online projects only: Use an online template for this. Choose your memoQ TMS at the top of Resource console. Click Select.

2. Select the project template to which you want to add the automated action. Right-click the selection, and click Edit.

   Online projects only: This action isn't available in local projects. If the eye is closed in the top right corner of the Edit project template window, click it.

3. In the Edit project template window, choose Automated actions. Click the Project automation tab if you don't see it at first.
4. Under Available triggers, click a project-level event when you want memoQ to start the automated action. You may need to run this after translation and review are finished. The best event here is After project wrap-up.
5. Next to Actions added to the selected trigger, click the + sign. The Select actions you want to add to the trigger window appears.

6. Click Export term bases on server. The Term base export - settings window appears.

   If you can't add this action because it's already there: Under Actions added to the selected trigger, click the same action. Next to the list, click the Settings  button. The corresponding settings window appears.

What can you do?

1. Choose which term bases you want to export:
• To export the primary term base only: Click the Primary term base radio button. From the project, memoQ TMS will export the one primary term base (it holds all languages).
• To export all term bases involved: Click the All term bases radio button. Use this if the primary term base changed over the project, or you need the contents of the other term bases, too.
2. At the bottom of the window: Configure the formatting and the contents of the CSV file that memoQ saves. You can choose an encoding, a delimiter character. You can choose whether or not there is a header row. And you can choose if you want to export each field.

   To learn more: See the topic about exporting term bases manually.

3. Under Export path rules, set up the folder and name of the exported files. You can use placeholders, so that memoQ TMS takes the name from the name of the project, the date or time when the file was created, the project languages, and so on. memoQ fills in the placeholders with actual details in ongoing projects that are created from this project template.

There is a fixed main folder: memoQ TMS saves the term base to the project's file store. This is a folder on the server. Only a system administrator can change the location of that folder.

Normally, memoQ TMS saves the term bases in the Term bases folder on the server.

The name of the exported file is put together from the name of the term base and the date and time when the term base is exported.

You can change this: You can add folders to the path, or you can use different placeholders in the name. You can also use these placeholders in the names of the folders. Don't change the main folder.

When you finish

To add the action to the project template: Click OK.

Nothing is exported when you click OK: To export the files automatically in an ongoing project: Create a project from this project template, and go through the entire workflow. Check the output folders.

To return to the Edit project template window, and not add an action to the project template: Click Cancel.