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

In Database activity, export dates as formatted dates

    Details

    • Affected Branches:
      MOODLE_22_STABLE, MOODLE_28_STABLE

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              melrome Melvin Romero created issue -
              melrome Melvin Romero made changes -
              Field Original Value New Value
              Attachment Date format is incorrect when exporting in CSV.jpg [ 28014 ]
              melrome Melvin Romero made changes -
              Issue Type Bug [ 1 ] Improvement [ 4 ]
              salvetore 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
              tsala Helen Foster made changes -
              Link This issue duplicates MDL-18537 [ MDL-18537 ]
              tsala Helen Foster made changes -
              Link This issue duplicates MDL-15574 [ MDL-15574 ]
              abgreeve Adrian Greeve made changes -
              Status Open [ 1 ] Open [ 1 ]
              Affects Version/s 2.8 [ 13150 ]
              Assignee moodle.com [ moodle.com ]
              Sprint candidate Soon [ 10241 ]
              mina Nicolas Martignoni made changes -
              Link This issue has a non-specific relationship to MDL-49473 [ MDL-49473 ]
              mina Nicolas Martignoni made changes -
              Link This issue has a non-specific relationship to MDL-46626 [ MDL-46626 ]
              abgreeve Adrian Greeve made changes -
              Link This issue is duplicated by MDL-53792 [ MDL-53792 ]

                People

                • Votes:
                  17 Vote for this issue
                  Watchers:
                  15 Start watching this issue

                  Dates

                  • Created:
                    Updated: