UnityText .csv File Packing Problem [PC Building Simulator]

How to translate the files of a game
yusuf0808
Posts: 41
Joined: Thu Jun 29, 2017 10:46 am

UnityText .csv File Packing Problem [PC Building Simulator]

Post by yusuf0808 »

Hey everyone, I am trying to translate PC Building Simulator. I successfully exported the text from resources_00001.-9 file. But when I try to import the text it gives an error:

Image

And when I looked at the file. I saw that the Russian characters were changed to question marks. So my conclusion was Excel is not saving it with right encoding. So I'm asking all of you, what should I do?

This is the original exported csv file: https://drive.google.com/open?id=1Aftbj ... huyy_0xPev

This is the edited csv file: https://drive.google.com/open?id=1UFsxZ ... WsjNzAUBOT

This is the resources_00001.-9 file: https://drive.google.com/open?id=1NLiOJ ... CGj4HIcvp3
yusuf0808
Posts: 41
Joined: Thu Jun 29, 2017 10:46 am

Re: UnityText .csv File Packing Problem

Post by yusuf0808 »

Can no one help me?
MerlinSVK
Posts: 165
Joined: Wed Aug 13, 2014 10:00 am

Re: UnityText .csv File Packing Problem

Post by MerlinSVK »

Encoding is wrong as you already figured it out, so from Excel try to save it with another encoding. There should be UTF-8 CSV option.
But UTF-8 is not the correct encoding either. Original CSV has UTF-16 Little Endian (sometimes called UCS-2).

So try save it as UTF-8, then open it in Notepad++, convert encoding to UCS-2, save it and then try to import it.

PS: I didn't test it, it just a theory.
yusuf0808
Posts: 41
Joined: Thu Jun 29, 2017 10:46 am

Re: UnityText .csv File Packing Problem

Post by yusuf0808 »

MerlinSVK wrote:Encoding is wrong as you already figured it out, so from Excel try to save it with another encoding. There should be UTF-8 CSV option.
But UTF-8 is not the correct encoding either. Original CSV has UTF-16 Little Endian (sometimes called UCS-2).

So try save it as UTF-8, then open it in Notepad++, convert encoding to UCS-2, save it and then try to import it.

PS: I didn't test it, it just a theory.


Thank you for your help. But we used the old copy paste method to solve this. :D

I am going to try this next time though.
MerlinSVK
Posts: 165
Joined: Wed Aug 13, 2014 10:00 am

Re: UnityText .csv File Packing Problem

Post by MerlinSVK »

Well, that's also a way... :D