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

    • 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

    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

              yao9394 John Yao
              yao9394 John Yao
              Brendan Heywood Brendan Heywood
              Jake Dallimore Jake Dallimore
              Shamim Rezaie Shamim Rezaie
              Sam Marshall, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona), Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                15/Jun/20

                Time Tracking

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