Export Report to a server directory with schedule

Hi there,

I have managed to use hooks to program events daily, monthly, etc. But I’m looking for an easy way to export a Report to a path (a directory in the server) with the scheduled hook.

I can’t figure how to export to xls the Report with a method.

Anybody has archieved this?

Kind Regards,

Rubén

Hi there again,

I’m trying to download the report with the public api:

frappe.ui.form.on(“Marcajes”, “boton”, function(frm){
frappe.call({
method:‘frappe.email.doctype.auto_email_report.auto_email_report.download’,
args: {name: “Informe de Marcajes”},
callback: function(r) {
frappe.msgprint(“OK!”);
}
});
});

But I get the error:

desk.min.js:1343 Uncaught TypeError: Cannot read property ‘responseText’ of undefined
at 200 (desk.min.js:1343)
at Object. (desk.min.js:1467)
at i (jquery.min.js:2)
at Object.fireWith [as rejectWith] (jquery.min.js:2)
at z (jquery.min.js:4)
at XMLHttpRequest. (jquery.min.js:4)

On the other hand I wouldn’t know how to indicate the location / path / directory to save the xls file.

Regards