Reporting the Quiz Results to a local server

August 11, 2010

Reporting the Quiz Results to a local server

Followers: 0 people
August 11, 2010

One of the most requested features in Adobe Captivate was the ability to store the course results on the local servers or database. Adobe Captivate 5 comes with an all new reporting workflow, being highlighted as Alternate Reporting, which enables its users to store and track their course results using their own servers and database.

Useful Resources

Alternate Reporting allows the users to integrate their content with their own webservers. Let us see how…in a very few steps…

Step I: Set-up the Web server

For integrating the course with a web server, first the user needs to setup a web server. Here, I will take an example of integrating the Captivate course with WAMP server (PHP-enabled server).

WAMP server is an open source project and a free to use web server. It can be downloaded from www.wampserver.com/en/downloads.php.

Tutorials for installing WAMP server can be found at: http://www.tagbytag.org/tutorials/getting-started/web-design-software/wamp-guide

Step II: Create a Reporting Script

Since some of the users want the results to be stored on their local servers and some want to be stored on some database, Adobe Captivate 5 provides a template script file – InternalServerReporting.php, which is available at the following location – [InstallDirectory]/Adobe Captivate 5/Templates/Publish/. Users can use this script file and modify it accordingly to solve their purpose. Also, there is no restriction on the scripting language used for the reporting script. Users can use any scripting language like PHP or ASP.

Once the script file is ready, you just need to place this file in the root folder of the web server. To check whether the script is correct and accessible or not, please try accessing it using the web browser.

For eg : If the server is on local machine, you can try the following link in your web browser : http://localhost/InternalServerReporting.php.

No error should be displayed in the browser.

 

Step III: Set the Quiz Reporting Preferences in Adobe Captivate 5

After the server is up and running, and the script file is in place, you need to set the preferences in Adobe Captivate 5, so that the results get reported to the web server.

Adobe Captivate 5 comes with two new reporting options available in the Reporting preferences of Quiz.

For tracking the results using the web server, you need to select and configure Internal Server as the reporting option.

Step IV: Configure the Internal Server

Now, user needs to configure the internal server to his own web server. For this, you should provide the link to the script file in the Server text area of the Alternate Reporting dialog. Also, you should provide the names of the Institute, Department and Course name in the respective fields. All these fields are mandatory and are used to store the course results in a formal structure.

And now, your course is integrated with your web server.

Whenever a student will take this course he will see a Post Results button on the result slide. Once the student uses this button to post the results, the results get posted on your web server.

 

 

How can you store the results on a database?

You can anytime modify your script file to connect to a database. Now whenever the results are passed to this script, the code in the script would directly store the results onto the database.

Hence, you can see how easy it is to store the course results on your own web servers/database using Alternate Reporting feature of Adobe Captivate 5.

I’ll give some more highlights on the code in the script in my further blog posts. So keep tuned.

Comments (131)
2016-01-17 20:26:00
2016-01-17 20:26:00

I am getting a couple of errors when running the internalserverreporting.php (Step II) ... regardless whether I place the files into the root folder or any subdirectory... I've set all permissions to 777... :-| any ideas? :-| Warning: mkdir(): File exists in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 35 Warning: mkdir(): File exists in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 37 Warning: mkdir(): File exists in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 39 Warning: mkdir(): File exists in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 41 Warning: fopen(./CaptivateResults////////): failed to open stream: Is a directory in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 43 Warning: fwrite() expects parameter 1 to be resource, boolean given in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 44 Warning: fclose() expects parameter 1 to be resource, boolean given in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 45

I am getting a couple of errors when running the internalserverreporting.php (Step II) … regardless whether I place the files into the root folder or any subdirectory… I’ve set all permissions to 777… 😐

any ideas? 😐

Warning: mkdir(): File exists in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 35

Warning: mkdir(): File exists in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 37

Warning: mkdir(): File exists in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 39

Warning: mkdir(): File exists in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 41

