Unable download of large site log report

Unable download of large site log report

by Raymon Akbar -
Number of replies: 4
Picture of Testers

Hi All,

Could you help me about how to download of huge file size under Logs feature in Moodle in Excel format? I cannot download "all days" for 280472 records.

Logs Report

After click "Get these logs"...

Blank page

I found this URL on Moodle Tracker, but It didn't help me.

Thanks in advance.

Cheers,
Raymon

Average of ratings: -
In reply to Raymon Akbar

Re: Unable download of large site log report

by Rex Lorenzo -

It appears that there are log export improvements that came in another tracker issue: 

https://tracker.moodle.org/browse/MDL-34867

However, the patch for that is coming in Moodle 2.9, which is scheduled to be released in May 2015.

In the meanwhile, a workaround would be to use phpMyAdmin or other way to view your database and export the contents of mdl_logstore_standard_log or split your download request into smaller day sets.

In reply to Rex Lorenzo

Re: Unable download of large site log report

by Raymon Akbar -
Picture of Testers

Hi Rex,

Almost 1 year...I just accessed my account and come back to my discussion. Anyway thank you for your reply, very helpful and detail. Yup, you're right about we can download or view the logs report from database.

Right now I'm trying a latest version of Moodle. 

In reply to Raymon Akbar

Re: Unable download of large site log report

by Sumrah Khalid -

Hello Raymon

Can you guide me how I can download site logs from database? Is there a SQL query to do so?


In reply to Rex Lorenzo

Re: Unable download of large site log report

by Sumrah Khalid -

Hello Rex

Can you guide me how I can download site logs from database? Is there a SQL query to do so?