EPLAN DeepL: Projekt übersetzen
Es hat genau einen Tag gedauert, seit EPLAN Newtonsoft.Json unterstützt, bis mein grandioser Kollege Daniel ein Script für EPLAN gebastelt hat, dass die fehlenden Übersetzungen im Wörterbuch mit DeepL übersetzt.
Das Script exportiert erstmal alle fehlenden Übersetzungen im Projekt (Quellsprache Deutsch).
Frägt dann die pro Eintrag die DeepL API nach einer Übersetzung (English).
Die Ergebnisse werden dann in einer XML-Datei gespeichert und angezeigt.
Diese Datei kann dann ins Wörterbuch importiert werden.
Vorraussetzung ist ein API-Key, welcher in der Windows Variable DEEPL_API_KEY gespeichert ist.
Orginal-Script findet Ihr auf GitHub.
Vielen Dank Daniel 💖
using System.Diagnostics;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Newtonsoft.Json;
using System.Net.Http;
using System.Windows.Forms;
using System.Xml.Serialization;
using Eplan.EplApi.ApplicationFramework;
using Eplan.EplApi.Base;
using Eplan.EplApi.Scripting;
namespace TranslateWithDeepl
{
public class TranslateWithDeepl
{
private readonly string _apiKey;
private readonly string _url = "https://api-free.deepl.com/v2/translate";
private readonly HttpClient _httpClient;
[Start]
public async void Execute(ActionCallingContext context)
{
var missingTerms = GetMissingTerms();
await TranslateTerms(missingTerms);
}
private async Task TranslateTerms(EplanLanguageDbRoot missingTerms)
{
var requestDto = new RequestDto();
requestDto.TargetLang = "EN";
requestDto.Text = missingTerms.TextSection.MT.SelectMany(mt => mt.T).Where(t => t.Lang == "de_DE").Select(t => t.Text).ToArray();
var translate = await Translate(requestDto);
for(int i = 0; i < missingTerms.TextSection.MT.Length; i++)
{
missingTerms.TextSection.MT[i].T.First(t => t.Lang == "en_US").Text = translate.Translations[i].Text;
}
var projectDoc = PathMap.SubstitutePath("$(DOC)");
var fileName = Path.Combine(projectDoc, "TranslatedTerms.xml");
var serializer = new XmlSerializer(typeof(EplanLanguageDbRoot));
using (var writer = new StreamWriter(fileName))
{
serializer.Serialize(writer, missingTerms);
}
Process.Start(fileName);
}
public EplanLanguageDbRoot GetMissingTerms()
{
var xmlFile = Path.GetTempFileName();
var context = new ActionCallingContext();
context.AddParameter("TYPE", "EXPORTMISSINGTRANSLATIONS");
context.AddParameter("LANGUAGE", "en_US");
context.AddParameter("EXPORTFILE", xmlFile);
context.AddParameter("CONVERTER", "XTrLanguageDbXmlConverterImpl");
new CommandLineInterpreter().Execute("translate", context);
var serializer = new XmlSerializer(typeof(EplanLanguageDbRoot));
EplanLanguageDbRoot eplanLanguageDbRoot = null;
using (var reader = new StreamReader(xmlFile))
{
eplanLanguageDbRoot = (EplanLanguageDbRoot)serializer.Deserialize(reader);
}
return eplanLanguageDbRoot;
}
public TranslateWithDeepl()
{
// get api key from %DEEPL_API_KEY% environment variable
_apiKey = System.Environment.GetEnvironmentVariable("DEEPL_API_KEY");
_httpClient = new HttpClient();
}
private async Task<string> Translate(string text, string targetLang)
{
var translateDto = new RequestDto
{
Text = new string[] { text },
TargetLang = targetLang
};
ResponseDto responseDto = await Translate(translateDto);
return responseDto.Translations[0].Text;
}
private async Task<ResponseDto> Translate(RequestDto translateDto)
{
var json = JsonConvert.SerializeObject(translateDto);
var data = new StringContent(json, Encoding.UTF8, "application/json");
_httpClient.DefaultRequestHeaders.Add("Authorization", string.Format("DeepL-Auth-Key {0}", _apiKey));
var response = await _httpClient.PostAsync(_url, data);
var result = await response.Content.ReadAsStringAsync();
ResponseDto responseDto = JsonConvert.DeserializeObject<ResponseDto>(result);
return responseDto;
}
}
public class ResponseDto
{
[JsonProperty("translations")]
public TranslationDto[] Translations { get; set; }
}
public class TranslationDto
{
[JsonProperty("detected_source_language")]
public string DetectedSourceLanguage { get; set; }
[JsonProperty("text")]
public string Text { get; set; }
}
public class RequestDto
{
[JsonProperty("text")]
public string[] Text { get; set; }
[JsonProperty("target_lang")]
public string TargetLang { get; set; }
}
[XmlRoot(ElementName = "EplanLanguageDbRoot")]
public class EplanLanguageDbRoot
{
[XmlAttribute(AttributeName = "Languages")]
public string Languages { get; set; }
[XmlAttribute(AttributeName = "numTexts")]
public int NumTexts { get; set; }
[XmlAttribute(AttributeName = "numTerms")]
public int NumTerms { get; set; }
[XmlAttribute(AttributeName = "numNonTranslate")]
public int NumNonTranslate { get; set; }
[XmlElement(ElementName = "TextSection")]
public TextSection TextSection { get; set; }
}
public class TextSection
{
[XmlElement(ElementName = "MT")]
public MT[] MT { get; set; }
}
public class MT
{
[XmlElement(ElementName = "T")]
public T[] T { get; set; }
}
public class T
{
[XmlAttribute(AttributeName = "xml:lang")]
public string Lang { get; set; }
[XmlText]
public string Text { get; set; }
}
}
