Top Menu

Welcome, Guest

TOPIC: Trouble with decimal separator

Trouble with decimal separator 02 Feb 2016 13:44 #436

Hi!

Thanks for an great extension.

Unfortunately, we have trouble updating prices with decimals in the latest 2 releases.

If we attempt to write a decimal number with comma or stop signs, the auto sale price goes nuts.

In short, it is not possible for me to input decimals as the systems neither likes comma nor stop sign separators. When an override is involved, it gets even more difficult.

I made this video to illustrate: https://sendvid.com/9hg4vr7p

cheers,
prokop
The administrator has disabled public write access.

Trouble with decimal separator 02 Feb 2016 18:22 #437

HI,

open wooc.php file , find this line:

$_num_sample = (1/2).'';

and replace it with :

$_num_sample = '0.0';
The administrator has disabled public write access.

Trouble with decimal separator 05 Feb 2016 12:13 #439

Hi!

I have no "wooc.php" on my system. I run Virtuemart. Could you provide me a similar fix for VM ?

cheers
The administrator has disabled public write access.

Trouble with decimal separator 05 Feb 2016 13:14 #440

Did you maybe activated German numbers option ? If yes turn it off.

If that is ok look for function:

function Getfloat($str) {
global $SETTINGS;
if($SETTINGS->german_numbers){
if(strstr($str, ".")) {
$str = str_replace(".", "", $str); // replace ',' with '.'
}
$str = str_replace(",", ".", $str);
}else{
if(strstr($str, ",")) {
$str = str_replace(",", "", $str); // replace ',' with '.'
}
}
return floatval($str);
};


modify it like this:

function Getfloat($str) {

return floatval($str);
};
The administrator has disabled public write access.

Trouble with decimal separator 15 Feb 2016 13:15 #452

Hi!

I do not understand what German numbers are or where to find that setting. Is it Virtuemart configuration ?

I searched my way to find the code you mentioned in vmexcellikeinput.php. Upon changing the code, I messed around to see if VMLEM accepted decimals. The component then started to randomly change the price of the shown products. See this vid for example: video

It changed about 30 products before I terminated the page. I then needed the table reconstructed from backup.

So my question is, what are German numbers and what do you think of this behaviour by VMLEM ?
The administrator has disabled public write access.

Trouble with decimal separator 15 Feb 2016 20:02 #456

That is when you set decimal separator to comma.

What is your database collation ?
The administrator has disabled public write access.

Trouble with decimal separator 16 Feb 2016 09:19 #459

Hi!

Thanks for the quick answer.

We use the danish currency, which carries the comma separator. The same system is used by the majority of the non-english speaking world: wiki on decimals

Our database collation is "utf8 - default collation"

Can you comment on how to correct our problem? We cannot correct prices as the system freaks out when inserting comma decimals.

Cheers,
The administrator has disabled public write access.

Trouble with decimal separator 17 Feb 2016 13:43 #463

Hi,

note that decimal option counts only for import/export . After you telling me that you need this for online editing ?
The administrator has disabled public write access.
Time to create page: 0.043 seconds