Warning: fopen(./CaptivateResults////////): failed to open stream: Is a directory in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 43

Warning: fwrite() expects parameter 1 to be resource, boolean given in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 44

Warning: fclose() expects parameter 1 to be resource, boolean given in /www/htdocs/xxxxxxx/captivate/internalServerReporting.php on line 45

Like
2014-05-15 07:04:00
2014-05-15 07:04:00

Is there a way to capture or report the date the quiz was taken in the Quiz Analyzer? The only place I can find the date is in the XML file captivate creates in the "Captivate Results" folder. But, I can't XML data into a usable/trackable format. I'd like to be able to generate a report in the Quiz Analyzer and then export it to excel where I can track it...but without the date I don't know when they took the quiz and when my trainees need to renew/retake the course. Can anyone help?

Is there a way to capture or report the date the quiz was taken in the Quiz Analyzer? The only place I can find the date is in the XML file captivate creates in the “Captivate Results” folder. But, I can’t XML data into a usable/trackable format. I’d like to be able to generate a report in the Quiz Analyzer and then export it to excel where I can track it…but without the date I don’t know when they took the quiz and when my trainees need to renew/retake the course. Can anyone help?

Like
2013-03-29 00:21:00
2013-03-29 00:21:00

When I put the correct url in the Captivate settings and hit 'OK', it doesn't create the "CaptivateResults" folder and doesn't work.

When I put the correct url in the Captivate settings and hit ‘OK’, it doesn’t create the “CaptivateResults” folder and doesn’t work.

Like
2013-02-20 19:25:00
2013-02-20 19:25:00

Does the Quiz Results include information about the test taker like an email address or name?

Does the Quiz Results include information about the test taker like an email address or name?

Like
2013-02-12 20:55:00
2013-02-12 20:55:00

I have a site that was using Captivate software and to my knowledge had been saving the test results and users information correctly for sometime. Just recently within a week or two the users have been reporting issues with the test not saving their information and getting error messages. Does anyone have a clue why this could be? Attached is an image of the error the users are getting

I have a site that was using Captivate software and to my knowledge had been saving the test results and users information correctly for sometime. Just recently within a week or two the users have been reporting issues with the test not saving their information and getting error messages. Does anyone have a clue why this could be? Attached is an image of the error the users are getting

Like
(1)
>
Anonymous
's comment
2013-02-14 10:07:00
2013-02-14 10:07:00
>
Anonymous
's comment

Hi Thomas, Has the InternalServerReporting.php file changed in your local system? You can also try to restart internal server once.

Hi Thomas, Has the InternalServerReporting.php file
changed in your local system?

You can also try to restart internal server once.

Like
2013-01-24 00:13:00
2013-01-24 00:13:00

I need help please with deleting quiz results from Adobe Captivate Quiz results Analyzer. I do not seem to be able to when selecting the delete button

I need help please with deleting quiz results from Adobe Captivate Quiz results Analyzer. I do not seem to be able to when selecting the delete button

Like
2012-11-30 22:03:00
2012-11-30 22:03:00

Are there any updates about writing Captivate results to a MySQL database? Has anyone written a script to do that?

Are there any updates about writing Captivate results to a MySQL database? Has anyone written a script to do that?

Like
(1)
>
Anonymous
's comment
2012-11-30 22:10:00
2012-11-30 22:10:00
>
Anonymous
's comment

Via PHP, I should have said.

Via PHP, I should have said.

Like
2012-08-08 05:15:00
2012-08-08 05:15:00

I noticed that the CaptivateResults folder was not created. Is there a step missing, or is there a way to simply create a folder in a location where the php expects to find the CaptivateResults folder?

I noticed that the CaptivateResults folder was not created. Is there a step missing, or is there a way to simply create a folder in a location where the php expects to find the CaptivateResults folder?

Like
(1)
>
Anonymous
's comment
2012-08-09 10:32:00
2012-08-09 10:32:00
>
Anonymous
's comment

Can you please tell some more details about the issue? Have you placed the PHP files (internalServerReporting.php & internalserverread.php) at the correct location?

Can you please tell some more details about the issue? Have you placed the PHP files (internalServerReporting.php & internalserverread.php) at the correct location?

Like
2012-07-27 01:14:00
2012-07-27 01:14:00

Is there a way to avoid showing the user id and email prompt when sending the scores to a local server? I really don't want this prompt to show since I already have the users login info in a session variable.

Is there a way to avoid showing the user id and email prompt when sending the scores to a local server? I really don’t want this prompt to show since I already have the users login info in a session variable.

Like
(3)
>
Anonymous
's comment
2012-10-12 21:12:00
2012-10-12 21:12:00
>
Anonymous
's comment

Did you receive an answer to your question?

Did you receive an answer to your question?

Like
>
Anonymous
's comment
2012-11-27 02:39:00
2012-11-27 02:39:00
>
Anonymous
's comment

Stephane, any luck?

Stephane,
any luck?

Like
>
Anonymous
's comment
2015-10-26 12:16:00
2015-10-26 12:16:00
>
Anonymous
's comment

Did you ever find an anwer to this one? I am searching for the answer to this already for some weeks now, there are many posts but only few real answers so I hope you guys can help me. I am coding (in PHP) an internal LMS using Adobe Captivate 9 where the results of the quiz are posted to "Internal Server". This works nice and I have changed the default InternalServerReporting script so it does push the results to our database so we can use them in our Admin console. Every user who take a course needs to login first so we do already know the name and email address of this user, but still at the end of each quiz, Captivate gives the popup where it asks to enter the name and email address of the user. Some months ago, when I was still using Captivate 8, I found a post somewhere (unfortunately I can't remember where) that pointed out to 1 setting that you can change (not in a menu, it was more in an ini file or regkey and as far as I remember even not in the project but more in the installed software) and that did the trick. Now I have upgraded to Captivate 9 and the same comes back but can't find that fix anymore. Does anyone maybe know how to get rid of this popup in Captivate 9 or else know where to find that original answer that I found months ago? Thanks Micha

Did you ever find an anwer to this one?

I am searching for the answer to this already for some weeks now,
there are many posts but only few real answers so I hope you guys can
help me.

I am coding (in PHP) an internal LMS using Adobe Captivate 9 where
the results of the quiz are posted to “Internal Server”. This works nice
and I have changed the default InternalServerReporting script so it
does push the results to our database so we can use them in our Admin
console.
Every user who take a course needs to login first so we do already know
the name and email address of this user, but still at the end of each
quiz, Captivate gives the popup where it asks to enter the name and
email address of the user.

Some months ago, when I was still using Captivate 8, I found a post
somewhere (unfortunately I can’t remember where) that pointed out to 1
setting that you can change (not in a menu, it was more in an ini file
or regkey and as far as I remember even not in the project but more in
the installed software) and that did the trick. Now I have upgraded to
Captivate 9 and the same comes back but can’t find that fix anymore.

Does anyone maybe know how to get rid of this popup in Captivate 9 or
else know where to find that original answer that I found months ago?

Thanks
Micha

Like
2012-07-19 22:58:00
2012-07-19 22:58:00

Links to tutorials broken. Any way to integrate with Wordpress existing database w/Captivate results?

Links to tutorials broken. Any way to integrate with WordPress existing database w/Captivate results?

Like
2012-06-30 01:49:00
2012-06-30 01:49:00

I've gotten my script created but have a specific variable that is in the URL that i also need to post to the database as well (TicketID=jdfsad7234jkldsaf;kasdf) this is the encrypted ticket number of the quiz they just took. Is there any way for me to request this parameter and pass it to the custom script? I did this in captivate 4 all the time but now in 5 it looks like the custom posting to database is relegated to just posting score, time, coursename, learnername and just a couple of other things. I sell courses online and the ticketid is how i mark a quiz complete when i submit the score to the DB. Thanks!

I’ve gotten my script created but have a specific variable that is in the URL that i also need to post to the database as well (TicketID=jdfsad7234jkldsaf;kasdf) this is the encrypted ticket number of the quiz they just took. Is there any way for me to request this parameter and pass it to the custom script? I did this in captivate 4 all the time but now in 5 it looks like the custom posting to database is relegated to just posting score, time, coursename, learnername and just a couple of other things. I sell courses online and the ticketid is how i mark a quiz complete when i submit the score to the DB. Thanks!

Like
2012-05-09 04:23:00
2012-05-09 04:23:00

This is my solution in VB.net . It uses three SQL tables (which is probably overkill) to store the results. One stores the post data Captivate sends on a single row, the other two "capHeaderData" and "capData" store the parsed out data from the XMLfile that gets sent. I'm supplying scripts to create all the tables at the end also. This is the code behind of a blank page I called captivateresults.aspx . I sent the Internal Reporting to this page which is hosted on the company Intranet. It collects the data captivate sends, then records it in capResults, then takes the XML file and parses it out into the other two tables, a header and a data table for the questions themselves. You will need to replace "incIntranet.pubConnStringIntranet" with a connection string to your database that works in your environment probably somethign like "Data Source=MYSQLINSTANCENAME;Initial Catalog=MYDATABASENAME;User Id=MYUSERNAME; Password=MYPASSWORD" ******************************************* Imports System.Data Imports System.Data.SqlClient Imports System Imports System.Xml Partial Class captivateresults Inherits System.Web.UI.Page Public incIntranet As New classIntranet Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load 'This page is called from Adobe Captivate. The quiz reults are sent in as a Post to this page. 'This page then loops through the request.params and and stores the data which is several fields a 'and a file which should be in XML. This data is inserted as a row in a capQuizResults table. Dim strListofVars As String = "" Dim strListofFormVars As String = "" Dim strCompanyName As String = "" Dim strDepartmentName As String = "" Dim strCourseName As String = "" Dim strFilename As String = "" Dim strFiledata As String = "" Dim strFileUpload As String = "" 'Request.Params goes combines all variables, Querystring, Post, Server For Each strPost As String In Request.Params 'If InStr(strPost, Request.ServerVariables()) = 0 Then 'End If strListofVars = strListofVars & strPost & " | " Response.Write("" & strPost & ":" & Request(strPost).ToString & "") Select Case strPost Case "CompanyName" strCompanyName = Request(strPost).ToString Case "DepartmentName" strDepartmentName = Request(strPost).ToString Case "CourseName" strCourseName = Request(strPost).ToString Case "Filename" strFilename = Request(strPost).ToString Case "Filedata" strFiledata = Request(strPost).ToString Case "Upload" strFileUpload = Request(strPost).ToString End Select Next For Each strPost As String In Request.Form strListofFormVars = strListofFormVars & strPost & " | " Next 'Insert into table and return the newly created ID Dim myConnection As New SqlConnection(incIntranet.pubConnStringIntranet) Dim strUpdateString As String = "INSERT INTO capResults (capResultsListOfVars, capResultsListOfFormVars, capResultsCompanyName, capResultsDepartmentName, capResultsCourseName, capResultsFileName, capResultsFileData, capResultsFileUpload) VALUES (@ListOfVars, @ListOfFormVars, @CompanyName, @DepartmentName, @CourseName, @FileName, @FileData, @FileUpload); SELECT SCOPE_IDENTITY() as NewID " Dim da As SqlDataAdapter = New SqlDataAdapter(strUpdateString, myConnection) 'Dim myCommand As New SqlCommand(strUpdateString, myConnection) da.SelectCommand.Parameters.Add(New SqlParameter("@ListOfVars", strListofVars)) da.SelectCommand.Parameters.Add(New SqlParameter("@ListOfFormVars", strListofFormVars)) da.SelectCommand.Parameters.Add(New SqlParameter("@CompanyName", strCompanyName)) da.SelectCommand.Parameters.Add(New SqlParameter("@DepartmentName", strDepartmentName)) da.SelectCommand.Parameters.Add(New SqlParameter("@CourseName", strCourseName)) 'da.SelectCommand.Parameters.Add(New SqlParameter("@LearnerName", strCourseName)) 'da.SelectCommand.Parameters.Add(New SqlParameter("@LessonName", strCourseName)) da.SelectCommand.Parameters.Add(New SqlParameter("@Filename", strFilename)) da.SelectCommand.Parameters.Add(New SqlParameter("@Filedata", strFiledata)) da.SelectCommand.Parameters.Add(New SqlParameter("@FileUpload", strFileUpload)) Dim dt As New DataTable da.Fill(dt) Dim intNewID As Int64 = dt.Rows(0).Item("NewID") 'From the XML , insert records for each questions for this ResultsID Dim strXML As New XmlDocument 'strXML.LoadXml(dt.Rows(0).Item("capResultsFileData")) strXML.LoadXml(strFiledata) 'Dim strXML As New XmlDocument ''strXML.LoadXml(dt.Rows(0).Item("capResultsFileData")) 'strXML.LoadXml(strFiledata) 'Course Dim strXMLCompany As String = strXML.GetElementsByTagName("CompanyName").Item(0).Attributes.ItemOf("value").Value Dim strXMLDepartment As String = strXML.GetElementsByTagName("DepartmentName").Item(0).Attributes.ItemOf("value").Value Dim strXMLCourseName As String = strXML.GetElementsByTagName("CourseName").Item(0).Attributes.ItemOf("value").Value Dim strXMLLearnerName As String = strXML.GetElementsByTagName("LearnerName").Item(0).Attributes.ItemOf("value").Value Dim strXMLLearnerID As String = strXML.GetElementsByTagName("LearnerID").Item(0).Attributes.ItemOf("value").Value Dim strXMLLessonName As String = strXML.GetElementsByTagName("LessonName").Item(0).Attributes.ItemOf("value").Value Dim strXMLQuizAttempts As String = strXML.GetElementsByTagName("QuizAttempts").Item(0).Attributes.ItemOf("value").Value Dim strXMLTotalQuestions As String = strXML.GetElementsByTagName("TotalQuestions").Item(0).Attributes.ItemOf("value").Value 'Core Data Dim strXMLStatus As String = strXML.GetElementsByTagName("Status").Item(0).Attributes.ItemOf("value").Value Dim strXMLLocation As String = strXML.GetElementsByTagName("Location").Item(0).Attributes.ItemOf("value").Value Dim strXMLRawScore As String = strXML.GetElementsByTagName("RawScore").Item(0).Attributes.ItemOf("value").Value Dim strXMLMaxScore As String = strXML.GetElementsByTagName("MaxScore").Item(0).Attributes.ItemOf("value").Value Dim strXMLMinScore As String = strXML.GetElementsByTagName("MinScore").Item(0).Attributes.ItemOf("value").Value Dim strXMLSessionTime As String = strXML.GetElementsByTagName("SessionTime").Item(0).Attributes.ItemOf("value").Value 'Dim nInteractions As XmlNode = strXML.GetElementsByTagName("InteractionData") 'Response.Write(nInteractions.Name & "") strUpdateString = "INSERT INTO capDataHeader (capResultsID, capDataHeaderCompanyName, capDataHeaderDepartmentName, capDataHeaderCourseName, capDataHeaderLearnerName, capDataHeaderLearnerID, capDataHeaderLessonName, capDataHeaderQuizAttempts, capDataHeaderTotalQuestions, capDataHeaderStatus, capDataHeaderLocation, capDataHeaderRawScore, capDataHeaderMaxScore, capDataHeaderMinScore, capDataHeaderSessionTime) " & _ "VALUES (@capResultsID, @strXMLCompany, @strXMLDepartment, @strXMLCourseName, @strXMLLearnerName, @strXMLLearnerID, @strXMLLessonName, @strXMLQuizAttempts, @strXMLTotalQuestions, " & _ " @strXMLStatus, @strXMLLocation, @strXMLRawScore, @strXMLMaxScore, @strXMLMinScore, @strXMLSessionTime); SELECT SCOPE_IDENTITY() as NewHeaderID " da = New SqlDataAdapter(strUpdateString, myConnection) 'Dim myCommand As New SqlCommand(strUpdateString, myConnection) da.SelectCommand.Parameters.Add(New SqlParameter("@capResultsID", intNewID)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLCompany", strXMLCompany)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLDepartment", strXMLDepartment)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLCourseName", strXMLCourseName)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLLearnerName", strXMLLearnerName)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLLearnerID", strXMLLearnerID)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLLessonName", strXMLLessonName)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLQuizAttempts", strXMLQuizAttempts)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLTotalQuestions", strXMLTotalQuestions)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLStatus", strXMLStatus)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLLocation", strXMLLocation)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLRawScore", strXMLRawScore)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLMaxScore", strXMLMaxScore)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLMinScore", strXMLMinScore)) da.SelectCommand.Parameters.Add(New SqlParameter("@strXMLSessionTime", strXMLSessionTime)) dt = New DataTable da.Fill(dt) Dim intNewHeaderID As Int64 = dt.Rows(0).Item("NewHeaderID") Dim strXMLDate As String Dim strXMLInteractionTime As String Dim strXMLInteractionID As String Dim strXMLObjectiveID As String Dim strXMLInteractionType As String Dim strXMLCorrectResponse As String Dim strXMLStudentResponse As String Dim strXMLResult As String Dim strXMLWeight As String Dim strXMLLatency As String Dim strXMLAttempt As String myConnection.Open() For Each nNode As XmlNode In strXML.GetElementsByTagName("Interactions") strXMLDate = nNode.SelectSingleNode("Date").Attributes.ItemOf("value").Value.ToString strXMLInteractionTime = nNode.SelectSingleNode("InteractionTime").Attributes.ItemOf("value").Value.ToString strXMLInteractionID = nNode.SelectSingleNode("InteractionID").Attributes.ItemOf("value").Value strXMLObjectiveID = nNode.SelectSingleNode("ObjectiveID").Attributes.ItemOf("value").Value strXMLInteractionType = nNode.SelectSingleNode("InteractionType").Attributes.ItemOf("value").Value strXMLCorrectResponse = nNode.SelectSingleNode("CorrectResponse").Attributes.ItemOf("value").Value strXMLStudentResponse = nNode.SelectSingleNode("StudentResponse").Attributes.ItemOf("value").Value If Not nNode.SelectSingleNode("Result") Is Nothing Then strXMLResult = nNode.SelectSingleNode("Result").Attributes.ItemOf("value").Value Else strXMLResult = "" End If strXMLWeight = nNode.SelectSingleNode("Weight").Attributes.ItemOf("value").Value strXMLLatency = nNode.SelectSingleNode("Latency").Attributes.ItemOf("value").Value strXMLAttempt = nNode.SelectSingleNode("Attempt").Attributes.ItemOf("value").Value strUpdateString = "INSERT INTO capData (capDataHeaderID, capDataInteractionDateTime, capDataInteractionID, capDataObjectiveID, capDataInteractionType, capDataCorrectResponse, capDataStudentResponse, capDataResult, capDataWeight, capDataLatency, capDataAttempt) " & _ "VALUES (@capDataHeaderID, @capDataInteractionDateTime, @capDataInteractionID, @capDataObjectiveID, @capDataInteractionType, @capDataCorrectResponse, @capDataStudentResponse, @capDataResult, @capDataWeight, @capDataLatency, @capDataAttempt) " Dim myCommand As SqlCommand = New SqlCommand(strUpdateString, myConnection) 'Dim myCommand As New SqlCommand(strUpdateString, myConnection) myCommand.Parameters.Add(New SqlParameter("@capDataHeaderID", intNewHeaderID)) myCommand.Parameters.Add(New SqlParameter("@capDataInteractionDateTime", CType(strXMLDate & " " & strXMLInteractionTime, Date))) myCommand.Parameters.Add(New SqlParameter("@capDataInteractionID", strXMLInteractionID)) myCommand.Parameters.Add(New SqlParameter("@capDataObjectiveID", strXMLObjectiveID)) myCommand.Parameters.Add(New SqlParameter("@capDataInteractionType", strXMLInteractionType)) myCommand.Parameters.Add(New SqlParameter("@capDataCorrectResponse", strXMLCorrectResponse)) myCommand.Parameters.Add(New SqlParameter("@capDataStudentResponse", strXMLStudentResponse)) myCommand.Parameters.Add(New SqlParameter("@capDataResult", strXMLResult)) myCommand.Parameters.Add(New SqlParameter("@capDataWeight", strXMLWeight)) myCommand.Parameters.Add(New SqlParameter("@capDataLatency", strXMLLatency)) myCommand.Parameters.Add(New SqlParameter("@capDataAttempt", strXMLAttempt)) myCommand.ExecuteNonQuery() Next myConnection.Close() ' foreach ($_POST as $k => $v) ' { ' if($k == "CompanyName") ' { ' $CompanyName = $v; ' } ' if($k == "DepartmentName") ' { ' $DepartmentName = $v; ' } ' if($k == "CourseName") ' { ' $CourseName = $v; ' } ' if($k == "Filename") ' { ' $Filename = $v; ' } ' if($k == "Filedata") ' { ' If (get_magic_quotes_gpc()) Then ' $Filedata = stripslashes($v); ' Else ' $Filedata = $v; ' } ' } '$ResultFolder = "./"."CaptivateResults"; 'mkdir($ResultFolder); '$CompanyFolder = $ResultFolder."//".$CompanyName; 'mkdir($CompanyFolder); '$DepartmentFolder = $CompanyFolder."//".$DepartmentName; 'mkdir($DepartmentFolder); '$CourseFolder = $DepartmentFolder."//".$CourseName; 'mkdir($CourseFolder); '$FilePath = $CourseFolder."//".$Filename; '$Handle = fopen($FilePath, 'w'); 'fwrite($Handle, $Filedata); 'fclose($Handle); End Sub End Class *************************************************** This is the sql scripts I used to create the tables involved. You will have to change "IntranetWeb" to the name of your database: USE [IntranetWeb] GO /****** Object: Table [dbo].[capResults] Script Date: 05/08/2012 15:45:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[capResults]( [capResultsID] [int] IDENTITY(1,1) NOT NULL, [capResultsDate] [datetime] NOT NULL, [capResultsListOfVars] [varchar](5000) NULL, [capResultsListOfFormVars] [varchar](5000) NULL, [capResultsCompanyName] [varchar](50) NULL, [capResultsDepartmentName] [varchar](50) NULL, [capResultsCourseName] [varchar](50) NULL, [capResultsFileName] [varchar](50) NULL, [capResultsFileData] [varchar](max) NULL, [capResultsFileUpload] [varchar](max) NULL, CONSTRAINT [PK_capResults] PRIMARY KEY CLUSTERED ( [capResultsID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[capResults] ADD CONSTRAINT [DF_capResults_capResultsDate] DEFAULT (getdate()) FOR [capResultsDate] GO USE [IntranetWeb] GO /****** Object: Table [dbo].[capDataHeader] Script Date: 05/08/2012 15:46:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[capDataHeader]( [capDataHeaderID] [int] IDENTITY(1,1) NOT NULL, [capResultsID] [int] NULL, [capDataHeaderCompanyName] [varchar](50) NULL, [capDataHeaderDepartmentName] [varchar](50) NULL, [capDataHeaderCourseName] [varchar](50) NULL, [capDataHeaderLearnerName] [varchar](50) NULL, [capDataHeaderLearnerID] [varchar](50) NULL, [capDataHeaderLessonName] [varchar](50) NULL, [capDataHeaderQuizAttempts] [int] NULL, [capDataHeaderTotalQuestions] [int] NULL, [capDataHeaderStatus] [varchar](50) NULL, [capDataHeaderLocation] [varchar](50) NULL, [capDataHeaderRawScore] [int] NULL, [capDataHeaderMaxScore] [int] NULL, [capDataHeaderMinScore] [int] NULL, [capDataHeaderSessionTime] [datetime] NULL, CONSTRAINT [PK_capDataHeader] PRIMARY KEY CLUSTERED ( [capDataHeaderID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [IntranetWeb] GO /****** Object: Table [dbo].[capData] Script Date: 05/08/2012 15:46:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[capData]( [capDataID] [bigint] IDENTITY(1,1) NOT NULL, [capDataHeaderID] [int] NOT NULL, [capDataInteractionDateTime] [datetime] NOT NULL, [capDataInteractionID] [int] NULL, [capDataObjectiveID] [varchar](50) NULL, [capDataInteractionType] [varchar](50) NULL, [capDataCorrectResponse] [varchar](50) NULL, [capDataStudentResponse] [varchar](50) NULL, [capDataResult] [varchar](50) NULL, [capDataWeight] [int] NULL, [capDataLatency] [datetime] NULL, [capDataAttempt] [int] NULL, CONSTRAINT [PK_capData] PRIMARY KEY CLUSTERED ( [capDataID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO

