Export to csv using crontab

I have a question around the export to csv code. I am trying to setup/code a crontab that will run hourly on the server to export all the new, renewals or upgraded membership. I need to import this into a third-pary software.

Can you give me some tips on how to do this. What is the SQL SELECT I would need to join all the right tables to get all the membership? Similar to the export to csv feature. Even if you just tell me were the code for the export is and I will look at it as long as it is not to complex the follow.

Hi Mark

You can look at the file administrator/components/com_osmembership/controller/subscription.php, method export.

All the logic for the export is handled there and you can get the code you want to implement it

Regards,

Tuan