MemoQ only imports the first row from an excel sheet Thread poster: Alex Maslow
|
Super weird issue. I have an excel file with multiple sheets. I'm trying to import strings from just one sheet using the multilingual delimited text filter. All I need is two columns, one for the source text and one for the translation. Thing is, it refuses to import the source text column, instead only importing the first row. What could possibly cause this? Also, when importing the file it gives me a lot of "merged with other cells, content ignored" messages. What is this?
[Edited at 20... See more Super weird issue. I have an excel file with multiple sheets. I'm trying to import strings from just one sheet using the multilingual delimited text filter. All I need is two columns, one for the source text and one for the translation. Thing is, it refuses to import the source text column, instead only importing the first row. What could possibly cause this? Also, when importing the file it gives me a lot of "merged with other cells, content ignored" messages. What is this?
[Edited at 2021-03-23 02:08 GMT] ▲ Collapse | | | Stepan Konev Russian Federation Local time: 17:09 English to Russian Did you change configuration when you imported the file? | Mar 23, 2021 |
After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to r... See more After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to right).
[Edited at 2021-03-23 14:45 GMT] ▲ Collapse | | | Alex Maslow Local time: 20:09 English to Russian TOPIC STARTER Yes, absolutely | Mar 23, 2021 |
Stepan Konev wrote: After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to right). [Edited at 2021-03-23 14:45 GMT] I'm positive I've selected everything that needed to be selected, down to the exact sheet and columns. I'm guessing something is wrong with this specific excel file, because I've checked a few other files and they imported with no issue. | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » MemoQ only imports the first row from an excel sheet 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 » |
| CafeTran Espresso | You've never met a CAT tool this clever!
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Buy now! » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |