Edit Translation Memory Content Externally

The content of a translation memory can be edited directly in the Memsource Editor (by an Administrator or a Project Manager). It can also be exported into a file and edited in an external program by anyone. The edited file then can be imported back to Memsource (again by a Memsource Administrator or a Project Manager).

Exported File Formats

  • An exported TMX file can be edited in a program such as Okapi Olifant (usually only up to 100,000 segments or "translation units"). Okapi Olifant has a lot of useful functions for editing the segments, deleting duplicates, etc.
  • An exported XLS file can be edited in Excel.

Importing XLSX files back

When a XLSX file is imported back to Memsource Translation Memory, the following process takes place:

  1. Translation units with the same source, target and context are deduplicated upon import.
  2. Translation units with edited source or target or context (or missing context) will be added as new translation units.
  3. Translation units with |update suffix and edited source or target or context will overwrite old units (see below).
  4. Translation units with |delete suffix will be deleted (see below).

Examples of Editing  a TM in Excel

When Editing the TM in Excel, you can do one of two things:

  • Edit it in Excel and then import the edited file to a new Translation Memory (and delete the old TM).
  • Edit the file in Excel, add "|update" or "|delete" to the segment's ID and import it back to the original Translation Memory.

Deleting Multiple 100% Matches

A 100% match is a segment with the same source but different context. If you want to have your segments with no context (every source text has only one translation, regardless of the context in the file), you can export the TM with no context and import it to a new, empty TM. Every duplicate segment in the XLS file will be overwritten by its newer version when imported back to Memsource.

  1. Step: Open the TM, click on Export and select XLS from the Format dropdown menu.
  2. Step: From the list of parameters, deselect the Previous segment, Next segment, and Segment key options. These are the options that add context around a segment, and without them, each segment will be context-free.
  3. Step: Click Export.
  4. Step: Import the file into a new TM in Memsource.
  5. Step: At this point, if you are absolutely sure you don't want to keep the segments with the context, you can delete the old TM.

export TM noContext

Note: You can choose to save your translations without context when importing new jobs to a project. Please see our TM Match Context and Optimization article for more details.

Deleting Segments From One User

If you want to delete all segments created (or modified) by one user, you can do this in Excel as well. You will have to export the TM with all parameter to XLS file, select all segments created (or modified) by that user and add "|delete" to the segments' ID. When the XLS file is imported back to the Memsource TM, all segments with "|delete" will be removed from the Memsource TM. Do this by following the steps below.

Important: Export the Excel file with context (by checking the Previous segment, Next segment, and Context key boxes) in order to prevent having duplicate the segments when importing the TM back to Memsource.

  1. Step: Export the TM as an XLS file with all the predefined options (that is, with all 3 context options) selected, and add Created by and/or Last Modified by.
  2. Step: In the created_by (or modified_by) column, turn on filters and select the user whose segments you want to delete.
  3. Step: Once the segments are filtered, go to the first column (titled *ID*), and type "|delete" using the | or 'pipe' character at the end of the ID tag with no spaces.
  4. Step: Do this for all segments that that user created.
  5. Step: Turn off the filter in the created_by column, and check to make sure only the segments you intend to delete have "|delete" written at the end of their ID.
  6. Step: Save the excel file and import it to your Memsource Translation Memory.


Editing a Segment's Source or Target

When editing segments in Excel, you can add "|update" to their IDs, save the Excel file, and import it back to your Memsource TM. Segments with "|update" will be updated while others will be skipped (if their source, target and context is unchanged).

  • Step 1: Export the TM in XLS format. Be sure to check the Previous segment, Next segment, and Context key boxes.
  • Step 2: Open the file in Excel and edit it as desired.
  • Step 3: In the first column (titled *ID*) add "|update" to the end of the ID for every item you updated. This is similar to the way you deleted segments in the section above.
  • Step 4: Save the Excel file and import it to your Memsource Translation Memory.

Note: For values in the created_by and modified_by columns, only Memsource usernames are supported. If the name is changed and does not correspond with a Memsource username, the field will be imported back to the TM as empty.

Was this article helpful?



Please sign in to leave a comment.