Moodle

Columns in csv file do not line up

Details

  • Type: Sub-task Sub-task
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 2.0
  • Fix Version/s: None
  • Component/s: Quiz
  • Labels:
    None
  • Affected Branches:
    MOODLE_20_STABLE

Description

OU Moodle with latest Quiz reports

Fairly trivial - the dates/times for 'Started on' and 'Completed' have a comma between the date and the time. This leads to two extra columns in a CSV file which the title and averages rows don't have ... and consequently they don't line up with the data.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Jamie Pratt added a comment -

I attach a patch that can be applied to OU moodle code, also applied this patch to HEAD.

Show
Jamie Pratt added a comment - I attach a patch that can be applied to OU moodle code, also applied this patch to HEAD.
Hide
Permalink
Philip Butcher added a comment -

This export now lines up correctly but I noticed one inconsistency.

In my data I had two dates 6th and 18th August. The formed shows in Excel as 06/08/2008 (right justified) whereas the second shows as 18th August 2008 (left justified). This inconsistent formatting draws attention to the column as one asks 'what do these two formats convey?'.

Further investigation shows that in the txt file that is exported there is a space before 18 but not before 6. Perhaps you could make this consistent by adding a space before all dates.

Show
Philip Butcher added a comment - This export now lines up correctly but I noticed one inconsistency. In my data I had two dates 6th and 18th August. The formed shows in Excel as 06/08/2008 (right justified) whereas the second shows as 18th August 2008 (left justified). This inconsistent formatting draws attention to the column as one asks 'what do these two formats convey?'. Further investigation shows that in the txt file that is exported there is a space before 18 but not before 6. Perhaps you could make this consistent by adding a space before all dates.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.5#665-sha1:422aead) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.