CiviCRM Community Forums (archive)

I upgraded my civicrm from 3.0.2 to 3.2.2, but im still not getting custom data fields using contact API in module.

civicrm_initialize(TRUE);
require_once "api/v2/Contact.php";
$params = array('id'   => 15547,
         'return.custom_6'   => 1,
                  );
$contacts = civicrm_contact_search( $params );

I tried civicrm_contact_get( $params ); but its not working.

I use another function to retrieve custom data, CRM_Core_BAO_CustomValueTable::getValues. The contact_get should work, but I had problems as well. It needs a thorough check-up, which I have planned for the end of this month. Try this?

$civipar = array(
                 "entityID" =>  $retrieved['contact_id'],
                 "custom_4" =>  1,
                 "custom_5" =>  1,
                 "custom_6" =>  1,
                 "custom_7" =>  1);
             $civires = CRM_Core_BAO_CustomValueTable::getValues($civipar);

Hey! now i want to update the organization custom data in a module... but its inserting a new row in custom table instead of updating..

$params = array('entityID'      => $eid,
         'custom_6'       => $helpline_no,
         'custom_9'       => $helpline_name,
         'custom_10'      => $sel_provider_list,
         'custom_12'      => $sel_rated_list
      );
$contact = CRM_Core_BAO_CustomValueTable::setValues($params);

$eid is exists in custom value table & custom group is not a multi-record custom group.

I went through the code in file CRM/Core/CustomValueTable.php, setValues() function calls self::create( $cvParams )

In my case, in create() function 'id' is not exists in $field array, so it is inserting the new record.

 if ( array_key_exists( 'id', $field ) ) {
   $sqlOP = "UPDATE $tableName ";
   $where = " WHERE  id = %{$count}";
   $params[$count] = array( $field['id'], 'Integer' );
   $count++;
   $hookOP = 'edit';
 } else {
   $sqlOP = "INSERT INTO $tableName ";
   $where = null;
   $hookOP    = 'create';
 }