Tekniska forum » CafeTran support »
Excel: Auto-translating columns with non-translatables
Trådens avsändare: CafeTran Trainer
CafeTran Trainer
CafeTran Trainer
Nederländerna
Medlem (2006)
Jan 26, 2023

The Memory menu has an item to import Excel tables (source + target). But sometimes you want to import one or several columns (source only) directly to the TM, in order to auto-translate non-translatables like names of manufacturers, brand names, part numbers with letters etc.

Here is an easy way to do that:

  • Copy the relevant columns to a new Excel file (e.g. column L in the example below).
  • Import this Excel file into your current translation project... See more
The Memory menu has an item to import Excel tables (source + target). But sometimes you want to import one or several columns (source only) directly to the TM, in order to auto-translate non-translatables like names of manufacturers, brand names, part numbers with letters etc.

Here is an easy way to do that:

  • Copy the relevant columns to a new Excel file (e.g. column L in the example below).
  • Import this Excel file into your current translation project, make sure that segmentation is set to "No segmentation in cells".
  • Copy all source segments to the target side.
  • Commit the file to the TM.
  • Use this TM to auto-translate the relevant columns.


Demo: https://youtu.be/szMyvXcOcN0

Screen Shot 2023-01-26 at 22.41.14

You can also decide to auto-translate columns that contain cells with part codes. But you have to be careful when they contain words in the source language. Do a visual scan and collect typical words in the source language that are present in these colums.

I'll import column G in the demo and use this list of typical source words:

Draht|für|Glieder|mit|nach|Profil|Winkel|Zeichnung


The vertical bar character is used to separate words when using a filter in CafeTran Espresso later. (You can save lists like these for your next projects.)

Demo: https://youtu.be/D4qalR37Lj4



[Edited at 2023-01-27 06:58 GMT] ▲ Collapse
 


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

Moderatorer för detta forum
Natalie[Call to this topic]

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

Excel: Auto-translating columns with non-translatables






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 »
LinguaCore
AI Translation at Your Fingertips

The underlying LLM technology of LinguaCore offers AI translations of unprecedented quality. Quick and simple. Add a human linguistic review at the end for expert-level quality at a fraction of the cost and time.

More info »