Export to Excel German mutated vowel (Umlaut)

[tb2603]

when exporting data from a subfile grid to Excel the German vowels are not transferred correctly:
Allemann Beata u. Jörg --> Allemann Beata u. Jörg
Burchietti u. Jäggin Valentina --> Burchietti u. Jäggin Valentina
Mühlefeldstrasse 48 --> Mühlefeldstrasse 48

DefaultNetCCSID in httpd.conf = 1208

[David]

I believe this problem is caused by Excel, rather than Profound UI.

Profound UI will correctly handle the German vowels. It also detects when to use the semi-color (;) versus comma (,) separator.

Howerver, Excel can have issues in opening the file, even with the correct data. See the attached file for an example.

The file contains some German vowels, encoded properly in Unicode UTF-8. If you open the file with a text editor like NotePad, you should see the correct characters.

But, opening in Excel will produce bad output.

This is a limitation of Excel/CSV. CSV format does not allow for any meta data or special encoding of characters in the file.

It should, though, pickup on the install language and interpret the characters accordingly. I believe we have some German Excel users who are opening CSV from Profound UI with no trouble.

What version of Excel are you using?

[tb2603]

I'm using Excel 2003. When I open the csv-file sent by you with Notepad the German vowels are presented correctly.
What can I do to get the correct presentation in Excel 2003?

[David]

I'm not exactly sure what controls this. I would imagine that if the Windows locale and Excel language are set to German, then Excel should figure it out.

Beyond that, the only thing I could recommend might be to replace the vowels with ae, oe, ue, etc, when they are displayed in an export capable grid.

If you were going to go this way, you'd probably also need to replace the ß.

I can also check with some other German users to see if they were able to get around this problem and how...

[tb2603]

could you please check with other German users how they could solve this. It would be very helpful for me and my customers.

[tb2603]

...could you send me a list of all German members (if possible) or could you inform them if they were interested to keep contact with me for exchanging ideas about PUI.

[David]

Actually, I checked this with another German user who reports the same problem -- the characters in the file are good, but Excel displays them improperly.

We are doing more research into this to see if there is any solution.