Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-41314

Logs show wrong time when downloaded in Excel format

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • None
    • 2.3.4, 2.4.4
    • Logging
    • MOODLE_23_STABLE, MOODLE_24_STABLE
    • Hide

      Download logs in text format.

      Show
      Download logs in text format.

      Moodle logs, when downloaded in Excel format, are off one hour from what is displayed on page. This occurs when the site time zone (Site administration > Location > Location settings; Default timezone) is set to a time that accounts for Daylight Saving Time. Logs, when downloaded in text format, are accurate and match what is displayed on the page.

      If a timezone is selected that does not account for DST, the Excel display time is accurate and matches the page display.

      Appears to be similar to closed tracker MDL-14934.

      Replication steps:

      1. Make sure site timezone is set to a time that accounts for Daylight Saving Time (ie. Site administration > Location > Location settings, Default timezone set to America/New York).
      2. Navigate to Site administration > Reports > Logs
      3. Select any set of log entries. Select "Display on page". Notice the time reported for the log entry.
      4. Now select "Download in Excel format". Review the log generated. Note the time for the log entry is one hour prior to the time displayed on the page.
      5. Now select "Download in text format". Review the log generated. The time for the log entry is the same as what was displayed on the page.

        1. Text Log.jpg
          Text Log.jpg
          27 kB
        2. Excel Log.jpg
          Excel Log.jpg
          47 kB
        3. Display Log.jpg
          Display Log.jpg
          76 kB

            Unassigned Unassigned
            michael.robinette Mike Robinette (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.