1

On CiviContact we have a number of custom fields set up as multi-record sets. Any ideas on how these can be exported?

The import to a multi-record set is hidden on the main import page > tooltips pop up has a link at the end of the help notes which takes you to the import page. Is the export function similarly hidden...

Any help appreciated.

5

I don't know of any hidden export pages, but if you can talk the data into appearing in a report then you can export as CSV from there. We've created a few custom reports to allow this on our multi-record custom data.

| improve this answer | |
  • 1
    Thank you Andrew! Yes I was having a brain dead day - reporting solves the non-export option fro multi record sets. Thank you – Catherine Jan 21 '16 at 10:57
  • 1
    Note that you have to use Contact Summary report and not Contact Detail report - the latter does not have a CSV export option – Mick Kahn Jul 17 '19 at 22:33
  • 1
    Warning! Depending on the report, it may not display all the records in the multi record set — it may choose one, arbitrarily, for each contact. For example, the Flexible Contact Report included with Fuzion's Extended Reports extension can handle multi-record custom fields, but make sure you set your filters so that the one record displayed on each line is the one you want. Or choose "group by Contact ID" so they'll be concatenated. – Noah Miller Sep 18 '19 at 22:07
  • Andrew - are you able to share an example of custom reports with multi-record custom data? – Jon G - Megaphone Tech Jun 11 at 18:14
  • Sure: gist.github.com/bhahumanists/98a6a154a394f008a86fec55d855f3ae. I don't know how compliant it is with best practices these days – Andrew West Jun 18 at 12:20
3

There’s a custom search available called ‘Custom Group Multiple Values Listing’ that allows you to search and export multi value fields –

Search > Custom Searches > Custom Group Multiple Values Listing

| improve this answer | |

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.