Automating exporting of a view I'm running a system where has a view with export functionality in order to export results in xls format.

Is there anyway I can automate it so every week it auto generates a report and email it.

I'm guessing I can use rules to do it but dont know how.

Thanks
If you are using the views_data_export module and you have command line access you can try the following:

cd [your_drupal_docroot] 
drush views-data-export [view-name] [display-id] &gt; [path-to-output-file]


You could then add this to cron as a one-liner, e.g. this would run every Monday at 5:59 AM:

59 5 * * 0 cd [absolute_path_to_drupal_docroot] &amp;&amp; drush views-data-export [view-name] [display-id] &gt; [path-to-output-file]