Migrate data from old richtext widget (before 3.8) to the HTML one

Support Developer
1

Is there a migration path documented somewhere for migrating text data to be supported in the new HTML richtext widget?

I am referring to this change: Issue 4962: Use valid HTML as richtext format - Tryton issue tracker

My current text data looks like

<p align=\'left\'>Hello World</p>

I can easily convert this by replacing <p> and \n to <div> and <br>, and so on for other things as well. But, the issue is that the client always thinks that the data was modified and it wants us to save data each time we open the record because it’s not normalised in the format that client expects it.

2

Normalizing the data with the same function as the client should fix the issue.

3

The normalize function doesn’t handle all the cases. Like I’ve described <p> and \n are not properly formatted and it renders the text in a very different format from the original format.
In my testing I saw that it removes all the tags it doesn’t support like <p>, <span> and encloses everything in a single div. While the correct output would be if it would replace \n\n with a <br>, convert all <p> to <div> and \n with empty string and only after that I can run normalize which would let tryton client know that the record is not in a dirty state.
If there’s no official way of doing this then I’ll just pick the normalize function from tryton client and write a python script to update all the records.

4

There is none because richtext field is for different usage than html.

5

For me this sounds like the more reasonable way to perform such task

6

and/or if you have any specific/special cases just write a proteus script with some regex to fix (the rest)