• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 431 subscribers
  • Views 603 views
  • Users 0 members are here
Options
Related

RWS Trados - previewing URL content in a Trados package/project

Gabriela Olszewska

Hello Everyone,

We've just stumbled upon an issue in a marketplace translation project.

We have a file that consists of a few thousand products with descriptions of clothing items and we would like the project to be as easy to translate as possible.

The source file is an excel file with a few columns to be translated - product names, categories, product descriptions, and a few columns not to be translated, including URLs to product images and packshots.

We've prepared the files but we're wondering about the references. We'd like our translators to see the product photos directly in Studio, if possible. Without clicking the links or going back to the source excel and looking for the right product. The reference images are crucial because a jacket could be a couple of things in our target languages. So there are repetitions in the file that are not true repetitions and will have to be adjusted, based on the photo or product category. 

And it wouldn't be a problem if we had a few photos to look at but it is a problem, when we have so many strings of text.

So we're looking for the best solution, our idea include:

- a possibility to have the URLs included in the file as segments (but is there a way to preview them directly from the segment in Trados, without opening your browser?),

- a possibility of using sdltb. Creating an sdltb file consisting of each URL text as source and target language and adding a field value "Photo" with a multimedia attachment. Then, translator would have the url segment before each new product to consult. However, we've encountered two further issues there. 

1. Is it possible to use multiterm convert to include field values set as multimedia that would display as photos? I've tried to create a test file and the field value was created but it did not automatically import the pictures. I worked on an Excel-based glossary and multiterm convert. Adding the URLs as a field value directly in the multiterm desktop after importing the data from the Excel worked. But it would be so time-consuming to do it for a few thousands of entries.

2. What are the options of previewing the termbase entries directly in Trados? Is "view term" option the only possible one? So that the translator has this termbase viewer window pinned in the studio editor?

Thanks in advance for any feedback regarding this puzzle Slight smile

Best regards,

Gabi
emoji
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0

     

    Probably the easiest and best solution would be this:

    1. convert your Excel to XML
    2. create a custom XML filetype for the XML in Studio
    3. create a stylesheet for the preview
    4. translate the XML with the preview showing what you need
    5. finally save the target and either convert the XML back to Excel, or just pretranslate the original Excel from your TM that now contains all the translations

    For example, my Excel:

    Excel spreadsheet with columns for Product Names, Categories, Product Descriptions, and Image links, showing entries for Apple iPhone 13, Dell XPS 13, and other products.

    Gets me this XML:

    <?xml version="1.0" encoding="UTF-8"?>
<Products>
    <Product>
        <ProductNames>Apple iPhone 13</ProductNames>
        <Categories>Mobile Phones</Categories>
        <ProductDescriptions>Latest model with A15 Bionic chip and dual-camera system.</ProductDescriptions>
        <Image>www.lidl.de/.../Image>
    </Product>
    <Product>
        <ProductNames>Dell XPS 13</ProductNames>
        <Categories>Laptops</Categories>
        <ProductDescriptions>13-inch laptop featuring 11th Gen Intel processors.</ProductDescriptions>
        <Image>www.dell.com/.../Image>
    </Product>
    <Product>
        <ProductNames>Samsung Galaxy S22</ProductNames>
        <Categories>Mobile Phones</Categories>
        <ProductDescriptions>High-performance smartphone with an advanced camera.</ProductDescriptions>
        <Image>www.backmarket.de/.../Image>
    </Product>
    <Product>
        <ProductNames>Sony WH-1000XM4</ProductNames>
        <Categories>Headphones</Categories>
        <ProductDescriptions>Noise-cancelling headphones with long battery life.</ProductDescriptions>
        <Image>image.coolblue.de/.../Image>
    </Product>
    <Product>
        <ProductNames>Instant Pot Duo</ProductNames>
        <Categories>Kitchen Gadgets</Categories>
        <ProductDescriptions>7-in-1 pressure cooker, slow cooker and more.</ProductDescriptions>
        <Image>m.media-amazon.com/.../Image>
    </Product>
    <Product>
        <ProductNames>Fitbit Versa 3</ProductNames>
        <Categories>Wearables</Categories>
        <ProductDescriptions>Fitness tracker and smartwatch with built-in GPS.</ProductDescriptions>
        <Image>img.kleinanzeigen.de/.../xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
    </Product>
    <Product>
        <ProductNames>Nikon D850</ProductNames>
        <Categories>Cameras</Categories>
        <ProductDescriptions>Full-frame DSLR with 45.7 megapixels and 4K video.</ProductDescriptions>
        <Image>petapixel.com/.../Image>
    </Product>
    <Product>
        <ProductNames>Amazon Echo Dot</ProductNames>
        <Categories>Smart Home</Categories>
        <ProductDescriptions>Compact smart speaker with Alexa voice assistant.</ProductDescriptions>
        <Image>sm.pcmag.com/.../Image>
    </Product>
