I want my site to generate an Excel sheet of selected node fields and save this on the server, once every 24 hours.

I have installed Views Export XLS which lets me create a view of the required fields in a table and then make that available as an .xls file. The way I do this manually is to go to the path I have set for the Excel feed display e.g. www.mysite.com/myexcelfile and up pops the .xls file for opening or saving. However, I can't work out how to generate this and save it automatically.

I looked at Rules and then Views Rules (https://drupal.org/project/views_rules) which says "VBO allows a rule to execute a view", so I have installed VBO, but can't seem to see any related VBO options in my view or anything in Rules which relates to the view.

Can anyone help??

Comments

bojanz’s picture

bojanz CreditAttribution: bojanz commented
Status: Active » Fixed

VBO in that use case only provides the selected entities (all of them that are found in the view), it's up to you to run an action on each returned entity.

I would honestly do through through custom code, in a hook_cron() implementation.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.