Moodle QA

CLONE - A teacher can export database activity entries in a choice of formats

Details

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.

Issue Links

This issue will be resolved by:
MDL-19864 Database: Excel export of URL field produces file with garbled text Critical Closed
MDL-28069 Evaluate use of Excel exports throughout Moodle Minor Closed
This issue has been marked as being related by:
MDL-28070 Review Excel writer package Major Open

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Anthony Borrow added a comment -

This works somewhat as expected provided we are not using the URL field type (and perhaps as long as a URL is not in a text field). I had filed MDL-19864 a while back. Another thing that I noticed that I would not expect is that the description field - since it is using the text editor saves the html code into the database and this code also gets exported which seems a bit ugly. I'm not sure if that is a feature or a bug. Peace - Anthony

Show
Anthony Borrow added a comment - This works somewhat as expected provided we are not using the URL field type (and perhaps as long as a URL is not in a text field). I had filed MDL-19864 a while back. Another thing that I noticed that I would not expect is that the description field - since it is using the text editor saves the html code into the database and this code also gets exported which seems a bit ugly. I'm not sure if that is a feature or a bug. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

URL fields are problematic so I am linking to this issue.

Show
Anthony Borrow added a comment - URL fields are problematic so I am linking to this issue.
Hide
Permalink
Anthony Borrow added a comment -

To reproduce failure
1) add a few links to the database at http://qa.moodle.net/mod/data/view.php?d=2
2) export the database and save as an Excel file
3) open the Excel file with OpenOffice (if I recall I also had this issue when working with Office directly) - see screen shot in MDL-19864 or Dongsheng for translation

Show
Anthony Borrow added a comment - To reproduce failure 1) add a few links to the database at http://qa.moodle.net/mod/data/view.php?d=2 2) export the database and save as an Excel file 3) open the Excel file with OpenOffice (if I recall I also had this issue when working with Office directly) - see screen shot in MDL-19864 or Dongsheng for translation
Hide
Permalink
Chad Outten added a comment -

+1. i can replicate the issue as described by Anthony.

Show
Chad Outten added a comment - +1. i can replicate the issue as described by Anthony.
Hide
Permalink
Anthony Borrow added a comment -

resetting to test again

Show
Anthony Borrow added a comment - resetting to test again
Hide
Permalink
Anthony Borrow added a comment -

While there are some known specific scenarios (like when URLs are in the text and exporting to Excel) where this test can fail (and there may be others), the basic functionality of being able to export a database is working but can use some TLC. I'm going to pass this issue and allow the developers some time to work on fixing MDL-19864. Peace - Anthony

Show
Anthony Borrow added a comment - While there are some known specific scenarios (like when URLs are in the text and exporting to Excel) where this test can fail (and there may be others), the basic functionality of being able to export a database is working but can use some TLC. I'm going to pass this issue and allow the developers some time to work on fixing MDL-19864. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

a backup file of a database with one field for each of the various types than can save time testing - no student data so a couple of entries will need to be added if using this

Show
Anthony Borrow added a comment - a backup file of a database with one field for each of the various types than can save time testing - no student data so a couple of entries will need to be added if using this
Hide
Permalink
Anthony Borrow added a comment -

the three exports of the mdlqa-964 database

Show
Anthony Borrow added a comment - the three exports of the mdlqa-964 database
Hide
Permalink
Anthony Borrow added a comment -

The Excel option is still failing. Since this can be accomplished by using either the CSV or ODF formats (both of which seem to be able to be opened via Excel) I think we can just remove the xls option which is problematic. For now, I am going to fail this until that option is removed and we can work on re-writing the test instructions. Folks using Excel should be recommended to use the csv option (Moodle Docs should probably be updated to reflect this) Peace - Anthony

Show
Anthony Borrow added a comment - The Excel option is still failing. Since this can be accomplished by using either the CSV or ODF formats (both of which seem to be able to be opened via Excel) I think we can just remove the xls option which is problematic. For now, I am going to fail this until that option is removed and we can work on re-writing the test instructions. Folks using Excel should be recommended to use the csv option (Moodle Docs should probably be updated to reflect this) Peace - Anthony
Hide
Permalink
Michael de Raadt added a comment -

Hi, Helen.

Could you please remove the Excel option from the test steps.

Also, could you change CVS to CSV. (I always mix those up.)

Michael;

Show
Michael de Raadt added a comment - Hi, Helen. Could you please remove the Excel option from the test steps. Also, could you change CVS to CSV. (I always mix those up.) Michael;
Hide
Permalink
Helen Foster added a comment -

Test description amended as suggested. Sorry for the CVS / CSV mix-up. I had ODS mixed up too!

Show
Helen Foster added a comment - Test description amended as suggested. Sorry for the CVS / CSV mix-up. I had ODS mixed up too!

People

Vote (0)
Watch (2)

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.