</Products>

    For which I create this stylesheet:

    <?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform">
  
  <xsl:template match="/">
    <html>
      <head></head>
      <body>
        <h2>Product List</h2>
        <table border="1">
          <tr>
            <th>Product Name</th>
            <th>Image</th>
          </tr>
          <xsl:for-each select="Products/Product">
            <tr>
              <td><xsl:value-of select="ProductNames"/></td>
              <td>
                <img>
                  <xsl:attribute name="src">
                    <xsl:value-of select="Image"/>
                  </xsl:attribute>
                  <xsl:attribute name="width">200</xsl:attribute>
                  <xsl:attribute name="height">200</xsl:attribute>
                </img>
              </td>
            </tr>
          </xsl:for-each>
        </table>
      </body>
    </html>
  </xsl:template>
  
</xsl:stylesheet>

    Then in Studio I get this:

    Screenshot showing the XML preview

    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 12:27 PM (GMT 0) on 29 Feb 2024]
Reply
  • 0

     

    Probably the easiest and best solution would be this:

    1. convert your Excel to XML
    2. create a custom XML filetype for the XML in Studio
    3. create a stylesheet for the preview
    4. translate the XML with the preview showing what you need
    5. finally save the target and either convert the XML back to Excel, or just pretranslate the original Excel from your TM that now contains all the translations

    For example, my Excel:

    Excel spreadsheet with columns for Product Names, Categories, Product Descriptions, and Image links, showing entries for Apple iPhone 13, Dell XPS 13, and other products.

    Gets me this XML:

    <?xml version="1.0" encoding="UTF-8"?>
<Products>
    <Product>
        <ProductNames>Apple iPhone 13</ProductNames>
        <Categories>Mobile Phones</Categories>
        <ProductDescriptions>Latest model with A15 Bionic chip and dual-camera system.</ProductDescriptions>
        <Image>www.lidl.de/.../Image>
    </Product>
    <Product>
        <ProductNames>Dell XPS 13</ProductNames>
        <Categories>Laptops</Categories>
        <ProductDescriptions>13-inch laptop featuring 11th Gen Intel processors.</ProductDescriptions>
        <Image>www.dell.com/.../Image>
    </Product>
    <Product>
        <ProductNames>Samsung Galaxy S22</ProductNames>
        <Categories>Mobile Phones</Categories>
        <ProductDescriptions>High-performance smartphone with an advanced camera.</ProductDescriptions>
        <Image>www.backmarket.de/.../Image>
    </Product>
    <Product>
        <ProductNames>Sony WH-1000XM4</ProductNames>
        <Categories>Headphones</Categories>
        <ProductDescriptions>Noise-cancelling headphones with long battery life.</ProductDescriptions>
        <Image>image.coolblue.de/.../Image>
    </Product>
    <Product>
        <ProductNames>Instant Pot Duo</ProductNames>
        <Categories>Kitchen Gadgets</Categories>
        <ProductDescriptions>7-in-1 pressure cooker, slow cooker and more.</ProductDescriptions>
        <Image>m.media-amazon.com/.../Image>
    </Product>
    <Product>
        <ProductNames>Fitbit Versa 3</ProductNames>
        <Categories>Wearables</Categories>
        <ProductDescriptions>Fitness tracker and smartwatch with built-in GPS.</ProductDescriptions>
        <Image>img.kleinanzeigen.de/.../xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
    </Product>
    <Product>
        <ProductNames>Nikon D850</ProductNames>
        <Categories>Cameras</Categories>
        <ProductDescriptions>Full-frame DSLR with 45.7 megapixels and 4K video.</ProductDescriptions>
        <Image>petapixel.com/.../Image>
    </Product>
    <Product>
        <ProductNames>Amazon Echo Dot</ProductNames>
        <Categories>Smart Home</Categories>
        <ProductDescriptions>Compact smart speaker with Alexa voice assistant.</ProductDescriptions>
        <Image>sm.pcmag.com/.../Image>
    </Product>
</Products>

    For which I create this stylesheet:

    <?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform">
  
  <xsl:template match="/">
    <html>
      <head></head>
      <body>
        <h2>Product List</h2>
        <table border="1">
          <tr>
            <th>Product Name</th>
            <th>Image</th>
          </tr>
          <xsl:for-each select="Products/Product">
            <tr>
              <td><xsl:value-of select="ProductNames"/></td>
              <td>
                <img>
                  <xsl:attribute name="src">
                    <xsl:value-of select="Image"/>
                  </xsl:attribute>
                  <xsl:attribute name="width">200</xsl:attribute>
                  <xsl:attribute name="height">200</xsl:attribute>
                </img>
              </td>
            </tr>
          </xsl:for-each>
        </table>
      </body>
    </html>
  </xsl:template>
  
</xsl:stylesheet>

    Then in Studio I get this:

    Screenshot showing the XML preview

    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 12:27 PM (GMT 0) on 29 Feb 2024]
Children
No Data