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.

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.