Forums

how can I export the db records by month and not all at the same time.

Hi janman,

Set up a little form that reads the last months new records and exports them - probably as an email attachment. The set up the form event linked to a cron job on your server so that it runs once a month.

Bob

Thanks bob
Can you please help me to setup the form.

Hi Bob
i have created a form to download the db, but i need to add it as a mail attachment and i need to export it by date.
Please any documentation or help will be greatly appreciated.
http://1021dev.co.za/proplaw/index.php?option=com_chronoforms5&chronoform=DB_Export

Hi janman,

Instead of downloading it, save it to the server; then you can attach it to an email.

What exactly do you mean by 'download by date'?

Bob

download the csv by month

How do i save the db to the server?

Hi janman,

Hmmm - it looks as though you can't do that in CFv5 (you could in CFv4). I have a beta version of a custom action that you can try, I'll PM you a link.

Bob

Thanks bob
I have installed the custom action, how do i include the file as an attachment in my email.

Hi janman,

I had to experiment to see how this worked. If you put the 'Form data name' value from the CSV Export [GH] settings in the attachments box - e.g. csv_export by default - then the file is attached correctly.

Bob