Importing Chinese characters with translations.rb doesn't work

[Brecht_Summa]

When trying to import simplified Chinese characters using an excel sheet, the xml database doesn't receive any input. When renaming the English column to the Chinese identifier, it does import the text assets. Is this an issue in the translations.rb script?

When copying the Chinese text from within the excel sheet to TouchGFX Designer, the text does appear, but this is quite labour intensive

[Brecht_Summa]

Update: 

When importing an excel with the chosen language as only column, next to the English column, it does work if in the unsorted text resources, the wildcard values are copied first. It seems the script expects a language in the xml database to have all wildcards present before importing. 

My current solution is to create a new language by setting initial values to an existing language and creating different versions of my excel file with columns removed.

[Brecht_Summa]

Another update:

Languages to be imported have to placed starting in the second column at least and no languages that aren't imported can be in between

[Flemming Gram CHRISTENSEN]

Hello Brecht

Could you provide a small Excel file that does not work with the simplified Chinese texts. I would like to check what happens. We can definitely improve the error messages.

You can also take a look if you like ruby :) You have the source code.

Best Regards

[Brecht_Summa]

Hey Flemming Gram, 

I tried looking in the Ruby files, but didn't really find where the issue occurs. I provided a small sample excel sheet as example.

Thanks!

[Flemming Gram CHRISTENSEN]

Hi

Thanks. We will take a look.

Could you provide the texts.xml file also. The one you are trying to import in to.

Thanks!

[Brecht_Summa]

Hey,

Yes, I've cleared out the correct translations in the xml below.

[Brecht_Summa]

I've been busy creating a script to automate creation of wildcard ranges and characters when importing translations and looked further into the ruby files, and an issue I discovered is that newline characters "
" were present in texts.xml and were changed by the xml writer (touchgfx\framework\tools\textconvert\lib\xml_writer.rb) changes these to "&
", invalidating the xml file.

Perhaps this is a different issue, but I haven't been able to look into the original issue yet