技术论坛 » MemoQ support »
Help with Excel filter options
论题张贴者: J M A
J M A
J M A
西班牙
Local time: 11:01
Dec 22, 2015

Hello!

I've been having some problems importing xls files on MemoQ.

I've imported the column translation and the column length without problems but I need to import more context and I don't know what I'm doing wrong.

Some information about my excel file:

A = order number
E = source
G = target (filled with the source text)
H = length
I = (not relevant)
J = comments
L = context
M = more context

... See more
Hello!

I've been having some problems importing xls files on MemoQ.

I've imported the column translation and the column length without problems but I need to import more context and I don't know what I'm doing wrong.

Some information about my excel file:

A = order number
E = source
G = target (filled with the source text)
H = length
I = (not relevant)
J = comments
L = context
M = more context

(There are some hidden columns)

I need to import the column G as translation, the column H as length and columns J, L and M as context and what I've done is:

Import with options > Change filter and configuration >

Importable ranges and general options: Here I selected only the option "skip hidden rows and columns" and on include or exclude ranges > import only these ranges > (Sheet!G1:G1500) [Good result]

Comment and context options:
>Import comments > Relative position C: +1 R: 0 [Good result for length restrictions]
>Import context IDs > Custom rules >

Sheet!J1:J1500 C: +3 R: 0
Sheet!L1:L1500 C: +4 R: 0
Sheet!M1:M1500 C: +5 R: 0

[Problem: this context (J,M,L) is not shown on comments]

I would like to know if anyone is used to treat this kind of documents and what is the correct way to do it, please.

Thanks in advance,

J M A.





[Edited at 2015-12-22 16:37 GMT]

[Edited at 2015-12-22 16:46 GMT]

[Edited at 2015-12-23 08:07 GMT] ▲ Collapse
 
Stanislav Okhvat
Stanislav Okhvat
Local time: 13:01
English英语译成Russian俄语
Use Multilingual delimited text filter Dec 22, 2015

Hello,

You are using the standard Excel filter. Instead, after you click Import with Options, click Change filter and configuration, select Multilingual Delimited Text Filter from the Filter list, and then configure the filter on the second tab. To do this, write down the letter names of each column (A, B, etc) in Excel before doing this.

Configurating the filter is quite intuitive, but if you have issues, there are several video tutorials on this (Kilgray's webinars) a... See more
Hello,

You are using the standard Excel filter. Instead, after you click Import with Options, click Change filter and configuration, select Multilingual Delimited Text Filter from the Filter list, and then configure the filter on the second tab. To do this, write down the letter names of each column (A, B, etc) in Excel before doing this.

Configurating the filter is quite intuitive, but if you have issues, there are several video tutorials on this (Kilgray's webinars) as well as memoQ help files.

Best regards,
Stanislav Okhvat
TransTools – Useful tools for every translator ▲ Collapse
 
J M A
J M A
西班牙
Local time: 11:01
主题发起人
Thanks a lot! Dec 23, 2015

Thank you very much Stanislav!

I didn't know about this filter but it is perfect for what I want to do

Best regards and Merry Christmas,

J M A

[Edited at 2015-12-23 09:46 GMT]

[Edited at 2015-12-23 11:40 GMT]
 


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

本论坛的版主
Maya Gorgoshidze[Call to this topic]
Peter Zauner[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Help with Excel filter options






Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »