Automating exporting of a view
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]