This is my solution in VB.net . It uses three SQL tables (which is probably overkill) to store the results. One stores the post data Captivate sends on a single row, the other two “capHeaderData” and “capData” store the parsed out data from the XMLfile that gets sent. I’m supplying scripts to create all the tables at the end also.

This is the code behind of a blank page I called captivateresults.aspx . I sent the Internal Reporting to this page which is hosted on the company Intranet. It collects the data captivate sends, then records it in capResults, then takes the XML file and parses it out into the other two tables, a header and a data table for the questions themselves.

You will need to replace “incIntranet.pubConnStringIntranet” with a connection string to your database that works in your

environment probably somethign like “Data Source=MYSQLINSTANCENAME;Initial Catalog=MYDATABASENAME;User Id=MYUSERNAME;

Password=MYPASSWORD”

*******************************************

Imports System.Data
Imports System.Data.SqlClient
Imports System
Imports System.Xml

Partial Class captivateresults
Inherits System.Web.UI.Page

Public incIntranet As New classIntranet

Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

‘This page is called from Adobe Captivate. The quiz reults are sent in as a Post to this page.
‘This page then loops through the request.params and and stores the data which is several fields a
‘and a file which should be in XML. This data is inserted as a row in a capQuizResults table.

Dim strListofVars As String = “”
Dim strListofFormVars As String = “”
Dim strCompanyName As String = “”
Dim strDepartmentName As String = “”
Dim strCourseName As String = “”
Dim strFilename As String = “”
Dim strFiledata As String = “”
Dim strFileUpload As String = “”

‘Request.Params goes combines all variables, Querystring, Post, Server
For Each strPost As String In Request.Params

‘If InStr(strPost, Request.ServerVariables()) = 0 Then

‘End If
strListofVars = strListofVars & strPost & ” | ”
Response.Write(“” & strPost & “:” & Request(strPost).ToString & “”)

Select Case strPost

Case “CompanyName”
strCompanyName = Request(strPost).ToString
Case “DepartmentName”
strDepartmentName = Request(strPost).ToString
Case “CourseName”
strCourseName = Request(strPost).ToString
Case “Filename”
strFilename = Request(strPost).ToString
Case “Filedata”
strFiledata = Request(strPost).ToString
Case “Upload”
strFileUpload = Request(strPost).ToString
End Select

Next

For Each strPost As String In Request.Form
strListofFormVars = strListofFormVars & strPost & ” | ”
Next

‘Insert into table and return the newly created ID

Dim myConnection As New SqlConnection(incIntranet.pubConnStringIntranet)
Dim strUpdateString As String = “INSERT INTO capResults (capResultsListOfVars, capResultsListOfFormVars,

capResultsCompanyName, capResultsDepartmentName, capResultsCourseName, capResultsFileName, capResultsFileData,

capResultsFileUpload) VALUES (@ListOfVars, @ListOfFormVars, @CompanyName, @DepartmentName, @CourseName, @FileName,

@FileData, @FileUpload); SELECT SCOPE_IDENTITY() as NewID ”
Dim da As SqlDataAdapter = New SqlDataAdapter(strUpdateString, myConnection)

‘Dim myCommand As New SqlCommand(strUpdateString, myConnection)
da.SelectCommand.Parameters.Add(New SqlParameter(“@ListOfVars”, strListofVars))
da.SelectCommand.Parameters.Add(New SqlParameter(“@ListOfFormVars”, strListofFormVars))
da.SelectCommand.Parameters.Add(New SqlParameter(“@CompanyName”, strCompanyName))
da.SelectCommand.Parameters.Add(New SqlParameter(“@DepartmentName”, strDepartmentName))
da.SelectCommand.Parameters.Add(New SqlParameter(“@CourseName”, strCourseName))

‘da.SelectCommand.Parameters.Add(New SqlParameter(“@LearnerName”, strCourseName))
‘da.SelectCommand.Parameters.Add(New SqlParameter(“@LessonName”, strCourseName))

da.SelectCommand.Parameters.Add(New SqlParameter(“@Filename”, strFilename))
da.SelectCommand.Parameters.Add(New SqlParameter(“@Filedata”, strFiledata))
da.SelectCommand.Parameters.Add(New SqlParameter(“@FileUpload”, strFileUpload))

Dim dt As New DataTable
da.Fill(dt)

Dim intNewID As Int64 = dt.Rows(0).Item(“NewID”)

‘From the XML , insert records for each questions for this ResultsID

Dim strXML As New XmlDocument
‘strXML.LoadXml(dt.Rows(0).Item(“capResultsFileData”))
strXML.LoadXml(strFiledata)

‘Dim strXML As New XmlDocument
”strXML.LoadXml(dt.Rows(0).Item(“capResultsFileData”))
‘strXML.LoadXml(strFiledata)

‘Course
Dim strXMLCompany As String = strXML.GetElementsByTagName(“CompanyName”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLDepartment As String =

strXML.GetElementsByTagName(“DepartmentName”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLCourseName As String = strXML.GetElementsByTagName(“CourseName”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLLearnerName As String =

strXML.GetElementsByTagName(“LearnerName”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLLearnerID As String = strXML.GetElementsByTagName(“LearnerID”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLLessonName As String = strXML.GetElementsByTagName(“LessonName”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLQuizAttempts As String =

strXML.GetElementsByTagName(“QuizAttempts”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLTotalQuestions As String =

strXML.GetElementsByTagName(“TotalQuestions”).Item(0).Attributes.ItemOf(“value”).Value

‘Core Data
Dim strXMLStatus As String = strXML.GetElementsByTagName(“Status”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLLocation As String = strXML.GetElementsByTagName(“Location”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLRawScore As String = strXML.GetElementsByTagName(“RawScore”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLMaxScore As String = strXML.GetElementsByTagName(“MaxScore”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLMinScore As String = strXML.GetElementsByTagName(“MinScore”).Item(0).Attributes.ItemOf(“value”).Value
Dim strXMLSessionTime As String =

strXML.GetElementsByTagName(“SessionTime”).Item(0).Attributes.ItemOf(“value”).Value

‘Dim nInteractions As XmlNode = strXML.GetElementsByTagName(“InteractionData”)
‘Response.Write(nInteractions.Name & “”)

strUpdateString = “INSERT INTO capDataHeader (capResultsID, capDataHeaderCompanyName, capDataHeaderDepartmentName,

capDataHeaderCourseName, capDataHeaderLearnerName, capDataHeaderLearnerID, capDataHeaderLessonName,

capDataHeaderQuizAttempts, capDataHeaderTotalQuestions, capDataHeaderStatus, capDataHeaderLocation, capDataHeaderRawScore,

capDataHeaderMaxScore, capDataHeaderMinScore, capDataHeaderSessionTime) ” & _
“VALUES (@capResultsID, @strXMLCompany, @strXMLDepartment, @strXMLCourseName, @strXMLLearnerName, @strXMLLearnerID,

@strXMLLessonName, @strXMLQuizAttempts, @strXMLTotalQuestions, ” & _
” @strXMLStatus, @strXMLLocation, @strXMLRawScore, @strXMLMaxScore, @strXMLMinScore, @strXMLSessionTime); SELECT

SCOPE_IDENTITY() as NewHeaderID ”
da = New SqlDataAdapter(strUpdateString, myConnection)

‘Dim myCommand As New SqlCommand(strUpdateString, myConnection)
da.SelectCommand.Parameters.Add(New SqlParameter(“@capResultsID”, intNewID))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLCompany”, strXMLCompany))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLDepartment”, strXMLDepartment))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLCourseName”, strXMLCourseName))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLLearnerName”, strXMLLearnerName))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLLearnerID”, strXMLLearnerID))

da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLLessonName”, strXMLLessonName))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLQuizAttempts”, strXMLQuizAttempts))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLTotalQuestions”, strXMLTotalQuestions))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLStatus”, strXMLStatus))

da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLLocation”, strXMLLocation))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLRawScore”, strXMLRawScore))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLMaxScore”, strXMLMaxScore))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLMinScore”, strXMLMinScore))
da.SelectCommand.Parameters.Add(New SqlParameter(“@strXMLSessionTime”, strXMLSessionTime))

dt = New DataTable
da.Fill(dt)

Dim intNewHeaderID As Int64 = dt.Rows(0).Item(“NewHeaderID”)

Dim strXMLDate As String
Dim strXMLInteractionTime As String
Dim strXMLInteractionID As String
Dim strXMLObjectiveID As String
Dim strXMLInteractionType As String
Dim strXMLCorrectResponse As String
Dim strXMLStudentResponse As String
Dim strXMLResult As String
Dim strXMLWeight As String
Dim strXMLLatency As String
Dim strXMLAttempt As String

myConnection.Open()

For Each nNode As XmlNode In strXML.GetElementsByTagName(“Interactions”)

