Quiz to database, instructions and code

[Dumarest]

If you have this working in PHP MYSQL I would be VERY grateful to receive a copy!
PLEASE!
<grin>

[Nemec]

I am not using PHP, but I am still working on getting this code to work for SQL. Have you looked into this link:

Email Results Tutorial - PHP

Hopefully that will help you.

[Rvieira]

Originally Posted by derick

I had a go at making a version for '09. Did a few things differently from Joe
(1) Created an ASPX version of quiz.html, it can be used as a common page for multiple quizzes, each of the quizzes can be kept in a different folder. The path for the folder is dynamically set.
(2) Added extra functions in the ASPX page, individual quiz files do not need to be modified now.
(3) Session Variables are used to identify the logged in user and the quiz name.
(4) Used XML for collecting the data and sending it to the server.
(5) Used Mootools for Ajax submission of the data

What is not done is the database integration, I have kept the method/variable names the same as Joe's original code to enable integration with his code.

Attached is a zip with the original files provided by Joe along with my zip - the one with a long name - QuizMaker09PostQuizResultsToDatabaseUsingASPDotNet .zip.

I am still evaluating the product but I hope this code is useful to anyone to current customers. Would have been best if Articulate had provided this functionality out of the box, love the product but what disappoints is that this functionality is too obvious to have not been deliberately left out.

Regards,

Derick D'souza

Attachment 1027

Hi Derick,

Could you perhaps post some instructions with regards to your solution.
I am a newbie to all this and not quite sure how to implement your solution.

Thanks

[jimmy_jammer]

Not sure it suit the business model of the company ! Thanks for te '09 update muh appreciated. Have you got ay more detailed instructions ofhow to appy this?

[sumit1022]

Hi I am lloking at a possibility - with your work published here
can I genrate a dump of somekind which has a user and question/survey on X&Y axis and responses mapped

for more clarity:


Q1 Q2 Q3 Q4

USER 1 NA Always Always NA
USER 2 Always Never Always Never
USER 3 NA Always Always Always
Thaks

[sumit1022]

Hi

I am lloking at a possibility - with your work published here
can I genrate a dump of somekind which has a user and question/survey on X&Y axis and responses mapped

for more clarity:


Q1 Q2 Q3 Q4

USER 1 NA Always Always NA
USER 2 Always Never Always Never
USER 3 NA Always Always Always
Thanks

[Wylie]

Hi,

We offer the Accord LMS. It is a low cost LMS that is fully SCORM compliant. We offer both hosted and self-hosted options. We have focused on Articulate during development and their content is completely compatible.

SCORM LMS Elearning Training Software Solution | Interzoic Accord

Contact us through our website if you have any questions.

Thanks,
Chris

[wendybridges]

Hi Joe. I dont know how to get this to work. Can you contact me?

[derick]

Quick update: found a simple way to intercept the call to save quiz results, this seems to work across browsers.

I have quickly tested this code and have found it work on the following: IE8, FF 3.5, Opera 10.10, Chrome 4.0.223.16, Safari 4.0.2.

We are finally going to move integration of Articulate Quizmaker output with our app to active development mode. I will post updates to this code if any.

Quick instructions, a basic .NET project should be ok - copy the code and follow instructions in my previous posts.

Derick

Originally Posted by derick

An update, found out that
(a) Quiz.swf is unique for each quiz (should have figured that out earlier)
(b) quiz_content folder cannot be renamed, quiz.swf has the path hard coded and fails to load the quiz if it is renamed.

I have removed quiz.swf from the zip, as it needs to be copied from the published folder.

I have changed the code, small changes to quiz.aspx & .cs that will get it to work with multiple quiz folders. I have replaced the 'content folder' variables in the javascript and asp.net code with a 'quiz folder' variable.

You can have the following folder structure now (you can name the folders as you like except for the quiz_content folder)
-->Quiz
----->QuizA
------------>quiz_content
----->QuizB
------------>quiz_content
----->QuizC
------------>quiz_content

Unzip all the files in the Quiz folder, copy quiz.swf from your published folder to the folder "QuizA", under "QuizA" copy the quiz_content folder as is from your published folder. Each published quiz will have its independent folder within the structure. Switching between quiz folders is achieved by setting the folder path in the 'quiz folder' variable in quiz.aspx.cs.

Regards,

Derick.

[beeneeb]

Thanks for posting the update Derick!