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

Is it possible to export the data collected in Feedback to a .csv file?

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9.5, 2.0
    • Fix Version/s: 2.0.10, STABLE backlog
    • Component/s: Feedback
    • Labels:
      None
    • Affected Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      Is it possible to export the data collected in Feedback to a .csv file?

        Gliffy Diagrams

          Issue Links

            Activity

            grabs Andreas Grabs created issue -
            Hide
            aborrow Anthony Borrow added a comment -

            Andreas - It might be good to have a separate tab for export. There seems to be a desire for having the data available in multiple formats (Excel, OpenOffice, csv, etc.). We could then also create options for selecting what to export. I know that some folks have requested the ability to export the user data (http://moodle.org/mod/forum/discuss.php?d=131643#p576121) without necessarily analyzing it on the Moodle side and I suspect others would like to keep the export the way that it is. Perhaps it would be helpful to have the ability to check which fields are included in the export. I would suggest having a look at how the database activity module handles exporting data. Peace - Anthony

            Show
            aborrow Anthony Borrow added a comment - Andreas - It might be good to have a separate tab for export. There seems to be a desire for having the data available in multiple formats (Excel, OpenOffice, csv, etc.). We could then also create options for selecting what to export. I know that some folks have requested the ability to export the user data ( http://moodle.org/mod/forum/discuss.php?d=131643#p576121 ) without necessarily analyzing it on the Moodle side and I suspect others would like to keep the export the way that it is. Perhaps it would be helpful to have the ability to check which fields are included in the export. I would suggest having a look at how the database activity module handles exporting data. Peace - Anthony
            Hide
            aborrow Anthony Borrow added a comment -

            Andreas - Attached is a screen shot of where the current export functionality is for Excel. Obviously we could simply add a separate button or a drop down area for the various types and then change the text of the button to simply Export and let the users select the file type (Excel, Open Office, csv, etc.) with Excel being the default. Ultimately, I think for consistency in the UI the separate Export tab may be best but I am open to your thoughts on the matter. Peace - Anthony

            Show
            aborrow Anthony Borrow added a comment - Andreas - Attached is a screen shot of where the current export functionality is for Excel. Obviously we could simply add a separate button or a drop down area for the various types and then change the text of the button to simply Export and let the users select the file type (Excel, Open Office, csv, etc.) with Excel being the default. Ultimately, I think for consistency in the UI the separate Export tab may be best but I am open to your thoughts on the matter. Peace - Anthony
            aborrow Anthony Borrow made changes -
            Field Original Value New Value
            Attachment MDL-19406.png [ 18304 ]
            Hide
            eswoope Elizabeth A. Swoope added a comment -

            I'm one who'd really like to be able to analyze the data myself (and I think I asked if this was possible several months ago). I have no preference for file format because I can manipulate pretty much any file format that could be produced and don't mind doing so, but I realize that lots of people prefer to be able to choose a format.

            The current export data is absolutely useless for my purposes so I'm having to enter the data by hand now.

            BTW, the feedback module is one of my favorite tools. It would be perfect if I could extract the data.

            Show
            eswoope Elizabeth A. Swoope added a comment - I'm one who'd really like to be able to analyze the data myself (and I think I asked if this was possible several months ago). I have no preference for file format because I can manipulate pretty much any file format that could be produced and don't mind doing so, but I realize that lots of people prefer to be able to choose a format. The current export data is absolutely useless for my purposes so I'm having to enter the data by hand now. BTW, the feedback module is one of my favorite tools. It would be perfect if I could extract the data.
            Hide
            raylec Ray Le Couteur added a comment -

            I fully agree with Elizabeth.

            This relatively minor isuue will GREATLY enhance the usefulness of the feedback module - why not export all the data and allow users to manipulate it themselves?

            Currently there is an export with very limited data and very limited usefulness.

            Show
            raylec Ray Le Couteur added a comment - I fully agree with Elizabeth. This relatively minor isuue will GREATLY enhance the usefulness of the feedback module - why not export all the data and allow users to manipulate it themselves? Currently there is an export with very limited data and very limited usefulness.
            Hide
            raylec Ray Le Couteur added a comment -

            Well ... just a few days on since my above post and I am feeling very stupid.

            I have just noticed that the csv export from the Feedback module does already have all the detail I want .... it's just that the detail is initially hidden on a 2nd tab when opened in Excel.

            I wonder if others who have commented on the deficiency of the csv export also made this mistake ......

            Show
            raylec Ray Le Couteur added a comment - Well ... just a few days on since my above post and I am feeling very stupid. I have just noticed that the csv export from the Feedback module does already have all the detail I want .... it's just that the detail is initially hidden on a 2nd tab when opened in Excel. I wonder if others who have commented on the deficiency of the csv export also made this mistake ......
            Hide
            aborrow Anthony Borrow added a comment -

            Ray - Good point, I had actually forgotten about that second tab. Thanks for the reminder! Peace - Anthony

            Show
            aborrow Anthony Borrow added a comment - Ray - Good point, I had actually forgotten about that second tab. Thanks for the reminder! Peace - Anthony
            skodak Petr Skoda made changes -
            Fix Version/s 1.9.6 [ 10340 ]
            Fix Version/s 1.9.5 [ 10320 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 1.9.7 [ 10360 ]
            Fix Version/s 1.9.6 [ 10340 ]
            stronk7 Eloy Lafuente (stronk7) made changes -
            Fix Version/s 1.9.8 [ 10400 ]
            Fix Version/s 1.9.7 [ 10360 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 1.9.9 [ 10405 ]
            Fix Version/s 1.9.8 [ 10400 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 1.9.10 [ 10407 ]
            Fix Version/s 1.9.9 [ 10405 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 1.9.11 [ 10410 ]
            Fix Version/s 1.9.10 [ 10407 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 2.0.1 [ 10420 ]
            Fix Version/s 2.0 [ 10122 ]
            dougiamas Martin Dougiamas made changes -
            Workflow jira [ 32243 ] MDL Workflow [ 44998 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 2.0.2 [ 10421 ]
            Fix Version/s 2.0.1 [ 10420 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 2.0.3 [ 10537 ]
            Fix Version/s 2.0.2 [ 10421 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 1.9.12 [ 10536 ]
            Fix Version/s 1.9.11 [ 10410 ]
            dougiamas Martin Dougiamas made changes -
            Workflow MDL Workflow [ 44998 ] MDL Full Workflow [ 73357 ]
            stronk7 Eloy Lafuente (stronk7) made changes -
            Fix Version/s 2.0.4 [ 10652 ]
            Fix Version/s 2.0.3 [ 10537 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s STABLE backlog [ 10463 ]
            Fix Version/s 1.9.12 [ 10536 ]
            dougiamas Martin Dougiamas made changes -
            Fix Version/s 2.0.5 [ 10950 ]
            Fix Version/s 2.0.4 [ 10652 ]
            stronk7 Eloy Lafuente (stronk7) made changes -
            Fix Version/s 2.0.6 [ 11250 ]
            Fix Version/s 2.0.5 [ 10950 ]
            stronk7 Eloy Lafuente (stronk7) made changes -
            Fix Version/s 2.0.7 [ 11451 ]
            Fix Version/s 2.0.6 [ 11250 ]
            stronk7 Eloy Lafuente (stronk7) made changes -
            Fix Version/s 2.0.8 [ 11554 ]
            Fix Version/s 2.0.7 [ 11451 ]
            stronk7 Eloy Lafuente (stronk7) made changes -
            Fix Version/s 2.0.9 [ 12051 ]
            Fix Version/s 2.0.8 [ 11554 ]
            stronk7 Eloy Lafuente (stronk7) made changes -
            Fix Version/s 2.0.10 [ 12160 ]
            Fix Version/s 2.0.9 [ 12051 ]
            Hide
            brendanheywood Brendan Heywood added a comment -

            In MDL-37132 I have implemented a raw data export in csv

            Show
            brendanheywood Brendan Heywood added a comment - In MDL-37132 I have implemented a raw data export in csv
            marina Marina Glancy made changes -
            Link This issue has been marked as being related by MDL-37132 [ MDL-37132 ]
            Hide
            brendanheywood Brendan Heywood added a comment -

            I've just submitted MDL-37132 for review which solves this. It depends on a new dataformat plugin system in MDL-51603 so you can download feedback data in Excel, ODS, CSV, JSON, and if other dataformats are installed you get them for free here as well.

            Show
            brendanheywood Brendan Heywood added a comment - I've just submitted MDL-37132 for review which solves this. It depends on a new dataformat plugin system in MDL-51603 so you can download feedback data in Excel, ODS, CSV, JSON, and if other dataformats are installed you get them for free here as well.
            brendanheywood Brendan Heywood made changes -
            Link This issue has been marked as being related by MDL-37132 [ MDL-37132 ]
            brendanheywood Brendan Heywood made changes -
            Link This issue will be (partly) resolved by MDL-37132 [ MDL-37132 ]
            marina Marina Glancy made changes -
            Link This issue will be (partly) resolved by MDL-53638 [ MDL-53638 ]
            marina Marina Glancy made changes -
            Link This issue will be (partly) resolved by MDL-37132 [ MDL-37132 ]
            Hide
            brendanheywood Brendan Heywood added a comment -

            This has now been fixed via MDL-37132 / MDL-51603

            Show
            brendanheywood Brendan Heywood added a comment - This has now been fixed via MDL-37132 / MDL-51603
            brendanheywood Brendan Heywood made changes -
            Status Open [ 1 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            marina Marina Glancy made changes -
            Link This issue will be (partly) resolved by MDL-51603 [ MDL-51603 ]

              People

              • Votes:
                7 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  9/Jul/12