Post by LocJAM日本語有志チーム in CSV loading issue

Viewing post in CSV loading issue

Hi, as clamm-san mentioned, some of us had the same issue but they seemed to solve it themselves. I would like to share the workarounds they tried for your reference.

-Download the official LocKit zip file.

-Upload that original zip file as-is.

-After you confirm the game properly displayed, unzip the zip file. Then, replace only translation.csv, and compress the folder. Once the folder is successfully compressed, upload it.

Also, one of the participants mentioned that they could not upload when they used LibreOffice but succeeded with notepad++. So maybe LibreOffice unexpectantly changes something in Japanese text.

gloc.team2 years ago

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!

Two Owls Translation2 years ago

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.

LocJAM2 years ago

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

Two Owls Translation2 years ago

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.

Elymnir2 years ago (1 edit)

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.

itch.io

Viewing post in CSV loading issue