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.

Pažymių vidurkis: -

Re: Export in CSV

Mary Cooch - ketvirtadienis, 2014 spalio 9, 18:00

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

Pažymių vidurkis:Useful (2)

Re: Export in CSV

Nico Potgieter - ketvirtadienis, 2014 spalio 9, 18:43

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

Pažymių vidurkis: -

Re: Export in CSV

Mary Cooch - ketvirtadienis, 2014 spalio 9, 19:06

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 )

Pažymių vidurkis:Useful (1)

Re: Export in CSV

Nico Potgieter - ketvirtadienis, 2014 spalio 9, 19:25

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

Pažymių vidurkis: -

Re: Export in CSV

Joaquin Morales - trečiadienis, 2015 birželio 3, 07:13

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

Pažymių vidurkis: -

Re: Export in CSV

Luke Primm - šeštadienis, 2015 birželio 20, 22:30

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!

Pažymių vidurkis: -

Group Column empty in the CSV

Javier Varas - ketvirtadienis, 2015 birželio 25, 00:52

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