1

I need your help. I need to disable a current relationship for 4000 records in the import process without using SQL command line.

There is no field for set active/inactive or expiry date of the current relationship in basic import process in CiviCRM.

Then I found this extension here https://civicrm.org/extensions/api-csv-import-gui,I've installed the extension and tried to inactive the current relationships. I used contact_id_a and contact_id_b and relationship_type id and set the is_active to 0 in csv file. But this extension gives me an error "Error with entity "create"! (Duplicate Relationship)". I'm going to update this relationship but this extension tries to create a relationship and fails because this relationship is already existed. Do you have any idea how to solve this?

Or do you have any other solution for this?

CiviCRM version is 5.13.5. And the relationship type is between two organization.

Edit: My requirement is:

Currently I have around 5000 records with a type of relationship in CiviCRM (organization to organization -one to many). Some of these records (relationship, name, email,...) have been updated in another system (A government system) and they gave the current list to me to update our current records in CiviCRM. I've updated contact details successfully but stuck in updating relationship, Because the CiviCRM basic import creates a new relationship not overwrite the existing one. If a relationship between 2 organization has changed in new file I need to disable the one that we have in civicrm and import the new one. So in future I know which records used to be in relationship but not any more. There is no option in CiviCRM import to do this (I couldn't find any). So I was thinking to find a way to disable the current one in CiviCRM and import new list. So if the relationship is no longer available in the new file, this has been disabled already in CiviCRM and if there is still a relationship between two records, it enables that again when I'm importing.

Thanks in advance

  • Hi, Welcome to SE! Do you have other records that need this relationship, or could you just disable that relationship type completely? – Aidan Jun 12 at 8:31
  • Hi Aidan, Thanks for replying. I need this relationship type in CiviCRM. I edited my question and add more description there about what I want to achieve here. Thanks – Mehrnoosh Jun 13 at 23:17
1

I used contact_id_a and contact_id_b and relationship_type id and set the is_active to 0 in csv file. But this extension gives me an error "Error with entity "create"! (Duplicate Relationship)".

Seems like you have relationship_type_id but not relationship id in the CSV file? If yes, I think you just need to add Relationship id to the columns.

The id is used by civicrm to update the records in the database instead of creating a new one.

Hence, try adding a new column in CSV and then proceed with the import.

  • Yes - where did the CSV come from? May need to do an export from Civi to get the relationship id's and match that up with the existing CSV – Aidan Jun 12 at 12:32
  • Hi Jitendra, Thanks for replying. where can I get the Relationship ID from CiviCRM? (I know they store in the database but I don't have access to back end).So I need to get them from front end, do you know if there is an option there? I couldn't get them from CiviCRM export data. – Mehrnoosh Jun 13 at 23:03
  • Hi Aiden, How Can I export the relationship id from civicrm? Thanks – Mehrnoosh Jun 13 at 23:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.