CiviCRM Community Forums (archive)

Definitely need to do this in a module which (very roughly) does the following:
- uses civicrm_contact_get api to retrieve all the contact ID's for your smart group
- retrieve the fields associated with your export map
- call functions from the Export BAO (CRM_Export_BAO_Export) - exportComponents does most of the work but you need to pass in the fields

Caveat - this is theoretical, might be some road-blocks. I do think it would be good to be able to do this, so if you hit issues jump on irc to discuss possible core improvements to make this possible.

Hi,

If you can do it by shell (ie run it in the cron and mail the result)

bin/csv/export.php is a new php shell in 3.4 and basically is a wrapper to any get api call.

if you call it from civicrm_root

bin/csv/export.php -uuser -ppassword -sdefault Contact group=42 rowCount=10000 return=sort_name,email,phone > /tmp/your.csv should do it.

If you need different columns name, update the first line of the csv.

if you need a complex mapping that isn't handled by contact api, create your api/v3/Ariel.php that has your civicrm_api3_Ariel_get and voila.

We would like to implement the same thing from the web as /civicrm/api/csv?entity=Contact&group=42&return= for 3.4.1....  would you be interested to make it happen ?

X+

P.S. If you have loads of contacts, I would suggest to create a new bin/csv/bigexport.php
It would first call the api to have a count of contacts, then call the get api with the right params (rowCount and start if my memory is right)

P.S2 the export cli is pretty new and I've used it only to export tags and relationship and options, ie. small lists. YMMV and patch welcome