Hi!

Is it possible to exoprt the quiz results trough PHPmyadmin and identify who have taken the different quizes?

I can always see the results inside the Administrator tools on the webpage, but when 2000 users have taken 13 courses in at total of 112 000 times it takes to much time to sort out lists with names working with pages that shows a maximum of 100 results, an the name lists are not alfabetic.

Do you have any good way that I can create a report for each of the courses showing who have passed? I might also be interested in pay some extra to get a reporting tool created.

Hello,

Could you send sample(s) of report(s) which you need by email?

Regards,
ARI Soft

Hi,
more then a report is it possible to have the same data of the View of the Quiz result in one or more mySQL tables?
Is there any query to get this data in a clear form? or how can we use the same query used to View the Quiz result?
It is not easy to understand the answers in the ariquizstatistics and ariquizstatisticsinfo tables.

Thank you.
gierre

Hello,

Answers are stored in XML format. It is necessary to parse it after retrieving from database.

Regards,
ARI Soft

Hi,
of course XML format, but if "data" of _ariquizstatistics table represents the answer, not fully clear the meaning of the "initdata" content:
if possible, can you help to clarify?
otherwise can you provide the same data of the "Quiz result" (format attached) of all the records of the _ariquizstatistics table in one or more mySQL tables?

Thank you.

gierre

It is possible to skip questions and return to them later and it is also possible to show answer in random order. InitData contains is populated when question is shown first time and later it is used to show answers in initial order.

User answers are stored in ariquizstatistics table. Questions with answers are stored in ariquizquestionversion table.

Regards,
ARI Soft