How to set up scheduled export with a cron job?

A client of mine wants to have a monthly report of an enquiry form emailed to him automatically. I've done some searching and seen that there are possible plans to allow for a scheduled export to CSV in future releases. One of the posts refers to wrapping the Gravity Forms export functions in a cron job to automate the process.

Is there anyone out there who has done this, and would be willing to share the code or a how-to on it? Or any decent resources that could point me in the right direction? My PHP knowledge is fairly limited, though I know enough to tinker with existing code and get it to do what I need it to. I've never played with cron, but I'm happy to learn if it's not too high level.

Thanks!

Thanks, David, that's exactly what I'm hoping for :)

The same request here, did somebody managed to do this?

I'm also very interested in this functionality - I'd greatly appreciate any help on achieving an automated scheduled report / data extract.

Figured it out .. should I do a blog post how to?

Again, myself very interested WebMechanix...very much needed.

Thanks

Any feedback on how to accomplish this?

Looking forward to your solution WebMechanix! Thanks in advance for sharing!

Looking forward to seeing that tutorial. Please link me up

Yes, +1 here too. I am working on similar functionality for a client. So far I am able to save to a .csv file all of the aggregated data via a PHP script but am not quite getting the formatting right.

For Joe and anyone else who's interested. I'm using this script to login to the database and get all of the data... some things will change depending on your install... then saving the data to a .csv file.

http://pastie.org/6630732

The next step is to send this file as an e-mail attachment... I'll hopefully be finishing this tomorrow and will post what I get.

I am also working on a solution, which would be more like an Add-On, so everything would be handled through the admin interface instead of scripts.

Great alsc! I hope we will see it soon maybe?

Well, thanks to all of you that have taken this up. This seems to be a very "in demand" feature. I am hoping that whatever the solutions are, at the minimum will just dump the form data in CSV format to a directory. It would really help me out if it had the option to overwrite any existing file, so I can set up a scheduled download of the form data. My peeps just want to be able to open in excel, access etc. without having to futz around with different file names, etc. They just want to wake up, drink their coffee and see what happened in the last few hours or the last day.

Again, thanks to all who have taken this on.

@alsc - Any updates? I hope it is going well.

@alsc - life always does. Can I help test?