CiviCRM Community Forums (archive)

Hello all,

I am trying to edit the drupal module "webform" so it adds data to the civiCRM sql tables.  For this I am using the api function civicrm_contact_add().  My problem is I don't know how to (include?) use API.

I have something like this in my "webform_submissions.inc" in my modules directory:
civicrm_initialize(true);
....
civicrm_contact_add($contactParams)
And get the error:

Fatal error: Call to undefined function civcrm_initialize() in /home/<stuff>/sites/all/modules/webform/webform_submissions.inc on line 44

Can anyone help?

Did you copy & paste this? If so you have a typo in civicrm_initialize

Fatal error: Call to undefined function civcrm_initialize() in /home/<stuff>/sites/all/modules/webform/webform_submissions.inc on line 44

This is what worked:

Edited include_path in php.ini.

then

civicrm_initialize(true);
require_once('api/v2/Contact.php);


I am searching for a way to create a contact record from web inquiries (contact us) page, do you really need to modify the php.ini file to do this? I like the use of the webform module idea.

mtkoan can you elaborate on what you did?

yes I tried that but then the 'message' is in the contact record and if the user submits a second 'contact us' form then it overwrites the previous message so the 1st message is lost. And the people who need to respond to the messages then have to go to the contact records to find them.

I've set up a content-type of 'inquiry' in drupal and a view that will list all inquiries and will sort by status, region and subject. Now I wonder if I can set up a rule with Rules, to run the civicrm_contact_add() each time an inquiry is submitted using the 'execute custom php' action.

This is the code I am trying to use in Rules as 'execute custom php' action

require_once($_SERVER['DOCUMENT_ROOT'].
'/sites/default/civicrm.settings.php');

/* Initialize CiviCRM so that API's can be used */
require_once ('$_SERVER['DOCUMENT_ROOT']./sites/all/modules/civicrm/CRM/Core/Config.php';
$config =& CRM_Core_Config::singleton( );

/* Load the required CiviCRM API's */
require_once('$_SERVER['DOCUMENT_ROOT']./sites/all/modules/civicrm/api/v2/Contact.php');

    $params = array(
                    'first_name'    => $node->field_fname[0]['value'],
                    'last_name'     => $node->field_lname[0]['value'],
                    'email'            => $node->field_contact_email[0]['value'],
                    'contact_type'  => 'Individual',
    'dupe_check'   => 'true',

                    );
    $contact =&civicrm_contact_add( $params );
    print_r($contact);


I've also tried it with the token values but either way it does not add the contact to civicrm, can any one point out what I'm doing wrong?

no message, no errors, seems like nothing happens

If anyone is interested I was able to use this code to insert a new contact record with the rules module, unfortunately there is no check for a duplicate match. I couldn't get the civicrm_contact_add() function to work so this is my plan B that works. I have a node type with cck name and address fields. Then I made a rule that activates on new node saved, this is in the 'execute custom php':

$firstname = $node->field_fname[0]['value'];
$lastname = $node->field_lname[0]['value'];
$email = $node->field_contact_email[0]['email'];
$city = $node->field_city[0]['value'];
$state = $node->field_state[0]['value'];
$postalcode = $node->field_zip[0]['value'];
if ($firstname && $lastname) {
   $sortname = $lastname.', '.$firstname;
}
else {
   $sortname = $email;
}

db_set_active('civicrm');
 
//insert name into civicrm
db_query("INSERT INTO civicrm_contact (first_name, last_name, sort_name, display_name, contact_type)
VALUES ('$firstname', '$lastname', '$sortname', '$firstname $lastname', 'Individual')");
$id = mysql_insert_id();

db_query("INSERT INTO civicrm_email (contact_id, email, is_primary) values ('$id', '$email', '1')");
db_query("INSERT INTO civicrm_address (contact_id, postal_code, city, is_primary, state_province_id) values ( '$id', '$postalcode', '$city','1', '$state')");

db_set_active('default');