Working effectively with localisation csv files ?

[Romulien]

Does anyone have a magic trick to work translations within CKII csv files ? :wacko:

Answers about csv questions seem to point to using a text editor like Notepad++.
But to be efficient I'd like to have some nice columns per language with word-wrap within cells, and as far as I know this isn't possible with Notepad++ ?
So I tried to open csv with OpenOffice Calc, managed the import, only to realize that the csv export breaks the file completely: Paradox format (x at end of line, empty line at the end) is not standard ! End line is removed, and x is either removed or an extra ; is added after depending on separator choices on import, ...

Did I miss something ?
Maybe I need some kind of script that adds back the x and the \n lol

 

[Athalcor]

Does anyone have a magic trick to work translations within CKII csv files ? :wacko:

Answers about csv questions seem to point to using a text editor like Notepad++.
But to be efficient I'd like to have some nice columns per language with word-wrap within cells, and as far as I know this isn't possible with Notepad++ ?
So I tried to open csv with OpenOffice Calc, managed the import, only to realize that the csv export breaks the file completely: Paradox format (x at end of line, empty line at the end) is not standard ! End line is removed, and x is either removed or an extra ; is added after depending on separator choices on import, ...

Did I miss something ?
Maybe I need some kind of script that adds back the x and the \n lol

I think you probably do not want to hear this, but Excel does the trick.

 

[Romulien]

Indeed I don't ! :laugh: But it made me try even harder, thanks !

The issue was coming from the number of ;;;;; on each lines to be different on few lines. :wacko:
Once this was fixed and the X aligned in same column, the blank line at the end of file was no more removed ...

Last thing is spellchecker language that is not configurable per column, so everything is redish, but 1 language at a time is OK.

I attached some screenshots (OpenOffice in French sorry), if it can help other modders...