Moodle in English: Export in CSV

A grate plugin and works well. I love the Rateing scale and is the main reason for using it

Is there a way to export the data to CSV format or does anybody have a SQL query for better reporting.

Average of ratings: -

Re: Export in CSV

by Mary Cooch - Thursday, 9 October 2014, 6:00 PM

Please see the section Download in text format in the documentation Viewing Questionnaire responses

Average of ratings: Useful (2)

Re: Export in CSV

by Nico Potgieter - Thursday, 9 October 2014, 6:43 PM

Thanks for that quick response.

I tried that but the export files does not contain any delimiters. I have attached the export txt

test (1).txt

Average of ratings: -

Re: Export in CSV

by Mary Cooch - Thursday, 9 October 2014, 7:06 PM

I just tried importing your attached file into Excel 2007 using the instructions in the CSV file How to use it (direct link to that section) and it displayed for me fine. Were you wanting it to do something else? (Sorry - I am not very practised in csv files )

Average of ratings: Useful (1)

Re: Export in CSV

by Nico Potgieter - Thursday, 9 October 2014, 7:25 PM

Ok I got it.

The file gets exported as a text file and the delimiters are TAB.

No need to change the extension to csv. When importing into Excel make sure the delimited is checked and on the next screen TAB delimiters are checked.

The file will then get imported correctly.

Thanks for you help

Average of ratings: -

Re: Export in CSV

by Joaquin Morales - Wednesday, 3 June 2015, 7:13 AM

I need to download all the responses of all questionnaires of a course, do you know a way to do that?

Average of ratings: -

Re: Export in CSV

by Luke Primm - Saturday, 20 June 2015, 10:30 PM

Hope all is well... I have a similar dilemma. The questionnaire ad-don is awesome, however exporting the data is where my problem lies. I understand how to export, im just looking for any input from the community on how you all have handled the data once its been collected? We are migrating from survey collection in vovici and now doing it all within moodle.

So my ask is anyone doing anything constructive with the survey data once its all been collected or do you all just keep it in a text doc or excel doc?

any ideas are appreciated, thanks!

Average of ratings: -

Group Column empty in the CSV

by Javier Varas - Thursday, 25 June 2015, 12:52 AM

The module is great but I have some trouble with the CSV. The group column is empty and I just don't see why.

Separate groups are enabled in the course (I also tried with Visible Grups). Users belong to a group. I can see all the responses or each group responses but if I Click "download in text format" the "Group" column is empty in the CSV".

Can anybody help me?

Thanks