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.
the csv I need to produce -
the code for the existing custom search([url removed, login to view])
4 civicrm tables: civicrm_custom_field, civicrm_custom_group, and civicrm_option_group
I also attach another custom search which displays custom fields (I need HACC client and Hacc carer)
The search I need is contribution aggregate by type (multi select) for a given date range.
the result needs to be all the custom fields from group ids 19 and 20 plus the aggregate hours into column 40.
4 freelancers are bidding on average $144 for this job
Hello, We are freelance software developers. If you contact us, we can give a quote for your project and we can discuss the details. w w w . s o l v e r . i o