The content of a translation memory can be edited directly in either the Memsource Web Editor or the Desktop 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 so-called "translation units"). Okapi Olifant has a lot of useful functions for editing the segments, deleting duplicates, etc.
- An exported XLS file can also be edited in Excel.
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.
Important: Every time the file is imported to a Memsource TM, it is checked for duplicates based on the segment's context. If the context is different or is missing, the segment will appear twice in the TM (each with a different context).
Deleting Multiple 100% Matches
A 100% match is a segment with the same source but different context. If you don't want to have your segments appear with the context, 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 (because there is no context to make segments appear different) by its newer version when imported to Memsource. To do this, follow the steps below.
Step 1: Open the TM, click on Export and select XLS in the Format menu.
Step 2: 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.
Step 3: Create a new, empty TM.
Step 4: Edit the file in Excel. When you're done, import the file into a new TM in Memsource.
Step 5: 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.
Note: You can choose to save your translations without context when importing new jobs to a project. Do this by clicking on New in the Jobs section. Expand the TM Match Context and Optimization section, and change the Context Type to No context. Please see further details in our TM Match Context and Optimization article.
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. All you have to do is 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 deduplicate the segments when importing them back to Memsource.
Step 1: 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.
Step 2: In the created_by (or modified_by) column, turn on filters and select the user whose segments you want to delete.
Step 3: 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.
Step 4: Do this for all segments that user created.
Step 5: 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.
Step 6: 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 deduplicated.
Important: As with deleting segments, you need to export the Excel file with context (by checking the Previous segment, Next segment, and Context key boxes) in order to deduplicate the segments when importing them back to Memsource.
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.
Articles related to Translation Memory: