How to export TMS TM to .csv format?

A Translation Memory(TM) can be exported from TMS application either in the Inbox page or from the Job Summary page.

• In the Inbox page, click on Download --> Download TMs.
• In the Job Summary page, if there are matches from a TM, those TMs can be found when clicked on Download --> TMs --> Select TM and download.

One can download TMs in .sdltm/.tmx/.mdb formats from here.

However, if the TM is needed in .csv format, there are two ways to do it:

1. SDL TMS TM Maintenance App has to be downloaded (from My Downloads --> System Downloads in TMS application). To export the TM in .csv format, open the app and:

• Click on TM --> Open --> TMS Server --> Ok
• Click on Add
• Provide the TMS instance URL in the Server section (For ex: mytms.sdlproducts.com).
• Select tick on The server requires a secure connection(SSL) and Use default port number
• Provide TMS login credentials in UserID and Password sections.
• Select the required TM from the Translation Memory drop-down.
• Choose the Source language and Target language as necessary.
• Once the TM is opened, click on TM --> Export --> Delimited File
• Use Comma delimiter and check Add column headers in first line.
• Select the required fields to export and click on Next.
• Choose export file destination and click on Finish.

2. Glossary Converter   app has to be downloaded from RWS App Store which is the quickest way to convert .tmx or .sdltb or .tbx TM export files to .csv format.

• Download/Export the TMs required from TMS.
• Unzip the downloaded file. Use 7 zip to unzip multiple files together.
• Once the zip file is unzipped, you can see the folder contains TMs with individual folders for each source and target language pair.
• Below commands can be used in Command Prompt which are useful to move all .sdltm or .tmx files from sub-folders to a single location:

  md "C:\Users\Desktop\TMs" -- create destination folder
  cd /d "C:\Users\Downloads\Source_unzipped_folder" -- source folder
  for /r %d in (*) do copy "%d" "C:\Users\Desktop\TMs" -- destination folder
  

• Once all the TM files are moved to a single location, open the Glossary Converter app.
• Go to Settings --> General --> Select Excel CSV --> Tick/select Use the selected output format for any input format and Save --> Ok.
• Click on in and select all the TMs to be converted and click on Open.
• Once the conversion is completed, the converted .csv files will be stored in the same location as source.