Empty relationships created when importing contacts

[bwaindwain]

Importing contacts with a relationship (child of, spouse of... etc) always creates the 2nd contact, even if it's blank. For example, if the imported csv is:

Code: [Select]

Lastname, Firstname, Spouse of Lastname, Spouse of Firstname
Adams, Alex, Adams, Anne
Adams, Bert, ,
then CiviCRM import will create 4 contacts: Alex Adams will have a spouse Anne Adams, but Bert Adams will have spouse of <blank>.

Seems like CiviCRM import process should NOT create these empty relationships. I've tried putting "null" or "none" in the field, but it still creates the relationship.

[Donald Lobo]

agreed, this is definitely incorrect behavior and should be fixed

Would be great if you could fix the code to do the needful.

Most of the import code that creates the related contacts is in:
CRM/Import/Parser/Contact.php (search for relationship)

Please file an issue and hopefully a patch with it

lobo

[petednz]

isn't it pretty straightforward to just sort your csv so you only do the 'relationship' for those that have them? ie do 2 imports - one with relationships and one without?

[petednz]

ha - now i am laughin on other side of my face on this. 

Did an import but all i was importing was the External Ids of the two contacts ie the second contact was a 'xxx of' the first and both were matchin on Ext ID.

So what happens is if it doesn't find a matching Ext ID it creates a new contact and builds the relationship and we end up with a load of contacts with NO email and NO first or last names.

And no Error report.