Problem importing termbases to MemoQ from xlsx/csv files
Thread poster: Sergii Kolomiiets

Sergii Kolomiiets  Identity Verified
Ukraine
Local time: 09:06
Ukrainian to English
+ ...
Jun 9, 2016

I have tried to import a termbase (English-Russian) to MemoQ 2014 from an Excel table and a csv file, but the memoQ only copies term segments (English) and ignores definition segments (Russian), so in the end I get a term base with terms that contain empty segments where definitions should be available. I properly assign functions to all table columns and choose corresponing languages, but it doesn't work out. The same happens when I try to import a TM.

Why does the software ignore the definition|target text column? What am I doing wrong, or is there a different way of getting text segments and their translations into MemoQ so they stay as a TM or a termbase?


Direct link Reply with quote
 

Tony M  Identity Verified
France
Local time: 08:06
Member
French to English
+ ...
Hidden columns? Jun 9, 2016

I don't know if it's relevant or even feasible in your situation, but just recently I got caught out when trying to import some Excell stuff into another document, as I hadn't noticed the opriginator had for some resaon included several columns that were 'hidden' (i.e. had width = 0) I only spotted this when I noticed that the column heading letters jumpsded from 'P' to 'S'. Those superfluous columns (apparently blank) were ruining the compatibility of my formatting.

Might just be worth checking?


Direct link Reply with quote
 

Sergii Kolomiiets  Identity Verified
Ukraine
Local time: 09:06
Ukrainian to English
+ ...
TOPIC STARTER
Thanks, but not a solution for me... Jun 9, 2016

Thanks for your input, Tony M, but, unfortunately, what you describe does not look like my case. I have a two column document, and MemoQ sees source text coulmn as F0, and target text column, as F1, and everything looks nice, and I hit import, and the F1 text just doesn't show up.

Direct link Reply with quote
 

Kelly Neudorfer  Identity Verified
Germany
Local time: 08:06
German to English
Language variants? Jun 9, 2016

I have never worked with Russian, so I don't know if this could be the case there, but you have to make sure that the variant (or lack thereof) is also lined up. I tried to import a termbase using the English (UK) and German (Germany) setting, and I kept getting only the English terms. It was driving me nuts, and then I tried just doing English (UK) and German with no country variant. It worked. So if Russian also has options for the variant, make sure that you've got the same one when you're setting up your termbase and defining the columns.

Direct link Reply with quote
 

Michael Joseph Wdowiak Beijer  Identity Verified
United Kingdom
Local time: 07:06
Member (2009)
Dutch to English
+ ...
that's what I was thinking too: check the language variants! Jun 9, 2016

Kelly Neudorfer wrote:

I have never worked with Russian, so I don't know if this could be the case there, but you have to make sure that the variant (or lack thereof) is also lined up. I tried to import a termbase using the English (UK) and German (Germany) setting, and I kept getting only the English terms. It was driving me nuts, and then I tried just doing English (UK) and German with no country variant. It worked. So if Russian also has options for the variant, make sure that you've got the same one when you're setting up your termbase and defining the columns.


Direct link Reply with quote
 

Sergii Kolomiiets  Identity Verified
Ukraine
Local time: 09:06
Ukrainian to English
+ ...
TOPIC STARTER
Thanks, but the language variant didn't help Jun 10, 2016

Thanks for your ideas, guys, but I originially did not assign a country variant. I played around with that, and, unfortunately, it didn't work...

I will welcome any new ideas.

Thanks!


Direct link Reply with quote
 

Stepan Konev  Identity Verified
Russian Federation
Local time: 09:06
English to Russian
Not a definition Jun 11, 2016

Both English and Russian columns (F0 and F1) must be imported as terms.

[Edited at 2016-06-11 14:12 GMT]


Direct link Reply with quote
 

Sergii Kolomiiets  Identity Verified
Ukraine
Local time: 09:06
Ukrainian to English
+ ...
TOPIC STARTER
Thank you Stepan! Jun 11, 2016

Thank you, Stepan!

It worked. As weird as it is, but yay, I fed my two-language term list into my MemoQ by assigning both language columns the function of terms.

Thanks again everyone!

Cheers!

Serg


Direct link Reply with quote
 

Anil Gidwani  Identity Verified
India
Local time: 11:36
German to English
+ ...
That worked for me too (DE->EN) Jan 12

Stepan Konev wrote:

Both English and Russian columns (F0 and F1) must be imported as terms.

[Edited at 2016-06-11 14:12 GMT]


Thanks Stepan:

That worked for me too (DE-EN) after several unsuccessful attempts with other strategies. It is weird, but one would have thought the second language should be imported as the definition. I guess memoQ 'defines definition' differently!

This is one of those things that is an exception to memoQ's otherwise superb ease of use.

Anil


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Problem importing termbases to MemoQ from xlsx/csv files

Advanced search






PDF Translation - the Easy Way
TransPDF converts your PDFs to XLIFF ready for professional translation.

TransPDF converts your PDFs to XLIFF ready for professional translation. It also puts your translations back into the PDF to make new PDFs. Quicker and more accurate than hand-editing PDF. Includes free use of Infix PDF Editor with your translated PDFs.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search