It will contain three tables: tblcore, tblinteraction, and tblperson. Use paste to replace the default sendMail() function with the new-and-improved one on your clipboard.(If you are using the sample project, the code has already been pasted into cp2db_v2_rc3.htm, so you can skip this step.) Locate and select the sendMail() function in foo.htm.Select all and copy the entire file to your clipboard. Open sendmail_v2.js in your favorite text editor.If you save your project as foo.cp, the HTML file will be named foo.htm. Be sure “Export HTML” is checked in the publish options. Save and publish your project as a Flash (SWF).Under the Pass or Fail category, set a pass/fail percentage.Ĭlick the OK button to confirm your preferences. Under “Reporting Level,” select “Interactions and score.” Under “Report to LMS as,” select the “Score” radio button. Select the “E-mail” radio button and specify an email address. Select the “Enable reporting for this project” checkbox. (I’ve included a sample project: cp2db_v2_rc3.cp.) This provides a way to connect user data to quiz data without resorting to a login/authentication scheme of some sort. I’ve expanded the score submission form to include an optional employee ID, but, behind the scenes, I will be using the user-submitted email to uniquely identify the user. It now has three tables (one for core data, one for interaction data, and one for person data). In order to store all of this in a useful way, I’ve expanded the database a bit.

T/F, multiple-choice, etc.), and some other metadata specific to the question. was the user’s answer correct or not), the time spent on that question, the interaction type (e.g. It includes the user’s answer, the correct answer, the result (i.e. Interaction data is data specific to each question/interaction in the quiz. It includes values for the user’s overall score, along with the maximum possible score, the minimum possible score, the total time the user spent on the quiz, and whether he or she passed the quiz (based on a pass/fail percentage you define in Captivate’s quiz preferences). Allows you to see the contents of the array pre- and post-submission.Ĭore data is aggregate data for the entire quiz. Version 1 captured everything in one table. Captures both “Core data” and “Interaction data” (explained below).(Based on very limited testing, this code seems to work for quizzes created in Captivate 3 as well.)

I even created a separate page for the project, but I’m still be using the blog to keep you informed about it. The holiday break gave me a little extra time to work on the project, so I’m happy to release a new version.

A lot of people liked my initial effort at creating a PHP/MySQL reporting solution for quizzes created with Adobe Captivate 4.

Adobe captivate quiz results