cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

Hi I have a question about data export

CHASEONHO
18-Opal

Hi I have a question about data export

Hi i'm SeonHo

my problem was Excel format

I don't know why, when i export my data it was broken

and i binding this infoTable

is this because of typing in korean?

how do i fixed it?

thanks

3 REPLIES 3
cmorfin
19-Tanzanite
(To:CHASEONHO)

Hi SeonHo


Your problem could be related to the use of Korean characters indeed.

If possible it would be interesting to make a simple test with similar data but using only ascii characters to check the results.

Also given the characters are broken it is very important to ensure you have the parameter -Dfile.encoding=UTF-8 in the Tomcat JVM parameters.

See the Installation guide, search for UTF-8 and you will find the references depending on your OS.


Hope this helps

Kind regards

Christophe

Hi Christophe

First, I'm sorry I'm late.
Because I was on vacation from yesterday to today.
I've verified Tomcat's parameters as you know.
And I confirmed that it was ###.
I do not think this is a problem.
Or maybe I should change my parameters to something else.

Thank you for answer.

cmorfin
19-Tanzanite
(To:CHASEONHO)

Hi SeonHo


Could you clarify what do you mean by "And I confirmed that it was ###." ?

Also:

- which version of ThingWorx are you using ?

- on which OS is it running

- on Which OS is the client

- have you tried the same thing with only ASCII characters ?

Note that your issues is probably related to https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS255971 . This article does give some workaround to make it work in Excel, so it is probably worth reading through the different workarounds and try the one that work best for you.

Thanks

Christophe

Top Tags