strXMLDate = nNode.SelectSingleNode(“Date”).Attributes.ItemOf(“value”).Value.ToString
strXMLInteractionTime = nNode.SelectSingleNode(“InteractionTime”).Attributes.ItemOf(“value”).Value.ToString
strXMLInteractionID = nNode.SelectSingleNode(“InteractionID”).Attributes.ItemOf(“value”).Value
strXMLObjectiveID = nNode.SelectSingleNode(“ObjectiveID”).Attributes.ItemOf(“value”).Value
strXMLInteractionType = nNode.SelectSingleNode(“InteractionType”).Attributes.ItemOf(“value”).Value
strXMLCorrectResponse = nNode.SelectSingleNode(“CorrectResponse”).Attributes.ItemOf(“value”).Value
strXMLStudentResponse = nNode.SelectSingleNode(“StudentResponse”).Attributes.ItemOf(“value”).Value
If Not nNode.SelectSingleNode(“Result”) Is Nothing Then
strXMLResult = nNode.SelectSingleNode(“Result”).Attributes.ItemOf(“value”).Value
Else
strXMLResult = “”
End If

strXMLWeight = nNode.SelectSingleNode(“Weight”).Attributes.ItemOf(“value”).Value
strXMLLatency = nNode.SelectSingleNode(“Latency”).Attributes.ItemOf(“value”).Value
strXMLAttempt = nNode.SelectSingleNode(“Attempt”).Attributes.ItemOf(“value”).Value

strUpdateString = “INSERT INTO capData (capDataHeaderID, capDataInteractionDateTime, capDataInteractionID,

capDataObjectiveID, capDataInteractionType, capDataCorrectResponse, capDataStudentResponse, capDataResult, capDataWeight,

capDataLatency, capDataAttempt) ” & _
“VALUES (@capDataHeaderID, @capDataInteractionDateTime, @capDataInteractionID, @capDataObjectiveID,

@capDataInteractionType, @capDataCorrectResponse, @capDataStudentResponse, @capDataResult, @capDataWeight, @capDataLatency,

@capDataAttempt) ”
Dim myCommand As SqlCommand = New SqlCommand(strUpdateString, myConnection)

‘Dim myCommand As New SqlCommand(strUpdateString, myConnection)
myCommand.Parameters.Add(New SqlParameter(“@capDataHeaderID”, intNewHeaderID))
myCommand.Parameters.Add(New SqlParameter(“@capDataInteractionDateTime”, CType(strXMLDate & ” ” &

strXMLInteractionTime, Date)))
myCommand.Parameters.Add(New SqlParameter(“@capDataInteractionID”, strXMLInteractionID))
myCommand.Parameters.Add(New SqlParameter(“@capDataObjectiveID”, strXMLObjectiveID))
myCommand.Parameters.Add(New SqlParameter(“@capDataInteractionType”, strXMLInteractionType))
myCommand.Parameters.Add(New SqlParameter(“@capDataCorrectResponse”, strXMLCorrectResponse))
myCommand.Parameters.Add(New SqlParameter(“@capDataStudentResponse”, strXMLStudentResponse))
myCommand.Parameters.Add(New SqlParameter(“@capDataResult”, strXMLResult))
myCommand.Parameters.Add(New SqlParameter(“@capDataWeight”, strXMLWeight))
myCommand.Parameters.Add(New SqlParameter(“@capDataLatency”, strXMLLatency))
myCommand.Parameters.Add(New SqlParameter(“@capDataAttempt”, strXMLAttempt))
myCommand.ExecuteNonQuery()

Next

myConnection.Close()

‘ foreach ($_POST as $k => $v)
‘ {
‘ if($k == “CompanyName”)
‘ {
‘ $CompanyName = $v;
‘ }
‘ if($k == “DepartmentName”)
‘ {
‘ $DepartmentName = $v;
‘ }
‘ if($k == “CourseName”)
‘ {
‘ $CourseName = $v;
‘ }
‘ if($k == “Filename”)
‘ {
‘ $Filename = $v;
‘ }
‘ if($k == “Filedata”)
‘ {
‘ If (get_magic_quotes_gpc()) Then
‘ $Filedata = stripslashes($v);
‘ Else
‘ $Filedata = $v;
‘ }
‘ }

‘$ResultFolder = “./”.”CaptivateResults”;
‘mkdir($ResultFolder);
‘$CompanyFolder = $ResultFolder.”//”.$CompanyName;
‘mkdir($CompanyFolder);
‘$DepartmentFolder = $CompanyFolder.”//”.$DepartmentName;
‘mkdir($DepartmentFolder);
‘$CourseFolder = $DepartmentFolder.”//”.$CourseName;
‘mkdir($CourseFolder);
‘$FilePath = $CourseFolder.”//”.$Filename;
‘$Handle = fopen($FilePath, ‘w’);
‘fwrite($Handle, $Filedata);
‘fclose($Handle);

End Sub
End Class

***************************************************

This is the sql scripts I used to create the tables involved. You will have to change “IntranetWeb” to the name of your

database:

USE [IntranetWeb]
GO

