Importing two columns
Thread poster: Juancar
Does any of you know if it's possible to import a bilingual file in Excel? I mean, we can import a bilingual Word document and have it in MQ in two columns. I wonder if this can be done with an Excel file with the original and the translation in two different columns, so that we get the same view in MQ than the Word doc.
Import with options > select filter "Multilingual delimited text filter" > Change filter and configuration > select the tab Columns and define which column contains source and target text.
Just try it out, it's very simple but also very powerful
PS: Please pardon my English
| | Juancar
English to Spanish
| Almost perfect || Oct 22, 2013 |
Thanks a million for this explanation!!!
It worked, but just a couple of precisions:
1) This option only exists in 2013 version
2) When you should the filter and change the configuration, you need to click the first tab, not the Columns tab.
At least it's the way it worked for me
Anyway, you gave me a really great hint!!!!!
Thanks a lot!!!
| | Marc Cordes
Local time: 19:44
English to German
| Another Thank you! || Oct 25, 2013 |
Big thanks from me as well. I just received an Excel sheet from one of my customers with 1300+ segments which are partly translated already.
Importing it the way you suggested lets me keep the segment structure and I was also able to import all segments already translated as locked so I avoid polluting the TM with any entries that are not my own (customer requested it).
This saved me a LOT of time!
[Edited at 2013-10-25 09:09 GMT]
To report site rules violations or get help, contact a site moderator:
You can also contact site staff by submitting a support request »