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

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

    XMLWordPrintable

    Details

    • Testing Instructions:
      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
    • Affected Branches:
      MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
    • Fixed Branches:
      MOODLE_39_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      master-MDL-67467

      Description

      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.

       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              yao9394 John Yao
              Reporter:
              yao9394 John Yao
              Peer reviewer:
              Brendan Heywood
              Integrator:
              Jake Dallimore
              Tester:
              Shamim Rezaie
              Participants:
              Component watchers:
              Sam Marshall, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                15/Jun/20

                  Time Tracking

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