Excel XML map problem with Greek characters.

[Former Member]

Hi,

I created a dashboard with XML map connetion. My embeded spreadsheet is linked to an xml file which contains my TOP 50 Customers.

Customers names are in Greek so my xml Header is like:

<?xml version="1.0" encoding="ISO-8859-7"?>

ISO-8859-7 is the Greek encoding for xml.

After embeding the spreadsheet into the dashboard i add a list component to present my TOP 50 Customers.

So far so good.

Then i add a refresh conection button to update my TOP 50 list. In preview mode everythinng works fine. But when i try to update my data by clicking the refresh button my list is updated but the customers names is turned to unidentified characters.

Is there any encoding problem or this is Xcelsius issue?

I use Xcelsius 2008 sp3 fp 3.2

[Former Member · Accepted solution]

Despite the header (i.e. ISO notification in the xml tag), make sure the file itself (the XML) is saved in a correct format. I suggest using UTF-8 for the file.

[Former Member · Accepted solution]

I thing if there was any problem with the xml file format i would not be able to map it in the Excel spreadsheet.

On the other hand, if i set xml encoding utf-8, MS Excel does not display correctly Greek characters.

My xml files are CR2008 reports (with simple xml tags) which are exported as text files with .xml extension.

I thing the problem is in Xcelsius ability to read xml files with ISO-8859-7(Greek) encoding.

[Former Member · Accepted solution]

I am not sure if it has problems with that encoding. What I do know is that it handles UTF-8 fine. Similar problems were in [this thread|] and converting it all to UTF-8 worked.

N.B. UTF-8 should cover your ISO manpage, so should be fine to work with, no? Bit awkward as well that your Excel can't read the UTF-8 file. That surprises me.

[Former Member · Accepted solution]

You are right.

I opened the XML file with notepad and saved it with utf-8 encode, also changed the xml tag to <?xml version="1.0" encoding="UTF-8"?> and it worked fine.

I map it in Excel Spreadsheet without problems and after refreshing in Xcelsius the characters are diplayed normaly.

So, correct me if i am wrong, the problem is the file encoding, no the xml encoding.

Both, file and xml encoding should be UTF-8.

As i mentioned before my xml files are Crystal Report 2008 reports which are exported as text files with .xml extension, so i have to look for answers in other forum.

thank you