Segmentation rules foe Excel files with DeepL integration

Question

Hey!

I have been researching segmentation rules, but I didn't find a solution that works for my case. From what I have seen, the regular approach would be to do a segmentation rule within a new translation memory. However, I didn't find a way to use DeepL íntegration as well. Whenever I use the DeepL integration and a translation memory, DeepL gets an orange highlight in the list alongside an error message.

I have a client who sends over Excel files with several big cells containing HTML code. The lines would always start with < and end with >.

Now, I would love to load the project file in and having it separated by each paragraph. At the same time, it could also be automatically be translated using the DeepL integration, so I only have to fix issues from there. Not using a line break rule so far only ends me up getting the entire cell in one line and manually line breaking in the target takes way too long.

Since I don't know if you could use a TM with a segmentation rule and DeepL as a translation source for it to work out, I guess I will also need a new project template to make it work? The files are always rather extensive, so I would love to not having to translate it manually.

How do you set up the segmentation rule for <> lines apart from that setup?

Thanks!

Paul · Answer

Patrick Karban 
 You could use a segmentation rule alongside the use of DeepL. But based on the minimal explanation of what you are doing I think you might be better off just creating a parser rule in your embedded content rules for Excel. If you're not sure what I mean can you provide a small sample file (zip it and attach using the Insert menu below your reply) and I can show you.

Paul · Answer

Patrick Karban 
 Patrick Karban said: Would I do the segmentation rule by adding the translation memory alongside DeepL as the translation resource? 
 No. 
 Patrick Karban said: Also, what kind of information are you missing? The job is about employee training for new product lines. They supply me with their learning content in Excel, but every cell is associated to an ID their software uses. So I wouldn't be able to change the Excel file at all, or it would stop working for them. Can you explain what you mean if you are not talking about changing the Excel file? A parser rule for embedded content doesn't ring a bell. 
 I just wanted an example Excel file so I could have shown you exactly how to solve your specific problem. But fair enough... you can do it yourself. This article is 9-yrs old now but does explain the principle. Today it's somewhat better: 
 https://multifarious.filkin.com/2013/08/21/embedded_content_excel 
 If you get stuck provide a SMALL sample file. You can attach it to your reply by zipping it first.

Paul · Answer

Patrick Karban 
 I created a short video explaining why the article will help you out... I hope this helps:

Trados Studio > 1. Trados Studio

Segmentation rules foe Excel files with DeepL integration