← Back to team overview

mahara-contributors team mailing list archive

[Bug 1915961] [NEW] Change date format in CSV export for 'Account details' report

 

Public bug reported:

When you download the 'Account details' report as CSV file, the date for
the last login is mentioned as 14 June 2021, 7:40. That makes it
impossible to sort the column. The date in the export should be
displayed as 2021-06-14, 7:40 instead so sorting is possible. However,
when viewing the report online, the date format can stay for easier
readability. It also looks like the sorting is done there correctly.

To replicate:

1. Add a few people to your site and log in as them. Masquerading won't help there.
2. Go to Admin menu -> Reports -> Accounts details report and activate the column 'Last login'.
3. View the report and see the login dates.
4. Download the CSV file.

Results:
- Expected: The date column in the CSV file can be sorted and shows the date as 2021-06-14, 7:40
- Actual result: The date column can't be sorted.

** Affects: mahara
     Importance: Medium
     Assignee: Gold (gold.catalyst)
         Status: Confirmed


** Tags: bite-sized

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1915961

Title:
  Change date format in CSV export for 'Account details' report

Status in Mahara:
  Confirmed

Bug description:
  When you download the 'Account details' report as CSV file, the date
  for the last login is mentioned as 14 June 2021, 7:40. That makes it
  impossible to sort the column. The date in the export should be
  displayed as 2021-06-14, 7:40 instead so sorting is possible. However,
  when viewing the report online, the date format can stay for easier
  readability. It also looks like the sorting is done there correctly.

  To replicate:

  1. Add a few people to your site and log in as them. Masquerading won't help there.
  2. Go to Admin menu -> Reports -> Accounts details report and activate the column 'Last login'.
  3. View the report and see the login dates.
  4. Download the CSV file.

  Results:
  - Expected: The date column in the CSV file can be sorted and shows the date as 2021-06-14, 7:40
  - Actual result: The date column can't be sorted.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1915961/+subscriptions


Follow ups