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
Wrong Decimal separator in csv export in German environment
-
- 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:
-
- 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
Here's some information about how you can control the separator:
http://www.profoundlogic.com/docs/displ ... +Separator
http://www.profoundlogic.com/docs/displ ... +Separator
-
- 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
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
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
-
- 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
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.
-
- 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
This problem is now fixed on our development box, and the fix will be included in the next release of Profound UI.
-
- 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
Thank you. We can wait for the next release.
Dieter
Dieter
Who is online
Users browsing this forum: No registered users and 1 guest