Storing QuizMaker results in a database
Mar 30, 2012
I am an ICT teacher at a school, and have created a solution to save all results to a database automatically after the quiz. I am using a MS SQL Server database, but it could easily be adapted to a MS Access or other database.
We have already taken hundreds of tests, and all results are stored, up to individual answers. The web interface enables you to download results per quiz, per student or per class in CSV format.
All source code is open sourced, and downloadable on http://code.google.com/p/quizbaker/
I am hoping for collaboration from many of you to improve the software. Email me if you like to cooperate on the project.
I have looked at joep's original solution in .NET and have created my own in classic ASP. See http://www.articulate.com/forums/articulate-quizmaker/4317-quiz-database-instructions-code.html
I plan on supporting MS Access, MySQL and port the version to PHP. One of the hardest problems was capturing the user name of the student, which is now done by forcing the student to use Internet Explorer, the only browser that sends the domain user automatically.
41 Replies
Michiel,
Sorry to ask again, but it seems I cannot locate the reply link to my question last month regarding passing variables to SQL using AJAX.
Can you please resend the email or link?
See the code under CC_PrintResults in /db/db.js in quizbaker. The url goes to /db/db.asp which then extracts the answers and stores them in a database.
Hi Mark,
I previously used this method to save the results of a Quizmaker 09 Survey to a Microsoft SQL Server database. Recently I have tried changing the survey questions and republishing the survey but it no longer works in IE11. Do you have any idea what changes are needed to make it work?
Hi Suzan,
This thread is a bit older so I'm not certain that folks are still subscribed. You may want to use the "contact me" button on their profile to reach out directly since we don't support reporting data to a database or text file.
Hi
My name is Michiel, not Mark. Don't worry about that though. Sorry to be late with my reply. I hope you have already solved the problem.
I have a new version already, but it's not ready for publishing. I am still working on that. I could send you the code base though.
Right now quizbaker has moved to GitHub, where you can find the code. If you want you can add an Issue here: https://github.com/blonkm/quizbaker/issues
Please use that to put in as much detail as you can about your problem. If you want you can press F12 in the browser (IE) and see in the console if there are any javascript errors. Please indicate which ones you see.
I can then fix the code and update the version. However, as I said this version is quite old and I need to update it with the latest
regards
Michiel
Hi Suzan and others,
I have uploaded the latest ASP code to GitHub. See https://github.com/blonkm/quizbaker/tree/proprietary
This is the code as it is used at our school, so it contains some school specific code. You can download it using the download zip button on the bottom right. I would recommend using the master branch though (choose branch, then master, then download zip).
I have also been working on the PHP version, which is now its own separate project. I know people like this because PHP on linux with mysql is completely free, and can easily be hosted online.
https://github.com/blonkm/Quizbaker-PHP
We are running dozens of quizzes with hundreds of students each year and it's still running great.
Thanks for sharing!
Thanks!
Sent from Windows Mail
Make a video please!
Hi Martin,
This thread is a bit older, and as such I'm not certain that folks are still subscribed. What element were you looking for a video around? You may want to message that user directly using the "contact me" button on their profile to see if they're able to weigh in and offer you some assistance.
Hi Martin!
This thread is a bit dated and the user you are reaching out to may no longer be subscribed. I would advise to utilize the 'Contact Me' option on the user profile to contact them directly if needed.
Storing results in a database is not something supported by Articulate.
We ended up using Jquery and Ajax to export and capture a variable that was then stored in a SQL database on the back end. This project was a collaboration with our IT department. Here is the storyline file I created for IT based on information I found on the Internet (don't ask me where). That was a contract project which ended, so I no longer have access to anything else. I hope you can find something to use or to help you find what you need. Best wishes.
Actually, here is the correct file ... more information. The first file is what I found on the Internet. This file is what I sent to our IT group.
Thanks so much for sharing, B, and hopefully that will be helpful for what Martin has in mind! :)
Martin, let me know what you are looking for, you can pm me.
Thanks for these great suggestions for solutions! I am also looking for a way to automatically send the result slide of my Articulate Storyline course to a database. Due to the stricter data protection laws in Germany I am not allowed to use Google Sheets for this, even if this would be the easiest solution. Mr. van der Blonk wrote in his post that you could also have the result slide sent to MS Access. However, I have no programming skills and little idea about this software. Could you help me here? :)