How to translate Excel files with HTML tags and text from Magento?

Good evening!

A client requested the translation of parts of a website made in Magento.

They sent 2 Excel files, so full with tags that it's hard to find the text. I asked for 2 files with just the text, but they refused: they are not able to insert the translation in the right place.

There is a way to ignore the tags and see only the text, in Trados? Here's an example of the file:

 class=""planWinkelLink"" target=""_blank"" href=""URL"">Plan een winkelbezoek</a>             </div>         </div>     </div>          <div class=""floating_one_fourth"">         <div class=""winkels-box-shadow"">             <div>                 <a title=""Leeuwarden"" target=""_self"">                     <img id=""klantenservice_card_img"" title=""Leeuwarden""                         src=""{{media url=&quot

Thank you all!

  • Does enabling Embedded Content in your project settings help?

    Trados Studio project settings window showing 'Microsoft Excel 2007-2016' with 'Embedded content' selected and 'Enable embedded content processing' checkbox checked.

    Then add as many tags/placehoders as you need.

    The Preview button at the button may help you as well to check how things go...

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 1:47 AM (GMT 0) on 29 Feb 2024]
  • Dear Jesùs, thanks! It really helped!

    However, I still have some issues with this file:

    Trados Screenshot

    As you can see, it fragmented a lot of tags/placeholders, and ignored some of them too. Is there something else I can do to solve this problem?

  • You need to define all the content you to not need to translate in the embedded content section. The regex enclosed there by default will not catch most of your tags. Ith will be a decent task defining all this tags via regex. Or you can have someone doing that for you (paid service). I assume, at least 2 or 3 hours will be necessary here, maybe even much more.

    _________________________________________________________

    When asking for help here, please be as accurate as possible. Please always remember to give the exact version of product used and all possible error messages received. The better you describe your problem, the better help you will get.

    Want to learn more about Trados Studio? Visit the Community Hub. Have a good idea to make Trados Studio better? Publish it here.