Create a custom search OR modify / create a custom report to produce a csv file to specifications.
The attached csv is what I need to produce. It would be nice if you could include all the empty and zero columns (hidden from the user) but I can paste them into excel file later.
The report includes approx 37 custom fields.(group IDs 19 and 20) NB these fields are not searchable (not indexed) and therefore even if you expose them to a report (which I can do myself) they will not appear.
One field needs to be an aggregate of contributions for a given time period (like the existing custom search "contributions by aggregate" )
Also for any of the select fields (not the other fields) I need the values not the label eg 1 or 2 not yes or no.
For the above three reasons I think a custom search would be the way to go.
Attached is
the csv I need to produce -
the code for the existing custom search([login to view URL])
4 civicrm tables: civicrm_custom_field, civicrm_custom_group, and civicrm_option_group