Mass Change Data Company

ferithon

hi to all,
i have this problem.
i've imported all Comapny and all is DONE.
now i must to change in all companies a silgle field "parent_company" from "company1" to "company2"...
which is the PHP command that i must to use???

Tnx a lot...

ajb

Hi,

At first I suggest to make a database backup.

There is a tool in /admin tools where you can "Run a PHP command" - you should unlock this on your installation,
then you have to obtain current parent company id and the new id.

It depends if you want to store information in RecordBrowser's history about record modification or you don't want.

To store history call such code:



$old_parent_id = 3;

$new_parent_id = 5;

$rs = new RBO_RecordsetAccessor('company');

foreach($rs->get_records(array('parent_company' => $old_parent_id)) as $rec) {

   $rec->parent_company = $new_parent_id;

   $rec->save();

}

Or to just modify in DB - without history:



$old_parent_id = 3;

$new_parent_id = 5;

DB::Execute('UPDATE company_data_1 SET f_parent_company=%d WHERE f_parent_company=%d', array($new_parent_id, $old_parent_id));

Second solution will be a lot faster than first.

Regards,
Adam

ferithon

Perfect...another question...

if i wanna to use the second method to update the field "parent company" adding not 1 but 2,3 or 4 company...it's possible...
can i use this command?
$old_parent_id = 3;
$new_parent_id = 5 6 7 8;
DB::Execute('UPDATE company_data_1 SET f_parent_company=%d WHERE f_parent_company=%d', array($new_parent_id, $old_parent_id));

it' ok or i must to use special symbol??
$old_parent_id = 3;
$new_parent_id = 5, 6, 7, 8;
DB::Execute('UPDATE company_data_1 SET f_parent_company=%d WHERE f_parent_company=%d', array($new_parent_id, $old_parent_id));

or
$old_parent_id = 3;
$new_parent_id = 5 - 6 - 7 - 8;
DB::Execute('UPDATE company_data_1 SET f_parent_company=%d WHERE f_parent_company=%d', array($new_parent_id, $old_parent_id));

Tnx a lot for your help

ajb

At first your parent company has to be a multiselect field. By default Parent company is a single selection field!!
Multiselect is stored in database as a string (not integer) so you have to change the field type using Administrator UI.

Then you have to edit SQL and change %d to %s, then encode multiselect value.

When you'll change the field type, all values will be converted to the format used by multiselect.



$old_parent_id = Utils_RecordBrowserCommon::encode_multi(3);

$new_parent_id = Utils_RecordBrowserCommon::encode_multi(array(5,6,7,8));

DB::Execute('UPDATE company_data_1 SET f_parent_company=%s WHERE f_parent_company=%s', array($new_parent_id, $old_parent_id));

Regards,
Adam

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge