Support #45

avatar

Export Answers to Excel

Added by Karthi V 743 days ago. Updated 706 days ago.

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

avatar
  • Start deleted (01/23/2010)

Updated by Mahmoud M'HIRI 743 days ago

avatar

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 Mahmoud M'HIRI 743 days ago

avatar
  • Target version set to 0.2.4

Updated by Karthi V 743 days ago

avatar

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

avatar

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

avatar

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

avatar

Good effort and work done!!!! Hats off to team....Let me know the Next version release month.

Updated by Mahmoud M'HIRI 743 days ago

avatar

Thank you Kathi for your nice words, we'll keep you updated!

Updated by Jonas Karv 735 days ago

avatar

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

avatar

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

avatar

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"

Updated by Mohamed Tougorti 706 days ago

avatar
  • Target version changed from 0.2.4 to 0.4.0

Also available in: Atom PDF