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

Update progress report (Download in Excel-compatible format) dates to a sortable format

XMLWordPrintable

    • MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
    • MOODLE_39_STABLE
    • master-MDL-67467
    • Hide
      1. Create a course
      2. Create some users and then enroll them in the course
      3. Create some activities that allow students to mark them as completed
      4. Please set one of the activities to have expected completion date.  
      5. Log in as some students and complete the activities
      6. Go back to the course as admin, go to course administration and click Activity completion in report section.
      7. Click "Download in Excel-compatible format (.csv)"  , we will be able to download a report. 
      8. Verify the dates look like "2019-12-10 17:46:22".
      9. Check the expected completion date in the report (compare to weekly or 3.8).
      10. Verify this is the same as weekly/3.8 and is of the format: "Friday, 6 December 2019, 1:58 AM"

      That means it is fixed

      Show
      Create a course Create some users and then enroll them in the course Create some activities that allow students to mark them as completed Please set one of the activities to have expected completion date.   Log in as some students and complete the activities Go back to the course as admin, go to course administration and click Activity completion in report section. Click "Download in Excel-compatible format (.csv)"  , we will be able to download a report.  Verify the dates look like "2019-12-10 17:46:22". Check the expected completion date in the report (compare to weekly or 3.8). Verify this is the same as weekly/3.8 and is of the format: "Friday, 6 December 2019, 1:58 AM" That means it is fixed

      Create a course

      Create some users and then enroll them in the course

      Create some activities that allow students to mark them as completed

      Log in as some students and complete some activities

      Go back to the course as admin, go to course administration and click Activity completion in report section.

      Click "Download in Excel-compatible format (.csv)"  , we will be able to download a report. We could see the dates look like "Friday, 6 December 2019, 1:58 AM", If we sort the column, it may just sort alphabetically but not really sorting the date as expected. 

      We want to be able to sort that column based on the date.

       

            yao9394 John Yao
            yao9394 John Yao
            Brendan Heywood Brendan Heywood
            Jake Dallimore Jake Dallimore
            Shamim Rezaie Shamim Rezaie
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 45 minutes
                45m

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