I've been doing a ton of searching but haven't found an answer I'm afraid. I use authorize.net for course enrollments. At the end of the day I need a list of that day's new enrollments including some information about them like address, phone, so on. This is so I can match this information back to my bank for record keeping. Any ideas would be greatly appreciated. Thanks!
Hi there,
I think that one solution for your problem is to query moodle database directly using a custom sql query like:
select * from moodle199.mdl_enrol_authorize
where timecreated between unix_timestamp("2010-08-10")
and unix_timestamp("2010-08-10");
If you want to do it all inside Moodle you can use Tim Hunt's module Admin Report: Custom SQL queries available in http://moodle.org/mod/data/view.php?d=13&rid=2884
hth
I think that one solution for your problem is to query moodle database directly using a custom sql query like:
select * from moodle199.mdl_enrol_authorize
where timecreated between unix_timestamp("2010-08-10")
and unix_timestamp("2010-08-10");
If you want to do it all inside Moodle you can use Tim Hunt's module Admin Report: Custom SQL queries available in http://moodle.org/mod/data/view.php?d=13&rid=2884
hth