Wrong Decimal separator in csv export in German environment

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
dieter
Experienced User
Posts: 122
Joined: Tue May 22, 2012 6:45 am
First Name: Dieter
Last Name: Schröder
Company Name: Ecclesia Holding GmbH
State / Province: Outside Canada/USA
Country: Germany
Contact:

Wrong Decimal separator in csv export in German environment

Post by dieter »

Hello,

we use the csv export option for grids. Unfortunately the numeric data is separated by a dot. Excel interprets this not correctly. Our German excel expects a comma as a decimal separator.
E.g.:
The export delivers: "3493.30"
But we need: "3493,30"

Is there a possibility to adjust the separator?

Thank you,
Dieter
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Wrong Decimal separator in csv export in German environment

Post by Scott Klement »

Here's some information about how you can control the separator:
http://www.profoundlogic.com/docs/displ ... +Separator
dieter
Experienced User
Posts: 122
Joined: Tue May 22, 2012 6:45 am
First Name: Dieter
Last Name: Schröder
Company Name: Ecclesia Holding GmbH
State / Province: Outside Canada/USA
Country: Germany
Contact:

Re: Wrong Decimal separator in csv export in German environment

Post by dieter »

Thank you Scott.
But i think there is a misunderstanding. I tried this by typing
pui["csv separator"] = ","; in my start.html.
But the effect is that the separator of the fields changes from semicolon to comma. The separator of the fields in the csv-file is not my problem. The problem is the decimal-separator of the numeric fields in the csv-file. (I don't know if "decimal-separator" is the correct term in English).

In my exported csv-files all fields are enclosed in quotation marks. Each field is separated from the next field by a semicolon. This is fine.

This is the actual export:
"FK 079185";"3493.30";"S"
"FK 079185";"3493.30";"H"

This should be the export:
"FK 079185";"3493,30";"S"
"FK 079185";"3493,30";"H"

Thanks,
Dieter
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Wrong Decimal separator in csv export in German environment

Post by Scott Klement »

I gave it a try and had the same results... the CSV export option is ignoring the job's decimal format. I'll see if I can fix it.
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Wrong Decimal separator in csv export in German environment

Post by Scott Klement »

This problem is now fixed on our development box, and the fix will be included in the next release of Profound UI.
dieter
Experienced User
Posts: 122
Joined: Tue May 22, 2012 6:45 am
First Name: Dieter
Last Name: Schröder
Company Name: Ecclesia Holding GmbH
State / Province: Outside Canada/USA
Country: Germany
Contact:

Re: Wrong Decimal separator in csv export in German environment

Post by dieter »

Thank you. We can wait for the next release.
Dieter
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest