This topic was archived here:

https://web.archive.org/web/20230000000000fw_/https://www.zenhax.com/viewtopic.php?t=8372

yusuf0808, posted Fri Aug 17, 2018 2:36 pm (37631)

---

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:



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, posted Sat Aug 18, 2018 4:24 pm (37646)

---

Can no one help me?

MerlinSVK, posted Sun Aug 19, 2018 9:08 am (37659)

---

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, posted Sun Aug 19, 2018 6:06 pm (37672)

---

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.

I am going to try this next time though.

MerlinSVK, posted Sun Aug 19, 2018 6:39 pm (37674)

---

Well, that's also a way...