CiviCRM Community Forums (archive)

Hi,

I'm adding a custom field using the following code:
    $fieldParms = array(
                     'custom_group_id'  => $customGroupID,
                     'name'             => 'cerkle_uid',
                     'label'            => 'Cerkle UserID',
                     'data_type'        => 'Integer',
                     'html_type'        => 'Text',
                     'is_required'      => 0,
                     'weight'           => 4,
                     'is_active'        => 1,
                     'is_searchable'    => 1
                    );
    echo "<br>Adding custom field 'cerkle_uid' to the new custom group...<br>";
    echo "Using parms: ".print_r($fieldParms,true)."<br>";
    $customField = civicrm_custom_field_create($fieldParms);
    echo "Returned value: ".print_r($customField,true)."<BR>";

But I'm getting an error saying "Missing Required field :custom_group_id", even though I can see it's there because of the print_r($fieldParms), the full output from the above code is:

Adding custom field 'cerkle_uid' to the new custom group...
Using parms: Array ( [custom_group_id] => 5 [name] => cerkle_uid [label] => Cerkle UserID [data_type] => Integer [html_type] => Text [is_required] => 0 [weight] => 4 [is_active] => 1 [is_searchable] => 1 )
Returned value: Array ( [is_error] => 1 [error_message] => Missing Required field :custom_group_id )

If I place the group id into an array, in the manner suggested by the API docs: http://wiki.civicrm.org/confluence/display/CRMDOC/Object+Properties+and+Custom+Data+APIs#ObjectPropertiesandCustomDataAPIs-crmCreateCustomField
e.g. $customGroupId = array ('id' => 12);
Then I get a different error:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_custom_field`, CONSTRAINT `FK_civicrm_custom_field_custom_group_id` FOREIGN KEY (`custom_group_id`) REFERENCES `civicrm_custom_group` (`id`) ON DELETE CASCADE), 1452

Any suggestions?

Thanks, Dougall

Whoops my mistake ... now that i've read more thoroughly through api/v2/CustomGroups.php I see that the way in which parameters are passed to the civicrm_custom_field_create is different to the old crm_create_custom_group.

I am now placing my field parameters array inside a second array under the key "fieldParams" and this fixes it.

My revised code is:
  $fieldParams = array(
                     'custom_group_id'  => $customGroupID,
                     'name'             => 'cerkle_uid',
                     'label'            => 'Cerkle UserID',
                     'data_type'        => 'Integer',
                     'html_type'        => 'Text',
                     'is_required'      => 0,
                     'weight'           => 4,
                     'is_active'        => 1,
                     'is_searchable'    => 1
                    );
    echo "<br>Adding custom field 'cerkle_uid' to the new custom group...<br>";
    echo "Using params: ".print_r($fieldParams,true)."<br>";

    $params = array ("fieldParams" => $fieldParams);

    $customField = civicrm_custom_field_create($params);
    echo "Returned value: ".print_r($customField,true)."<BR>";


One thing I did notice however was that if the field params array is missing the field "label" then the error message says "Missing Required field :custom_group_id" rather than "Missing Required field :label" ... looks like i get to file an issue after all ... Dougall