How to programmatically add Termbase to a project with optimal language mapping

Question

Dear All 
 When attaching a termbase to a project, the languages of the termbase needs to be mapped to the source- and targetlanguage of the project. Often the mapping is not perfect, so French (FR) has to be mapped to French Switzerland (fr-CH) or French France (fr-FR). 
 http://producthelp.sdl.com/SDK/ProjectAutomationApi/2017/html/7a0aa922-1aa2-4976-afd3-7637104f2def.htm 
 
 string [] termbaseIndex = { "English" , "German" , "French" };

Language projSourceLang = new Language(CultureInfo.GetCultureInfo( "en-US" ));
Language projTargetLang1 = new Language(CultureInfo.GetCultureInfo( "de-DE" ));
Language projTargetLang2 = new Language(CultureInfo.GetCultureInfo( "fr-FR" )); 
 
 Here they only show a simple example, where the language is hardcoded, however, i am interested in a general approach for an arbitrary termbase where the languages are extracted from the termbase. 
 The final touch would be to programmatically add the language to the termbase if it does not contain the project language parent, so if the sourcelanguage is de-CH and the termbase only has FR and IT then add DE. 
 Best Marco

Patrick Andrew Hartnett · Answer

Hi Marco Holzer It really depends on the type of terminology provider that you are working with, as you would need to create an instance of the provider to recover a list of available languages (or add them). If this is a Multiterm provider, then you would need to first open the *.sdltb file, and then recover the language indexes from the definition. You can reference Sdl.MultiTerm.TMO.Interop.dll to access the multiterm api Example : using MultitermApplication = Sdl.MultiTerm.TMO.Interop.Application; var multiterm = new MultitermApplication(); var repository = multiterm.LocalRepository; repository.Connect(string.Empty, string.Empty); var termbase = repository.Termbases[0]; var languageIndexes = termbase.Definition.Indexes; Having said that, you could potentially create an instance of the provider factory by recovering the extension point from the plugin manager. This might be advantageous in the sense that it is reusing the existing implementation of the GetLanguages() method (overridden from AbstractTerminologyProvider). However, I can only see this working if you are casting the provider to a known interface that allows you to access it in this way. I will demonstrate here how you could get access to the provider factory, in case this is useful for you. However, I have never tested this type of scenario, so can't guarantee how reliable this is... Also, keep in mind that this type of solution probably won’t work with the integrated multiterm provider, as you would need to cast the provider to IMultiTermTerminologyProvider to first open a connection, which is not possible seeing as this interface is located in Sdl.MultiTerm.Client; not a public API. var currentProject = GetProjectController().CurrentProject; if (currentProject == null) { return; } var termbaseConfiguration = currentProject.GetTermbaseConfiguration(); var termbaseConfigurationLanguages = termbaseConfiguration.LanguageIndexes; // identify the termbase/s you are working with; for this example, I reference the default tb var defaultTermbase = termbaseConfiguration.Termbases.FirstOrDefault(a => a.Enabled); if (defaultTermbase == null) { return; } // 1. the path associated with the provider var localPath = GetTermbasePath(defaultTermbase); if (string.IsNullOrEmpty(localPath)) { return; } // 2. get a list of the terminology factories from the plugin registry var extensionPoint = PluginManager.DefaultPluginRegistry.GetExtensionPoint(); if (extensionPoint == null) { return; } var providerLanguages = new List(); foreach (var extension in extensionPoint.Extensions) { // 3. identify if the provider is enabled if (!extension.Enabled) { continue; } // 4. idetnify if the extension a provider of interest to you // extension.ExtensionType == etc.. // extension.Plugin.Id == etc... // 5. create an instance of the providers factory var factory = (ITerminologyProviderFactory)extension.CreateInstance(); if (factory == null) { continue; } // 6. create an instance of the terminology provider var uri = new Uri("sdltb.file:///" + localPath); var credentials = new TerminologyProviderCredentialStore(); var provider = factory.CreateTerminologyProvider(uri, credentials); // 7. get a list of the languages from the AbstractTerminologyProvider implementation providerLanguages = provider.GetLanguages().ToList(); } // 8. check and assign the langauge index. foreach (var languageIndex in termbaseConfigurationLanguages) { // if the selected index is not assigned, then attempt to assign it automatically, given // that we already have a list of the termbase definition languages. if (string.IsNullOrEmpty(languageIndex.TermbaseIndex)) { var language = GuessLanguage(providerLanguages, languageIndex); if (language != null) { languageIndex.TermbaseIndex = language.Name; } } } // 9. update the configuration currentProject.UpdateTermbaseConfiguration(termbaseConfiguration); private static string GetTermbasePath(Termbase defaultTermbase) { var termbasePath = string.Empty; if (defaultTermbase is LocalTermbase termbase) { termbasePath = termbase.FilePath; } else { // if server based provider, then parse the Path value from the SettingsXML } return termbasePath; } private static ILanguage GuessLanguage(IEnumerable definitionLanguages, TermbaseLanguageIndex languageIndex) { foreach (var definitionLanguage in definitionLanguages) { if (definitionLanguage.Locale.Name == languageIndex.ProjectLanguage.CultureInfo.Name) { return definitionLanguage; } if (definitionLanguage.Locale.ThreeLetterISOLanguageName == languageIndex.ProjectLanguage.CultureInfo.ThreeLetterISOLanguageName) { return definitionLanguage; } if (definitionLanguage.Locale.TwoLetterISOLanguageName == languageIndex.ProjectLanguage.CultureInfo.TwoLetterISOLanguageName) { return definitionLanguage; } } return null; } private static ProjectsController GetProjectController() { return SdlTradosStudio.Application.GetController(); }

Trados Studio Developers > Studio Developers Q&A

How to programmatically add Termbase to a project with optimal language mapping

Top Replies