When I export a list of contacts and I include data about their spouse, the spouse data is included for only one of the contacts. Like so:

Name Spouse Name City Sam Smith Linda Smith Tulsa Linda Smith Tulsa

I can't find anywhere that indicates this is proper behavior. Is it by design? Bug?

"Spouse of" fields in the export

  • Not clear what you mean. I see Sam and i see Linda. What is missing? Maybe add screenshots of your Export mapping
    – petednz - fuzion
    Commented Oct 22, 2018 at 18:45
  • I think the issue is that the row for Sam shows Linda, but the row for Linda does not show Sam. How are you doing the export? How are you recording spouse (eg as a relationship, a custom field ...)
    – Aidan
    Commented Oct 23, 2018 at 8:51
  • Yes, what Aidan said. I am recording it as a standard Civi relationship. I am doing a fairly standard Contacts export where I select fields, which include several "Spouse of" relationship fields. I'll see about including some screen shots. Commented Oct 23, 2018 at 15:13
  • can you explain why you need the rows for both ends of the relationship? If you have all the fields you need about Sam, and all the fields you need about his Spouse does it matter much? ie not sure if this is just awkward or actually preventing you do what you want. or is the issue more 'how can i do a search to only find those at end A rather than end B" (eg change B name 'spouse of' to 'spouse is' just so you can select only those at end A (this may sound goobledegook -if so let me know and i will expand in an Answer)
    – petednz - fuzion
    Commented Oct 23, 2018 at 19:30
  • Well, I'm finding what I need for my current use, but I guess I don't think that one needs a reason why the output should be what one would reasonably expect when exporting spouse data. If I export hundreds of contacts to a spreadsheet and then look at only one line, I would think that Sam Smith doesn't have a spouse; that is wrong information. More importantly, if my export includes Sam Smith but not Linda, Sam's spouse data isn't in my exported data set at all. (This same behavior applies to "Friend of" relationships and presumably others where A>B and B>A language is the same.) Commented Oct 24, 2018 at 14:37


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.