• State Suggested Answer
  • Replies 5 replies
  • Answers 2 answers
  • Subscribers 432 subscribers
  • Views 2464 views
  • Users 0 members are here
Options

Converting TM file into Excel. Set tags disappearing.

Keni Lee

Hello, I was wondering if anyone knew a workaround to my problem.

So there are many TM files I have and I wanted to convert them into Excel. 

Obviously when I Batch task to export a project's excel file the excel file will have the Tags show up on both the Source and Target side of the excel

However, I have some old TM files where I don't have (or don't know where) the original file is so I wanted to convert that TM file into Excel using the Glossary Converter.
When I did, The tags whether they were color codings, or other variable codings (such as {0}) were removed on the exported excel.

I'm thinking that the tags were thought to be formatting tags so they were removed, but I need to be able to have them also converted and show up on Excel as if I was exporting the project file as stated first.

Does anyone know how I can go about this?
emoji
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
  • 0

    Hello,

    It seems like you're trying to convert TM files into Excel while preserving the tags. The Glossary Converter might not be the best tool for this task as it's primarily designed for converting terminology glossaries, not translation memories, and it might not handle tags correctly.

    Instead, you can use Trados Studio's built-in export feature to export your TM as a TMX file, and then use a third-party tool to convert the TMX file to Excel. Here's a step-by-step guide:

    Step 1: Open Trados Studio and go to the Translation Memories view.

    Step 2: Right-click on the TM you want to export and select Export.

    Step 3: Choose a location to save the TMX file and click Save.

    Step 4: Now, you have a TMX file which is an XML-based format. You can open this file in Excel, but it might not be very user-friendly.

    Step 5: To convert the TMX file to a more readable Excel format, you can use a third-party tool. There are several online converters available that can do this, just make sure to choose one that preserves tags.

    Please note that this process might not be perfect and some manual editing might be required in Excel to ensure all tags are correctly displayed.

    I hope this helps! If you have any other questions, feel free to ask.

    Best regards,

    RWS Community AI
    emoji
  • 0

     

    Might be worth explaining why you want to do this?  The Glossary Converter was designed for a different purpose... the purpose being to get at the text.  So retaining the tags is normally undesirable.  If you can explain what your usecase is perhaps there is a better solution to your problem.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji
  • 0 in reply to Paul

    For a game translation company we have many variables that show up within the text. 

    These variables are not only formatting texts such as <color#12312> </color> 
    Some of the strings will have variables such as {0} to to replaced within the game later on when put into the game.
    Such as
    "Player {0} will be kicked from the <color#12312>guild</color>, are you sure you want to continue?"  {0} = username
    "Would you like to purchase {1} {0} from the market?" {0} = item name / {1} quantity

    Sometimes there are string with many tags so when translating, games companies will usually, set these variables as tags so that it's quicker to insert it into the Target text and when running verification we are able to see if the source and target both include the variable(tags).

    That's the explanation as to why we use the tag function. As for why I'm trying to convert the TM into Excel is because original excel files (or the finished project excel files) from old projects that we have done are not available to us anymore because we cannot find them. However, we still have all the TM from those projects. So I wanted to convert the TM  into Excel so we can use the Excel to use as a data and organize them.

    I don't know if I explained it well to your understanding. 

    Please let me know if there's any other information you may need
    emoji
  • 0 in reply to Keni Lee

     

    ok - understood. 

    Keni Lee said:
    So I wanted to convert the TM  into Excel so we can use the Excel to use as a data and organize them.

    In this case your best bet is to export to TMX so the tag placeables will still be there and then bring the TMX into Excel so you retain the tags.  They won't be useful in Excel because the TM doesn't know what to do with the tags.. they are just placeables, but at least you'd know they were there.

    So if I take your example:

    Excel spreadsheet showing two rows of text with placeholder tags and color formatting tags within the sentences.

    Translate in Studio:

    Excel spreadsheet with two rows displaying source and target language content, including placeholder tags and color formatting tags, with NMT icons indicating translation status.

    Export from my TM as TMX:

    Fullscreen
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    <?xml version="1.0" encoding="utf-8"?>
    <tmx version="1.4">
    <header creationtool="SDL Language Platform" creationtoolversion="8.1" o-tmf="SDL TM8 Format" datatype="xml" segtype="sentence" adminlang="en-US" srclang="en-US" creationdate="20240429T090048Z" creationid="GLOBAL\pfilkin">
    <prop type="x-Recognizers">RecognizeAll</prop>
    <prop type="x-IncludesContextContent">True</prop>
    <prop type="x-TMName">gaming</prop>
    <prop type="x-TokenizerFlags">DefaultFlags</prop>
    <prop type="x-WordCountFlags">DefaultFlags</prop>
    </header>
    <body>
    <tu creationdate="20240429T090031Z" creationid="GLOBAL\pfilkin" changedate="20240429T090055Z" changeid="GLOBAL\pfilkin" lastusagedate="20240429T090055Z">
    <prop type="x-LastUsedBy">GLOBAL\pfilkin</prop>
    <prop type="x-Context">0, 0</prop>
    <prop type="x-Origin">TM</prop>
    <prop type="x-ConfirmationLevel">Translated</prop>
    <tuv xml:lang="en-US">
    <seg>Player <ph x="1" type="0" /> will be kicked from the <bpt i="2" type="1" x="2" /><ept i="2" /></seg>
    </tuv>
    <tuv xml:lang="de-DE">
    <seg>Der Spieler <ph x="1" type="0" /> wird vom getreten <bpt i="2" type="1" x="2" /><ept i="2" /></seg>
    </tuv>
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    Create a macro in Excel to bring it in with the tags included:

    Fullscreen
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    Sub ImportTMX()
    Dim fd As FileDialog
    Dim tmxPath As String
    Dim xmlDoc As Object
    Dim xmlNodeList As Object
    Dim tuNode As Object
    Dim tuvNode As Object
    Dim segNode As Object
    Dim row As Integer
    ' Create a file dialog object to select the TMX file
    Set fd = Application.FileDialog(msoFileDialogFilePicker)
    fd.Title = "Select a TMX File"
    fd.Filters.Add "TMX Files", "*.tmx"
    If fd.Show = -1 Then
    tmxPath = fd.SelectedItems(1)
    Else
    MsgBox "No file selected. Exiting macro."
    Exit Sub
    End If
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    Run it and select the TMX:

    Excel spreadsheet with three columns labeled ID, Source language content, and Target language content, showing text with XML placeholder tags.

    Now I have the tags too and not just the text.  Is that what you wanted?

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub



    Generated Image Alt-Text
    [edited by: Trados AI at 9:22 AM (GMT 1) on 29 Apr 2024]
  • 0 in reply to Paul

    oh wow ty, I'll try it out and update you!
    emoji