CiviCRM Community Forums (archive)

Hi ,

        As I mentioned, I am taking step by step knowing CRM. I have successfully imported users, events. But I think I missed something while creating relationship.
         My contact table got contact ids from two range due to deletion or table autoincrement set while taking export. It is
         contact ids happens to be 1-120 , and the next contact id starts from 740 to 52000 . Relationships are also fine in user tables. To create relation while importing users I have used the API function.
         Now, I tried to create a relation between event and event manager using same logic. It creates with type id set to event_manager_relationship_type_id but I find it not creating relation for any events whose event id happens to be in the range 120 - 740. This seems some thing reference to contact table. Am I missing sth that I got to build relation between event and event coordinators? OR it is not possible to build relation between event and a contact.

sample Code fragment i used to create user relationship. I just modified the same logic with contact_id_a to be of event_id and relationship_type_id mapped to RoleManger id.

                              $params_a = array(
                    'contact_id' => $crm_contact_id,
                    );
                    $params_b = array(
                    'contact_id' => $crm_parent_id,
                    );
                    require_once 'api/v2/Relationship.php';

                    $result = & civicrm_contact_relationship_get( $params_a, $params_b );
    foreach($result as $k=>$entries){
  //foreach($entries as $entry){
    $params_rel = array(
    'id'=> $k
    );
$resultdel = & civicrm_relationship_delete( $params_rel );
    // }
    }
    var_dump($result);
                   
      $params_rel = array(
                    'contact_id_a'             => $crm_contact_id,
                    'contact_id_b'             => $crm_parent_id,
                    'relationship_type_id'     => 1,
              'start_date'               => (isset($date)? $date : $today),//$today,
              //'end_date'               => ,//$today,      
                    'is_active'                => 1
                  );
require_once 'api/v2/Relationship.php';
                $relate = & civicrm_relationship_create( $params_rel );
        if( civicrm_error( $relate)) {
          $errors[$i] = "Error building relationship with : ".$crm_contact_id." to contact : "
            .$res_Set_crm['parent_id']." : ". $relate['error_message'];
        if($cronSettings->browserOn){
    $msg = 'Error: building Relationship ..';
    echo '<p class="good">'.$msg.'</p>';
    }


         

Thanks in advance for the pointer suggestions

Regards

Saffron

Hi Yashodha ,

                      Thanks for your patience , consideration, & reply. Your reply helped me understand some basics with relationship and participants.

Regards,

Saffrongeek