ZenHAX

Free Game Research Forum | Official QuickBMS support | twitter @zenhax | SSL HTTPS://zenhax.com
It is currently Mon Sep 24, 2018 9:48 pm

All times are UTC




Post new topic  Reply to topic  [ 5 posts ] 
Author Message
PostPosted: Fri Aug 17, 2018 2:36 pm 

Joined: Thu Jun 29, 2017 10:46 am
Posts: 8
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


Top
   
PostPosted: Sat Aug 18, 2018 4:24 pm 

Joined: Thu Jun 29, 2017 10:46 am
Posts: 8
Can no one help me?


Top
   
PostPosted: Sun Aug 19, 2018 9:08 am 

Joined: Wed Aug 13, 2014 10:00 am
Posts: 147
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.


Top
   
PostPosted: Sun Aug 19, 2018 6:06 pm 

Joined: Thu Jun 29, 2017 10:46 am
Posts: 8
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.


Top
   
PostPosted: Sun Aug 19, 2018 6:39 pm 

Joined: Wed Aug 13, 2014 10:00 am
Posts: 147
Well, that's also a way... :D


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 5 posts ] 

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Powered by phpBB® Forum Software © phpBB Limited