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

Parents Reply Children
  • Paul & Daniel: thanks for pointing this out Slight smile

    Somehow I prefer not so automated solutions, but this is certainly an error. The Olifant is indeed quite tricky. The good about Olifant: you can edit the TMX. But TBH you can edit the Excel upfront, so GC is certainly the best here.

    _________________________________________________________

    When asking for help here, please be as accurate as possible. Please always remember to give the exact version of product used and all possible error messages received. The better you describe your problem, the better help you will get.

    Want to learn more about Trados Studio? Visit the Community Hub. Have a good idea to make Trados Studio better? Publish it here.

  • 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)

  • I downloaded Glossary Converter, but I don’t see anything like the second screenshot, certainly no SDLTM output option. What went wrong?

    emoji
  •  

    Go to Settings and chose Default Output:

    Trados Studio settings window showing Formats section with Default Output dropdown menu set to 'Excel 2007 Workbook'. Options to Add, Delete, Load, Save, Reset, Help, and OK are visible.

    _________________________________________________________

    When asking for help here, please be as accurate as possible. Please always remember to give the exact version of product used and all possible error messages received. The better you describe your problem, the better help you will get.

    Want to learn more about Trados Studio? Visit the Community Hub. Have a good idea to make Trados Studio better? Publish it here.

    emoji


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