How to create memoq termbase with .xls file
Thread poster: traiston

traiston  Identity Verified
Australia
Local time: 17:16
Member (2008)
English to Chinese
+ ...
Aug 9, 2013

My dear friends:
The client sent me a glossary file in .xls format. I want to create a termbase with it. But Memoq only can import CSV or TMX file. I saved the file as .CSV file, but erro appeared when importing it.
Thank you in advance.

[修改时间: 2013-08-10 00:48 GMT]


Direct link Reply with quote
 

Chunyi Chen
United States
Local time: 23:16
English to Chinese
Use the Unicode Text file format instead Aug 10, 2013

It will not import correctly if you save the file in csv format. The correct format is actually the Unicode Text (.txt) file. In Excel, save your xls file in Unicode Text format. Then import the .txt file using the same import function for csv/tmx to MemoQ, assigning the source and target languages accordingly. It should work.

Good luck!

Chun-yi

traiston wrote:

My dear friends:
The client sent me a glossary file in .xls format. I want to create a termbase with it. But Memoq only can import CSV or TMX file. I saved the file as .CSV file, but erro appeared when importing it.
Thank you in advance.

[修改时间: 2013-08-10 00:48 GMT]


Direct link Reply with quote
 

traiston  Identity Verified
Australia
Local time: 17:16
Member (2008)
English to Chinese
+ ...
TOPIC STARTER
Thank you for you help. Aug 10, 2013

Hi, Chen
I imported it successfully. Thank you very much.


Direct link Reply with quote
 

Richard Purdom  Identity Verified
Portugal
Local time: 07:16
Dutch to English
+ ...
Can only import source OR target from unicode or excel Nov 6, 2014

I followed the advice above. However even though I can 'import' both excel files and unicode files, when I look at the term base only the target language appears on the right, with nothing on the left, or all the source language on the left, with nothing on the right. No error according to memoQ.

I select the language/source(target/fields before importing, I can't see what I'm doing wrongly.
Help!


Direct link Reply with quote
 
VIP9N
Local time: 09:16
Russian to English
+ ...
It's simple: Nov 7, 2014

Richard Purdom wrote:
...only the target language appears on the right, with nothing on the left,...
...I select the language/source(target/fields before importing, I can't see what I'm doing wrongly. Help!


Hi Rich,
The Memo's logic is quite simple, you have to get it as follows:
When you selected the relevant file (csv or txt) to be imported into your termbase, select the required fileds:
1. F0 - Import as term - Language (I select French (France), for ex.)
2. F1 - Import as term - Language (I select Russian, for ex.)
Voilà & that's all.

Good luck


Direct link Reply with quote
 

Richard Purdom  Identity Verified
Portugal
Local time: 07:16
Dutch to English
+ ...
sorted! Nov 7, 2014

Thanks for your help, I was trying to import the translation column as 'definition'.

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 »

How to create memoq termbase with .xls file

Advanced search






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

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