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

François-Xavier Pâque
Belgium
Local time: 05:47
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: 23:47
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: 02:47
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: 02:47
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: 06:47
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: 02:47
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: 06:47
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: 02:47
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: 02:47
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: 06:47
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





memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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