Importing excell glossary into WFP
Thread poster: François-Xavier Pâque

François-Xavier Pâque
Belgium
Local time: 09:15
Member (2010)
Russian to French
+ ...
Oct 6, 2009

Hello !!

I would have a question concerning WFP : Is it possible to import excel (.xls or .xlsx) glossaries into WFP (mac)?

If it is could you tell me how to do it coz i'm a bit of a newbie for those things...


thanks in advance !!


Direct link Reply with quote
 

Kristyna Marrero  Identity Verified
United States
Local time: 03:15
Importing TM into Wordfast Oct 6, 2009

Hi François-Xavier,

Are you trying to import a glossary or TM? Wordfast Pro can accept glossaries as tab-delimited text format. Simply save the excel file as tab-delimited text and open it in Wordfast Pro.

Sincerely,

Kristyna

[Edited at 2009-10-06 10:17 GMT]

[Edited at 2009-10-06 10:53 GMT]


Direct link Reply with quote
 

P Forgas  Identity Verified
Brazil
Local time: 04:15
Portuguese to Spanish
+ ...
txt Oct 6, 2009

Hi François,

save the excel file as Text (Tab delimited) (*.txt), and voilà.

WF glossaries are very simple txt files.

P.


Direct link Reply with quote
 

veratek
Brazil
Local time: 04:15
French to English
+ ...
why is it not working? Apr 15, 2011

save the excel file as Text (Tab delimited) (*.txt), and voilà.
=============

I tried this and it didn't work -free version of wordfast.

I tried exporting a two-column glossary from excel into txt and xml nothing worked.

If I write up a little text file manually and save it, wordfast will recognize it.

Any ideas?

(I also noted excel inserts a bunch of blank lines when saving to txt format - shouldn't make a difference, I would think...)


Direct link Reply with quote
 

Yasmin Moslem  Identity Verified
Egypt
Local time: 09:15
English to Arabic
What does WFP say? Apr 15, 2011

veratek wrote:

save the excel file as Text (Tab delimited) (*.txt), and voilà.


Dear Vera,

What is the (error) message you receive exactly?

If you like, you can send me the TXT file to check.

Kind regards,
Yasmin


Direct link Reply with quote
 

veratek
Brazil
Local time: 04:15
French to English
+ ...
it just doesn't work Apr 15, 2011

Yasmin Moslem wrote:

veratek wrote:

save the excel file as Text (Tab delimited) (*.txt), and voilà.


Dear Vera,

What is the (error) message you receive exactly?

If you like, you can send me the TXT file to check.

Kind regards,
Yasmin


Hi,

Thanks for your reply. I don't get any error messages at all for the exported txt with tabs file. For the xml, wordfast says it can't open it.

But even if I successfully get wordfast to open the glossary.txt file, the glossary function simply doesn't work at all (no highlighting of words contained in the glossary as you are translating the segments).

Do you know if the blank lines should make a difference? I haven't tested a manual deletion of lines in such a file to see if they were causing problems...


Direct link Reply with quote
 

Yasmin Moslem  Identity Verified
Egypt
Local time: 09:15
English to Arabic
Are they imported? Examples? Apr 15, 2011

If the xml was actually a TBX glossary, try to adjust the extension; otherwise, the xml is not a supported format FOR glossaries.

As for the txt glossary, if you press Ctrl+E (Glossary Editor), can you see the problematic entry on the list; was it successfully imported?

If yes, could you please give me examples of entries not highlighted; how they appear in the glossary and in the source text.


Many thanks in advance!

---
Best regards,
Yasmin Moslem

Wordfast Support Team
www.wordfast.com | www.wordfast.net


Direct link Reply with quote
 

veratek
Brazil
Local time: 04:15
French to English
+ ...
I found the problem! Jul 16, 2011

So simple...

The issue was that my Excel was not saving a text file when I selected to save as txt. I tried all the the txt options, and all the ways to save it, and it simply won't save a file as a plain txt file.

So, I copied the two FR-EN columns into Word and followed the instructions below. Checked the resulting file and it is a beautiful, simple, tab-delimited txt. It works perfectly now as a WFC glossary.

Importing your personal glossary into Wordfast

How do I convert a glossary from Word or Excel?
To convert the Word table or Excel glossary to plain text with tab delimiters, follow the following instructions:

MS Word 2003
1. Select the rows or table that you want to convert to text
2. Choose Convert from the Table menu, then chose Table to Text from the resulting submenu.
Word then displays the Convert Table to Text dialog box
3. Select the tab delimiter (tabs)
4. Data is then separated by tabs and can be saved as with a .txt extension

MS Word 2007
1. Select the rows or table that you want to convert to text
2. Under Table, on the Layout tab, in the data group, click Convert to Text
3. Under Separate Text With, click the option for Tabs
4. Data is then separated by tabs and can be saved as with a .txt extension

MS Excel
1. Click File and select Save As...
2. Under Save As type: select the Text (tab delimited) .txt option

http://www.translatum.gr/forum/index.php?PHPSESSID=9fc4c61ff914fda5b63336a2b3e0d95d&topic=21445.0#ixzz1SGer963F


Direct link Reply with quote
 

veratek
Brazil
Local time: 04:15
French to English
+ ...
thanks Jul 16, 2011

Yasmin Moslem wrote:

If yes, could you please give me examples of entries not highlighted; how they appear in the glossary and in the source text.
---
Best regards,
Yasmin Moslem

Wordfast Support Team
www.wordfast.com | www.wordfast.net


Thanks again.


Direct link Reply with quote
 

Yasmin Moslem  Identity Verified
Egypt
Local time: 09:15
English to Arabic
Great! Thanks! Jul 16, 2011

Dear Vera,

I am happy that your problem has been solved. Thanks for the explanation.

Also, colleagues can check the relevant video here:
http://www.wordfast.com/tips_and_tricks.html

Kind regards,
Yasmin


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 »

Importing excell glossary into WFP

Advanced search


Translation news related to Wordfast





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 »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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