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

          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 ]

              People

              • Votes:
                13 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                • Created:
                  Updated: