Hi all
I have some excellent SQL reports set up in the Configurable Reports block and want to be able to have them scheduled to run and email out to an admin email.
The Auto run daily option looks promising
but:
- you don't seem to be able to select a time
- I don't know where the report is going to eg is it parked in a folder and overwritten each day?
- I can't see what email it is being sent to - if it is being sent to an email?
Any assistance greatly appreciated.
Regards
Dot
I have the same question. Did anybody figure this one out yet?
The time of day is configured in the block administration settings:
.../moodle/admin/settings.php?section=blocksettingconfigurable_reports
I'm still trying to figure out where the reports get saved and whether they can be emailed automatically.
I'd also like to be able to run some reports weekly instead of daily-- I'm trying to figure out if the schedule option is a component/plugin or is integral to the block.
The email feature is implemented here:
I don't know if or how it implements with the scheduled report feature. The email feature seems designed to send emails to users defined as rows in the report, using information from that user's report row. It doesn't seem to be intended to use to send the whole report to someone.
Our similar report https://moodle.org/plugins/view.php?plugin=report_customsql can do weekly or monthly, and can email any scheduled report.
Yes, but they are only available to administrators... Configurable Reports can be made available to instructors without also giving instructors access to all administrative reports.
I have the option selected to auto run an insert SQL report, yet it doesn't appear to have run. I have changed the time in admin settings. Have you had success with scheduling reports?
Hello,
I am looking at the available report options but don't see one that counts currently enrolled users within a time period e.g. How many users were enrolled between 1 month or some other time period. I am just looking for the number of enrolled users across the whole site that are enrolled between dates and not course specific: Could someone point me to which one would carry that out please? Or perhaps help with the query that I would need to use or change?
Thanks
Al
