Mass update error with decimal and currency fields

[kinshibuya]

Hi there,

im using 5.2 CE and im having an error with massupdate.
My default decimal separator is: ,
and thousand separator is: .
so my currency or float fields are displayed like this: 3.457,22

When i update records using mass update my fields are all wrong
i have 3.457.220.000,00 for currency (it adds 6 digits)
and 3.45.722,00 if it is a float field

is there a way to fix this or to disable massupdate for this module?

[kinshibuya]

Hi there,

so i solved this matter only for currency type, when we create a currency field it create as dbtype FLOAT(26,6), doing a little research i changed it to DOUBLE and it works for currency fields, but for Decimal fields im still having the mass update problem, any ideas?

[kinshibuya]

ok so i had to make a logic hook before save to correct this issue for now:

     function updateamount(&$bean, $event, $arguments){
        
        //value for massupdate
        if($_REQUEST['action'] == 'MassUpdate') { 
        $bean->valor= (float)$bean->fetched_row['valor'];

        }  
        
    } 
  

[digger72]

Hi, i have the same Problem with the MassUpdate.
Please can you tell me where you have placed the hook and the file from where this function is called?

Big Thanks
Frank

[kinshibuya]

Hi there,

so the file that calls the function is on

sugarcrm/custom/modules/<MyModule>/logic_hooks,php

 <?php
 $hook_version = 1; 
$hook_array = Array(); 
// position, file, function 
$hook_array['before_save'][] = Array(1,'currencymassupdate', 'modules/<MyModule>/<MyModule>LogicHook.php','<MyModule>LogicHook', 'currencymassupdate'); 



?>  

and the function on the file sugarcrm/modules/<MyModule>/<MyModule>LogicHook.php

 
<?php

 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); 

class <MyModule>LogicHook {

function currencymassupdate(&$bean, $event, $arguments){
    
           //currency fields for mass update
        if($_REQUEST['action'] == 'MassUpdate') { 
                $bean->valorlancamento = (float)$bean->fetched_row['valorlancamento'];
        }  
        
    }

}  

you should replace <MyModule> for your module's name. In this case valorlancamento is the name of the field i need to update

[ifv]

I was having similar problems with locale settings (decimal and thousands separators), and, by adding the following on to vardefs.php, I managed to fix the problem:

     'disable_num_format' => true, 
  

Resulting in

 [...]
  'amount' =>
  array (
    'name' => 'amount',
    'vname' => 'LBL_AMOUNT',
    'disable_num_format' => true,   
    'type' => 'currency',
    'dbType' => 'double',
   )
[...]