Convert Excel to TM

MARIA-TERESA ALVAREZ-BENITO over 4 years ago

Hi,

I have an Excel file, 2 columns, source and target languages, and I need to use it as a TM. How can I do that? I use Trados 2019.

Can you explain all the steps?

Thanks

Translate

Rate translation

Suggest better translation

Moderator UI

Thread Subject & Description
Convert Excel to TM Hi, I have an Excel file, 2 columns, source and target languages, and I need to use it as a TM. How can I do that? I use Trados 2019. Can you explain all the steps? Thanks
Get AI Suggestion

AI Reply

Accept answer Reject Answer

Parents

0 Daniel Hug over 4 years ago

Hi MARIA-TERESA ALVAREZ-BENITO

Since Jerzy already pointed to two ways, I will point out another one...

Using the Glossary Converter, a free app from the SDL Appstore, you select "Sdl TM" as output format, drop the file on it and the job is done:

Select target format:

Select the direction of the TM:

Job done:

It really is that simple. Jerzy's solutions work just as well, but Olifant is the most tricky of the three mentioned here I would say.

Daniel

Generated Image Alt-Text
[edited by: Trados AI at 11:37 AM (GMT 0) on 29 Feb 2024]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 MARIA-TERESA ALVAREZ-BENITO over 4 years ago in reply to Daniel Hug

The Glossary Converter does not work. Here is what it says:

El archivo de la plantilla debe ser una base terminológica sdltb o un archivo de definición xdt.

