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

In Database activity, export dates as formatted dates

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      1. Create a data activity and add a date field.
      2. Add at least one entry.
      3. Export the records with having 'Date fields in human-readable format' unchecked. (Expectation: the date value is a UNIX timestamp).
      4. Export the records with having 'Date fields in human-readable format' checked. (Expectation: the date value is formatted according to your current language).

       

      Show
      Create a data activity and add a date field. Add at least one entry. Export the records with having 'Date fields in human-readable format' unchecked. (Expectation: the date value is a UNIX timestamp). Export the records with having 'Date fields in human-readable format' checked. (Expectation: the date value is formatted according to your current language).  
    • Affected Branches:
      MOODLE_22_STABLE, MOODLE_28_STABLE, MOODLE_33_STABLE, MOODLE_34_STABLE
    • Pull Master Branch:
      MDL-32637-master

      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.

        Attachments

        1. addentry.png
          addentry.png
          13 kB
        2. Date format is incorrect when exporting in CSV.jpg
          Date format is incorrect when exporting in CSV.jpg
          284 kB
        3. export.png
          export.png
          39 kB
        4. exportfile.png
          exportfile.png
          9 kB

          Issue Links

            Activity

              People

              • Votes:
                26 Vote for this issue
                Watchers:
                20 Start watching this issue

                Dates

                • Created:
                  Updated: