Support #45
Export Answers to Excel
| Status: | New | Start: | ||
| Priority: | Normal | Due date: | ||
| Assigned to: | - | % Done: | 0% |
|
| Category: | - | |||
| Target version: | 0.4.0 | |||
Description
Dear Developer
It will be great if get support for below issue
Presently i am conducting a survey thru Jquarks, now i need to export answers to excel sheet
pls help me
Karthi.V
History
Updated by Mahmoud M'HIRI 743 days ago
Hi Kathi,
JQuarks provides a CSV export functionality allowing administrators to export sessions to a CSV file (check "sessions" tab).
The generated file can be used in Microsoft Excel to generate stats and graphs based on quizzes and user stats.
Tip: The file will contain only sessions visible on the current view. You can use the bottom paginator to display more items or even all records. You can also use the top filter combo-boxes to extract sessions of a custom quiz or user.
Was that what were you looking for ?
-Mahmoud M'HIRI
Updated by Karthi V 743 days ago
Dear Mahmound,
Thx for Quick reply, I am able to download Session details (Good Option), similar way I need to export answers provided by users to CSV file (like paragraph answers and other answers given by user)
once this option is loaded, we can use Jquarks for survey programs(For Survey programs we required answers, which user has selected nor results or sessions.)we can do analyse the answers exported to CSV file
Hope i am not disturbing you much!!!!
karthi.V
Updated by Karthi V 743 days ago
Thx for Quick reply, I am able to download Session details (Good Option), similar way I need to export answers provided by users to CSV file (like paragraph answers and other answers given by user)Once this option is loaded, we can use Jquarks for survey programs(For Survey programs we required answers, which user has selected nor results or sessions.)we can do analyse the answers exported to CSV file
Hope i am not disturbing you much!!!!
karthi.V
Updated by Mahmoud M'HIRI 743 days ago
You're welcome Kathi.
Well , actually we thought since the beginning that we will definitely need such information to provide details stats, that's why we are currently saving every answer in the database. Only interfaces are missing.
Besides, they are planned to be part of the 0.4.0 release. Therefore, it will likely get several weeks to get releases, but if you need some hints to do it yourself, we'll be glad to help you get it done!
Regards,
-Mahmoud M'HIRI
Updated by Karthi V 743 days ago
Good effort and work done!!!! Hats off to team....Let me know the Next version release month.
Updated by Jonas Karv 735 days ago
Could you please tell me how in easy way, extract all survey answers (the same problem as Karthi, but I can't wait for new version)?
In wich tables in MySQL I could find this information?
Thank ypou in advance.
Updated by Mohamed Tougorti 734 days ago
Hello Jonas Karv,
Thank you for using JQuarks,
The table used to store the answers is #__jquarks_quizzes_answersessions, I would recommend taking a look at the methods in SITE_ROOT/administrator/components/com_jquarks/models/session.php
Regards.
Updated by Jonas Karv 728 days ago
Thank you for your answer but I need export all answers, because I use JQuarks as a survey.
It's really great component, simple, nice and very useful, but without all answers export capability ... :-(
Could you please propose some workaround or SQL query how in easy why extract all ansewrs from DB. Thank you!
P.S. Could you explain what do you mean about : "look at the methods in SITE_ROOT/administrator/components/com_jquarks/models/session.php"