/****** Object: Table [dbo].[capResults] Script Date: 05/08/2012 15:45:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[capResults](
[capResultsID] [int] IDENTITY(1,1) NOT NULL,
[capResultsDate] [datetime] NOT NULL,
[capResultsListOfVars] [varchar](5000) NULL,
[capResultsListOfFormVars] [varchar](5000) NULL,
[capResultsCompanyName] [varchar](50) NULL,
[capResultsDepartmentName] [varchar](50) NULL,
[capResultsCourseName] [varchar](50) NULL,
[capResultsFileName] [varchar](50) NULL,
[capResultsFileData] [varchar](max) NULL,
[capResultsFileUpload] [varchar](max) NULL,
CONSTRAINT [PK_capResults] PRIMARY KEY CLUSTERED
(
[capResultsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS =

ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[capResults] ADD CONSTRAINT [DF_capResults_capResultsDate] DEFAULT (getdate()) FOR [capResultsDate]
GO

USE [IntranetWeb]
GO

/****** Object: Table [dbo].[capDataHeader] Script Date: 05/08/2012 15:46:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[capDataHeader](
[capDataHeaderID] [int] IDENTITY(1,1) NOT NULL,
[capResultsID] [int] NULL,
[capDataHeaderCompanyName] [varchar](50) NULL,
[capDataHeaderDepartmentName] [varchar](50) NULL,
[capDataHeaderCourseName] [varchar](50) NULL,
[capDataHeaderLearnerName] [varchar](50) NULL,
[capDataHeaderLearnerID] [varchar](50) NULL,
[capDataHeaderLessonName] [varchar](50) NULL,
[capDataHeaderQuizAttempts] [int] NULL,
[capDataHeaderTotalQuestions] [int] NULL,
[capDataHeaderStatus] [varchar](50) NULL,
[capDataHeaderLocation] [varchar](50) NULL,
[capDataHeaderRawScore] [int] NULL,
[capDataHeaderMaxScore] [int] NULL,
[capDataHeaderMinScore] [int] NULL,
[capDataHeaderSessionTime] [datetime] NULL,
CONSTRAINT [PK_capDataHeader] PRIMARY KEY CLUSTERED
(
[capDataHeaderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS =

ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

USE [IntranetWeb]
GO

/****** Object: Table [dbo].[capData] Script Date: 05/08/2012 15:46:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[capData](
[capDataID] [bigint] IDENTITY(1,1) NOT NULL,
[capDataHeaderID] [int] NOT NULL,
[capDataInteractionDateTime] [datetime] NOT NULL,
[capDataInteractionID] [int] NULL,
[capDataObjectiveID] [varchar](50) NULL,
[capDataInteractionType] [varchar](50) NULL,
[capDataCorrectResponse] [varchar](50) NULL,
[capDataStudentResponse] [varchar](50) NULL,
[capDataResult] [varchar](50) NULL,
[capDataWeight] [int] NULL,
[capDataLatency] [datetime] NULL,
[capDataAttempt] [int] NULL,
CONSTRAINT [PK_capData] PRIMARY KEY CLUSTERED
(
[capDataID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS =

ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Like
(1)
>
Anonymous
's comment
2012-05-09 10:30:00
2012-05-09 10:30:00
>
Anonymous
's comment

Ofir, thanks for sharing the vb.net solution for internal server (alternate) reporting in #AdobeCaptivate

Ofir, thanks for sharing the vb.net solution for internal server (alternate) reporting in #AdobeCaptivate

Like
2012-05-04 02:14:00
2012-05-04 02:14:00

Does anyone know if there is a way to edit the 2 questions being asked in the Post Results prompt? Currently it asks for Name and Email Address. I'd like to ask for 2 different variables if possible, but cant find where the code files are for that specific prompt.

Does anyone know if there is a way to edit the 2 questions being asked in the Post Results prompt? Currently it asks for Name and Email Address. I’d like to ask for 2 different variables if possible, but cant find where the code files are for that specific prompt.

Like
2012-04-24 01:56:00
2012-04-24 01:56:00

Hello, I just upgraded to Captivate 5.5 from Captivate 4.0. We embed our courses in our internal intranet and have set it up so that when the user clicks the submit e-mail button the score is posted to our intranet. Now that I have upgraded to 5.5 it makes the user click the "send e-mail" button twice in order for the score to post. Can you suggest how I might set up the configurations so that the user only needs to click the send e-mail button once. The intranet programmer at our company would not like to use the internal server option because this option just sends information to a page on a web server and our courses are embedded within the intranet using JavaScript. Any suggestions you can give so that the users don't have to click the "send e-mail" button twice in order for the results to post would be much appreciated! Thank you!

Hello,

I just upgraded to Captivate 5.5 from Captivate 4.0. We embed our courses in our internal intranet and have set it up so that when the user clicks the submit e-mail button the score is posted to our intranet. Now that I have upgraded to 5.5 it makes the user click the “send e-mail” button twice in order for the score to post. Can you suggest how I might set up the configurations so that the user only needs to click the send e-mail button once.

The intranet programmer at our company would not like to use the internal server option because this option just sends information to a page on a web server and our courses are embedded within the intranet using JavaScript.

Any suggestions you can give so that the users don’t have to click the “send e-mail” button twice in order for the results to post would be much appreciated! Thank you!

Like
2012-03-25 17:08:17
2012-03-25 17:08:17

[...] https://elearning.adobe.com/2010/08/reporting-the-quiz-results-to -a-local-server.html#comment-... [...]

[…] https://elearning.adobe.com/2010/08/reporting-the-quiz-results-to -a-local-server.html#comment-… […]

Like
2012-03-22 00:52:47
2012-03-22 00:52:47

[...] popular authoring tool such as Adobe Captivate and embed those tests into your course. You can even configure Captivate to display the test results to the learner. The problem with this approach is getting reports for all learners in an easy and [...]

[…] popular authoring tool such as Adobe Captivate and embed those tests into your course. You can even configure Captivate to display the test results to the learner. The problem with this approach is getting reports for all learners in an easy and […]

Like
2012-03-08 12:10:31
2012-03-08 12:10:31

[...] Some details about how to set up this solution can be found here: https://elearning.adobe.com/2010/08/reporting-the-quiz-results-to -a-local-server.html [...]

[…] Some details about how to set up this solution can be found here: https://elearning.adobe.com/2010/08/reporting-the-quiz-results-to -a-local-server.html […]

Like
2012-02-22 07:39:49
2012-02-22 07:39:49
Like
2011-12-23 22:32:00
2011-12-23 22:32:00

Is there a way for this to just do generic HTTP post (standard parm names) without having to call specific php script to save the results? That would make things much easier.

Is there a way for this to just do generic HTTP post (standard parm names) without having to call specific php script to save the results? That would make things much easier.

Like
2011-12-09 22:07:00
2011-12-09 22:07:00

Is there a way to automatically post the results without the user having to click the X on the upper right hand corner..... currently I have an assessment posted on a site, when the assessment ends the use sees his/her score and if they DO NOT click the X the score doesn't get posted to our spreadsheet..... Can anybody help with me this?

Is there a way to automatically post the results without the user having to click the X on the upper right hand corner….. currently I have an assessment posted on a site, when the assessment ends the use sees his/her score and if they DO NOT click the X the score doesn’t get posted to our spreadsheet….. Can anybody help with me this?

Like
2011-10-27 23:58:00
2011-10-27 23:58:00

I blogged about how to do this with Ruby on Rails. http://leveton.blogspot.com/2011/10/publish-adobe-captivate-results-with.html

I blogged about how to do this with Ruby on Rails.
http://leveton.blogspot.com/2011/10/publish-adobe-captivate-results-with.html

Like
2011-10-20 00:40:00
2011-10-20 00:40:00

Great post. It mentions that ASP can be used instead of PHP. Has anyone done this? Are ASP scripts available from Adobe or from the Captivate community?

Great post. It mentions that ASP can be used instead of PHP. Has anyone done this? Are ASP scripts available from Adobe or from the Captivate community?

Like
2011-10-13 03:29:00
2011-10-13 03:29:00

Is there a way to automatically post the results without the user having to explicitly post the results. I have a user account system already in place and have access to the userid and e-mail either through PHP from a database or javascript. I would like to submit the quiz results to a database after the user completes the entire presentation or when they close the windows.

Is there a way to automatically post the results without the user having to explicitly post the results. I have a user account system already in place and have access to the userid and e-mail either through PHP from a database or javascript. I would like to submit the quiz results to a database after the user completes the entire presentation or when they close the windows.

Like
(6)
>
Anonymous
's comment
2011-10-13 10:36:00
2011-10-13 10:36:00
>
Anonymous
's comment

Hi Stephen, this is not possible in the current version. You can definitely go ahead and log an enhancement request for the use case.

Hi Stephen, this is not possible in the current version. You can definitely go ahead and log an enhancement request for the use case.

Like
>
Anonymous
's comment
2011-10-22 04:38:00
2011-10-22 04:38:00
>
Anonymous
's comment

How do I log an enhancement request? Is there a workaround that I could implement by modifying the CaptivateMaintimeline.as or other file on my local Captivate install (MacOS). What I would like to do is have the results auto submitted when the user exits explicitly or when they close the presentation. In my case, I am actually displaying the .swf in a on my main page as a .swf object. I guess I would have to pass the close event to the SWF somehow?

How do I log an enhancement request?

Is there a workaround that I could implement by modifying the CaptivateMaintimeline.as or other file on my local Captivate install (MacOS). What I would like to do is have the results auto submitted when the user exits explicitly or when they close the presentation. In my case, I am actually displaying the .swf in a on my main page as a .swf object. I guess I would have to pass the close event to the SWF somehow?

Like
>
Anonymous
's comment
2011-11-22 00:10:00
2011-11-22 00:10:00
>
Anonymous
's comment

Stephen, Did you find a solution for this? I would like to acomplish the same thing.

Stephen, Did you find a solution for this? I would like to acomplish the same thing.

Like
>
Anonymous
's comment
2011-11-22 09:30:00
2011-11-22 09:30:00
>
Anonymous
's comment

Hi Stephen, you can log an enhancement request here: https://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

Hi Stephen, you can log an enhancement request here: https://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

Like
>
Anonymous
's comment
2011-12-23 03:10:00
2011-12-23 03:10:00
>
Anonymous
's comment

I am also interested in knowing the resolution of this. I will be fine with having the submit button there as long as they can get rid of the pop up box that asks for name and email address.

I am also interested in knowing the resolution of this. I will be fine with having the submit button there as long as they can get rid of the pop up box that asks for name and email address.

Like
>
Anonymous
's comment
2012-11-27 02:41:00
2012-11-27 02:41:00
>
Anonymous
's comment

Did anyone find a solution for this?

Did anyone find a solution for this?

Like
2011-10-03 20:05:00
2011-10-03 20:05:00

Can you do this in Captivate 4? I need to get test results into a spreadsheet. If possible point me to any "step by steps" Reason I'm having to do this - our current LMS doesn't allow us to capture the level of detail we need - expecially for a group of people who do not have logins to our LMS right now. Yes, we will eventually be upgrading (to OracleLMS) but I need a robust interim solution,now. BTW - I'm not a techy and have never done JS so an a real novice Thanks Jenni_NT

Can you do this in Captivate 4?
I need to get test results into a spreadsheet. If possible point me to any “step by steps”

Reason I’m having to do this – our current LMS doesn’t allow us to capture the level of detail we need – expecially for a group of people who do not have logins to our LMS right now.
Yes, we will eventually be upgrading (to OracleLMS) but I need a robust interim solution,now.
BTW – I’m not a techy and have never done JS so an a real novice
Thanks
Jenni_NT

Like
(2)
>
Anonymous
's comment
2011-10-04 12:47:00
2011-10-04 12:47:00
>
Anonymous
's comment

Hi Jenni, the alternate reporting function was only introduced in Captivate 5. In Captivate 4, you could try the email reporting function- but this still doesn't get your results into a spreadsheet automatically.

Hi Jenni, the alternate reporting function was only introduced in Captivate 5. In Captivate 4, you could try the email reporting function- but this still doesn’t get your results into a spreadsheet automatically.

Like
>
Anonymous
's comment
2011-10-15 05:47:00
2011-10-15 05:47:00
>
Anonymous
's comment

Jenni, you need the Variables to Google Form widget. It populates a Google Form which in turn populates a Google Spreadsheet. We are using it as an interim way to collect scores etc. until our LMS is fully deployed. It can be a pain to get it working, but it works reliably thereafter. You can get it for Captivate 4 here: http://captivatedev.com/2010/03/10/captivate-4-widget-cp-variables-to-google-form/

Jenni, you need the Variables to Google Form widget. It populates a Google Form which in turn populates a Google Spreadsheet. We are using it as an interim way to collect scores etc. until our LMS is fully deployed. It can be a pain to get it working, but it works reliably thereafter. You can get it for Captivate 4 here: http://captivatedev.com/2010/03/10/captivate-4-widget-cp-variables-to-google-form/

Like
2011-09-15 22:32:00
2011-09-15 22:32:00

what needs to be set up so that the module talks to the web server? how is the data put into the web server and in what format? has anyone successfully set this up?

what needs to be set up so that the module talks to the web server? how is the data put into the web server and in what format?
has anyone successfully set this up?

Like
2011-09-15 22:28:00
2011-09-15 22:28:00

we are setting this up and need to have the full list of steps as in many of the blogs it is not straightforward. does anyone have steps to share when using the internal web server? if you have any tips on pitfalls, challenges this is most appreciated.

we are setting this up and need to have the full list of steps as in many of the blogs it is not straightforward. does anyone have steps to share when using the internal web server? if you have any tips on pitfalls, challenges this is most appreciated.

Like
2011-09-14 17:24:00
2011-09-14 17:24:00

Hello, It seems that users that receive the libnk for the quiz have to have an Acrobat.com account in order to send their results? THank you, Rodica

Hello,

It seems that users that receive the libnk for the quiz have to have an Acrobat.com account in order to send their results?

THank you,
Rodica

Like
2011-09-14 17:24:00
2011-09-14 17:24:00

Hello, It seems that users that receive the libnk for the quiz have to have an Acrobat.com account in order to send their results? THank you, Rodica

Hello,

It seems that users that receive the libnk for the quiz have to have an Acrobat.com account in order to send their results?

THank you,
Rodica

Like
2011-08-27 18:11:00
2011-08-27 18:11:00

how can you make the post button go away after posting to prevent others from claiming same score. kirby

how can you make the post button go away after posting to prevent others from claiming same score. kirby

Like
2011-08-08 14:52:00
2011-08-08 14:52:00

Hi I am trying to use the Email as the reporting system, but unfortunately this doenst seem tobe working. I have downloaded Captivate 5 free trail and I have taken online training and its says its as easy as 1) enable reprting ) enter email address 3) chooses reporting options and ok but nothing comes through? Im not sure why this int working can anyone help. I have also tried Acrobat.com and this isnt working either.

Hi I am trying to use the Email as the reporting system, but unfortunately this doenst seem tobe working. I have downloaded Captivate 5 free trail and I have taken online training and its says its as easy as 1) enable reprting ) enter email address 3) chooses reporting options and ok but nothing comes through? Im not sure why this int working can anyone help. I have also tried Acrobat.com and this isnt working either.

Like
(1)
>
Anonymous
's comment
2012-03-19 22:37:00
2012-03-19 22:37:00
>
Anonymous
's comment

Did you ever figure out how to do this? I'm having the same issues....

Did you ever figure out how to do this? I’m having the same issues….

Like
2011-06-06 06:37:18
2011-06-06 06:37:18

How do I save text entry box information to file? I want to review my short answers separately.

How do I save text entry box information to file? I want to review my short answers separately.

Like
2011-05-31 20:37:11
2011-05-31 20:37:11

Using Adobe Captivate 5 with an internal reporting server which is configured properly for PHP using IIS 6. I can create the XML files all day long but the quiz results analyzer will not generate the report even though it does find the "Organization", "Department", and "Course" values from the directory structure. When I click "Generate Report", I get the message saying "Data not found on the local file system" etc When I try and view the report using Source as "From this computer", it will load the XML files data just fine. Any suggestions? Any help would be appreciated! Thanks

Using Adobe Captivate 5 with an internal reporting server which is configured properly for PHP using IIS 6. I can create the XML files all day long but the quiz results analyzer will not generate the report even though it does find the “Organization”, “Department”, and “Course” values from the directory structure. When I click “Generate Report”, I get the message saying “Data not found on the local file system” etc
When I try and view the report using Source as “From this computer”, it will load the XML files data just fine.
Any suggestions?
Any help would be appreciated! Thanks

Like
2011-05-09 22:39:52
2011-05-09 22:39:52

Since I was not able to use ColdFusion to process the results I am now using the provided PHP file on a PHP Server. Works fine when the quiz is located on the same domain as the php server. Is there a way to make this work though were the quiz is located on one server and the PHP file on another?

Since I was not able to use ColdFusion to process the results I am now using the provided PHP file on a PHP Server. Works fine when the quiz is located on the same domain as the php server. Is there a way to make this work though were the quiz is located on one server and the PHP file on another?

Like
(1)
>
Anonymous
's comment
2011-05-12 17:30:43
2011-05-12 17:30:43
>
Anonymous
's comment

Stephen, this is an enhancement request. I'm forwarding it to wish-captivate. You can of course edit the PHP file(s) yourself as well, but i don't know the issues involved. My guess is there may also be a need for a change in the published SWF, and of course you'd need a x-domain policy on the server.

Stephen, this is an enhancement request. I’m forwarding it to wish-captivate. You can of course edit the PHP file(s) yourself as well, but i don’t know the issues involved. My guess is there may also be a need for a change in the published SWF, and of course you’d need a x-domain policy on the server.

Like
2011-05-09 21:09:21
2011-05-09 21:09:21

I am trying to have captivate report quiz results to our internal server - SharePoint. Following all instructions I can find, we set up the server correctly and the settings on the quiz are correct. When submiting the results the returned message is successful. However, there are no new files created - no results anywhere. What am I missing???

I am trying to have captivate report quiz results to our internal server – SharePoint. Following all instructions I can find, we set up the server correctly and the settings on the quiz are correct. When submiting the results the returned message is successful. However, there are no new files created – no results anywhere. What am I missing???

Like
(1)
>
Anonymous
's comment
2011-05-12 17:28:43
2011-05-12 17:28:43
>
Anonymous
's comment

Scott - it sounds like a permissions problem. If the permissions on the PHP scripts aren't sufficient, then it won't have permission to create new files on your server. Try expanding the perms on the PHP script.

Scott – it sounds like a permissions problem. If the permissions on the PHP scripts aren’t sufficient, then it won’t have permission to create new files on your server. Try expanding the perms on the PHP script.

Like
2011-04-27 00:33:59
2011-04-27 00:33:59

If I'm getting to the post results stage and hanging on Connecting.... does anyone know where my problem might lay? Any help appreciated-confused learning designer working with IT person who is managing the script....

If I’m getting to the post results stage and hanging on Connecting…. does anyone know where my problem might lay?
Any help appreciated-confused learning designer working with IT person who is managing the script….

Like
(1)
>
Anonymous
's comment
2011-04-27 01:40:31
2011-04-27 01:40:31
>
Anonymous
's comment

Most likely the *.php file doesn't have the right permisssions. Try giving the file more CHMOD perms.

Most likely the *.php file doesn’t have the right permisssions. Try giving the file more CHMOD perms.

Like
2011-04-14 11:33:42
2011-04-14 11:33:42

Could any one share me the modified internalserverreporting.php file. If so it would be helpful for me. Thanks in advance.

Could any one share me the modified internalserverreporting.php file. If so it would be helpful for me.

Thanks in advance.

Like
2011-04-07 02:27:29
2011-04-07 02:27:29

Hi Allen Yes, I have tried the URL directly from my web browser and it resolves properly. I have even tested posting form results to the same URL and it works fine. Is there something else the Internal Server function needs to return in order for it to connect?

Hi Allen

Yes, I have tried the URL directly from my web browser and it resolves properly. I have even tested posting form results to the same URL and it works fine. Is there something else the Internal Server function needs to return in order for it to connect?

Like
(4)
>
Anonymous
's comment
2011-04-07 03:01:07
2011-04-07 03:01:07
>
Anonymous
's comment

Here is the example quiz published as Flash Player 10: http://training.wonderware.com/quiz/test.htm and it should be posting results to a ColdFusion File here http://training.wonderware.com/quiz/test.cfm The cold fusion file just saves the posted form data to a file. You can go there directly to see that it resolves properly. I have triple checked the captivate file to make sure the URL is correct. Does this require us to use PHP? Is there something that must be returned back to the Quiz for it to say results posted successfully? s

Here is the example quiz published as Flash Player 10:
http://training.wonderware.com/quiz/test.htm

and it should be posting results to a ColdFusion File here
http://training.wonderware.com/quiz/test.cfm

The cold fusion file just saves the posted form data to a file. You can go there directly to see that it resolves properly. I have triple checked the captivate file to make sure the URL is correct. Does this require us to use PHP? Is there something that must be returned back to the Quiz for it to say results posted successfully?

s

Like
>
Anonymous
's comment
2011-04-12 18:23:10
2011-04-12 18:23:10
>
Anonymous
's comment

Could you share the Coldfusion code you're using to capture the results? It would be incredibly helpful and save a huge amount of time.

Could you share the Coldfusion code you’re using to capture the results? It would be incredibly helpful and save a huge amount of time.

Like
>
Anonymous
's comment
2011-04-13 00:47:07
2011-04-13 00:47:07
>
Anonymous
's comment

I was getting this same error, and ended up doing a trace on the connection. Turns out JRun is returning a 501 error because of the following: "Corrupt form data: no leading boundary: != --3141592653 ..." So far, I haven't been able to resolve it.

I was getting this same error, and ended up doing a trace on the connection.

Turns out JRun is returning a 501 error because of the following:

“Corrupt form data: no leading boundary: != –3141592653 …”

So far, I haven’t been able to resolve it.

Like
>
Anonymous
's comment
2011-05-09 22:42:52
2011-05-09 22:42:52
>
Anonymous
's comment

Yeah I dont think its possible. There is something with the way Adobe created the posting application in the quiz that only sends to the php file from whati can gather. there are not supporting docs for it.

Yeah I dont think its possible. There is something with the way Adobe created the posting application in the quiz that only sends to the php file from whati can gather. there are not supporting docs for it.

Like
2011-04-04 23:07:32
2011-04-04 23:07:32

Having problems getting this to work myself. Each time I try posting it shows an error "No Connection" Any idea what that means? Ive tested the URL for my internal server directly and it works fine.

Having problems getting this to work myself. Each time I try posting it shows an error “No Connection” Any idea what that means? Ive tested the URL for my internal server directly and it works fine.

Like
(2)
>
Anonymous
's comment
2011-04-05 06:59:52
2011-04-05 06:59:52
>
Anonymous
's comment

Stephen, most likely you don't have the right URL. Are you referencing via http? Are you sure it resolves? LMK-Allen

Stephen, most likely you don’t have the right URL. Are you referencing via http? Are you sure it resolves? LMK-Allen

Like
>
Allen_Partridge
's comment
2011-04-07 02:32:49
2011-04-07 02:32:49
>
Allen_Partridge
's comment

Does the internal server address have to be on the same server as the quiz/captivate file? Or can it be on any public web server address?

Does the internal server address have to be on the same server as the quiz/captivate file? Or can it be on any public web server address?

Like
2011-04-01 21:42:22
2011-04-01 21:42:22

After diging a lot, I get almost everything works. Now, my only problem is that Quiz Analyser (CS5) is connecting to my internal server, but instead of showing me the datat of the XML file, it just show dot (".") in the Organization/Dept/Course drop-down menu. No datas are retrieved. If I FTP the CaptivateResults directory on my computer and read the file with Quiz Analayser, everything work fine. I gave full permissio to all folders on my website. Any idea? Martin :)

After diging a lot, I get almost everything works. Now, my only problem is that Quiz Analyser (CS5) is connecting to my internal server, but instead of showing me the datat of the XML file, it just show dot (“.”) in the Organization/Dept/Course drop-down menu.

No datas are retrieved.

If I FTP the CaptivateResults directory on my computer and read the file with Quiz Analayser, everything work fine.

I gave full permissio to all folders on my website.

Any idea?

Martin 🙂

Like
2011-03-26 23:01:40
2011-03-26 23:01:40

I just want a way to insert the scores, time taken etc into a mysql database simple right? well there are just no examples of how to accomplish this around the forums This xml file it writes isn't very helpful but then again i can't even get that to work either. in Captivate 4 i used a hacked javascript file for sendmail() to post to a page and insert that into a database but that doenst' work on 5 :(

I just want a way to insert the scores, time taken etc into a mysql database simple right? well there are just no examples of how to accomplish this around the forums

This xml file it writes isn’t very helpful but then again i can’t even get that to work either. in Captivate 4 i used a hacked javascript file for sendmail() to post to a page and insert that into a database but that doenst’ work on 5 🙁

Like
2011-03-11 09:21:45
2011-03-11 09:21:45

greetings, I am trying to find any documentation at all which explains how to collect quiz results by e-mail. Can anybody help me here please?

greetings, I am trying to find any documentation at all which explains how to collect quiz results by e-mail.

Can anybody help me here please?

Like
2011-03-02 06:27:51
2011-03-02 06:27:51

Does anyone have an ASP template for the internal server? I have spent several hours searching for one.

Does anyone have an ASP template for the internal server? I have spent several hours searching for one.

Like
2011-03-01 02:03:50
2011-03-01 02:03:50

Is there a way to have the quiz analyzer show the time it took for a student to go through the quiz? I know this is stored in the XML but would like to be able to pull it from the analyzer

Is there a way to have the quiz analyzer show the time it took for a student to go through the quiz? I know this is stored in the XML but would like to be able to pull it from the analyzer

Like
2011-02-16 19:02:20
2011-02-16 19:02:20

hi, can i use a hosted server as the internal server for reporting. i use 1and1

hi, can i use a hosted server as the internal server for reporting. i use 1and1

Like
(1)
>
Anonymous
's comment
2011-02-18 16:17:40
2011-02-18 16:17:40
>
Anonymous
's comment

Matt, if the hosted server has PHP you should be fine - though you may need to coordinate with the host to ensure everything is working. Just install the two php files into a directory on the server. (Make sure the permissions on the files and the directory are sufficient.)

Matt, if the hosted server has PHP you should be fine – though you may need to coordinate with the host to ensure everything is working. Just install the two php files into a directory on the server. (Make sure the permissions on the files and the directory are sufficient.)

Like
2011-02-09 07:02:00
2011-02-09 07:02:00

Im having a similar problem. I have chosen to report to an internal server, but when I click on post results it just reads "connecting..." with no other msgs. Any ideas how to fix this?

Im having a similar problem. I have chosen to report to an internal server, but when I click on post results it just reads “connecting…” with no other msgs.

Any ideas how to fix this?

Like
(2)
>
Anonymous
's comment
2011-02-23 09:40:41
2011-02-23 09:40:41
>
Anonymous
's comment

I am having this exact problem. It just hangs at "Connecting ..." Is there something that is supposed to be customized in the internalServerReporting.php. Cannot find any examples of this.

I am having this exact problem. It just hangs at “Connecting …” Is there something that is supposed to be customized in the internalServerReporting.php. Cannot find any examples of this.

Like
>
Anonymous
's comment
2011-03-01 02:05:17
2011-03-01 02:05:17
>
Anonymous
's comment

Check the url you are using. I ran into this problem when students didn't have the www. in the url and the reporting does.

Check the url you are using. I ran into this problem when students didn’t have the www. in the url and the reporting does.

Like
2011-02-05 15:39:29
2011-02-05 15:39:29

I've set up a quiz in Captivate 5. I created a second adobe id so I could test the quiz. I take the quiz but when I try to post the results I get message "Network may not be available" any one have this same problem

I’ve set up a quiz in Captivate 5. I created a second adobe id so I could test the quiz. I take the quiz but when I try to post the results I get message “Network may not be available” any one have this same problem

Like
2011-02-04 01:32:49
2011-02-04 01:32:49

How large will the results files be? We have about 200 users and I need to make sure my web server will be able to store all of the results.

How large will the results files be? We have about 200 users and I need to make sure my web server will be able to store all of the results.

Like
(1)
>
Anonymous
's comment
2011-02-04 19:15:53
2011-02-04 19:15:53
>
Anonymous
's comment

Results are in tiny xml files. It's just text data so no need to worry about even hundreds of thousands of records.

Results are in tiny xml files. It’s just text data so no need to worry about even hundreds of thousands of records.

Like
2011-01-28 04:02:50
2011-01-28 04:02:50

I have been trying to get the quiz results to post to my acrobat.com account with little success. When others post their quiz results they are requested to enter the email address and password to my account at acrobat.com. Is this how the reporting is suppose to work when using acrobat.com?

I have been trying to get the quiz results to post to my acrobat.com account with little success. When others post their quiz results they are requested to enter the email address and password to my account at acrobat.com. Is this how the reporting is suppose to work when using acrobat.com?

Like
(2)
>
Anonymous
's comment
2011-01-28 04:58:17
2011-01-28 04:58:17
>
Anonymous
's comment

Hi Terra. When learners take the quiz the system asks them for 'their' Adobe ID to login to acrobat.com - not for yours. The system will post to your account, but asks them for their login info. You can use alternate reporting if you want to avoid forcing your learners to have Aadobe ID's. In the alternate reporting paradigm, you put the php scripts provided on your own server, and the data is loaded to your custom server. Users are prompted in that model for a login email rather than an Adobe ID. Hope this helps, Allen.

Hi Terra. When learners take the quiz the system asks them for ‘their’ Adobe ID to login to acrobat.com – not for yours. The system will post to your account, but asks them for their login info. You can use alternate reporting if you want to avoid forcing your learners to have Aadobe ID’s. In the alternate reporting paradigm, you put the php scripts provided on your own server, and the data is loaded to your custom server. Users are prompted in that model for a login email rather than an Adobe ID. Hope this helps, Allen.

Like
>
Allen_Partridge
's comment
2011-01-29 01:25:26
2011-01-29 01:25:26
>
Allen_Partridge
's comment

Hi Allen. I thought there was a way for my acrobat.com account to be saved like a default. That way when individuals report they just hit the report button and it automatically goes to my acrobat.com account without them entering anything. Is there a way to do this? If so, can you please instruct me how to do it? I really don't want a huge amount of individuals having to sign up for acrobat.com just for this. Thanks for your help. Terra

Hi Allen. I thought there was a way for my acrobat.com account to be saved like a default. That way when individuals report they just hit the report button and it automatically goes to my acrobat.com account without them entering anything. Is there a way to do this? If so, can you please instruct me how to do it? I really don’t want a huge amount of individuals having to sign up for acrobat.com just for this. Thanks for your help. Terra

Like
2010-12-07 14:14:45
2010-12-07 14:14:45

I have used the Internal Server option and can see my results in the xml file. When the Post results option is selected, a popup comes up asking for the user id and email address. This information can be seen in the resulting xml too. But because this quiz will be made available through our internal website where the user would have to login - we already have the user information - and hence would not like him to enter the information twice. How do we disable the popup? Also the control from the Post Results button goes to Action Script? We have AS3 programming capability in the team - Is that something we can modify in a way that every quiz we publlish using Captivate has the same functionality behind the Post Results button? If yes, can I get some pointers on how to approach this? Sharad

I have used the Internal Server option and can see my results in the xml file. When the Post results option is selected, a popup comes up asking for the user id and email address. This information can be seen in the resulting xml too.
But because this quiz will be made available through our internal website where the user would have to login – we already have the user information – and hence would not like him to enter the information twice.
How do we disable the popup?

Also the control from the Post Results button goes to Action Script? We have AS3 programming capability in the team – Is that something we can modify in a way that every quiz we publlish using Captivate has the same functionality behind the Post Results button? If yes, can I get some pointers on how to approach this?

Sharad

Like
(2)
>
Anonymous
's comment
2011-04-14 14:40:16
2011-04-14 14:40:16
>
Anonymous
's comment

Hi Sharad, Can you please share me the internalreporting.php. I need to check my results through internal server. Can you please help me regarding this.

Hi Sharad,

Can you please share me the internalreporting.php. I need to check my results through internal server. Can you please help me regarding this.

Like
>
Anonymous
's comment
2011-12-02 20:50:00
2011-12-02 20:50:00
>
Anonymous
's comment

Did you ever find a solution to disable the popup? We're having the same issue.

Did you ever find a solution to disable the popup? We’re having the same issue.

Like
2010-12-07 12:41:39
2010-12-07 12:41:39

Can anyone help me with the solution to disable/ customize the 'Post Resuts(prompting to enter name and email)' popup that comes after a Quiz is taken ?

Can anyone help me with the solution to disable/ customize the ‘Post Resuts(prompting to enter name and email)’ popup that comes after a Quiz is taken ?

Like
2010-11-20 00:09:51
2010-11-20 00:09:51

I have modified the interserverReporting.php script that ships with Captivate 5 to report the results to a MySQL database with some success. The problem I'm having has to do with the message that displays to the user when the click the Submit button. i would like to customize the text that appears in the popup and somehow disable the submit button after the user clicks it so that they don't resubmit multiple times. Anyone have ideas on where to look to do this?

I have modified the interserverReporting.php script that ships with Captivate 5 to report the results to a MySQL database with some success. The problem I’m having has to do with the message that displays to the user when the click the Submit button. i would like to customize the text that appears in the popup and somehow disable the submit button after the user clicks it so that they don’t resubmit multiple times. Anyone have ideas on where to look to do this?

Like
(3)
>
Anonymous
's comment
2011-03-03 17:54:19
2011-03-03 17:54:19
>
Anonymous
's comment

Hi Kevin, You say that you have had some success modifying the interserverReporting.php script to report the results to a MySQL database. Can you give me some pointers on this, i am a complete novice when it comes to scripting!!

Hi Kevin,

You say that you have had some success modifying the interserverReporting.php script to report the results to a MySQL database. Can you give me some pointers on this, i am a complete novice when it comes to scripting!!

Like
>
Anonymous
's comment
2011-04-20 19:13:19
2011-04-20 19:13:19
>
Anonymous
's comment

Hi Kevin..Please could you explain better on how you setup the results to be posted to a mysql database. please it is really urgent. I will appreciate your cooperation, cheers

Hi Kevin..Please could you explain better on how you setup the results to be posted to a mysql database. please it is really urgent. I will appreciate your cooperation, cheers

Like
>
Anonymous
's comment
2011-06-26 09:55:00
2011-06-26 09:55:00
>
Anonymous
's comment

can you give as a sample script

can you give as a sample script

Like
2010-11-11 18:21:19
2010-11-11 18:21:19

I am wondering how I can capture the users name when capturing the results and sending them the this web server?? Can anybody help me here??

I am wondering how I can capture the users name when capturing the results and sending them the this web server??

Can anybody help me here??

Like
(1)
>
Anonymous
's comment
2011-03-24 21:59:28
2011-03-24 21:59:28
>
Anonymous
's comment

Hi Derek, what I've done is created an ungraded quiz question that prompts the user to enter in their personal information. This way it will populate their info with the rest of the quiz results. This is the only solution I've come up with so far...hope this helps!

Hi Derek, what I’ve done is created an ungraded quiz question that prompts the user to enter in their personal information. This way it will populate their info with the rest of the quiz results.

This is the only solution I’ve come up with so far…hope this helps!

Like
2010-11-01 23:15:44
2010-11-01 23:15:44

Has anyone tried saving the quiz data via ColdFusion? Specifically, I'm wondering what are the Captivate quiz parameters that are passed out of Captivate to the cfc or cfm page.

Has anyone tried saving the quiz data via ColdFusion? Specifically, I’m wondering what are the Captivate quiz parameters that are passed out of Captivate to the cfc or cfm page.

Like
(3)
>
Anonymous
's comment
2011-01-11 03:23:19
2011-01-11 03:23:19
>
Anonymous
's comment

Has anyone ever given you a pointer on how to send the data to a CFC or CFM page?

Has anyone ever given you a pointer on how to send the data to a CFC or CFM page?

Like
>
Anonymous
's comment
2011-04-07 02:41:57
2011-04-07 02:41:57
>
Anonymous
's comment

Been trying using Coldfusion and cannot get it to post data. but I also cannot get it to work with the provided PHP example either. It just says "Connecting..." when trying use the PHP and No Connection when tryin to use the CFM file. ug... So frustrating, wish there was some help on this.

Been trying using Coldfusion and cannot get it to post data. but I also cannot get it to work with the provided PHP example either. It just says “Connecting…” when trying use the PHP and No Connection when tryin to use the CFM file. ug… So frustrating, wish there was some help on this.

Like
>
Anonymous
's comment
2011-04-07 22:28:10
2011-04-07 22:28:10
>
Anonymous
's comment

Hey Curt or anyone, does this work with ColdFusion? I cant get it to even post to the cfm page at all.

Hey Curt or anyone, does this work with ColdFusion? I cant get it to even post to the cfm page at all.

Like
2010-10-29 19:59:14
2010-10-29 19:59:14

Does anyone know of the script that the Post Results button calls so it could be automated to run on screen exit? Or perhaps a way of customising the Post Results popup box?

Does anyone know of the script that the Post Results button calls so it could be automated to run on screen exit?

Or perhaps a way of customising the Post Results popup box?

Like
2010-10-21 23:44:27
2010-10-21 23:44:27

like so many, i have worked thru a couple of challenges to get Results to and from a local server. The results do post, and can be verified as on the server. However, when I attempt to retrieve them via the Quiz Analyzer, I get a " Download could not be completed" error. Any ideas as to how to correct??

like so many, i have worked thru a couple of challenges to get Results to and from a local server. The results do post, and can be verified as on the server. However, when I attempt to retrieve them via the Quiz Analyzer, I get a ” Download could not be completed” error. Any ideas as to how to correct??

Like
2010-10-21 12:27:21
2010-10-21 12:27:21

I am new to Captivate 5 and still learning. While creating the Quiz was pretty easy, how do we also capture the learners name or id so we know "who" answered the quiz?

I am new to Captivate 5 and still learning.
While creating the Quiz was pretty easy, how do we also capture the learners name or id so we know “who” answered the quiz?

Like
(3)
>
Anonymous
's comment
2010-10-22 07:23:57
2010-10-22 07:23:57
>
Anonymous
's comment

In Quiz Preferences, you are going to indicate wheter you will create results at Acrobat.com or and Internal server. Once the quiz is taken, you can view results utilizing the Quiz Results Analyzer. That will give you the information you are looking for.

In Quiz Preferences, you are going to indicate wheter you will create results at Acrobat.com or and Internal server. Once the quiz is taken, you can view results utilizing the Quiz Results Analyzer. That will give you the information you are looking for.

Like
>
Anonymous
's comment
2010-10-28 20:17:55
2010-10-28 20:17:55
>
Anonymous
's comment

I'm curious, how will it give information the quiz itself doesn't ask for? If the user is taking this via a browser, I don't understand how it's going record any personal information about the taker. I need the user and department information on my quizzes. Previously I used Cap 3 and dumped results to a DB. In that case I used a pop up html page to have the user enter their information before hitting a submit button.

I’m curious, how will it give information the quiz itself doesn’t ask for? If the user is taking this via a browser, I don’t understand how it’s going record any personal information about the taker. I need the user and department information on my quizzes. Previously I used Cap 3 and dumped results to a DB. In that case I used a pop up html page to have the user enter their information before hitting a submit button.

Like
>
Anonymous
's comment
2011-03-24 21:58:11
2011-03-24 21:58:11
>
Anonymous
's comment

@Anthony, I wondered this as well. I published to acrobat.com at first to see what the output would be and it only assigned displayed the users by their adobeID. I don't want my users to have to sign up for Adobe just to be able to post their results so I've decied to go the internal server route. What I ended up doing to identify the test taker was creating an ungraded question where the users could enter in their personal info. This would allow the responses to this question to be populated with the rest of the course test results. I hope this helps although I know I'm seeing this quite late!

@Anthony, I wondered this as well. I published to acrobat.com at first to see what the output would be and it only assigned displayed the users by their adobeID. I don’t want my users to have to sign up for Adobe just to be able to post their results so I’ve decied to go the internal server route. What I ended up doing to identify the test taker was creating an ungraded question where the users could enter in their personal info. This would allow the responses to this question to be populated with the rest of the course test results. I hope this helps although I know I’m seeing this quite late!

Like
2010-09-30 18:16:32
2010-09-30 18:16:32

No, the Send Email button (in the pdf doc) didn't work for us in Captivate 5, either.

No, the Send Email button (in the pdf doc) didn’t work for us in Captivate 5, either.

Like
2010-09-23 00:56:50
2010-09-23 00:56:50

We are thinking of using the WAMP server for our internal training program which will need to process requests and store results from about 150 users. We would like to know whether or not the WAMP server with default configurations can handle such load and process the requests successfully. Also, can we rely on this opensource WAMP sever for our proffessional use?

We are thinking of using the WAMP server for our internal training program which will need to process requests and store results from about 150 users. We would like to know whether or not the WAMP server with default configurations can handle such load and process the requests successfully. Also, can we rely on this opensource WAMP sever for our proffessional use?

Like
(1)
>
Anonymous
's comment
2010-09-30 01:56:11
2010-09-30 01:56:11
>
Anonymous
's comment

@Rachel The WAMP(or XAMPP) suggestion is for a developer configured setup of a PHP/MySQL/Apache server. I wouldn't advise using this outside of a secure internal network. I run a XAMPP server locally on my computer as well as on a test server in our companies network. If planning on deploying a production server (internal or external) with a PHP/MySQL/Apache setup I would consult an IT professional. Most web hosting packages are based on a PHP/MySQL setup the other being ASP/MSSQL. MySQL isn't the end all be all for databases. My IT department uses Microsoft SQL. It all depends on the connection string given to PHP or ASP in which database the script talks to. Some commands within the script may have to change to accommodate the database of choice.

@Rachel
The WAMP(or XAMPP) suggestion is for a developer configured setup of a PHP/MySQL/Apache server. I wouldn’t advise using this outside of a secure internal network. I run a XAMPP server locally on my computer as well as on a test server in our companies network. If planning on deploying a production server (internal or external) with a PHP/MySQL/Apache setup I would consult an IT professional. Most web hosting packages are based on a PHP/MySQL setup the other being ASP/MSSQL.

MySQL isn’t the end all be all for databases. My IT department uses Microsoft SQL. It all depends on the connection string given to PHP or ASP in which database the script talks to. Some commands within the script may have to change to accommodate the database of choice.

Like
2010-09-08 21:43:03
2010-09-08 21:43:03

Captivate 4 only supported the Send Email button if the course was viewed in html. Will Captivate 5 Alternate Reporting work if the student views the course in PDF?

Captivate 4 only supported the Send Email button if the course was viewed in html.
Will Captivate 5 Alternate Reporting work if the student views the course in PDF?

Like
2010-09-03 23:41:42
2010-09-03 23:41:42

I have followed the instructions for the internal server and even though I publish to the local folder, I don't see the "automatic folder" appearing for Captivate Results. Please advise!! I'm in a hurry! 206-992-4446 Thank you!!

I have followed the instructions for the internal server and even though I publish to the local folder, I don’t see the “automatic folder” appearing for Captivate Results. Please advise!! I’m in a hurry! 206-992-4446 Thank you!!

Like
2010-09-03 22:43:31
2010-09-03 22:43:31

Initially we were able to use the alternate quiz reporting feature successfully. There is currently an error code that comes up when we try to post results after a quiz.. "Unknown Error' is shown after the student name and email address are entered. Is there a way to trace back what this error message means?

Initially we were able to use the alternate quiz reporting feature successfully. There is currently an error code that comes up when we try to post results after a quiz.. “Unknown Error’ is shown after the student name and email address are entered. Is there a way to trace back what this error message means?

Like
2010-09-03 22:36:29
2010-09-03 22:36:29

Our training group has the same question as Mike's August 13th post. Is there a way to have the student's results posted automatically?

Our training group has the same question as Mike’s August 13th post. Is there a way to have the student’s results posted automatically?

Like
2010-08-23 19:20:59
2010-08-23 19:20:59

I currently have a website that uses Captivate 3 and I post the results to a database on my website server using the post results by email tutorial and sending to a database. The issue that I have is that I need the full test posted which includes the questions and answers to the questions along with if they are right or wrong. Rihgt now I only get the results which includes the letter before the answer and a C or W if right or wrong. Will Captivate 5 fix this issue? If so, then I will upgrade

I currently have a website that uses Captivate 3 and I post the results to a database on my website server using the post results by email tutorial and sending to a database. The issue that I have is that I need the full test posted which includes the questions and answers to the questions along with if they are right or wrong.
Rihgt now I only get the results which includes the letter before the answer and a C or W if right or wrong.
Will Captivate 5 fix this issue? If so, then I will upgrade

Like
2010-08-23 14:58:46
2010-08-23 14:58:46
Like
(14)
>
Anonymous
's comment
2011-03-20 07:51:19
2011-03-20 07:51:19
>
Anonymous
's comment

*IF YOU ARE HAVING PROBLEMS ON AN INTERNAL SERVER, READ THIS* Sorry to shout for your attention, but sometimes it's necessary. :) Sorry, but that's wrong Rob. You will not get an error back if you do that, but you will also not get any information back either. (Since it doesn't do anything when it runs the script, no error message.) If they do that, then they will get nothing back from the report. Here's the secret sauce that is missing for most people: For most servers, you need to specify a value for the mkdir function. Open up the internalServerReporting.php file in a text pad or Dreamweaver. If you don't have Dreamweaver and are on Windows, I recommend Notepad ++. Go to line 36. It will say: "mkdir($ResultFolder);" Remove the quotations. But that's wrong for most servers. This is because there is no permission setting specified, and most servers by default do not allow just anyone to start writing files and making directors on them. To fix this, type this in: "mkdir($ResultFolder, 0777);" This gives you permission to write into that folder and file. Now, if you're running it locally, the configuration will be: http://localhost/(folder_you_name)/internalServerReporting.php Add in the permissions, point to the correct php script, and you'll get back an XML file.

*IF YOU ARE HAVING PROBLEMS ON AN INTERNAL SERVER, READ THIS*

Sorry to shout for your attention, but sometimes it’s necessary. 🙂

Sorry, but that’s wrong Rob. You will not get an error back if you do that, but you will also not get any information back either. (Since it doesn’t do anything when it runs the script, no error message.) If they do that, then they will get nothing back from the report.

Here’s the secret sauce that is missing for most people:

For most servers, you need to specify a value for the mkdir function. Open up the internalServerReporting.php file in a text pad or Dreamweaver. If you don’t have Dreamweaver and are on Windows, I recommend Notepad ++. Go to line 36. It will say:

“mkdir($ResultFolder);”

Remove the quotations. But that’s wrong for most servers. This is because there is no permission setting specified, and most servers by default do not allow just anyone to start writing files and making directors on them. To fix this, type this in:

“mkdir($ResultFolder, 0777);”

This gives you permission to write into that folder and file. Now, if you’re running it locally, the configuration will be:

http://localhost/(folder_you_name)/internalServerReporting.php

Add in the permissions, point to the correct php script, and you’ll get back an XML file.

Like
>
Anonymous
's comment
2011-03-20 08:18:10
2011-03-20 08:18:10
>
Anonymous
's comment

Just found out, they put a video on it on adobe.tv that shows exactly how to do it: https://tv.adobe.com/watch/publish-and-track-results/reporting-using-lms-or-internal-server/

Just found out, they put a video on it on adobe.tv that shows exactly how to do it:

https://tv.adobe.com/watch/publish-and-track-results/reporting-using-lms-or-internal-server/

Like
>
Anonymous
's comment
2013-11-19 21:46:00
2013-11-19 21:46:00
>
Anonymous
's comment

THANK YOU!!! This made it so much easier!!

THANK YOU!!! This made it so much easier!!

Like
>
Anonymous
's comment
2017-03-06 01:55:43
2017-03-06 01:55:43
>
Anonymous
's comment

Sir, I can't open the video.

Sir, I can’t open the video.

Like
>
Anonymous
's comment
2017-03-06 01:56:27
2017-03-06 01:56:27
>
Anonymous
's comment

Sir, In captivate 9 how can we publish and track results reporting using internal server??

Sir,

In captivate 9 how can we publish and track results reporting using internal server??

Like
>
OliverT05
's comment
2017-03-07 10:19:26
2017-03-07 10:19:26
>
OliverT05
's comment

Hi Oliver, Trust you are doing well. Publishing and tracking results using an internal server is a multi-step process: 1. Set the reporting preferences. 2. Set the preferences in Captivate Quiz Analyzer. 3. Submit the result. 4. View the result. For more information, refer to the official doc, https://helpx.adobe.com/captivate/using/report-quiz-results-internal-server.html The document is updated as of Captivate 9. Please try the steps given in the document. Let us know the results. Thanks, Saurav

Hi Oliver,

Trust you are doing well. Publishing and tracking results using an internal server is a multi-step process:

1. Set the reporting preferences.
2. Set the preferences in Captivate Quiz Analyzer.
3. Submit the result.
4. View the result.

For more information, refer to the official doc, https://helpx.adobe.com/captivate/using/report-quiz-results-internal-server.html

The document is updated as of Captivate 9.

Please try the steps given in the document. Let us know the results.

Thanks,
Saurav

Like
>
Saurav Ghosh
's comment
2017-03-08 03:04:20
2017-03-08 03:04:20
>
Saurav Ghosh
's comment

Mr.Saurav, I almost try that. But after i get the results always said connection failed? Why?

Mr.Saurav,
I almost try that. But after i get the results always said connection failed? Why?

Like
>
OliverT05
's comment
2017-03-09 06:51:51
2017-03-09 06:51:51
>
OliverT05
's comment

Oliver, Are you using the IP address or fully-qualified server name for your server? For ex, are you using localhost:/xxxx.php or 192.x.x.x/xxxx.php to define the server? Thanks, Saurav

Oliver,

Are you using the IP address or fully-qualified server name for your server?

For ex, are you using localhost:/xxxx.php or 192.x.x.x/xxxx.php to define the server?

Thanks,
Saurav

Like
>
Saurav Ghosh
's comment
2017-03-09 07:19:26
2017-03-09 07:19:26
>
Saurav Ghosh
's comment

I'm using the localhost:8080/InternalServerReporting.php then in the preferences localhost:8080/internalserverread.php. Sir, where planning to buy the captivate. But still we need to test the software. Please help us sir. Actually i posted an questions about this. This is the link maybe you can answer. Please check this sir. https://forums.adobe.com/thread/2287280 I'm looking forward to your answer. Thanks! Regards, Oliver

I’m using the localhost:8080/InternalServerReporting.php then in the preferences localhost:8080/internalserverread.php.

Sir, where planning to buy the captivate. But still we need to test the software. Please help us sir. Actually i posted an questions about this. This is the link maybe you can answer.

Please check this sir.
https://forums.adobe.com/thread/2287280

I’m looking forward to your answer.

Thanks!

Regards,
Oliver

Like
>
Saurav Ghosh
's comment
2017-03-09 07:25:40
2017-03-09 07:25:40
>
Saurav Ghosh
's comment

Mr. Saurav, I'm curious there's is no file "CaptivateResult" or XML file result after I take the quiz? I first try to install in my laptop the captivate 9, It has a folder CaptivateResults inside the Templates/Publish but when I try to install the captivate 9 in my office, there's is no such file "CaptivateResult" is there a problem to my installation or what?

Mr. Saurav,

I’m curious there’s is no file “CaptivateResult” or XML file result after I take the quiz?

I first try to install in my laptop the captivate 9, It has a folder CaptivateResults inside the Templates/Publish
but when I try to install the captivate 9 in my office, there’s is no such file “CaptivateResult” is there a problem to my installation or what?

Like
>
Saurav Ghosh
's comment
2017-03-09 07:47:40
2017-03-09 07:47:40
>
Saurav Ghosh
's comment

Oliver, Create a folder in your webroot or htdocs folder (if you're using wamp/xampp). For example, http://localhost:8012/report/internalserverread.php http://localhost:8012/report/internalServerReporting.php I think this should work. You will also see the CaptivateResult folder. Thanks, Saurav

Oliver,

Create a folder in your webroot or htdocs folder (if you’re using wamp/xampp).

For example,
http://localhost:8012/report/internalserverread.php

http://localhost:8012/report/internalServerReporting.php

I think this should work. You will also see the CaptivateResult folder.

Thanks,
Saurav

Like
>
Saurav Ghosh
's comment
2017-03-09 08:47:18
2017-03-09 08:47:18
>
Saurav Ghosh
's comment

I almost try that Sir, but still have an error. After I get the results always saying url not found this is the link i put in the preferences http://localhost:8080/report/internalserverread.php and I try to open it in the localhost with this address http://localhost:8080/report/internalServerReporting.php The result is; "Object not found, Error 404"

I almost try that Sir,

but still have an error. After I get the results always saying url not found this is the link i put in the preferences
http://localhost:8080/report/internalserverread.php

and I try to open it in the localhost with this address http://localhost:8080/report/internalServerReporting.php
The result is; “Object not found, Error 404”

Like
>
OliverT05
's comment
2017-03-09 08:59:37
2017-03-09 08:59:37
>
OliverT05
's comment

The following thread contains all details: https://elearning.adobe.com/discussion/2287280/

The following thread contains all details:

https://elearning.adobe.com/discussion/2287280/

Like
>
OliverT05
's comment
2017-03-09 09:56:41
2017-03-09 09:56:41
>
OliverT05
's comment

Oliver, Can you please send me a screenshot of the contents of the report folder inside xampp/htdocs? Thanks, Saurav

Oliver,

Can you please send me a screenshot of the contents of the report folder inside xampp/htdocs?

Thanks,
Saurav

Like
2010-08-23 14:56:56
2010-08-23 14:56:56

Just a note for those hosting on an Internal Server - in the Quiz results analyser you must specify the Internal Server location of http:///internalServerRead.php, rather than http:///InternalServerReporting.php. Wish I'd known that 3 hours ago. ;)

Just a note for those hosting on an Internal Server – in the Quiz results analyser you must specify the Internal Server location of http:///internalServerRead.php, rather than http:///InternalServerReporting.php. Wish I’d known that 3 hours ago. 😉

Like
2010-08-20 17:39:57
2010-08-20 17:39:57

[...] last post mentioned the way to set up an owned server, for getting the Captivate quiz results. This blog [...]

[…] last post mentioned the way to set up an owned server, for getting the Captivate quiz results. This blog […]

Like
2010-08-17 23:34:09
2010-08-17 23:34:09

I am trying to Create a Reporting Script using asp instead of php. How do I do this? How do I translate php code into asp? DO I need to translate internalserverread.php also to asp file? I tried printing Request.form("Company") - it returns nothing. Thank you.

I am trying to Create a Reporting Script using asp instead of php. How do I do this? How do I translate php code into asp? DO I need to translate internalserverread.php also to asp file?
I tried printing Request.form(“Company”) – it returns nothing.

Thank you.

Like
2010-08-13 20:33:06
2010-08-13 20:33:06

Is there any way to auto-post the test data? Learners my not know that they have to take this extra step to save their score. Thanks, Mike

Is there any way to auto-post the test data? Learners my not know that they have to take this extra step to save their score.

Thanks,
Mike

Like
(1)
>
Anonymous
's comment
2010-09-27 06:10:14
2010-09-27 06:10:14
>
Anonymous
's comment

This would be really helpful - is there a solution?

This would be really helpful – is there a solution?

Like
2010-08-11 22:39:08
2010-08-11 22:39:08

2 questions: I would like to have the date the quiz was taken displayed when viewing results from the Quiz Results Analyzer but I don't see it. Am I missing something? How can I have them display? Also, my IT guys tell me the scripts shipped with Captivate don't work with Linux without customization. Will this be offered soon?

2 questions: I would like to have the date the quiz was taken displayed when viewing results from the Quiz Results Analyzer but I don’t see it. Am I missing something? How can I have them display?

Also, my IT guys tell me the scripts shipped with Captivate don’t work with Linux without customization. Will this be offered soon?

Like
(2)
>
Anonymous
's comment
2010-10-21 01:26:02
2010-10-21 01:26:02
>
Anonymous
's comment

I second the request for date information. Is there a solution?

I second the request for date information. Is there a solution?

Like
>
Anonymous
's comment
2012-01-13 23:14:00
2012-01-13 23:14:00
>
Anonymous
's comment

Hiii...I am unable to view the results that are being stored in the local databse.I have gone though the above steps but i am inable to figure it out where exactly i am going wrong...Can any one help me out clearly.I am doing it using sql server and .net..Help will be appriciated... Kindly let me know through my mail id..."tagurgautham@gmail.com"

Hiii…I am unable to view the results that are being stored in the local databse.I have gone though the above steps but i am inable to figure it out where exactly i am going wrong…Can any one help me out clearly.I am doing it using sql server and .net..Help will be appriciated… Kindly let me know through my mail id…”tagurgautham@gmail.com”

Like
Add your comment