Thank you very much for sharing your findings!
I'm a bit perplexed by step #2, but I guess it's an effective way to confirm that the game is intact.
Step 3 is what I would recommend to everyone: work on a "dirty" local copy, and then paste your translations on an otherwise 100% fresh zipfile. Why take any risks?
And indeed, the only tool I really tested is Excel. I'm confident LibreOffice can work just as well, but you may need to figure out some more stuff on your own.
Thanks again!
Viewing post in CSV loading issue
LibreOffice seems to automatically use "," as separator instead of tabs like the original file.
Even if you copy your translation into a freshly downloaded translation.csv and try to save that using the original format, LibreOffice still changes the separator automatically.
We noticed this discrepancy after looking at both files with Notepad++ as suggested before.
We are currently trying to save the file using tabs as separators but can't figure out how.
I would recommend using Excel (since all you need with that is a double-click on the file)
Otherwise tweak the saving options in LibreOffice and then compare the format with the original using notepad
Actually found the solution!
When working with LibreOffice it is mandatory to save the file with the "Save As..." option and, in the Save As dialogue, additionally activate the option "Edit filter settings".
After hitting "Save" it will ask you to confirm the file format. Hit "Use Text CSV Format" and in the next dialog you have to select the
Character set "UTF-16" (Character Set of the original file)
and [TAB] as field delimiter. Hit OK and .zip up the file.
Hi there!
Thank you SO MUCH for this fix, nothing was working for me and this actually did. However, when I try and test the game, I can't click anything, like the "play" or "language" buttons. Did you encounter anything similar?
Edit: while translating I changed the "Language: {0}" segment, as I thought there was a language code to enter. After changing it back to 0, everything works fine.