number format with decimal point
Posted: Sun Aug 02, 2009 4:57 am
Hi,
my current import filters for the products database are reading German style decimal numbers and date formats from an XML or CSV.
I found that while the date is automatically formatted from "dd.mm.yy" to the MySQL format, my decimal numbers are cut off because the "," is not automatically converted to ".".
While it is very easy to convert this before importing the actual number, I wonder whether this should be handled automatically by some kind of locale setting. The date is automatically converted - who does it, Xataface or MySQL? Maybe the numbers conversion should be at the same place?
My users are also complaining that they have to enter "." instead of "," for numbers when using xataface forms. I know this can be changed by some type of field filters, but I'm not sure if this would be a clean solution to the general problem?
Bernd
my current import filters for the products database are reading German style decimal numbers and date formats from an XML or CSV.
I found that while the date is automatically formatted from "dd.mm.yy" to the MySQL format, my decimal numbers are cut off because the "," is not automatically converted to ".".
While it is very easy to convert this before importing the actual number, I wonder whether this should be handled automatically by some kind of locale setting. The date is automatically converted - who does it, Xataface or MySQL? Maybe the numbers conversion should be at the same place?
My users are also complaining that they have to enter "." instead of "," for numbers when using xataface forms. I know this can be changed by some type of field filters, but I'm not sure if this would be a clean solution to the general problem?
Bernd