https://por.proz.com/forum/memoq_support/350270-memoq_multilingual_excell_import_problems.html

MemoQ Multilingual Excell Import Problems
Tópico cartaz: Spela Groselj

Spela Groselj  Identity Verified
Eslovênia
Local time: 21:33
espanhol para esloveno
+ ...
Apr 8

Hi!

I am having troubles importing certain columns from the Excell sheet to my MemoQ. I have selected the columns which I wish to import: B column as a source text and C column would be my translation text. Here comes the problem: I can select the "Translation", but MemoQ doesn't save it. Therefore, it doesn't import the document as there is no "Translation" column.


 

Tomasz Sienicki  Identity Verified
Dinamarca
Local time: 21:33
Membro (2007)
dinamarquês para polonês
+ ...
Indicate the source column Apr 8

Remember that after specifying “Meaning of selected column” as “Translation” you have to indicate the source column in the “For column” drop-down list.

HTH.


 

Spela Groselj  Identity Verified
Eslovênia
Local time: 21:33
espanhol para esloveno
+ ...
CRIADOR(A) DO TÓPICO
When selecting "Translation" the option "source coulmn" remains locked. Apr 8

Thank you Tomasz,

I have tried this, but it doesn't give me an option. If I select "Context", "Source Text" or basically anything else, it works just fine. The only thing it doesn't let me select is the "Translation".

I have also tried another option: basic 2 language text, but the Excell file is locked, therefore it just imports the first sheet.


 

Tomasz Sienicki  Identity Verified
Dinamarca
Local time: 21:33
Membro (2007)
dinamarquês para polonês
+ ...
Works for me Apr 8

I use this filter several times a month and it simply works. You must be making some basic mistake. Please have a look at the instruction at https://docs.memoq.com/current/en/Places/multilingual-excel-and-delimit.html

Good luck!


 

Stepan Konev  Identity Verified
Federação Russa
Local time: 22:33
inglês para russo
screenshot Apr 8

First you say: I can select the "Translation"
Then you say: The only thing it doesn't let me select is the "Translation".
Which one of these statements is correct?
You should select B and mark it as Source text. Then you select C and mark it as Translation/For column B/Target language.
What is a 'basic 2 language text'? Which Excell file is locked (and where)?
Can you attach a screenshot?


[Edited at 2021-04-08 22:22 GMT]


 

Spela Groselj  Identity Verified
Eslovênia
Local time: 21:33
espanhol para esloveno
+ ...
CRIADOR(A) DO TÓPICO
Screenshhot Apr 9

Stepan Konev wrote:

First you say: I can select the "Translation"
Then you say: The only thing it doesn't let me select is the "Translation".
Which one of these statements is correct?
You should select B and mark it as Source text. Then you select C and mark it as Translation/For column B/Target language.
What is a 'basic 2 language text'? Which Excell file is locked (and where)?
Can you attach a screenshot?


[Edited at 2021-04-08 22:22 GMT]


Hi!

Thank you! I have solved it.

Alternatively, I tried to import it as a bilingual document, where you have an option to say: all columns B are "Source Text" and all columns C are "Translation". In this case, it imported just the first sheet. When I checked the Excell, if it's possible to save every sheet as a separate document, I noticed that this was not an option, as the document was protected for this kind of changes.



[Edited at 2021-04-09 05:45 GMT]


 


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


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

MemoQ Multilingual Excell Import Problems






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »