Moodle
  1. Moodle
  2. MDL-32637

In Database activity, export dates as formatted dates

    Details

    • Affected Branches:
      MOODLE_22_STABLE
    • Rank:
      39568

      Description

      This test requires a database activity in which several students have added entries.

      1. Login as a teacher and try exporting database activity entries as a CSV file.
      2. Open the CSV file in Excel or OpenOffice and check that all entries are listed.
      3. Select only one field for export then try exporting entries in ODS format.
      4. Open the file and check that all entries with just the field selected are listed.

      The dates are not in the format YYYY/MM/DD. Instead, it shows Unix timestamps, for example: 1335758400.

        Issue Links

          Activity

          Melvin Romero created issue -
          Melvin Romero made changes -
          Field Original Value New Value
          Attachment Date format is incorrect when exporting in CSV.jpg [ 28014 ]
          Melvin Romero made changes -
          Issue Type Bug [ 1 ] Improvement [ 4 ]
          Michael de Raadt made changes -
          Summary In Database activity, dates are not correctly displayed when exporting in CSV format In Database activity, export dates as formatted dates
          Fix Version/s DEV backlog [ 10464 ]
          Description This test requires a database activity in which several students have added entries.

          1. Login as a teacher and try exporting database activity entries as a CSV file.
          2. Open the CSV file in Excel or OpenOffice and check that all entries are listed.
          3. Select only one field for export then try exporting entries in ODS format.
          4. Open the file and check that all entries with just the field selected are listed.

          The dates are not correctly displayed. It is not in the format YYYY/MM/DD. Instead, it shows random numbers, for example: 1231423423434223.
          This test requires a database activity in which several students have added entries.

          1. Login as a teacher and try exporting database activity entries as a CSV file.
          2. Open the CSV file in Excel or OpenOffice and check that all entries are listed.
          3. Select only one field for export then try exporting entries in ODS format.
          4. Open the file and check that all entries with just the field selected are listed.

          The dates are not in the format YYYY/MM/DD. Instead, it shows Unix timestamps, for example: 1335758400.
          Labels triaged
          Helen Foster made changes -
          Link This issue duplicates MDL-18537 [ MDL-18537 ]
          Helen Foster made changes -
          Link This issue duplicates MDL-15574 [ MDL-15574 ]

            People

            • Votes:
              6 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated: