CiviCRM Community Forums (archive)

Hi,

A client needs to be able to export lists of activities and contact details, e.g.
ContactNameA, (client details), ActivityA1, (activity details)
ContactNameA, (client details), ActivityA2, (activity details)
ContactNameB, (client details), ActivityB1, (activity details)

They can get the relevant contacts via advanced search on activity history but cannot export the results in the required format because activity fields are not available for export. Understandably, as they aren't related 1:1 to contacts.

A search through the forums & mailing list suggests that this isn't implemented & that doing so would add unwelcome additional complexity to the export code. I see that we now have CiviReport/BIRT but the installation process looks a bit much to expect the client to do. We don't run a J2EE server. So I'm thinking my best bet is to write some custom code to generate a .csv file, and hook it up to the actions drop-down on the search results page. Is this the most sensible approach? Any tips or gotchas, or places to look for similar code that I can adapt?

Thanks,

Dave J

Thanks speleo for the suggestion. I'm not keen though to open up port 3306 to the outside world just for one client to perform one query.

Dave J