CiviCRM Community Forums (archive)

Hello,

I've written this hook to be run when saving custom data on an organisation (context here: http://wiki.civicrm.org/confluence/pages/viewpage.action?pageId=1880885).

I now want to apply it retrospectively to all organisations.  Is there a way I can loop through and edit all organisations and thus invoke this hook for them all? Or another way I can update all my contact records based on this?

Thanks,
Michael

function cavsa_custom_data_civicrm_custom( $op, $groupID, $entityID, &$params ) {

// If we are custom data from custom data group 1, i.e. a contact record

if ( $groupID==1 && ( $op=='edit' || $op=='add' )) {

// Define some variables

$tableName='civicrm_value_areas_of_work_and_service_provis_1';
$columnName='summary_30';

// The foreach below creates an array that is based on the column name minus the last number.
// This array is used to populate the summary checkbox data.
//
// NOTE: This code assumes that you have named the values of the summary data after the column
// names in the custom data group, trimed to 31 characters
//
// You could alternatively use an array to translate these values.

foreach($params as $param) { //
if($param['custom_group_id']== 1 and $param['value']!= NULL ) {
$summaryData[]=substr($param['column_name'], 0,31);
// $summaryData values have to be trimmed to max. length of option value
}
}

// Format the value in the CiviCRM way.  Is there a better CiviCRM function for this?
$summaryData=CRM_Core_DAO::VALUE_SEPARATOR.implode(CRM_Core_DAO::VALUE_SEPARATOR, $summaryData).CRM_Core_DAO::VALUE_SEPARATOR;

//Insert the data into the custom data table
$sql = "

UPDATE $tableName
SET $columnName = '$summaryData'
WHERE entity_id = $entityID

";

CRM_Core_DAO::executeQuery( $sql, CRM_Core_DAO::$_nullArray );

}
}