search

MegaphoneJon / com.jlacey.electoral

Other
2 stars 3 forks source link

District Fields don't show up for Export #10

Open jimcrist opened 2 years ago

jimcrist commented 2 years ago

Selected some records and tried to export the District field and it doesn't show up in the drop down list?! Electoral Status shows up but not the District fields. I looked in Custom Data and the Electoral fields don't show up there. I went into Search Preferences and checked the Electoral fields for Quicksearch but that didn't help. I looked in the SQL table CIVICRM_CUSTOM_GROUP and they're marked as public. The District fields do show up in CiviReport however...

jmcclelland commented 2 years ago

Unfortunately, this is a limitation. The electoral extension uses custom contact fields with multiple values. That means, for each contact record, there are multiple rows of electoral info. The export system simply can't handle that - it needs just one row per contact.

One work around is to use the Search Kit extension - which allows you to group records by contact id - that will give you the option of listing all the records in a comma separate field.

jimcrist commented 2 years ago

Yes, the 'ol one to many relationship. Yes, Jon clued me into the Search Kit back in February. That did the trick...thanks!