LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dhrobertson

Hi guys,

I have a number of excel files that are country specific.
a few are in their own local language.
For example the Greek file has all of its contents in Greek and the Israeli file is in Hebrew.
The Excel Acquisition node doesn't seem to be able to cope with these languages. It just seems to output as bunch of arrows
--> --> --> --> etc.etc.

How do I get around this? does anyone have any suggestions? Is this a lava thing or an OS thing?


thanks very much,

regards

douglas

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dhrobertson

looks like it is a Unicode/string thing..

if I bring it through as Unicode it works but converting to string causes the problems. I'll stick to Unicode then....

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mgajdosik

I encountered issue like this, even though it was not with Excel input... You need to be careful, that there are two settings of your encoding, one is in the BRE, if you go to Tools->Preferences->Advanced->Server and Execution, you will see at the bottom server code page settings, which can be modified...

Still if you modify this to handle your local language, it may run correctly, but when you try to open it in BRD viewer, then you will see weird symbols possibly there comes the other setting. so in brd viewer you need to go to Preferences->Set codepages and modify this setting as well, first setting is for column names and second one is for data.

This works a bit tricky, so be patient with finding correct settings for your data set.

Marek

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sahmed

I also came across this issue when using 6.1 server version and i found that the two changes mentioned above would not stick unless i also added a line into the ls_brain.prop (restart processes). The below thread is really helpful as to changes to be made:

http://community.lavastorm.com/threa...Import-problem