Source: GlossaryConverter
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.TryToResolveFromTemplate(List`1 fields)
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.TryToResolveFields(List`1 fields, IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.ResolveFields(List`1& fields, IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Filters.ExcelReader.GetFields(IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Core.FieldReader.Read(List`1 inputFilters, List`1 inputPaths)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.Converter.Convert(List`1 inputFilters, List`1 inputPaths, IFilter outputFilter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.HandleMultipleFiles(List`1 files)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.ProcessFiles(List`1 files)
Program version 6.0.7588.22667

Windows version: Windows 10, Build 18363, 64 bit (Spanish (Spain, International Sort))

.net versions:
Client 4.8.03752
Full 4.8.03752
Client 4.0.0.0

Libre/OpenOffice version:

MultiTerm version: MultiTerm 15.0.0.0

22/01/2021 19:06 Could not find LibreOffice.CalcDocument\CurVer in registry
22/01/2021 19:06 Could not find opendocument.CalcDocument\CurVer in registry

<Settings version="3">
<AlwaysShowFieldsDialog>false</AlwaysShowFieldsDialog>
<CheckForUpdates>true</CheckForUpdates>
<PlaySound>false</PlaySound>
<FastExcelMode>true</FastExcelMode>
<ExcelTags>true</ExcelTags>
<ExcelRawMode>false</ExcelRawMode>
<DefineTermbaseOutputFormat>true</DefineTermbaseOutputFormat>
<MergeFiles>false</MergeFiles>
<UseTermbaseTemplate>true</UseTermbaseTemplate>
<UseMasterTermbase>false</UseMasterTermbase>
<MergeLanguages>false</MergeLanguages>
<MergeSubLanguages>false</MergeSubLanguages>
<MergeEntryNumber>false</MergeEntryNumber>
<MasterTermbase></MasterTermbase>
<MergeField></MergeField>
<TermbaseTemplate>C:\Users\Maite\Desktop\TM TEST.xlsx</TermbaseTemplate>
<Synonyms>
<Type>OneLine</Type>
<Column></Column>
<Repeat>false</Repeat>
<Separator>|</Separator>
</Synonyms>
<DefaultGlossaryFormat>Translation Memory eXchange</DefaultGlossaryFormat>
<UiLocale>es</UiLocale>
<UiTheme>Default</UiTheme>
<SettingsTab>0</SettingsTab>
<EmptyOutput>false</EmptyOutput>
<IgnoreUnknownFields>false</IgnoreUnknownFields>
<CreateEmptyFields>false</CreateEmptyFields>
<WriteDocType>false</WriteDocType>
<LargeFileExcelMode>false</LargeFileExcelMode>
<MultiFieldMode>ignore</MultiFieldMode>
<CreationUser>glossaryconverter</CreationUser>
<TbCopyright></TbCopyright>
<TbDescription></TbDescription>
<UseContentFilter>false</UseContentFilter>
<RegexContentFilter>false</RegexContentFilter>
<ContentFilterText></ContentFilterText>
<Tbx>
<Dialect>Core</Dialect>
<ResolveNote>false</ResolveNote>
<MappingFile></MappingFile>
<UseMappingFile>false</UseMappingFile>
</Tbx>
</Settings>

dentro: C:\Users\Maite\Desktop\tm test.xlsx
fuera: C:\Users\Maite\Desktop\tm test.tmx

Inicio de conversión: 22/01/2021 19:06:12
**** Hubo un error al crear el archivo de salida.
System.Exception: El archivo de la plantilla debe ser una base terminológica sdltb o un archivo de definición xdt.
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.TryToResolveFromTemplate(List`1 fields)
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.TryToResolveFields(List`1 fields, IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.ResolveFields(List`1& fields, IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Filters.ExcelReader.GetFields(IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Core.FieldReader.Read(List`1 inputFilters, List`1 inputPaths)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.Converter.Convert(List`1 inputFilters, List`1 inputPaths, IFilter outputFilter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.HandleMultipleFiles(List`1 files)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.ProcessFiles(List`1 files)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate

Reply

0 MARIA-TERESA ALVAREZ-BENITO over 4 years ago in reply to Daniel Hug

The Glossary Converter does not work. Here is what it says:

El archivo de la plantilla debe ser una base terminológica sdltb o un archivo de definición xdt.

Source: GlossaryConverter
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.TryToResolveFromTemplate(List`1 fields)
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.TryToResolveFields(List`1 fields, IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.ResolveFields(List`1& fields, IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Filters.ExcelReader.GetFields(IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Core.FieldReader.Read(List`1 inputFilters, List`1 inputPaths)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.Converter.Convert(List`1 inputFilters, List`1 inputPaths, IFilter outputFilter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.HandleMultipleFiles(List`1 files)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.ProcessFiles(List`1 files)
Program version 6.0.7588.22667

Windows version: Windows 10, Build 18363, 64 bit (Spanish (Spain, International Sort))

.net versions:
Client 4.8.03752
Full 4.8.03752
Client 4.0.0.0

Libre/OpenOffice version:

MultiTerm version: MultiTerm 15.0.0.0

22/01/2021 19:06 Could not find LibreOffice.CalcDocument\CurVer in registry
22/01/2021 19:06 Could not find opendocument.CalcDocument\CurVer in registry

<Settings version="3">
<AlwaysShowFieldsDialog>false</AlwaysShowFieldsDialog>
<CheckForUpdates>true</CheckForUpdates>
<PlaySound>false</PlaySound>
<FastExcelMode>true</FastExcelMode>
<ExcelTags>true</ExcelTags>
<ExcelRawMode>false</ExcelRawMode>
<DefineTermbaseOutputFormat>true</DefineTermbaseOutputFormat>
<MergeFiles>false</MergeFiles>
<UseTermbaseTemplate>true</UseTermbaseTemplate>
<UseMasterTermbase>false</UseMasterTermbase>
<MergeLanguages>false</MergeLanguages>
<MergeSubLanguages>false</MergeSubLanguages>
<MergeEntryNumber>false</MergeEntryNumber>
<MasterTermbase></MasterTermbase>
<MergeField></MergeField>
<TermbaseTemplate>C:\Users\Maite\Desktop\TM TEST.xlsx</TermbaseTemplate>
<Synonyms>
<Type>OneLine</Type>
<Column></Column>
<Repeat>false</Repeat>
<Separator>|</Separator>
</Synonyms>
<DefaultGlossaryFormat>Translation Memory eXchange</DefaultGlossaryFormat>
<UiLocale>es</UiLocale>
<UiTheme>Default</UiTheme>
<SettingsTab>0</SettingsTab>
<EmptyOutput>false</EmptyOutput>
<IgnoreUnknownFields>false</IgnoreUnknownFields>
<CreateEmptyFields>false</CreateEmptyFields>
<WriteDocType>false</WriteDocType>
<LargeFileExcelMode>false</LargeFileExcelMode>
<MultiFieldMode>ignore</MultiFieldMode>
<CreationUser>glossaryconverter</CreationUser>
<TbCopyright></TbCopyright>
<TbDescription></TbDescription>
<UseContentFilter>false</UseContentFilter>
<RegexContentFilter>false</RegexContentFilter>
<ContentFilterText></ContentFilterText>
<Tbx>
<Dialect>Core</Dialect>
<ResolveNote>false</ResolveNote>
<MappingFile></MappingFile>
<UseMappingFile>false</UseMappingFile>
</Tbx>
</Settings>

dentro: C:\Users\Maite\Desktop\tm test.xlsx
fuera: C:\Users\Maite\Desktop\tm test.tmx

Inicio de conversión: 22/01/2021 19:06:12
**** Hubo un error al crear el archivo de salida.
System.Exception: El archivo de la plantilla debe ser una base terminológica sdltb o un archivo de definición xdt.
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.TryToResolveFromTemplate(List`1 fields)
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.TryToResolveFields(List`1 fields, IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.FieldResolver.ResolveFields(List`1& fields, IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Filters.ExcelReader.GetFields(IFilter filter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Core.FieldReader.Read(List`1 inputFilters, List`1 inputPaths)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.Converter.Convert(List`1 inputFilters, List`1 inputPaths, IFilter outputFilter)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.HandleMultipleFiles(List`1 files)
en Sdl.MultiTerm.Tools.GlossaryConverter.Workflow.FileHandler.ProcessFiles(List`1 files)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate

Children

No Data

Trados Studio > 1. Trados Studio

Convert Excel to TM