5 Replies Latest reply on Jun 1, 2018 7:15 PM by MoonpieRC

    Can you "translate" from one language to the same language?

    MoonpieRC

      Greetings!

       

      Here is what I am attempting to do:

       

      We have some "legalese" (terms & conditions in one document, something else in another) that sometimes gets updated and changed.  For one of these documents we have translations (via .xlf files) into 12 languages.

       

      Currently whenever we have to update the "legalese" in the main language (U.S. English) on our main .rtf template (or in an .rtf subtemplate), we have to update all 12 .xlf files so that the <source> text matches the newly updated en-US text so that the <target> translation text gets displayed/printed.  Not terribly bad for the one document, but we keep adding different documents, each with multiple translations, and the number of languages could grow.  So over time this will get unwieldy.

       

      What I want to do is create a main .rtf where the "legalese" text reads something like, 'This is a placeholder for the Terms text.'  Then, have an .xlf file that "translates" from 'en-US' to 'en-US' - just like all the others currently translate (from 'en-US' to 'fr-FR', for example).  In that "U.S. English to U.S. English 'translation'", the <source> would be 'This is a placeholder for the Terms text.' and the <target> would be the U.S. English terms & conditions.

       

      That way, whenever the "legalese" gets updated in English but doesn't have to be updated in other languages, I only have to modify the one "English-to-English" .xlf file <source>.  I won't then have to update the <source> of 12 .xlf files.

       

      Problem is, I've tried it and can't get it to work either when using the Template Builder for Word or in our test environment.

       

      Has anyone done this or something similar and gotten it to work?

       

      Thanks,

      -Moonpie

        • 1. Re: Can you "translate" from one language to the same language?
          Brajesh Shukla

          In which platform you are running the report?

          • 2. Re: Can you "translate" from one language to the same language?
            MoonpieRC

            Brajesh,

             

            We have BIP 11.1.1.7 running the report from Siebel IP2016.

             

            Thanks,

            -Moonpie

            • 3. Re: Can you "translate" from one language to the same language?
              Brajesh Shukla

              We had similar requirement in Oracle EBS so we used lookup(its kind of mapping  where you can define one value and there respective translated value) to achieve the same.

              Based on language we are checking the lookup and picking the respective translated value in rtf. So its similar to defining translation in xlf file rather we used lookup to define translation. 

              So we have only one rtf and one lookup with multiple lookup values for each rtf tag. In future if some new field is getting added then we just need to make one entry in lookup with the respective translation.

               

              Hope you have similar lookup functionality in Siebel as well.

              • 4. Re: Can you "translate" from one language to the same language?
                MoonpieRC

                Brajesh,

                 

                Thank you for the details of what you implemented.  Upon reading it, I do not see how we can do anything similar in Siebel.

                 

                However, in thinking through what you wrote (this is sort of "stream of consciousness" here, because I started typing this immediately after thinking this), my first thought was "Maybe we could put the U.S. English Terms & Conditions in a field and translate the other languages."  But that won't work, because we don't have multiple languages set up in Siebel itself, so we can't translate the field values.  (And there are other overhead and other considerations and liabilities.)

                 

                But my next thought was just just simply do this: "Hard code" the U.S. English Terms & Conditions in the .rtf file, but make it's selection conditional: only choose this text if the locale is 'en-US'; otherwise, choose the "This is a placeholder..." text.  Then the .xlf files can use "This is a placeholder..." as the <source> and their proper translation as the <target>.

                 

                I believe this will work.  I will try it later today, and hopefully post back this week with results.

                 

                But if anyone can make my original desired functionality work, that would be a much more elegant design and easier to read in the template.

                 

                Thanks,

                -Moonpie

                • 5. Re: Can you "translate" from one language to the same language?
                  MoonpieRC

                  OK, so "this week" turned into "this Spring".  My apologies for the delayed follow up.

                   

                  Background info:

                  • We are executing this BIP report from Siebel
                  • Our default language is English-United States
                  • We had an existing .rtf template and an existing .rtf subtemplate
                  • We had existing .xlf translation files for various locales
                  • I wanted to do this not for all text in the templates, but for some text other than just the Terms & Conditions that sometimes only needs to be changed in one language or in one locale

                   

                  For the sections of text we thought needed this "semi-fluidity", here is what I ultimately did:

                  • In the .rtf template and subtemplate, I put this statement: <?choose:?><?when:$_XDOLOCALE=”en-US”?>.  (I know I could use some sort of if-then-else statement since there are only two choices, but we have had to use <?choose:?> in a number of other places in this and other templates, so I went with the familiarity and consistency.)
                  • Inside this <?when:?> I put the full actual Terms and Conditions text in U.S. English.
                  • I next added the <?otherwise:?>, in which I put this exact text: "Terms and Conditions Text Placeholder".  (What you put here is irrelevant, as long as it is obvious/easily recognized/easy to follow by you and others that will touch these files.)
                  • I then extracted the .rtf template text into the .xlf language/locale translation files.  I found the <source> element with "Terms and Conditions Text Placeholder", and in the corresponding <target> element I put the proper T&C text for the locale.  (Mind you, the T&C text for each locale is not an exact translation of the U.S. English T&C text - it is the proper terms & conditions text required by the authorities in that locale.  So if translated, might say something drastically different from country to country.)

                   

                  It worked like a charm.

                   

                  So now if our U.S. legal department tells us we have to change the U.S. T&C text, we no longer have to update the <source> element in 10+ .xlf files; we only have to change one .rtf template.  Much more efficient.

                   

                  -----

                  Here is an example of what I did....

                  In the ABCOffer.rtf template:

                  In the ABCOffer_fr_FR.xlf translation file:

                  (I assume my French is not entirely correct - please ignore that, as this is just an example, not what is really in our file.  The point is that it is not an exact translation, but that the details are different for this locale: Different document number and different number of days before expiration.)

                   

                  Now if for some reason ABC Company changes its U.S. T&C document number to ABC789, or changes the expiration to 30 days, only one file has to be touched.

                  -----

                   

                  Again, it would be even more elegant to only have "Placeholder Text" in the .rtf template with no <?choose:?> statement, and then have a _en_US.xlf file with the actual T&C text.  However, since that does not seem to work, this appears to be a good alternative.